Courses

In this 1 day training course we look at all of the aspects of creating and manipulating Pivot tables. They are useful if you are looking to extract more meaningful information from your data. A PivotTable is an interactive table that quickly summarizes large amounts of numeric data so you can then analyse in it detail Prerequisites: Candidates should have knowledge of Excel to an advanced level and have ideally attended level1, level2 & level 3 training or have the equivalent working knowledge.

An Excel dashboard is a visual dynamic interface showing a summary of consolidated data on a single screen. On this course you will learn how to create Dashboards using the existing tools in Excel. You don’t need any knowledge of Visual Basic macros and there is no need for extra ‘add-ins’.