Excel 2003 Beginning, Intermediate, and Advanced

Excel 2003 Beginning, Intermediate, and Advanced

Click on the links next to the red icons

below to view the free movies.
Click here to setup a login account and view all of the movies.

** These Movies Have Sound
** The Flash Plug-in is Required

Beginning
	Introduction

Working With WorkSheets

Copy and AutoFill

Formatting Cells

Formula Basics

SUM, AVERAGE, MAX, MIN, and COUNT Functions

Printing WorkSheets and WorkBooks

Using the Spell Checker

Intermediate
	Find and Replace Contents of Cells

Using and Creating Styles

Using and Creating Templates

Absolute Cell Reference

PMT and FV Functions

Creating a Financial Spreadsheet

Logical Functions

Determining the Difference Between Dates

Creating a Chart

Adding Data to a Chart

Adding Non Contigous Data to a Chart

Modifying an Existing Chart

Using the Drawing Toolbar to Modify a Chart

Creating a Pie Chart

Printing a Chart

Copy and Move WorkSheets

Copy and Paste Charts

Formatting Multiple WorkSheets

Linking WorkSheets in a WorkBook

Splitting a Window and Freezing Panes

Using Multiple Windows

Hiding Rows and Columns

Zooming In and Out

Using Hyperlinks

Saving a Spreadsheet as a Web Page

Paste Special

Inserting a Picture

Emailing a Workbook

Advanced
	Restricting Cell Entries with Validation

Restricting Cell Values to a List

Formatting Numbers

Creating a Custom Number Format

Conditional Formatting

Using and Naming Cell Ranges

Using the VLOOKUP Function

Trace Precedents and Dependents

Linking WorkBooks

Creating a Workspace

Sorting Data

Creating SubTotals

Filtering Data

Creating Lists

Getting Data from External Sources

Pivot Tables Part 1

Pivot Tables Part 2

Making a Pivot Table Look Good

Creating Pivot Tables for the World Wide Web

Using Goal Seek

Using Scenarios

Sharing a WorkBook and Tracking Changes

Inserting Comments

Accepting or Rejecting Changes

Protecting a Shared WorkBook

Protecting a WorkSheet