Microsoft Excel: Advanced Pivot Tables eLearning Course
- Publisher
- Simon Sez IT
- Accreditation or Endorsements
- No
- Duration
- 7 Hours 30 Minutes
Course Overview
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.
Learning Objectives:
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
This course has a minimum of 25 learner registrations for us to provide a quotation.
Request a Quotation- Date Last Updated
- 5/22/2025
- Duration
- 7 Hours 30 Minutes
- Accreditation or Endorsements
-
- No
- Completion Criteria
-
- Visit all pages
- Pass Mark
-
- None
See all details Hide details
- Includes Video
-
- Yes
- Audio is Required
-
- Yes
- Language
- UK
- Suitable Devices
-
- PC
- Tablet
- Course Technology
-
- HTML5
- SCORM 1.2
- Can be customised
-
- No
- Downloadable Resources
-
- Accessibility Files
- Exercise Files
- Languages
-
- English
Need something more specific?
Can’t find the right off-the-shelf course?
We can create bespoke eLearning around your people, processes and objectives.