This is a 1 day advanced Microsoft Excel training course focusing on the most popular formulae and functions plus working with lists and Pivot Tables. The topics are combined from our Advanced Formulae and Function and Validate and Summarise courses.
If you have attended our Intermediate course or have a good basic knowledge of Excel already you can improve your calculations further with this course. Learn the best functions you need to work with data faster and present the data better using Excel’s reporting features.
By the end of this course you will be able to use a wide range of advanced calculations, use conditional formatting to display your data in various formats and summarise large data sets more easily.


