| Course Code |
EX-3 |
| Description: |
More advanced functions in Excel 2003 for Windows. |
| Aim: |
To teach more advanced techniques for using Excel 2003 for Windows. |
| Duration: |
1 day non-residential |
| Pre-Requisites: |
Delegates should have an understanding of the principles and techniques
associated with the Excel 2003 for Windows Introduction (EX-1) and Intermediate
(EX-2) courses. |
| Designed For: |
Staff who are required to use Excel 2003 for Windows in the course of their work who wish to build on the skills gained in the Introduction and Intermediate courses - a 3 month gap is required between completion of the intermediate course and attendance on this course. |
| Cost for Non MoD Applicants: |
The cost of this course is £225.00 excluding VAT. Details of payment options will be sent in a confirmation e-mail when you apply for the course. |
| Post Course Exercises: |
|
| Objectives: |
By the end of the course delegates will be able to: • Use Text Manipulation;
• Create Lookup Tables;
• Insert and manipulate Pivot Tables;
• IF Statements including And/Or IF Statements;
• Use Validation and Auditing;
• Create and edit Macros;
• Protecting data. |
| Related Learning: |
• Excel 2003 for Windows – Introduction (EX-1);
• Excel 2003 for Windows – Intermediate (EX-2) |
