CellWorks

Google Sheets · Professional

Lookups, conditional logic, tables and charts for everyday work.

Lessons

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