| |
Introduction
to Excel Environment
Editing
a Worksheet
- Cut,
Copy & Paste Data
- Inserting
& Deleting Rows & Columns
Basic
Formulaes
- Sum, subtract
- Autosum
- Copy Formulaes
across rows & columns
- Editing Formulaes
- Viewing all
formulaes on spreadsheet
Formatting
Spreadsheet
- Changing
Font size, type, colour
- Adjusting
column & row width and height
- Using
number formats eg. currency
- Merge
cells
- Clearing
all formats
|
Creating
and Editing Charts
-
Selecting
Data to be used in chart
-
Creating
chart using shortcut key
-
Creating
chart using the Chart Wizard
-
Applying
Chart Titles using the Wizard
-
Moving
& Enlarging Chart after creation
- Printing
Charts & Data on sheet
- Deleting
Chart
Editing
a Workbook
- Inserting
& Deleting worksheets
- Renaming
worksheet
- Moving
worksheets in workbook
Printing
a Workbook
- Printing
Worksheet
- Printing
Highlighted data
- Using Header
& Footers
- Creating
a Print Title
|
|
