Free courseTechnology & IT
Data Analysis Basics with Spreadsheets
Learn the basics of data analysis in a spreadsheet using real Statistics Canada open data: tidy tables, cleaning, summaries, pivot tables and honest charts. Five short lessons and a quiz, with a certificate of completion.
60minutes
5lessons
1final quiz
Freecertificate of completion
What you’ll be able to do
- Follow a five-step analysis workflow from question to findings
- Lay out data in a tidy table and tell numbers, text and dates apart
- Clean a messy sheet with TRIM, PROPER, VALUE and Remove Duplicates
- Calculate average, median, range, COUNTIF and differences, and check them by hand
- Build a pivot table, group dates by month and use XLOOKUP
- Make a line chart from Statistics Canada data and write a four-sentence summary
Curriculum
01
Course lessons
5 lessons · module quiz- 01
The analysis workflow and a Statistics Canada tableLesson - 02
Cleaning a messy spreadsheetLesson - 03
Summarizing data with formulasLesson - 04
Sorting, filtering and pivot tablesLesson - 05
Charts and honest findingsLesson - 06
QUIZData Analysis Basics with Spreadsheets quizQuiz