Course Outline
| Access 2007 Advanced | ||
| Section One | Advanced Topics | |
| Lesson 1.1 | Setting Excel Options | |
| Lesson 1.2 | Excel and Windows | |
| Lesson 1.3 | Using the Excel Viewer | |
| Section Two | Getting the Most from your Data | |
| Lesson 2.1 | Getting the Most from your Data | |
| Lesson 2.2 | PivotTables | |
| Lesson 2.3 | More About PivotTables | |
| Lesson 2.4 | Exploring Scenarios | |
| Lesson 2.5 | What If Analysis | |
| Section Three | Excel and the Internet | |
| Lesson 3.1 | Excel and Hyperlinks | |
| Lesson 3.2 | Saving Workbooks as Web Pages | |
| Lesson 3.3 | Getting Data from the Internet | |
| Lesson 3.4 | Excel and Office Servers | |
| Section Four | Advanced Excel Tasks | |
| Lesson 4.1 | Creating and Using Shared Workbooks | |
| Lesson 4.2 | Using Custom AutoFill Lists | |
| Lesson 4.3 | Using the VLOOKUP Function | |
| Lesson 4.4 | Linking, Consolodating, and Combining Workbooks | |