Organise data cleanly
Build tables that are easy to understand and analyse.
minData & digital skills · Beginner
Spreadsheets & Data Skills
Learn structured data, spreadsheet formulas, filtering, charts and responsible interpretation for digital projects and small businesses.
minutes · Self-paced
Course overview
Learn structured data, spreadsheet formulas, filtering, charts and responsible interpretation for digital projects and small businesses. This expanded learning path includes additional applied workshops and a practical course project.
What you will learn
- Organise data cleanly
- Use formulas and functions
- Sort, filter and visualise information
- Interpret results responsibly
- Apply the skills in a practical project
- Review and improve your completed work
Skills covered
- Data structure
- Data cleaning
- Formulas
- Summary statistics
- Sorting and filtering
- Data visualisation
- Interpretation
- Reporting
Prerequisites
No previous experience is required. Practical exercises are included in every module.
Course modules
Use formulas and functions
Calculate totals and summaries from source values.
minSort, filter and visualise information
Find patterns without losing the meaning of the data.
minInterpret results responsibly
Separate a useful finding from an unsupported conclusion.
minClean and validate a dataset
Missing values, duplicates, inconsistent spellings and incorrect formats can distort analysis. Keep source data and document cleaning steps.
minStructure data consistently
A useful data table has clear headings, consistent fields and one record per row. Distinguish text, dates, categories and numeric values.
minSummarise data and choose metrics
Totals, averages, counts and ranges answer different questions. Averages can hide variation, so compare groups and examine distributions.
minVisualise and communicate findings
A chart should answer a question without exaggerating differences. Choose a suitable chart, label it clearly and state limitations; correlation does not prove causation.
min