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.

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.