Advanced PivotTables
- Description
- Course Resources
Advanced PivotTables
- DURATION: 7.31 hours
- VIDEOS: 49
- LEVEL: Intermediate
In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function.
In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool. Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting are just a few of the subjects included in this PivotTable deep-dive.
This course is perfect for intermediate users of Excel who are comfortable using the PivotTable function. We don’t recommend this course for people brand new to Excel.
In this course, you will learn:
- How to do a PivotTable (a quick refresher)
- How to combine data from multiple worksheets for a PivotTable
- Grouping, ungrouping and dealing with errors
- How to format a PivotTable, including adjusting styles
- How to use the Value Field Settings
- Advanced Sorting and Filtering in PivotTables
- How to use Slicers, Timelines on multiple tables
- How to create a Calculated Field
- All about GETPIVOTDATA
- How to create a Pivot Chart and add sparklines and slicers
- How to use 3D Maps from a PivotTable
- How to update your data in a PivotTable and Pivot Chart
- All about Conditional Formatting in a PivotTable
- How to create a basic macro to refresh PivotTable data
Course Format
This is a video-led, Advanced Microsoft Excel training course. You can preview some videos in the pane above. This course includes practice exercises so you can practice as you learn. This course is designed for PC users and does require a working knowledge of Microsoft Excel.
This course is also suitable for Office 365 users.
Advanced PivotTables
The course comes with exercise files and instructor demo files. You will need to download both the Advanced PivotTables Exercise Files and the Advanced PivotTables Instructor Demo Files to your PC or Mac (the files are not compatible with a mobile device). Note, this course is designed to be taken on a Mac.
Click on the below to open DropBox in a new browser tab, then click on “Download” in the top right-hand corner. Once downloaded you’ll have access to all the files included.
What people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More