Actions and Detail Panel
Pivot Table Workshop
Wed, May 3, 2017, 9:30 AM – 12:30 PM BST
Pivot Tables in Excel provide a summary of your data, allowing you to total, count, and average entire data sets with a few clicks on the the mouse. This workshop will show you how to create a Pivot Table and how to manipulate the Pivot to show the details you require. We will also look at creating Dashboards and Slicers.
- Preparing your Source Data
- Manipulating the Pivot Table
- Formatting and Designing your Pivot
- Working with Fields
- Grouping and ungrouping
- Dashboards and Slicers
A knowledge of the fundamentals of Excel such as formatting, and basic formula such as SUM would be an useful if you wish to attend this course. All versions of Excel catered for. Please bring your own laptop, and ensure the Excel App is installed. Course bookings cannot be refunded, although every effort will be made to book you on a future course.