The fourth video lesson in this Excel tutorial series. You will learn:

Creating 3D Formulas:
1. Creating 3D Formulas
2. 3D Formula Syntax
3. Creating 3D Range References

Named Ranges:
1. Naming Ranges
2. Moving to a Named Range
3. Using Named Ranges in Formulas
4. Creating Names from Headings
5. Deleting Range Names

Spreadsheet Tools:
1. Moving between Spreadsheets
2. Selecting Multiple Spreadsheets
3. Inserting and Deleting Spreadsheets
4. Renaming Spreadsheets
5. Coloring Spreadsheet Tabs
6. Switching to Full Screen View
7. Splitting the Screen
8. Freezing Panes
9. Copying and Moving Entire Worksheets
10. Cutting, Copying and Pasting Data between Spreadsheets
11. Printing Multiple Spreadsheets
12. Hiding Spreadsheets

Using Workspaces:
1. Creating Workspaces
2. Opening and Closing Workspaces
3. Selecting Workbooks in a Workspace
4. Organizing a Workspace

Paste Special:
1. Paste Special Options
2. Pasting Linked Formulas

The most comprehensive Excel tutorial available. Covers all of the same material as a three-day classroom training - Introductory, Intermediate & Advanced.

For versions 2003, 2002 XP, 2000 & 97.

The DVD purchase of this download contains all Mastering Excel downloads.