Excel 97
Foundation Level |
Section One
Section Two
Section Three
Section Four |
The Fundamentals
Edit A Workbook
Format a Worksheet
Manage Workbooks |
Enhanced Level |
Section One
Section Two
Section Three
Section Four
Section Five |
Create Charts
Functions and Formulas
Work with Lists
Work with Macros
Integration and Internet |
Expert Level |
Section One
Section Two
Section Three |
Data Analysis & PivotTables
What If Analysis
Customize and Share |
|
Foundation |
|
Section One - The Fundamentals |
Start Excel
Use Menus and Toolbars
Fill Out Dialog Boxes
Keystroke and Right-click Shortcuts
Open and Save a Workbook
Move the Cell Pointer
Navigate a Worksheet
Enter Labels in a Worksheet
Enter Values and Select a Cell Range
Calculate Value Totals with AutoSum
Enter Formulas
Use AutoFill
Preview and Print a Worksheet
Help from the Office Assistant
Use the What's This Button
Close a Workbook and Exit Excel |
|
Foundation |
|
Section Two - Edit a Workbook |
Enter Date Values and AutoComplete
Edit and Replace Cell Contents
Cut, Copy, and Replace Cell Contents
Drag and Drop Cell Contents
Absolute and Relative Cell References
Use Paste Special
Insert and Delete
Use Undo and Redo
Correct Spelling
Find and Replace Information
Advanced Print Options
File Management
Insert Cell Comments |
|
Foundation |
|
Section Three - Format a Worksheet |
Format Fonts
Format Values
Adjust Row Height and Column Width
Change Cell Alignment
Add Borders
Apply Colours and Patterns
Use the Format Painter
Use AutoFormat
Create a Custom Number
Format Create, Apply, and Modify a Style
Format with Conditional Formatting
Merge Cells, Rotate Text, and AutoFit |
|
Foundation |
|
Section Four - Manage Workbooks |
Switch between Worksheets
Insert and Delete Worksheets
Rename and Move Worksheets
Multiple Workbooks and Windows
Split and Freeze a Window
Reference External Data
Create Headers and Footers
Print Area and Page Breaks
Page Margins and Orientation
Print Titles and Gridlines
Paper Size and Print Scale
Protect and Hide a Worksheet
Views and Custom Views
Work with Templates
Consolidate Worksheets |
|
Enhanced |
|
Section One - Create Charts |
Create a Chart
Move and Resize a Chart
Format and Edit Objects
Change the Data Source
Change the Chart Type
Add Titles, Gridlines, and Data Table
Format a Data Series and Chart Axis
Annotating a Chart Work with 3D Charts
Select and Save a Custom Chart
Use Fill Effects |
|
Enhanced |
|
Section Two - Functions and Formulas |
Multiple Operators and Cell Ranges
Use the Formula Palette
Use Range Names
Non-Adjacent Ranges and AutoCalculate
Conditional Formulas
The PMT Function Display and Print Formulas
Fix Errors in Formulas
Mathematical Functions
Financial Functions
Date and Time Functions
Statistical Functions
Database Functions |
|
Enhanced |
|
Section Three - Work with Lists |
Create a List
Use the Data Form
Find Records
Delete Records
Sort a List
Use AutoFilter
Create a Custom AutoFilter
Use an Advanced Filter
Copy FIltered Records
Use Data Validation |
|
Enhanced |
|
Section Four - Work with Macros |
Record a Macro
Play a Macro and Shortcut Keys
Add a Macro to a Toolbar
Edit Visual Basic Code
Insert Code in an Existing Macro
Declare Variables and Add Remarks
Prompt for User Input
Use the IF...THEN...ELSE Statement |
|
Enhanced |
|
Section Five - Integration and Internet |
Insert a Worksheet in Word
Modify an Inserted Worksheet
Insert a Linked Chart in Word
Insert Graphics
Manage Different Formats
Add Hyperlinks
Browse Hyperlinks and The Web Toolbar
Convert an Excel File to a Web Page |
|
Expert |
|
Section One - Data Analysis and PivotTables |
Create a PivotTable
Modify a PivotTable's Structure
Add a Page Field to a PivotTable
Group Dates in a PivotTable
Update a PivotTable
Create Subtotals
Use Database Functions
Use Lookup Functions
Group and Outline a Worksheet |
|
Expert |
|
Section Two - What If Analysis |
Define a Scenario
Create a Summary Report
Use a One and Two-Input Data Table
Understand Goal Seek
Use Solver |
|
Expert |
|
Section Three - Customize and Share |
Add, Position, and Remove Toolbars
Create Custom Toolbars
Create a Custom AutoFill List
Change Excel's Options
Password Protect a Workbook
File Properties and Find a File
Share a Workbook and Track Changes
Merge and Revise a Shared Workbook |
|
