Pivot Table Masterclass Course
- Duration:75 minutes
- Cost:£99 + VAT
- Ref:
Who is it for
People who have a good understanding of Microsoft Excel 2007 and who would like to know how to manipulate and analyse data using pivot tables.
What is it about
Pivot tables are an invaluable tool to those people who need to analyse large amounts of data. They can provide an excellent snapshot of data and are incredibly helpful when producing management information.
Course Overview
This 75 minute session is a masterclass in pivot tables. It will cover how to create pivot tables, and how to summarise the data in them. It will look at how to sort and filter pivot data, as well as how to format the tables.
We recommend that you attend one of our Learn How to Learn Online sessions before attending this Virtual Classroom to ensure that you get the most out of the course. To book a free place, click here or contact us on 0800 170 7777.
What will I get out of it?
Introducing PivotTables
- Formatting data for use in a PivotTable
- Configuring a PivotTable
- Connecting to an external data source
- Managing PivotTables
Summarising PivotTable Data
- Adding, removing, and positioning subtotals and grand totals
- Changing the PivotTable data field summary operation
- Summarising more than one data field
- Creating a calculated field
- Grouping PivotTable fields
- Using PivotTable data in a formula
- Drilling down to the underlying data
Sorting and Filtering PivotTable Data
- Sorting PivotTable data
- Creating a custom sort order
- Filtering a PivotTable
- Filtering a PivotTable with report filter fields
- Clearing and reapplying PivotTable filters
Formatting PivotTables
- Highlighting cells by applying a rule
- Highlighting the top or bottom values in a PivotTable
- Formatting PivotTable cells using data bars
- Conditional formatting rules