Course content

Lesson 1: Customizing the work area

• Working with built-in toolbars
• Using custom toolbars
• Creating and using styles
• Using templates

Lesson 2: Advanced formula construction

• Using names
• Using the IF function
• Using the VLOOKUP function
• Using IS functions and the Auditing features

Lesson 3: Using pivot tables

• Creating pivot tables
• Modifying pivot tables
• Grouping and summarizing data in a pivot table

Lesson 4: Working with multiple worksheets

• Working with workbooks
• Linking cells in different workbooks
• Workbook versus links and workspaces

Lesson 5: Consolidating and analyzing data

• Consolidating data from more than one worksheet
• Using the Goal Seek and Solver utilities
• Using Scenario Manager to view a worksheet with different input values

Lesson 6: Using protection and display options

• Using comments
• Protecting workbooks
• Using custom views

Lesson 7: Introduction to macros

• Running macros
• Recording a macro
• Viewing and editing VBA code

Lesson 8: Working with interactive Excel Web documents

• Saving Excel worksheets as Web documents
• Spreadsheet Web Components

Return to Courses