Pivot Table Masterclass
Learn how to summarise large amounts of Excel data effectively
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.
What will I get out of it?
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 also look at how to sort and filter pivot data, as well as formatting best practice.
What will I learn?
Summarising PivotTable Data
Adding, removing, and positioning subtotals and grand totals
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, Formatting and Filtering PivotTable Data
Creating a custom sort order
Highlighting cells by applying a rule
Highlighting the top or bottom values in a pivot table
Formatting pivot table cells using data bars
Conditional formatting rules