| Course Code |
EX-2 |
| Description: |
More complex functions in Excel 2003 for Windows. |
| Aim: |
To teach more complex 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 Excel
2003 for Windows Introduction. (After completion of this course, a 3 months gap is required before attending Excel
2003 for Windows - Advanced). |
| 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. |
| Cost for Non MoD Applicants: |
The cost of this course is £195.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 Function wizard;
• Use Statistical Functions;
• Use IF statements;
• Conditional Formatting
• Name ranges/cell notes;
• Use Dates;
• Split/freeze Window panes;
• Use Multiple worksheets and understand three dimensional formulae;
• Use lists/databases;
• Use advance filter;
• Use sub-total;
• Use Spreadsheet templates. |
| Related Learning: |
• Excel 2003 for Windows – Introduction (EX-1);
• Excel 2003 for Windows – Advanced (EX-3) |
