| Customizing the Work Area | | Consolidating Data and Using Analysis Tools |
 | Working with and creating toolbar | | | Consolidating worksheets |
| Advanced Formula Construction | | | Using the Goal Seeker and Solver utilities |
| Nested functions | | | Creating a scenario by using Scenario Manager |
| The if function | | Protect and Display Options |
| The VLOOKUP function | | | Using comments |
| Error handling and auditing features | | | Protecting the worksheet |
| Pivot Tables | | | Hiding information |
| Creating pivot tables | | | Custom views |
| Working with pivot tables | | Introduction to Macros |
| Viewing pivot tables at different levels | | | Running a macro |
| Multiple file linking | | | Recording a macro |
| Working with workbooks | | | Viewing and editing VBA code |
| Linking individual cells | | | |
| Workbooks versus links and workspaces | | | |
