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
Spreadsheet Basics and Clean Data
7 min9 text and a 5-question quiz
- 2
Formulas, References and Lookups
8 min9 text and a 5-question quiz
Reports and KPIs
- 3
Percentages, Pivot Tables and KPIs
8 min9 text and a 5-question quiz
- 4
Charts, Checks and Sharing Safely
6 min7 text and a 5-question quiz
- 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.