Excel Intermediate

This course is aimed at delegates who are using Excel to maintain lists of data and carry out some form of analysis on them. It is designed for people who need to know how to fully understand and manipulate lists to maximum effect. This will be done by covering data manipulation and filters, the more advanced mathematical and statistial analysis of data and ultimately the use of Pivot Tables within Excel.

One Day Course

Course Outline (PDF)

Course Objectives:

For delegates who use Excel to story and analyse data instea of Microsoft Access
To create and maintain a list of data that makes lists work for you
Use filters to quickly select sets of data within lists
Manipulate data into useful elements
Pivot Tables