Microsoft Excel 2003 Beginning, Intermediate, and Advanced

Microsoft 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.

Beginning
	Introduction

Working With WorkSheets

NOTES

Copy and AutoFill

1) These Movies Have Sound.

Formatting Cells

2) The Flash Plug-in is Required to

Formula Basics

View the Movies.

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


STANDARD PLAN			Access To Every Tutorial 24 Hours 7 Days A Week Learn More or ORDER NOW See Sales Demo>>

PREMIUM PLAN			Access to Every Tutorial 24 Hours 7 Days A Week Access to the IPOD Ready Tutorial Market Place Offline and Online Access Practice Tests Flash Cards End of Movie Quizzes Learn More or ORDER NOW See Sales Demo>>

LMS (Learning Management System) PLAN			Access to Every Tutorial 24 Hours 7 Days A Week Access to the IPOD Ready Tutorial Market Place Offline and Online Access Practice Tests Flash Cards End of Movie Quizzes Access to the Administrator Control Panel Assign Homework to Users Assign Pre & Post Tests Track All Results Learn More or ORDER NOW See LMS Demo>>