 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel XP 2002 - Financial Modelling
Course Aims
This course will teach the reader about the database management and analysis aspect of Microsoft Excel XP 2002. Readers will learn about multiple worksheets/workbooks, financial functions, what-if-analysis,
pivot analysis, auditing, charting and automating excel. |
Assumed Knowledge
Familiarity with basic features of MS Excel is required, gained either by previous experience or by reading our "Microsoft Excel XP 2002 Level 1; Introduction" and "Microsoft Excel XP 2002 Level 2; Intermediate" courses. |
Course Audience
Users with a basic understanding of Excel 2002 who want to consolidate and expand on their knowledge of the basic features in a short space of time. |
|
Table of Contents
|
Multiple Worksheets/Workbooks
|
Linking Worksheets/Workbooks
|
|
Editing A Data Consolidation Table
|
|
|
|
Financial Functions
|
Lookup And Reference Formulae
|
|
|
|
|
What-If-Analysis
|
|
|
Pivot Analysis
|
|
|
|
Auditing
|
|
|
|
Charting
|
|
|
|
Automating Excel
|
|
|
|
|
