Using What-if Analysis

• What-if Analysis
• Tracking a What-if Analysis with Scenario Manager
• Generating a Scenario Summary
• Projecting Figures Using a Data Table
• Using Goal Seek
• Setting up a Complex What-if Analysis with Solver 
• Running Solver and Summarizing Results
• Analyzing Data Using the Analysis ToolPak 

Analyzing Data with PivotTables 

• Planning and Designing a PivotTable Report
• Creating a PivotTable Report
• Changing a PivotTable's Summary Function and Design
• Filtering and Sorting PivotTable Data
• Updating a PivotTable Report
• Changing the Structure and Format of a PivotTable Report 

Exchanging Data with Other Programs 

• Planning a Data Exchange
• Importing a Text File
• Importing a Database Table
• Inserting a Graphic File in a Worksheet
• Embedding a Workbook in a Word Document
• Linking a Workbook to a Word Document
• Linking an Excel Chart to a Powerpoing Slide
• Importing a Table into Access

Customizing Excel and Advanced Worksheet Managment

• Auditing a Worksheet
• Controlling Worksheet Calculations
• Grouping Worksheet Data
• Using Cell Comments
• Creating Custom AutoFill Lists
• Customizing Excel Workbooks
• Customizing Excel Options
• Creating a Template

Programming with Excel

• Viewing VBA Code
• Analyzing VBA Code
• Writing VBA Code
• Adding a Conditional Statement
• Prompting the User for Data
• Debugging a Macro
• Creating a Main Procedure
• Running a Main Procedure