Unit K: Using What-If Analysis

• Define What-If Analysis
• Track a What-If Analysis with Scenario Manager
• Generate a Scenario Summary
• Project Figures Using a Data Table
• Create a Two-Input Data Table
• Use Goal Seek
• Set Up a Complex What-If Analysis with Solver
• Run Solver and Generate an Answer Report

Unit L: Analyzing Data with PivotTables

• Plan and Design a PivotTable Report
• Create a PivotTable Report
• Change the Summary Function of a PivotTable Report
• Analyze Three-Dimensional Data
• Update a PivotTable Report
• Change the Structure and Format of a PivotTable Report
• Create a PivotChart Report
• Use the GETPIVOTDATA Function

Unit M: Exchanging Data with Other Programs

• Plan a Data Exchange
• Import a Text File
• Import a Database Table
• Insert a Graphic File in a Worksheet
• Embed a Worksheet
• Link a Worksheet to another Program
• Embed an Excel Chart into a PowerPoint Slide
• Import a List into an Access Table

Unit O: Customizing Excel and Advanced Worksheet Management

• Find Files
• Audit a Worksheet
• Outline a Worksheet
• Control Worksheet Calculations
• Create Custom AutoFill Lists
• Customize Excel
• Add a Comment to a Cell
• Create a Template

Unit P: Programming with Excel

• View VBA Code
• Analyze VBA Code
• Write VBA Code
• Add a Conditional Statement
• Prompt the User for Data
• Debug a Macro
• Create a Main Procedure
• Run a Main Procedure