Google Sheets · Professional
Lookups, conditional logic, tables and charts for everyday work.
Lessons
- 1Decisions with IFMark an online course’s exam results as Pass or Retake and calculate the points still needed.Not startedPremium lesson15 min
- 2IFS, AND & ORAssign gym membership plans and prices with IFS, OR and AND.Not startedPremium lesson16 min
- 3COUNTIF & SUMIF with WildcardsSummarise staff expense claims by category using criteria cells, operators and wildcards.Not startedPremium lesson16 min
- 4SUMIFS & COUNTIFS with Date RangesReport ticket sales for a festival by channel and date range from criteria cells.Not startedPremium lesson17 min
- 5VLOOKUP & IFNAFill a school library loan sheet from the catalogue and flag unknown codes with IFNA.Not startedPremium lesson16 min
- 6XLOOKUP and INDEX/MATCHAnswer timetable questions in both directions with XLOOKUP and INDEX/MATCH.Not startedPremium lesson17 min
- 7Cleaning Data with TRIM, PROPER & REGEXClean a marketplace product export with TRIM, PROPER, REGEXREPLACE and REGEXEXTRACT.Not startedPremium lesson18 min
- 8Scheduling with DatesPlan home renovation tasks with date arithmetic, WEEKDAY and NETWORKDAYS.Not startedPremium lesson17 min
- 9FILTER & SORT FunctionsPlan a charity’s volunteer shifts with FILTER and SORT, including empty results.Not startedPremium lesson18 min
- 10QUERY BasicsAnswer stock questions for an interior shop with QUERY select, where, order by and limit.Not startedPremium lesson20 min
- 11Reports with QUERY GROUP BYBuild a sales leaderboard and regional figures with QUERY aggregation and grouping.Not startedPremium lesson22 min
- 12Final Assessment: Accounts Receivable ReportPractical assessment: prioritise unpaid orders and report with IFS, SUMIFS, IFNA lookups, FILTER and QUERY.Not startedPremium lesson28 min
