Microsoft Excel 2000 Advanced
| Duration: | 1 day |
| Prerequisite: | Excel Introduction and Excel Intermediate or equivalent experience. |
| Course Materials: | Course manual with CD containing exercises, 160 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class covers the Advanced concepts of Microsoft Excel 2000 with what-if analyses, Pivot Tables, and exchanging data with other programs. . The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
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
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
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
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
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