  |
|
|
|
Home |
|
Courses/Prices |
|
Qualifications |
|
Contact |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
EXCEL XP (2002)
Corporate | Individual | Tips | SAGE Accounts | SAGE Payroll | ECDL | MOS | Dreamweaver | Centre Locations
|
Beginner
|
Intermediate
|
|
| Duration | 10 hours | 10 hours |
| Suitable for | Complete beginners or for those with any other spreadsheet knowledge. | Those with knowledge of spreadsheet packages |
| Pre-requisites | Complete beginners or for those who wish to transfer their skills from any other spreadsheet package. | Excel XP beginners course or knowledge of similar spreadsheet packages |
| Course objectives | To teach the essential features of this popular spreadsheet package for work or home use. | To teach the more in depth features of this spreadsheet package for work or home use. |
| Course outline |
Introduction· Getting started· Moving around the screen· Entering text; numbers and formula· Editing cell contents· Copying and moving cell contents· Opening and saving worksheet files· Changing column widths and row heights· Changing the alignment (justification) of cells· Number formats· Freezing panes· Views & toolbars· Spreadsheet mathematics· Building formulae· Cell references in formulae · Inserting and deleting rows and columns· Formatting cells· Copying cell formats· Printing a worksheet· Print preview |
·Open and Save As· Sorting files· Working with workbooks· Managing worksheets - renaming, moving, copying, deleting and inserting· Absolute cell references· Filling cells - fill and AutoFill· Creating a series· Custom lists· AutoComplete· Cell names and comments· Page Setup - sheet and page options, margins· Headers and footers· Chart types· The chart wizard· Formatting charts· Pictures· Text boxes· Drawing Tools· Sorting data· Find and replace |
| Follow on courses | Excel XP (2002) Intermediate and Advanced courses | Other Microsoft Office packages |
|
|
 |
 |
|
 |
|
 |
|
 |