Learn from home - we offer this course as a live instructor-led virtual session delivered by the same expert trainers as our classroom courses
High quality training courses
We'll match like-for-like prices*
In this Microsoft Excel Pivot Tables and Advanced Filtering training course, delegates will learn how to quickly explore and analyse raw data using Excel.
After completing this course delegates will be able to:
- Apply multiple and custom filters to data
- Enable filtering by colour
- Design and create pivot tables
- Apply pivot table calculations and report pages
- Filter pivot tables
- Multi Filters
- Filtering by Colour
- Custom Filters
- Criteria Filtering (i.e. Greater Than, Less Than, Between, Not Equal To)
- Multi Criteria Filtering (Advanced Filter)
- Multi Criteria Filtering “In Place” and “Copy of another Location”
- Designing and Creating a Pivot Table
- Modifying a Pivot Table Layout
- Updating a Pivot Table and using Pivot Table options
- Managing Pivot Table Totals and Sub Totals
- Grouping Pivot Table Data
- Creating a Pivot Table using External Data
- Filtering Pivot Tables using Slicers and Timelines
- Pivot Table “Dashboards” using Slicers
- Creating Multiple Pivot Tables on the same sheet
- Consolidating Pivot Table Data
- Pivot Table calculations
- Pivot Table Report pages
- Linking using the GETPIVOTDATA function
- Creating Pivot Charts and Modifying Pivot Charts
- Filtering Pivot Charts
This course includes:
- Training from an experienced Microsoft trainer
- Computer / Laptop to use for the duration of the course
- Detailed course notes and sample exercises
- Officeskills full colour course manual (if available)
- Free online Excel training videos
Course Key Points
Duration: 1 day
Practice Exam(s): N/A
Type: Available as Classroom, Virtual Live and In-house
Save time and money by letting our expert trainers come to your offices.
Enter your onsite training requirements below and a member of our team will be in contact with you to discuss them further.
Looking to book 4 or more delegates onto a single course?
Enter your group training requirements below and a member of our team will be in contact with you to discuss them further.
Learn new skills from our expert instructors in your own time and at your own pace.
Can’t find the course dates or training location you are looking for? We’ll try our best to accommodate.
Enter your training requirements below and a member of our team will be in contact with you to discuss them further.