Excel Reporting Dashboards

Pivot Tables & Dashboards

Knowledge Pack 5 of 7

Pivot Tables made easy - everything you need to know

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

64 Lessons


4.5 Hours


3 Quizzes

Expert Certification


What is Pivots & Dashboards?

A step-by-step guide for Excel Beginners

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 unerstand. 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.

Includes Loads of Helpful tools

When you sign up for the Reporting & Dashboards Knowledge Pack, you’ll also get a FREE copy of our “Excel Cheat Sheets” and “15 Keyboard Shortcuts” to save you time everyday.

eLearnExcel is used by the World's Leading Companies

Here’s just four you may recognize

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 utilise the inbuilt recommeded 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 Drilldown Options

Once you have your Pivot Table, we show you how to utilise 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


Senior System Administrator, FIS


Talent Manager, U.S. Bank Home Mortgage


Program Assistant, West Virginia

Module 3 : Dashboards

An introduction to Dashboards

Excel Dashboards are a very powerful way to improve your Excel Data visualisation. 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

Who would benefit from this Knowledge Pack

Excel Foundations

Finance Pro's

If you work in Banking or any Finance related role – being an Excel Master will save you hours of work each week

Excel Foundations

Data Analysts

Use your Excel Master skills to turn large data into information and help companies make better business decisions

Excel Foundations

Admin Assistants

Administrative assistants, secretaries and other administrative staff members use Excel spreadsheets for a variety of purposes

Excel Foundations


An Excel master can prepares asset, liability, and capital account entries by compiling and analyzing information

eLearnExcel has been featured in

Frequently Asked Questions

What is a Knowledge Pack?

It’s so much more than a traditional online course and it’s much more than a blog article.

I works like this:

You get unlimited access to every video. The videos take you step-by-step through the topics in a logical manner.

At the end of each module there’s a quiz, so you can check your Excel skills in the topic.

You can take the quiz as many times as you like, and when you pass you are awarded Excel Certification.

The Knowledge Pack also includes, Practice Files, so you work along with our expert. Plus, you get:

  • Tips
  • Helpful Shortcuts
  • Cheat Sheets
  • Downloadable Templates



What makes eLearnExcel unique?

There are some great online learning resources out there, and some not so great ones.

Our program is delivered by our Excel experts – who have been teaching people Excel for over 25 years.

Because we teach it every day in the classroom, we know when a topic gets tricky, so our experts take a bit more time to walk you through it.

You’ll find we are answering your questions, before you’ve had time to ask them.

Many providers script and get a voice-over artist or someone in a far flung place to read it. This means your experience is diluted and robotic.

Our learning isn’t ready from a script – it’s given to you by the same people who deliver it in the classroom every day – the same experts who have trained people in Excel for over 25 years.


Is there a guarantee?

Yes…all our Knowledge Packs have a 30-day, no-questions-asked guarantee.

In other words, if you aren’t happy for any reason, just let us know and we’ll give you your money back. We obviously don’t think it’ll come to that, but if you’re even the least bit worried if this will work for you, then put your mind at ease.

You either get the results you want or you get your money back. It’s as simple as that!

How soon do I get access?


When you purchase a Knowledge Pack or Membership, in the CHECKOUT, you’ll be asked to enter your email and create a password.

This email and password are your key to access your content.

When you’ve completed the Checkout, simply click LOG IN at the top of the page.

That’s it you’re in.

Join now and be amazing at Microsoft Excel

Share This