Excel Mod I
Basic

Download Class
Data Files

Exploring Excel
Starting Excel
Working with Excel Windows
Working with Worksheets
Using Menu Commands
Displaying and Hiding Toolbars
Displaying Hidden Toolbar Buttons
Moving and Resizing Toolbars
Changing Menu and Toolbar Options
Using the Task Pan
Exiting Excel

Using Online Help
Working with Online Help
Viewing ScreenTips
Using Help Contents
Using Help Window Features
Using the Help Answer Wizard
Using the Help Index 
       

Excel Mod II
Intermediate

Download Class
Data Files

Using Automatic Formatting and Styles
Using Automatic Formatting Features Applying an AutoFormat
Changing AutoFormat Options
Extending List Formats and Formulas Creating a Style by Example
Applying a Style
Creating a New Style
Editing an Existing Style
Merging Styles

Using Large Worksheets
Increasing the Magnification
Decreasing the Magnification
Changing the Magnification of a Range
Switching to Full Screen View
Splitting the Window
Removing Split Windows
Freezing the Panes
Unfreezing the Panes

Working with Multiple Worksheets
Using Multiple Worksheets
Navigating between Worksheets
Selecting Worksheets
Renaming Worksheets
Selecting Multiple Worksheets
Coloring Worksheets Tabs
Inserting Worksheets
Deleting Worksheets
Printing Selected Worksheets

Managing Worksheets
Copying Worksheets
Moving Worksheets
Using Grouped Worksheets
Moving Data between Worksheets
Copying Data between Worksheets
Creating 3-D Formulas
Using 3-D Ranges in Functions  

Working with Outlines
Applying an Outline
Expanding/Collapsing an Outline
Modifying Outline Settings
Clearing an Outline
Using Auto Outline
Using Range Names
Working with Range Names
Jumping to a Named Range
Assigning Names

Using Range Names in Formulas
Creating Range Names from Headings
Applying Range Names
Deleting Range Names
Using Range Names in 3-D Formulas Creating 3-D Range Names
Using 3-D Range Names in Formulas
Working with Labels in Formulas
Using Labels in Formulas
Using Labels to Define a Range
Using Multiple Stacked Headings
Referring to Individual Cells

Using Paste Special
Working with Paste Special
Copying Formats between Worksheets
Copying Values between Worksheets Performing Mathematical Operations

Using Multiple Workbooks
Opening Multiple Workbook Windows Cascading Open Workbook Windows
Activating Cascaded Workbook Windows
Tiling Open Workbook Windows
Activating Tiled Workbook Windows
Copying Data between Workbooks
Saving a Workspace
Closing All Open Workbooks
Opening a Workspace
Linking Workbooks
Opening Linked Workbooks

Working with Comments
Creating Comments
Viewing a Comment
Using the Reviewing Toolbar
Printing Comments

Using Worksheet Protection
Unlocking Cells in a Worksheet
Protecting a Worksheet
Unprotecting a Worksheet
Creating Allow-Editing Range
Deleting Allow-Editing Range
Protecting Workbook Windows
Unprotecting Workbook Windows
Assigning a Password
Opening a Protected File
Removing a Password
Setting Manual Calculation
Resetting Automatic Calculation

Managing Files
Changing Workbook Properties
Using the Basic Search Task Pane
Using the Advanced Search Task Pane
Clearing Search Criteria
Selecting File Views
Sorting Excel Files

Excel Mod III
Advanced Functions

Download Class
Data Files

Working with Data Series
Using the Series Command
Creating a Linear Series
Creating a Date Series
Using a Stop Value
Crating a Growth Trend Series

Using Other Functions
Using Function Arguments
Using Financial Functions
Using Logical Functions
Using Date Functions
Formatting Dates
Revising Formulas

Using Advanced Functions
Using Lookup Functions
Using the VLOOKUP Function
Using the HLOOKUP Function
Using the IF Function
Using Nested IF Functions
Using the ISERROR Function
Using an AND Condition with IF
Using an OR Condition with IF
Using the ROUND Function
Limiting the Precision of Numbers

Using Conditional and Custom Formats
Applying Conditional Formats
Changing a Conditional Format
Adding a Conditional Format
Deleting a Conditional Format
Creating a Custom Format

Using Scenarios and Goal Seeking
Using the Scenario Manager
Creating a Scenario
Displaying a Scenario
Editing a Scenario
Creating a Scenario Summary Report

Using Data Tables
Using Data Tables
Placing Formulas in Data Tables
Creating a One-Variable Table
Creating a Two-Variable Table

Using Auditing Tools
Displaying the Auditing Toolbar
Displaying/Removing Dependent Arrows
Displaying/Removing Precedent Arrows
Removing Tracer Arrows
Using Trace Error Button
Tracing Cells Causing Errors
Using Error Checking Button
Using the Evaluate Formula Button

Consolidating Worksheets
Consolidating by Category
Consolidating by Position
Consolidating Worksheets

Solving Problems
Using Solver
Saving a Solution as a Scenario
Restoring the Original Values
Changing a Constraint
Creating a Solver Report
Using Scenarios to View Solutions

Working with Views
Using Views
Creating a Normal View
Creating a Custom View
Displaying a View
Deleting a View

Using the Report Manager
Working with the Report Manager
Using Sheets in a Report
Printing a Report
Using Scenarios and Views in a Report
Reordering Sections in a Report

Using Templates
Working with Templates
Saving a Workbook as a Template
Using a Template
Editing a Template
Inserting a New Worksheet
Deleting a Template
Creating Default Templates

Using HTML Files
Previewing a Web Page
Creating a Hyperlink
Editing a Hyperlink
Saving a Worksheet as a Web Page
Using Publishing Options
Opening an HTML File