Microsoft Excel 2000: Advanced Course Guide

Unit 1: Using What-If Analysis Defining a What-If Analysis Tracking a What-If Analysis with Scenario Manager Generating a Scenario Summary Projecting Figures Using a Data Table Creating a Two-Input Data Table Using Goal Seek Setting Up a Complex What-If Analysis with Solver Running Solver and Generating an Answer Report Unit 2: Summarizing Data with Pivot Tables Planning and Designing a PivotTable Creating a PivotTable Changing the Summary Function of a PivotTable Analyzing Three-Dimensional Data Updating a PivotTable Changing the Structure and Format of a PivotTable Creating a PivotChart Report Using the GETPIVOTDATA Function Unit 3: 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 Worksheet Linking a Worksheet to Another Program Pasting an Excel Chart into a PowerPoint Slide Converting a List to an Access Table Unit 4: Gaining Control over Your Work Finding Files Outlining a Worksheet Controlling Worksheet Calculations Creating Custom AutoFill Lists Customizing Excel Adding a Comment to a Cell Saving a Workbook as a Template Unit 5: Programming with Excel Viewing Existing VBA Code Analyzing Existing VBA Code Writing VBA Code Adding a Conditional Statement Prompting the User for Data Debugging a Macro Procedure Creating a Main Procedure Running a Main Procedure