Microsoft Excel 2003 Level 3
| Duration: | 1 day |
| Prerequisite: | Excel Introduction 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 2003 with performing "what if" analysis, creating PivotTables, exchanging Excel data with other programs, controlling worksheet properties and calculations, and programming with Excel. 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