| |
ADVANCED PRINTING
|
 |
Page Break View |
 |
Printing Titles |
 |
Page Set-Up
|
| |
PROTECTION
|
 |
Cell Protection |
 |
Worksheet Protection
|
| |
NAMING RANGES IN FORMULAS
|
 |
Creating named Ranges |
 |
Using named Ranges
|
| |
CUSTOM FORMATS, STYLES & TEMPLATES
|
 |
Dates, Text, Numbers |
 |
Styles |
 |
Templates
|
| |
USING LISTS (DATABASES)
|
 |
Creating a basic Database List |
 |
Using the Data Form |
 |
Sorting data |
 |
Filtering Data |
 |
Using Subtotals |
 |
Introduction to Pivot Tables |
|
| |
LINKING
|
 |
Using Multiple Sheets |
 |
Linking Mulitple Files |
 |
Working with Linked Files |
 |
Editing Links |
 |
Consolodating Data
|
| |
ADVANCED CHARTING TECHNIQUES
|
 |
Editing a Data Series |
 |
Enhancing Charts with Graphics |
 |
Creating & Editing a Pictograph
|
| |
ADVANCED FUNCTIONS
|
 |
Using the IF Function |
 |
Using Lookup Tables and the VLOOKUP |
 |
Function |
|