Advanced Training for Excel 2003: Course 4101

This course provides an overview of the advanced capabilities of Microsoft® Office Excel 2003, including the following: working with Excel and other Office programs, organizing data, performing calculations on data, analyzing data, working with pivot tables, working with graphics and charts, working with database data and macros, publishing on the Web and using XML, and collaborating in Excel.

This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.

This course is 5 hours long.

System Requirements:

Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Flash Player 7.0 or higher;
Speakers and soundcard.

Subscription: 1 year

Modules & Lessons
Advanced Training for Microsoft Office Excel 2003

Pre-Assessment
Pre-Assessment

Working with Excel and Other Office Programs
Lesson Introduction
Creating a Template from an Existing Worksheet
Modifying Workbook Settings
Using Custom Data Formats
Sharing Data Between Excel and Other Office Programs

Organizing Data
Lesson Introduction
Limiting the Data That Appears on the Screen
Performing Calculations on Filtered Data
Validating Data
Changing Data Appearance Based on Value
Summarizing and Grouping Multiple Sets of Data

Performing Calculations on Data
Lesson Introduction
Naming Cell Ranges
Creating Formulas to Calculate Values
Finding and Correcting Errors in Calculations

Analyzing Data
Lesson Introduction
Defining and Editing Alternative Data Sets
Defining Multiple Alternative Data Sets
Working with Goal Seek and Solver
Analyzing Data with Descriptive Statistics

Working with PivotTables
Lesson Introduction
Creating and Using PivotTables
Editing PivotTables
Creating PivotTables from External Data

Working with Graphics and Charts
Lesson Introduction
Formatting and Resizing Graphics
Creating a Chart
Creating a Dynamic Chart Using PivotCharts

Working with Database Data and Macros
Lesson Introduction
Locating and Retrieving Data from a Database
Summarizing List Data
Introducing Macros
Creating and Modifying Macros

Publishing on the Web and Using XML
Lesson Introduction
Converting an Excel Workbook to XML
Using XML Data Capabilities and Retrieving Web Data
Publishing Worksheets and PivotTables on the Web

Collaborating in Excel
Lesson Introduction
Sharing and Comparing Workbooks
Managing Comments
Tracking and Managing Changes
Protecting Workbooks and Worksheets

Post Assessment
Post Assessment

Reference and Glossary
Quick Reference