CPS 321 / 721
This course is aimed at someone who uses, or is starting to use Excel and needs a broad understanding of the tools available.
Delegates will learn how to enter and edit information, create and apply simple formulae and build charts to visually display data.

CPS 322 / 722
This course is aimed at delegates who use Excel on a regular basis, understand the basic functionality and now want to streamline and enhance their skill set.  Delegates will learn how to sort, filter and analyse data using common functions such as If and Vlookup.  The use of absolute cell references, named ranges and conditional formatting will also be explored.

CPS 323 / 723
This course is aimed at delegates who spend substantial amounts of time working with Excel and want to understand advanced Excel functions such as building pivot tables to analyse data and creating complex charts to visually display information.  The course will also cover data validation, nested functions and an introduction to macros.

CPS 324 / 724
This course is aimed at delegates who currently make extensive use of Excel and need to take their knowledge to the next level by creating custom code solutions that make significant use of VBA.
The course will cover the basic principles of creating macros, such as declaring variables, running through loops and error handling.