Microsoft Excel 2002 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 intermediate concepts of Microsoft Excel 2002 with managing workbooks, automating tasks, using and analyzing list data, enhancing charts and worksheets, and working with Excel and the Internet. 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. |
Working with Other Programs
Inserting an Excel Worksheet into a Word Document
Modifying an Inserted Excel Worksheet
Inserting a Linked Excel Chart in a Word Document
Inserting a Graphic into a Worksheet
Opening and Saving Files in Different Formats
Review
Student Exercises
Using Hyperlinks and the Web Toolbar
Adding and Working with Hyperlinks
Browsing Hyperlinks and Using the Web Toolbar
Review
Student Exercises
Data Analysis and PivotTables
Creating a PivotTable
Specifying the Data a PivotTable Analyzes
Changing a PivotTable's Calculation
Selecting What Appears in a PivotTable
Grouping Dates in a PivotTable
Updating a PivotTable
Formatting and Charting a PivotTable
Creating Subtotals
Using Database Functions
Using Lookup Functions
Grouping and Outlining a Worksheet
Review
Student Exercises
What-If Analysis
Defining a Scenario
Creating a Scenario Summary Report
Using a One and Two-Input Data Table
Understanding Goal Seek
Using Solver
Review
Student Exercises
Advanced Topics
Hiding, Displaying, and Moving Toolbars
Customizing Excel's Toolbars
Sending Faxes
Creating a Custom AutoFill List
Changing Excel's Options
Password Protecting a Workbook
File Properties and Finding a File
Sharing a Workbook and Tracking Changes9
Merging and Revising a Shared Workbook
Using Detect and Repair
Review
Student Exercises