Office Skills
Excel & Google Sheets for Work: From Zero to Confident
Learn spreadsheets the practical way: enter and format data, write formulas, use SUM, IF, VLOOKUP and more, sort and filter, make charts, and build a real budget or inventory sheet. Works in both Excel and free Google Sheets. Quick checks in every lesson, two hands-on assignments and a certificate.
BEGINNER 278 min · 17 lessonsBy Career Forge
What you'll learn
- Enter, format and organise data clearly
- Write formulas and understand cell references
- Use SUM, AVERAGE, COUNT, MIN, MAX and IF
- Look up information with VLOOKUP or XLOOKUP
- Sort, filter and clean data
- Build charts that tell a story
- Create a working budget and an inventory tracker
Requirements
- A computer or phone with Excel or a free Google account for Google Sheets
- Basic maths (adding, percentages)
- No spreadsheet experience needed
Curriculum
Spreadsheet Basics
- 🧠 Quick check: spreadsheet basics
- 🧱 Cells, rows, columns and formattingPreview
- 👋 Welcome: why spreadsheets matterPreview
Formulas and Functions
- 🔀 Making decisions with IF
- 🔎 Looking up information
- 🧠 Formulas and functions checkpoint
- ➕ SUM, AVERAGE, COUNT, MIN and MAX
- 🧮 Your first formulas
- 🧾 Assignment 1: Build a monthly budget
Organise, Analyse and Present
- 📈 Charts that tell a story
- 📦 Pivot tables and summaries
- 🧠 Analyse and present checkpoint
- 📦 Assignment 2: Build an inventory tracker
- 🔃 Sorting, filtering and cleaning data
Final Exam: Real-World Spreadsheet
- 🧰 Spreadsheet cheat sheet
- 🏁 FINAL EXAM: Sales report for a small business
- 🎓 You did it! Certificate and what is next