Excel 2000
Expert Specialist
|
 |
Course Length/Prerequisites
This three-day course requires Windows 95 or Windows NT 4.0 Introduction
as well as the Excel User Specialist course. Familiarity with all features
covered in the User Specialist course or equivalent experience with
the product is a prerequisite. Profound knowledge of basic concepts
such as referencing cells and ranges in formulas, formatting spreadsheets,
creating charts and setting print options as well as moderate typing
skills are required.
Intended Audience
This course is intended for students who wish to prepare for the Microsoft
Office User Specialist exam "Proficient User" for Excel 2000.
Styles
Definitions and Use
Creating a Custom Number Format
Copying a Style between Workbooks
Changing the Normal Style
Templates
Definitions and Use
Creating Templates
Using Templates
Editing Templates
Creating and Using Autotemplates
Other Autotemplates
Excel’s Built-in Templates
Outlining
Definition and Use
Creating and Using an Outline
Printing and Charting Summary Information
Copying Summary Information
Working with a List
Definitions and Use
Creating a List
Guidelines for Using Lists
Editing a List Using the Data Form
Filtering Records
AutoFilter — Top Ten
Custom Filtering Criteria
Sorting
Subtotals
Retrieving External Data
Using Analysis Tools
Working With Scenarios
Using Report Manager
Using Goal Seek
Using Solver
Using Pivot Table Reports
Creating a Pivot Table Report
Modifying Pivot Tables
Inserting a Calculated Field in a Pivot Table
Grouping Column/Row Headings
Creating a Pivot Table from an External Database
Creating an Interactive Pivot Table for The Web
Working with Multiple Worksheets and Workbooks
Consolidating Data with 3-D References
Linking Workbooks
Group Editing
Consolidating Worksheets
Using a Workspace File
Printing and Previewing Multiple Sheets
Printing
Advanced Formulas and Functions
Introduction and Definitions
Creating and Using Range Names in Formulas
IF Function
AND and OR Functions
Rounding Errors
ISERROR Function
VLOOKUP Function
COUNTIF and SUMIF Functions
Enhancing Functionality
Converting Formulas to Values
Auditing a Worksheet
Conditional Formatting
Data Validation
Importing and Exporting Data
Importing Data From Other Applications
Importing Data From Text Files
Importing an HTML file
Exporting Data
Collaborating With Workgroups
Adding Comments to Cells
Sharing Workbooks
Merging Workbooks
Protection
Using Macros
Recording a Macro
Running a Macro
Relative References in a Macro
Viewing and Editing Macros
Using Step Into
Deleting Macros
Customizing Toolbars
Assigning Macros to Drawn Objects
