Excel at Excel
CoursesMy learning
Log in
Excel Dashboards
Dashboard thinking
  • Who the dashboard is for
  • Choosing the questions and KPIs
  • Sketching before you build
  • One page or many
  • The anatomy of a good dashboard
Data foundations
  • Tidy data for dashboards
  • Tables and named ranges
  • Calculation sheets
  • PivotTables as the engine
  • Refreshing without breaking anything
Layout and grid
  • Setting up the canvas
  • Grids, alignment and spacing
  • Visual hierarchy
  • Titles, headers and labels
  • Designing for screen, print and phone
Colour and typography
  • Building a palette
  • Colour that means something
  • Fonts and number formats
  • Contrast and accessibility
  • Themes and reusable styles
KPI cards and scorecards
  • Building a KPI card
  • Targets and variance
  • Sparklines
  • Icons and conditional formats
  • Scorecards and traffic lights
Chart design
  • Choosing the right chart for the question
  • Cleaning up a default chart
  • Combo and dual axis charts
  • Annotating the story
  • Maps, funnels and other visuals
Interactivity
  • Slicers
  • Timelines
  • Dropdown filters and linked controls
  • Dynamic titles and drill downs
  • Buttons and navigation
Finishing and projects
  • Protecting and publishing
  • Sharing and refreshing
  • Project: a sales dashboard
  • Project: a finance dashboard
  • Project: an operations dashboard

D-4-2 · Colour and typography

11 min

Colour that means something

Log in to open this lesson

Students log in to see their lessons and progress.

Get the bundle

© 2026 Excel at Excel