Excel XP/2003 Advanced (Level 3)

Overview: Students will learn the skills and concepts necessary to work with advanced features of Excel.

Course content

Lesson 1: Customizing the work area

Working with existing toolbars
Creating a new toolbar
Creating and using styles
Creating templates

Lesson 2: Advanced formula construction

Nested functions
The IF function
The VLOOKUP function
Error handling and the Auditing features

Lesson 3: Pivot tables

Creating pivot tables
Working with pivot tables
Viewing pivot tables at different levels

Lesson 4: Multiple file linking

Working with workbooks
Linking individual cells
Workbooks versus links and workspaces

Lesson 5: Consolidating data and using analysis tools

Consolidating worksheets
Using the Goal Seeker and Solver utilities
Creating a scenario by using Scenario Manager

Lesson 6: Protect and display options

Using comments
Protecting the worksheet
Hiding information
Custom views

Lesson 7: Introduction to macros

Running a macro
Recording a macro
Viewing and editing VBA code