Level 6 · Design
Excel Dashboards
Dashboard design in Excel
Design dashboards that look professional and are a pleasure to use: layout, colour, KPI cards, clear charts and interactive filters, finished with three complete projects.
Log in to open this level
Students log in to see their lessons and progress.
What is inside
1Dashboard thinking0/5
- D-1-1Who the dashboard is forComing soon
- D-1-2Choosing the questions and KPIsComing soon
- D-1-3Sketching before you buildComing soon
- D-1-4One page or manyComing soon
- D-1-5The anatomy of a good dashboardComing soon
2Data foundations0/5
- D-2-1Tidy data for dashboardsComing soon
- D-2-2Tables and named rangesComing soon
- D-2-3Calculation sheetsComing soon
- D-2-4PivotTables as the engineComing soon
- D-2-5Refreshing without breaking anythingComing soon
3Layout and grid0/5
- D-3-1Setting up the canvasComing soon
- D-3-2Grids, alignment and spacingComing soon
- D-3-3Visual hierarchyComing soon
- D-3-4Titles, headers and labelsComing soon
- D-3-5Designing for screen, print and phoneComing soon
4Colour and typography0/5
- D-4-1Building a paletteComing soon
- D-4-2Colour that means somethingComing soon
- D-4-3Fonts and number formatsComing soon
- D-4-4Contrast and accessibilityComing soon
- D-4-5Themes and reusable stylesComing soon
5KPI cards and scorecards0/5
- D-5-1Building a KPI cardComing soon
- D-5-2Targets and varianceComing soon
- D-5-3SparklinesComing soon
- D-5-4Icons and conditional formatsComing soon
- D-5-5Scorecards and traffic lightsComing soon
6Chart design0/5
- D-6-1Choosing the right chart for the questionComing soon
- D-6-2Cleaning up a default chartComing soon
- D-6-3Combo and dual axis chartsComing soon
- D-6-4Annotating the storyComing soon
- D-6-5Maps, funnels and other visualsComing soon
7Interactivity0/5
- D-7-1SlicersComing soon
- D-7-2TimelinesComing soon
- D-7-3Dropdown filters and linked controlsComing soon
- D-7-4Dynamic titles and drill downsComing soon
- D-7-5Buttons and navigationComing soon
8Finishing and projects0/5
- D-8-1Protecting and publishingComing soon
- D-8-2Sharing and refreshingComing soon
- D-8-3Project: a sales dashboardComing soon
- D-8-4Project: a finance dashboardComing soon
- D-8-5Project: an operations dashboardComing soon