| Course Code |
EX97-3 |
| Description: |
A highly interactive course which will provide the delegates with a working knowledge of the application at an advanced level. |
| Aim: |
At the end of the course the student will have a better understanding of how to utilise some of the more advanced features of Microsoft Excel 97. |
| Duration: |
2 days non-residential. |
| Pre-Requisites: |
Good knowledge of Excel or
attendance on Excel 97 for Windows – Introduction (EX97-1) & Excel 97 for
Windows – Intermediate (EX97-2). |
| Designed For: |
Personnel who already have a good working knowledge of the software |
| Objectives: |
By the end of the course delegates will have a
working knowledge of: • Linking and
Embedding Data;
• Consolidate Data;
• Nesting Formula;
• Lookup Functions;
• Calculating Filtered Data;
• Sorting and Subtotalling;
• Pivot Tables;
• Importing & Exporting with Excel. |
| Related Learning: |
• Excel 97 for Windows – Introduction (EX97-1);
• Excel 97 for Windows – Intermediate (EX97-2). |
