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. 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, 2× 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, slicers, and timelines. Then use shapes, linked text boxes, hierarchy, color, and typography to build a deliberate interface around the working report.

Start here

A six-stage learning path

You do not need to master all of Excel. You need a small group of skills that stack together cleanly.

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—trend, ranking, composition, distribution, or hierarchy—then select the simplest honest chart.

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

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 is why I do not treat “making it pretty” as the final cosmetic step. Layout, labels, chart choice, and interaction determine whether the correct work can be understood.

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, slicers, and the finished 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 is built, and adapt the parts that solve your problem.

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, and 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, PivotCharts, slicers, and timelines. After the technical system works, add layout, hierarchy, color, typography, and reusable theme settings.

Do I need VBA?

No. Many useful interactive dashboards can be built with Tables, PivotTables, PivotCharts, formulas, slicers, timelines, shapes, and linked text boxes. VBA is optional when a workflow requires 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, honest calculations, appropriate charts, useful interaction, and a clear decision it helps someone make.