1. What-if Analysis
Using the Scenario Manager
Creating and editing scenarios
Creating a Scenario Report
Using Goal Seek
Using the Solver2. Data Tables
The single-variable data table
The two-variable data table
Adding conditional formatting
3. Working with Outlines
Applying an outline
Automatic outlining
Displaying and collapsing levels
Modifying outline settings
Creating subtotals |
|
4. Analysing Data with Pivot Tables
Creating a pivot table
Defining the source range
Inserting. moving and deleting fields
Showing and hiding fields
Grouping and ungrouping fields
Renaming fields
Defining field properties
Formatting a pivot table
Refreshing a pivot table
Drilling down |
|
5. Excel Macros
About macros and VBA
Macro security
Recording macros
Running a Macro
Absolute and relative references
Saving and distributing macros
Assigning a macro to a button
Editing macro code
Automatic macros |
