| What is Excel............... |
What is a spreadsheet? |
|
How
to Access Excel
The
Spreadsheet Screen
Moving
Around the Screen
The
Pull Down Menus
The
ToolBars
|
Entering text and data |
|
AutoFill
Undoing
and Repeating Commands
|
Selecting Cells |
Saving Worksheets |
Simple Calculations |
|
AutoSum
Manually
Entering a Formula
Using
a Range
|
Amending the worksheet, Text and Formulae |
|
Inserting
Rows and Columns
Deleting
Rows and Columns
Editing
Text or Formulae
|
Formatting Cells |
|
Changing
the Font
Formatting
Numbers
Changing
Column Width
Formatting
Multiple Columns
Alignment
Borders
AutoFormat
|
Naming Ranges |
|
Create
Names
Define
Names
Using
Named Ranges
|
Copying and Moving |
|
Cut
and Paste
Copy
and Paste
Clear
Paste
Special
Paste
Special Options
Paste
Link
|
Functions |
|
Simple
Functions
Functions
in Formulae
|
Charts |
|
Creating
a Chart
Adding
a Legend
Altering
the Chart Type
Adding
Text to a Chart
Moving
and Altering the Size of a Chart
Changing
the Data Series Patterns
Chart
Rotation
Setting
the Default Chart Type
|
Printing |
|
Print
Preview
Printing
Print
Options
Page
Setup
Page
Margins
Headers
and Footers
Sheet
Selecting
a Print Area
|
 |