All courses
Basics · Beginner
Excel & Google Sheets for Work
Formulas, lookups, sorting, charts and pivot tables for budgets, sales records and reports - the spreadsheet skills almost every office job asks for.
About 1 h 30 min + project
10 lessons + 10-question quiz
3 downloads Listen to every lesson
Certificate with a project
Light on data
What you'll be able to do
- Set up clean, well-formatted tables that are easy to work with
- Write formulas with SUM, AVERAGE, IF, COUNTIF, SUMIF and more
- Use absolute references, percentages and lookups (VLOOKUP, XLOOKUP)
- Sort, filter, clean data and highlight what matters
- Build clear charts and pivot tables for reports
- Create a working sales or budget tracker you can use every day
Who it's for
Job seekers, office workers, and business owners who keep records.
Lessons
1
Spreadsheet basics: cells, data and formats
8 min
Free
2
Building a clean table
8 min
3
Your first formulas
8 min
4
Absolute references and percentages
8 min
5
Decisions with IF, COUNTIF and SUMIF
8 min
6
Looking things up: VLOOKUP and XLOOKUP
8 min
7
Sort, filter, clean and highlight
8 min
8
Charts that tell a clear story
8 min
9
Pivot tables: summaries in seconds
8 min
10
Real-world sheets: trackers, printing and sharing
8 min
Course quiz (pass mark 70%)
Project & certificate
Downloads
Practice Workbook - sample sales dataUse this data for every "Try it" task in the course. Open in Excel or Google Sheets. Formula Cheat SheetThe formulas used most at work. Examples follow the Practice Workbook: C = Category, D = Qty, E = Unit price, G = Paid, H = Total. Work in Excel and Google Sheets unless noted. Sales Tracker (with formulas)Ready to use: type Date, Item, Qty, Unit price and Paid - Total, Balance and the summary calculate themselves. Rows 2-4 are examples; replace them.Certificate project
Build a working tracker (sales, stock or budget) in Excel or Google Sheets with: (1) a clean table of at least 20 rows with a frozen header and proper number/date formats; (2) formulas including SUM, an IF, a SUMIF or COUNTIF, and an absolute reference; (3) a dropdown (data validation) and conditional formatting; (4) a VLOOKUP or XLOOKUP from a price or customer list; (5) one clear chart and one pivot table. Submit a view link (Google Sheets) or a shared OneDrive/Drive link to the file.
