Charts & PivotTables · ~1 min read

Build a Simple Excel Dashboard (Beginner Friendly)

Combine PivotTables, charts and slicers into a one-page dashboard.

Video link coming soon
What you will learn

Step by step

1. One page

A dashboard is one page that answers the big questions at a glance, and lets anyone click to dig in. You can build one in five minutes.

Three pieces: a PivotTable for the numbers, a PivotChart for the picture, and a slicer for the clicks.

Build a Simple Excel Dashboard (Beginner Friendly): One page
One page

2. The numbers

The numbers: Control and T, Enter, Alt, N, V, T, place it at F1, and tick Region and Sales.

Shortcut: Ctrl + T

Build a Simple Excel Dashboard (Beginner Friendly): The numbers
The numbers

3. The picture

The picture: click inside the PivotTable and press Alt and F1. Because the source is a PivotTable, you get a PivotChart.

Build a Simple Excel Dashboard (Beginner Friendly): The picture
The picture

4. The clicks

The clicks: with the PivotTable selected, Alt, N, S, F, tick Rep with Space, and Enter.

Click Emma. The table and the chart both change: Emma sells only in the North, four thousand.

Quick pause: if your first dashboard is taking shape, a like really helps the channel. Now let's make it look clean.

Build a Simple Excel Dashboard (Beginner Friendly): The clicks
The clicks

5. Clean it up

Clear the slicer, then turn off the gridlines: Alt, W, V, G. Without the grid, the page reads like a report, not a spreadsheet.

Build a Simple Excel Dashboard (Beginner Friendly): Clean it up
Clean it up

6. The refresh trap

Now the trap. A new sale arrives: in A14 type Emma, East, nine hundred and a date.

The dashboard did not move. East still says five thousand nine hundred. Every PivotTable and chart is a snapshot until you refresh.

Press Control, Alt and F5. That is Refresh All: every PivotTable in the file updates at once. East is now six thousand eight hundred.

Build a Simple Excel Dashboard (Beginner Friendly): The refresh trap
The refresh trap

7. Recap

Recap: a PivotTable for numbers, Alt and F1 for a PivotChart, a slicer for clicks, gridlines off, and Control Alt F5 after new data.

In the next lesson, you will learn which chart type fits which question.

What would your first dashboard track: sales, budget, or something else? Tell me in the comments.

Build a Simple Excel Dashboard (Beginner Friendly): Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: Excel Slicers: Filter PivotTables with Buttons
Next tutorial: Which Chart Should You Use? (Excel Chart Types Guide) →