The Big Excel Energy learning center

Learn Excel dashboard design in the order that actually matters

Most dashboard tutorials start with a finished picture and a bag of tricks. I've found the order matters more than the tricks. This path starts with the source table, builds the reporting system, and only then turns it into something people can understand and use.

Joshua Cottrell-SchloemerBy Joshua Cottrell-Schloemer, 3× Microsoft Excel MVP and creator of Big Excel Energy. Built from years of dashboard work, courses, templates, and hundreds of public Excel lessons.

The shortest useful Excel dashboard curriculum is: clean data → analysis → interaction → communication → a reusable design system. Learn Excel Tables and PivotTables first. Add PivotCharts, then wire up slicers and timelines. After that, use shapes, linked text boxes, and a real hierarchy of color and type to build a deliberate interface around the working report.

Start here

A seven-stage learning path

You don't need to master all of Excel. You need a small group of skills that stack together cleanly.

Stage 00 · Decide

Does this need a dashboard?

Not every request is a dashboard. Some are an alert, some are a table or a one-off report, and some belong in a BI dashboard rather than an Excel one. It pays to know which you're holding before you build a permanent system.

Use the workflow test → Stage 01 · Structure

Build from clean data

One header row, one consistent kind of record per row, useful fields in columns, and no decorative merged cells in the source.

Build the technical pipeline → Stage 02 · Analysis

Answer questions with PivotTables

Use the source to calculate the handful of comparisons the audience actually needs, not every possible metric.

Plan the analysis → Stage 03 · Visualization

Choose the right chart

Start with the relationship you need to show, then pick the simplest honest chart for it. A trend wants a different chart than a ranking, a composition, a distribution, or a hierarchy.

Use the chart decision guide → Stage 04 · Interaction

Add slicers and timelines

Connect each control to every relevant PivotTable so one selection updates the complete view.

Make it dynamic → Stage 05 · Communication

Use Excel like PowerPoint

This is where you layer shapes, images, charts, icons, and text on top of the grid to control the reading order and explain the result.

Learn the layer model → Stage 06 · System

Build a reusable theme

Put the fonts and colors into the workbook so new charts inherit the brand instead of needing to be repaired one at a time.

Create the theme →
The complete stack

Technical skills and design skills are one job

I see dashboard work split into two camps all the time. One group protects the data: accurate definitions, clean transformations, correct calculations. The other understands the people who will use it: their questions, the operational context, and what they will actually adopt. A dashboard needs both. Perfect numbers inside a report nobody opens are not a successful outcome.

The technical foundation gives the workbook integrity. The communication layer gives it a chance to change a decision. That's why I don't treat “making it pretty” as the final cosmetic step. Layout and labeling determine whether the correct work can even be understood, and so do the chart you pick and the interaction you build.

Data foundation
Excel Tables, consistent fields, refreshable sources, definitions, and validation.
Analysis
PivotTables, formulas, comparisons, time periods, targets, and business context.
Interface
Slicers, timelines, navigation, useful states, and a clear place to start.
Communication
Hierarchy, chart choice, linked metric text, annotations, color, typography, and whitespace.
System
Theme colors, theme fonts, reusable components, spacing rules, and documented conventions.
Learn by taking things apart

A better way to practice

1
Rebuild one small report, not a giant portfolio dashboardUse a clean dataset and answer one real question. A single trend, comparison, and filter is enough to learn the system.
2
Separate the source, calculations, and presentationKeep raw data clean, analysis auditable, and the dashboard free to behave like an interface.
3
Deconstruct a working fileClick the charts, inspect the source ranges, open Report Connections, and use the Selection Pane. A finished workbook is a map of the decisions behind it.
4
Test ugly data and awkward screen sizesLong labels, missing values, new months, large numbers, and empty filters reveal whether the design is a system or only a screenshot.
5
Ask what changed for the readerIf the dashboard cannot name the decision it makes faster or safer, more decoration will not rescue it.
Full-length lessons

Watch the complete build process

The written guides are designed for reference. These longer public lessons show the decisions happening in a real workbook.

Full Excel dashboard tutorial

A roughly one-hour, four-part build covering Tables, PivotTables, PivotCharts, and slicers, then the finished, styled dashboard.

Watch the series →

45-minute core concepts lesson

The underlying technical and design concepts to understand before trying to copy a finished style.

Watch the lesson →

Ecommerce dashboard build

A complete dashboard tutorial built around ecommerce data, with the source-to-interface workflow in context.

Watch on YouTube →

Get a real Excel file to take apart

My free Excel + Design newsletter sends practical templates with the tutorial inside the workbook. Start with the file, inspect how it's built, and adapt the parts that solve your problem. If you want a small one to start on, the personal budget template is about as simple as a working dashboard gets.

Join the free newsletter →
Go deeper

Design-specific guides

Dashboard layout

Grids, margins, gutters, alignment, and a clear reading path.

Learn layout →

Color palettes

Neutrals, one accent, semantic color, accessible contrast.

Choose color →

Typography

Font choices, number hierarchy, labels, and readable sizing.

Choose type →

KPI cards

Turn one metric into a useful card with context and hierarchy.

Build KPI cards →
FAQ

Learning Excel dashboards

What should I learn first?

Start with clean tabular data and Excel Tables, then learn PivotTables and PivotCharts followed by slicers and timelines. After the technical system works, add layout, hierarchy, color and type, plus a reusable theme so you never rebuild the look.

Do I need VBA?

No. You can build genuinely useful interactive dashboards with Tables, PivotTables, PivotCharts, formulas, slicers, timelines, shapes, and linked text boxes. VBA is optional. I only reach for it when a workflow needs automation beyond those features.

Is dashboard design just making Excel look better?

No. Visual polish improves comprehension and adoption, but a strong dashboard also needs reliable source data and honest calculations, plus charts that fit the comparison, useful interaction, and a clear decision it helps someone make.