Microsoft Excel (Advanced) 2007/2010

This course is designed to follow-on from the MS Excel Intermediate course. Having already familiarised yourself with the most efficient way of performing everyday tasks, and having covered some intermediate tasks, it is now time to build on that knowledge.

A large proportion of the course is dedicated to using the Database Features in MS Excel - this is a very powerful side to Excel that not many people utilise to its fullest potential.

Useful functions such as IF and Lookups are covered in addition to automating tasks using Macros etc.