 |
On-Line
Computing
Maritime
House
Kingston
Street
Hull
HU1 2DB
Tel: 0870
1998 617 |
|
| |
|
MS EXCEL® "HALF
DAY USER TRAINING"© |
| Attainment Levels |
Comprehensive Excel
training is achieved by attending three incremental courses:
Introductory, Intermediate and Advanced. |
| Duration and
Location |
Each instructor-led
course is approximately half a day in length and
has a maximum of only 8
attendees. Courses take place throughout the year in a fully equipped
training suite at our Hull city centre offices adjacent to the Ice
Arena. Ample free private parking is available. |
|
COURSE DESCRIPTIONS |
| Course title |
Introduction to Microsoft Excel |
| Course objective |
To provide the attendee with the knowledge and skills
required to begin using Microsoft Excel |
|
Prerequisites |
The attendee must be able to use a Windows-based PC |
|
Topics |
Introduction |
What is
Microsoft Excel?
A tour of the screen |
|
Working in an Excel Worksheet |
Creating, saving, opening
and closing a Workbook
Entering and editing data
Copying, moving and
erasing data
Using AutoCalculate, AutoComplete and
AutoCorrectPreviewing and
printing a Worksheet
Working with named ranges
Using the Spell Check |
|
Formatting |
Formatting cells
AutoFormat |
|
Using Worksheets |
Inserting, renaming and deleting
Worksheets Simple
consolidation of Worksheets |
|
|
|
Course Title |
Microsoft Excel Intermediate |
|
Course Objective |
To further the knowledge
and skills of those using Microsoft Excel |
|
Prerequisites |
The attendee must have a
basic understanding of Microsoft Excel or have attended the Introductory
course |
|
Topics |
Charts |
Creating a Chart
Modifying Chart appearance
Printing a Chart |
|
Maps |
Creating a Map
Modifying Map appearance
Printing a Map |
|
Drawing |
Using the Drawing toolbar |
|
Macros |
What is a Macro?
Creating and running a Macro |
|
|
|
Course Title |
Microsoft Excel Advanced |
|
Course Objective |
To further the knowledge
and skills of those using Microsoft Excel |
|
Prerequisites |
The attendee must have a
good understanding of Microsoft Excel or have attended the Intermediate
course |
|
Topics |
Databases |
Sorting and querying
Creating subtotals
Working with Pivot Tables |
|
Multiple Files |
Consolidating data and
workspaces |
|
Working in an Excel
worksheet |
Styles, comments,
protection, outlines and views |
|
Functions |
Logic functions and Lookup functions
Using Scenario Manager |
|
Auditing a
Worksheet |
Exchanging data
Linking Workbooks
Inserting Objects |
|
www.onlinecomputing.net |
|