Excel — Dashboards · Course on Udemy

Build 10 interactive Excel dashboards from scratch

A step-by-step course that takes you from raw data to one-page dashboards people actually read, with templates you can reuse at work.

★ 4.5 from 7,580 ratings on Udemy · 182 lessons · 20.5 hours · updated for Microsoft 365

Enroll on Udemy →Watch a free lesson first

30-day refund through Udemy · Lifetime access · Certificate of completion

Watch the course trailer (2:58)

Is this course for you?

Dashboards turn the report you rebuild every month into one page that updates itself.

You will get the most from it if you…

spend hours every week rebuilding the same report
copy and paste data into charts by hand
need to show results to a manager, a client or a team
know your way around Excel, but not dashboards yet

By the end you will be able to…

turn raw data into dashboard-ready tables
choose the right chart for each KPI
build interactive dashboards with pivot tables, slicers and form controls
create pro components: dynamic charts, heat maps, rankings, in-cell charts
reuse your finished dashboards as templates at work

New to Excel? Start with Excel Tips & Shortcuts first.

The 10 dashboards you will build

Each one built with you, step by step, from the raw data to the finished page.

01Company Dashboard

02Monthly Reporting Pivot Dashboard

03Pivot-KPI Dashboard

04Business Sales Dashboard

05Financial KPI Dashboard

06Balanced Scorecard

07Pivot & Slicer Dashboard

08KPI Dashboard

09Autoparts Dashboard (milestone project)

10Traffic Lights (RAG) Dashboard

What is inside

Four parts, from the first design rule to dashboards driven by macros.

1. Foundations

Dashboard design principles, the creation process, colour and layout, building a data model, keyboard shortcuts for speed and accuracy, and charting techniques with conditional formats.

2. The function toolbox and your data

VLOOKUP, INDEX and MATCH, OFFSET, SUMIFS, SUMPRODUCT, CHOOSE, text functions and custom number formats. Then bringing data in from text files, workbooks, Access and Power Query.

3. Analysis and interactivity

Pivot tables, pivot charts and slicers, GETPIVOTDATA, and form controls: drop-downs, option buttons, check boxes, list boxes and scroll bars. Plus the charts made for dashboards: bullet graphs, waffle charts, funnels, sparklines, panel charts and heat maps.

4. The ten builds, then advanced

Each dashboard built step by step, then protecting and sharing it, linking it to PowerPoint and saving it to OneDrive. The last part adds macros: navigation buttons and an animated chart with VBA.

What students say

Reviews from students of this course.

“This course blew me away. Very detailed and full of good stuff from start to finish. I thought the course was only about charts and dashboards but I learned also formulas and many Excel tips!”Mark

“What an amazing course! Very well presented and the teaching is so smooth.”Martyna

“Very detailed and well organized course. Difficult concepts are delivered easily and systematically for easy grasping. Definitely worth the time and effort.”Mandi

What is included

182 video lessons, 20.5 hours
Project files and dashboard templates
Lifetime access on any device, including the Udemy app for offline viewing
Certificate of completion
A Q&A section on every lesson
30-day refund through Udemy

Your instructor

Andreas Exadaktylos, MSc in Computer Science, has taught Excel for over 25 years and runs Mellon Training.

More than 80,000 students have taken his courses on Udemy. He also publishes free Excel tutorials on YouTube and on this site.

Questions before you start

Anything else? Write to info@mellontraining.com.

Do I need Excel experience?

You should know the basics: entering data, simple formulas and making a chart. If you are brand new to Excel, start with Excel Tips & Shortcuts.

Which version of Excel do I need?

Excel 2016 or newer, or Microsoft 365, for every feature in the course. Most techniques also work in older versions.

Where is the course hosted?

On Udemy. You buy and watch it there, keep it for life, and can learn offline in the Udemy app.

What if it is not right for me?

Udemy offers a refund within 30 days of purchase, under its refund policy.

Can I see a lesson before I buy?

Yes. Watch the free dashboard lesson on this site, or the preview lessons on the Udemy course page.

Ready to build your first dashboard?

182 lessons, 10 dashboards, and templates you keep.

Enroll on Udemy →