Excel Pivot Tables & Dashboards Course

Excel Reporting Dashboards

Pivot Tables – everything you need to know

Be Brilliant at using Pivot Tables and Dashboards to impress your Boss and Colleagues

64 Lessons

}

4.5 Hours

t

3 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

What is a Pivot Table?

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

Insert and Customize Slicers

Our Excel Program just works ...

Check out what some of our customers have said

Luis

Senior System Administrator, FIS

Amanda

Talent Manager, U.S. Bank Home Mortgage

Shawn

Program Assistant, West Virginia

The Dashboard

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

Enroll now and add Excel Certification to your resume