Access 2003
Excel 2003
FrontPage 2003
Outlook 2003
PowerPoint 2003
Project 2003
Publisher 2003
Web
Windows XP
Word 2003
Excel 2003 - Course List
| n |
Introduction |
Half Day |
| |
Introduction to Excel. The module is suitable for users with little or no experience of spreadsheets. The course covers spreadsheet formatting, text editing and simple calculations. Incorporates module: EXL-03-02 Excel 2003 Manipulating Existing Worksheet
Ref: EXL-03-01 |
|
|
|
|
|
| n |
Manipulating Existing Worksheets |
2 Hours |
| |
Guidelines for manipulating text and data in existing spreadsheets. Incorporates topics from module: EXL-03-01 Excel 2003 Introduction
Ref: EXL-03-02 |
|
|
|
|
|
| n |
Worksheet Tools (Linking sheets & files) |
2 Hours |
| |
Introduction to working with Excel functions and linking worksheets and files. Also covers the function wizard, named ranges and absolute addressing. Incorporates topics from module: EXL-03-01 Excel 2003 Introduction
Ref: EXL-03-03 |
|
|
|
|
|
| n |
Managing Data |
2 Hours |
| |
This module will suit all users who need to build and manage lists of data. Incorporates aspects of module: EXL-03-01 Excel 2003 Introduction
Ref: EXL-03-04 |
|
|
|
|
|
| n |
Analysing Data |
2 Hours |
| |
This module will introduce users to working with analytical tools and using scenarios for what-if analysis. Features covered include pivot tables, scenario manager, report manager and solver.
Ref: EXL-03-05 |
|
|
|
|
|
| n |
Workshop |
1 Hour-1 Day |
| |
A session to cover any aspects of Excel.
Ref: EXL-03-06 |
|
|
|
|
|
| n |
Macros |
1 Day |
| |
Introduction to recording, running and assigning macros. The course covers using the Visual Basic editor to edit recorded macros.
Ref: EXL-03-07 |
|
|
|
|
|
| n |
Worksheet Functions |
2 Hours |
| |
The course explores the function wizard to write logical, string, date and other useful functions.
Ref: EXL-03-08 |
|
|
|
|
|
| n |
Creating Templates |
Half Day |
| |
Create reusable worksheet layouts using templates. Understand template components. Create a template from a worksheet.
Ref: EXL-03-09 |
|
|
|
|
|
| n |
Visual Basic for Applications |
2 Days |
| |
The course covers the fundamentals of programming using Visual Basic for Applications within Excel. The cousrse covers adding functionality and logic to recorded macros; automating repetitive tasks and communicating with the user using dialog boxes.
Ref: EXL-03-11 |
|
|
|
|
|
|
