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