Microsoft Excel 2003 – Advanced Level

Course Outline

Review of Some Excel Basics

Checking and Correcting Data, Adding a Graphic to a Document

 Performing Calculations on Data

Naming Groups of Data

Creating Formulas to Calculate Values

Finding and Correcting Errors in Calculations

Focusing on Specific Data Using Filters

Limiting the Data That Appears on the Screen

Performing Calculations on Filtered Data

Defining a Valid Set of Values for a Range of Cells

Combining Data from Multiple Sources

Using a Data List as a Template for Other Lists

Working with More Than One Set of Data

Linking to Data in Other Workbooks

Summarizing Multiple Sets of Data

Grouping Multiple Data Lists

Reordering and Summarizing Data

Sorting a Data List

Organizing Data into Levels

Analyzing Alternative Data Sets

Defining and Editing Alternative Data Sets

Defining Multiple Alternative Data Sets

Varying Your Data to Get a Desired Result

Finding Optimal Solutions with Solver

Analyzing Data with Descriptive Statistics

Creating Dynamic Lists with PivotTables

Creating Dynamic Lists with PivotTables

Editing PivotTables

Creating PivotTables from External Data

Automating Repetitive Tasks with Macros

Creating and Modifying Macros

Creating a Toolbar to Hold Macros

Creating a Menu to Hold Macros

Running a Macro When a Workbook Is Opened

Collaborating with Colleagues

Sharing a Data List

Managing Comments

Tracking and Managing Colleagues’ Changes

Identifying Which Revisions to Keep

Protecting Workbooks and Worksheets

Authenticate Workbooks