For intermediate levels
Most suitable for advanced users of Excel who need to perform data analysis and chart reports or dashboards.
of this course is to provide students with a set of tools to analyse data captured in a database, summarize values and present it in way that is easy to read in either data form or through a chart. The student will learn to use some of the less known Pivot table tools that allow to greatly enhance the resulting table (chart).
Module 1: The Table Tool
Module 2: Pivot Tables and Pivot Charts