Data & SpreadsheetsBeginner
Excel & Google Sheets Essentials
The spreadsheet skills every student, worker and business owner needs.
5.0 (1 rating)15 lessons1h 57m of video2 quizzes1 practical task Certificate
What you'll learn
- Create and format spreadsheets in Excel and Google Sheets
- Use formulas and functions like SUM, AVERAGE, IF and COUNTIF
- Sort and filter data to find answers quickly
- Look up information with XLOOKUP
- Summarise data with pivot tables and charts
- Understand mean, median and mode
Course content
Part 1. Spreadsheet basics3 lessons
Part 2. Formulas & functions4 lessons
Part 3. Organising & finding data4 lessons
Capstone project: Capstone project: Build a budget or results tracker. You finish by building something real; a mentor reviews it before your certificate is issued.
About this course
Spreadsheets are used in almost every job and business — for budgets, school results, sales, stock and more. This course teaches you Microsoft Excel and the free Google Sheets from the very beginning: entering data, formulas and functions, sorting and filtering, lookups, charts and pivot tables. Google Sheets is free and works on a phone, so anyone can practise.
What learners say
5.0 from 1 learner