Microsoft^®

Excel 2003 Level 3

Prerequisites:

Students must have experience using Excel and completed or have knowledge of information in Level 1 and 2 to progress to this level.

Course Content:

• Creating a PivotTable
• Specifying the Data a PivotTable Analyzes
• Changing a PivotTable's Calculation
• Selecting What Appears in a PivotTable
• Grouping Dates in a PivotTable
• Updating a PivotTable
• Formatting and Charting a PivotTable
• Creating Subtotals
• Using Database Functions
• Using Lookup Functions
• Grouping and Outlining a Worksheet

• Defining a Scenario
• Creating a Scenario Summary Report
• Using a One and Two Input Data Table
• Understanding Goal Seek
• Using Solver

• Recording a Macro
• Playing a Macro and Assigning a Macro a Shortcut Key
• Adding a Macro to a Toolbar
• Editing a Macro's Visual Basic Code
• Inserting Code in an Existing Macro
• Declaring Variables and Adding Remarks to VBA Code
• Prompting for User Input
• Using the If...Then...Else Statement

• Creating and Using Custom Toolbars
• Sending Faxes
• Creating a Custom AutoFill List
• Changing Excel's Options
• Password Protecting a Workbook
• File Properties and Finding a File
• Sharing a Workbook and Tracking Changes
• Merging and Revising a Shared Workbook
• Using Detect and Repair