Pivot Tables – everything you need to know
64 Lessons
4.5 Hours
2 Quizzes
Expert Certification
What is Pivots & Dashboards?
A step-by-step guide for Excel users
63 bite-size videos give you everything you need to know about Pivot Tables and Dashboards. Watch anytime, anywhere, at your own pace.
Delivered by Experts
We walk you through the entire process so you know exactly what to do and you feel confident implementing every step
Practice and check your knowledge
Downloadable Practice files make it easy to unserstand. Take the online quiz to confirm your new Excel knowledge.
Prove to others
Add CPD Certified Excel Expert Certification to your Resume to prove you have the skills to succeed and help you land that promotion.
Click an icon to see what's covered
Module 1 : Intro to Pivot Tables
What is a Pivot Table?
Pivot Tables are one of Excel’s most powerful features. They allow you to get data from a larger data set. This Module explains how.
Recommended Pivot Tables
We show you to utilize the inbuilt recommended Pivot Tables in Microsoft
Build your own Pivot Tables
We walk you through step-by-step examples of how to create your own Pivot Tables and how to edit them
Data Source, Table Styles and Drill-down Options
Once you have your Pivot Table, we show you how to utilize it
Module 2 : Advanced Pivot Tables
Slicers and Timelines
You’ll be able to filter your Pivot Table with Slicers and Timelines and see what Filters are applied
Pivot Charts
Find out how to easily represent, visually, the data in your Pivot Table, in the form of Pivot Charts. How to get the Data, Filter Connections and Design your Table
Our Excel Program just works ...
Amazing !! I love the tutorials and even though I’ve been using Excel for years, I now have many new tricks that will make my job a lot easier.
Great and very easy to follow. If you need to go over everything more than once, you can! Plus, the certificate looks great on my resume!
Very helpful, instructions are super easy and layout is step by step… I will purchase from them again – thumbs up and 5 star rating from me!!!
Module 3 : Dashboards
An introduction to Dashboards
Excel Dashboards are a very powerful way to improve your Excel Data visualization. We start at the beginning and guide step by step using examples
More Advanced Dashboards
Over 45 bite-size lessons we show you Styles, examples, the Camera Tool, and how to make your amazing Dashboard truly interactive