Spreadsheets for Reports and KPIs

By Learning Hub Academy5 lessons38 min

Build and read daily and weekly reports in Excel or Google Sheets with confidence. Learn to keep data clean, use the core formulas and lookups, work out percentages and KPIs correctly, check and share a report safely, and build a one-page dashboard with tables, slicers and an actual-vs-target chart.

  • Data and reporting
  • Digital skills

What you'll learn

  • Keep report data clean with one row per record, dropdowns and safe sorting and filtering
  • Use everyday formulas, conditional counts and sums, IF, and $ to lock a cell
  • Look values up with VLOOKUP and XLOOKUP, and understand #N/A
  • Work out percentages, percentage change and KPIs correctly, and use pivot tables
  • Check totals, blanks and outliers, and share a report safely
  • Build a one-page dashboard with tables, slicers and an actual-against-target chart

Working with data

  1. 1

    Spreadsheet Basics and Clean Data

    7 min9 text and a 5-question quiz

  2. 2

    Formulas, References and Lookups

    8 min9 text and a 5-question quiz

Reports and KPIs

  1. 3

    Percentages, Pivot Tables and KPIs

    8 min9 text and a 5-question quiz

  2. 4

    Charts, Checks and Sharing Safely

    6 min7 text and a 5-question quiz

  3. 5

    Tables, Slicers and a One-page Dashboard

    9 min9 text and a 5-question quiz

The final assessment opens once every lesson is done.