Pivot Tables Online Training Course
This course dives deep into one of the most powerful data presentation tool available to Excel. There are no pre-requisites prior to taking this course. At the end of this course you should be very confident in producing quality PivotTable dashboards that will efficiently provide solutions for data analysis. Additionally, this course can be accessed at your own time, wherever, and whenever, on your phone or computer.
Quick Stats
- 21 Walkthrough Excel Files
- 2+ hours’ worth of video content
- 172 interactive Slides
- 18 Questions
Description
This course presents the key points in building PivotTables in interactive slides, video guides, and in Excel walkthrough files. It will highlight key mistakes and design aspects to avoid when creating PivotTables, and give insight on the design approaches to take to ensure that your PivotTables are not only robust, but efficiently highlight trends in data. We also give you tips on what sort of Tables to create depending on the type of data you are working with.
Programme outline
- Introduction to PivotTables
- PivotTable Formatting
- Value Field Settings
- PivotTable Sorting
- Conditional Formatting in PivotTables
- PivotTable Filters
- PivotTable Grouping
- PivotTable Slicers
- Calculated Fields & Items
- PivotCharts
- PivotTable Dashboards
Requirements:
- Working internet connection
- Computer or handheld device
- Excel 2010, 2013 or 2016
