1. Defining a What-If Analysis
2. Tracking a What-If Analysis with Scenario Manager
3. Generating a Scenario Summary
4. Projecting Figures Using a Data Table
5. Creating a Two-Input Data Table
6. Setting Up a Complex What-If Analysis with Solver
7. Running Solver and Generating an Answer Report
8. Planning and Designing a PivotTable
9. Creating a PivotTable
10. Changing the Summary Function of a PivotTable
11. Analyzing Three-Dimensional Data
12. Updating a PivotTable
13. Changing the Structure and Format of a PivotTable
14. Creating a PivotChart Report
15. Importing a Database Table
16. Inserting a Graphic File in a Worksheet
17. Embedding a Worksheet
18. Linking a Worksheet to Another Program
19. Converting a List to an Access Table
20. Finding Files
21. Outlining a Worksheet
22. Controlling Worksheet Calculations
23. Creating Custom AutoFill Lists
24. Adding a Comment to a Cell
25. Saving a Workbook as a Template
26. Viewing Existing VBA Code
27. Analyzing Existing VBA Code
28. Writing VBA Code
29. Adding a Conditional Statement
30. Prompting the User for Data
31. Debugging a Macro Procedure
32. Creating a Main Procedure
33. Running a Main Procedure