| |
INTRODUCTION TO SPREADSHEETS
|
 |
Opening Screen |
 |
Using Toolbars |
 |
Setting Defaults
|
| |
CREATING A SPREADSHEET
|
 |
Creating, Opening, Saving & Summary |
 |
Information
|
| |
WORKING WITH SPREADSHEETS
|
 |
Keyboard Navigation |
 |
Selecting Text/Data |
 |
Entering Data/Text |
 |
Modifying & Deleting Data
|
| |
FORMULAE & FUNCTIONS
|
 |
Introduction to Simple Formulae |
 |
Introduction to Basic Functions |
 |
Absolute & Relative Cell Refs. |
 |
Calculation |
 |
Copying & Moving Data |
 |
Inserting & deleting Rows/Columns
|
| |
ENHANCING A SPREADSHEET
|
 |
Fonts & Colours |
 |
Borders & Shading |
 |
Alignment |
 |
Number formating |
|
| |
SETTING UP THE PRINTER PAGE
|
 |
Landscape/Portrait |
 |
Headers/Footers |
 |
Alignment
|
| |
PRINTING
|
 |
Print Preview |
 |
Previewing Sections |
 |
Print Areas |
 |
Row/Column Titles
|
| |
CUSTOM FORMATS
|
 |
Dates |
 |
Custom Lists
|
| |
SPREADSHEET PROTECTION
|
 |
Cell & Worksheet Protection
|
| |
CHARTING
|
 |
Creating & Modifying Charts |
 |
Adding New Items |
 |
Adding & Enhancing Text |
 |
Legends |
 |
Saving & Printing |
 |
Charting Options
|
| |
FILE MANAGEMENT
|
 |
Password Protection |
|