| Working with Advanced Formulas |
Pivot Tables and Pivot Charts |
| Using names |
Working with Pivot Tables |
| Using decision-making functions |
Rearranging Pivot Tables |
| Creating nested functions |
Formatting Pivot Tables |
| Using financial functions |
Working with Pivot Charts |
| Working with Macros |
Interactive Web Pages |
| Running and recording a macro |
Creating interactive Web spreadsheets |
| Viewing VBA code |
Publishing Pivot tables on the Web |
| Function procedures |
|
| Lookups and Data Tables |
Exporting and Importing |
| Working with lookup functions |
Exporting and importing text files |
| Creating data tables |
Querying external databases |
| Advanced List Management |
Using Analytical Options |
| Creating subtotals |
Working with Goal Seek and Solver |
| Validating cell entries |
Working with scenarios |
| Exploring database functions |
Working with views |
