MS Excel 2003 (MOS) CD Training (CBT) Course

Course Contents:

Level 1
Course Introduction
Entering and Editing Data
Enter and Edit Cell Content
Data Entry Tools
Navigate to Specific Cell Content
Using Office Tools
Inserting Graphics
Insert, Position, and Format a Graphic
Using the AutoFilter Tool
Filter Data Using AutoFilter
Data Sorting Tools
Sort a List
Inserting Formulas
Insert and Modify a Formula
Using Advanced Functions
Formatting Cells
Apply and Modify a Cell Format
Row and Column Styles
Applying Templates
Editing and Moving Cell Content
Insert, Delete, and Move Cells
Working with Worksheets
Rename and Reorder Worksheets
Links and Hyperlinks
Create a Link
Arrange Window Layout
Customize Window Layout
Print Page Setup
Add a Header and Change Print Margins
Using Print Preview
Print a Selection from a Worksheet
Summary
Level 1 - Review

Level 2
Manipulating and Analyzing Data
Apply Subtotals
Using Advanced Filters
Define and Apply Advanced Filters
Data Validation Tools
Creating and Modifying Lists
Create and Modify a List
Using Scenarios
Automated Data Analysis Tools
Using Goal Seek
Automated Data Analysis Tools
Using Solver
Perform Data Analysis
Setup PivotTables
Create a PivotTable
Reference Functions
Working with Database Functions
Error Tracking Tools
Audit a Formula
Setting Up Named Ranges
Define and Apply a Named Range
Working with Data Formats
Conditional Formatting
Use Conditional Formatting
Summary
Level 2 - Review

Level 3
Displaying and Sharing Data
PivotCharts
Create and Modify a PivotChart
Collaboration Tools
Insert and Edit a Comment
Protection Features
Tracking Changes
Track Changes to a Workbook
Managing Changes
Importing and Exporting Data
Consolidating Data
Publishing to the Web
Save a Workbook as a Web Page
Working with XML Data
Customizing Excel
Create and Edit Macros
Summary
Level 3 - Review