 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel XP 2002 - Database Management and Analysis
Course Aims
This course will teach the reader about the database management and analysis aspect of Microsoft Excel XP 2002. Readers will learn about sorting and filtering, statistical functions, pivot analysis, the analysis tool pack, data analysis, auditing and charting. |
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
|
|
Sorting & Filtering
|
|
|
Statistical Functions
|
Lookup And Reference Formulae
|
|
|
|
The Analysis Tool Pack
|
Anova: Single-Factor Analysis Tool
|
|
Correlation Analysis Tool
|
|
|
|
|
Pivot Analysis
|
|
|
Data Analysis
|
|
|
|
Auditing
|
|
|
|
Charting
|
|
|
|
|
