PivotTables are arguably Excel’s most powerful feature, transforming huge tables of data into instant summaries and insights with a few clicks. This masterclass equips participants to master PivotTables, covering everything from the basics to advanced techniques for analysing and presenting data.
As PivotTable skills dramatically boost data productivity, mastering them is highly valuable. This course combines PivotTable fundamentals with advanced technique and introduces emerging features in data summarisation.
Course Objectives
Upon the successful completion of this program, attendees will be able to:
- Understand PivotTable concepts
- Prepare data for PivotTables
- Create a PivotTable
- Arrange rows, columns, and values
- Apply summarisation methods
- Group and ungroup data
- Apply filters and slicers
- Use timelines
- Apply calculated fields and items
- Show values as percentages and rankings
- Build PivotCharts
- Apply PivotTable formatting
- Refresh and manage data sources
- Connect multiple tables with the data model
- Apply PivotTable best practices
- Apply emerging features in data summarisation
Course Outline
- Module 1: PivotTable Concepts
- Module 2: Preparing Data for PivotTables
- Module 3: Creating a PivotTable
- Module 4: Rows, Columns & Values
- Module 5: Summarisation Methods
- Module 6: Grouping & Ungrouping Data
- Module 7: Filters & Slicers
- Module 8: Timelines
- Module 9: Calculated Fields & Items
- Module 10: Values as Percentages & Rankings
- Module 11: PivotCharts
- Module 12: PivotTable Formatting
- Module 13: Refreshing & Managing Data Sources
- Module 14: The Data Model & Multiple Tables
- Module 15: Emerging Features in Data Summarisation
Who Should Attend
This course is intended for Excel users who want to master PivotTables for data analysis and reporting. A basic Excel foundation is recommended.
Registration & Inquiry
For more details & inquiry, please contact us at:
