"Very efficient Very clear and easy to understand Simon was very accommodating in showing us functions outside the day course Easy to follow instructions Lovely lunch and snacks. Simon and Cindy are really pleasant and lovely people, I left with the feeling that I had learnt a lot Mission accomplished!"

Beginners Level Overview

You need to get answers to questions and you need them quickly. How many people buy a certain product? In which month should we discount that product? If you've yet to embrace Pivot Tables, then you won't know how quickly you can get answers. Not only that but you can within minutes create effective summary tables and charts to be used in presentations and reports.

This course is designed specifically to look at Pivot Tables. You will learn how to correctly structure data, learning various Excel formulas and functions to enable you to do this. We will also take a look at the PowerPivot plugin in Excel, giving you an opportunity to use DAX with multiple data sources.

Previous Excel experience such as writing simple formulas, along with a basic understanding of how to add rows and columns would be beneficial.