All courses

Spreadsheets for indicators and data checks

Build a workbook that preserves the source, checks records and produces a reproducible indicator. Work with filters, pivot tables and a summary chart.

Learning objectives

Designing a table of comparable rows
Aggregation and percentages in a pivot table
Chart, reconciliation and delivery

Syllabus

  1. Data structure and quality (2)
  2. Communicating an indicator (1)
Sign in