What You'll Learn in this Course

This course will take you from raw data to a dynamic and interactive dashboard.

Along the way, you'll learn the key tools in Excel you need in order to become an expert.

  • Import your raw data with Power Query.
  • Transform your data into a usable format with Power Query.
  • Build relational data models to analyse multi-table data sets.
  • Build Pivot Tables and Pivot Charts to summarize and visualize your data.
  • Add DAX measures to create new calculations with your data.
  • Build stylish dashboard elements with shapes and icons.
  • Add Slicers and Timelines for user interaction.
  • Layout, align and lock down your dashboards.

Course Curriculum

  Welcome
Available in days
days after you enroll
  Importing & Transforming Data with Power Query
Available in days
days after you enroll
  Building an Excel Data Model
Available in days
days after you enroll
  Creating Key Performance Indicator Data Cards (KPI's)
Available in days
days after you enroll
  Dashboard Charts
Available in days
days after you enroll
  Slicers and Timelines
Available in days
days after you enroll
  Dashboard Final Touches
Available in days
days after you enroll
  Course Feedback
Available in days
days after you enroll
  Extras
Available in days
days after you enroll

Hi, I’m John!


I’ve worked all over the world as an actuary and data analyst. I’ve been using Microsoft Excel for over 15 years.


I started the HowToExcel website in 2016 to share my passion and expertise with the world. The site now has well over 100k followers that are learning how to Excel.


In 2017, I was awarded the Microsoft Excel MVP status (most valuable professional) from Microsoft for sharing my technical expertise and knowledge with the community. This is a distinction that only 83 others around the world have been awarded!

Select a pricing plan and sign up

$67

Lifetime Course Access

FAQ's

When does the course start and finish?

The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.



How long do you have access to the course?

How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.


What are the prerequisites for the course?

You should have:

  • Have basic Excel knowledge.
  • Have Excel 2013 or higher.
  • Have Excel for a Windows PC.


What if you are unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.