CellWorks

Google Sheets · Expert

Advanced functions, modelling and dashboards.

Lessons

  1. 1ARRAYFORMULACalculate a bakery’s pre-orders with one ARRAYFORMULA per result instead of copied formulas.Not started20 min
  2. 2Advanced QUERYAnalyse SaaS subscriptions with QUERY using and/or logic, contains, grouping and limits.Not started22 min
  3. 3Advanced FILTER LogicShortlist job applicants with multi-condition FILTER, OR logic, REGEXMATCH and nested SORT.Not started22 min
  4. 4Leaderboards with SORTN & COUNTUNIQUEBuild an esports tournament leaderboard with SORTN, COUNTUNIQUE and grouped QUERY totals.Not started22 min
  5. 5Analysing Text with Regular ExpressionsParse application log lines into level, ID and date and count errors with REGEX functions.Not started24 min
  6. 6Complex Lookups: Latest Records & Composite KeysAnswer calibration-log questions: latest result per asset, results on a date and distinct failing assets.Not started24 min
  7. 7Modelling with LETBuild a freelancer quote model with LET: rush uplift, VAT and required hours.Not started22 min
  8. 8IMPORTRANGE WorkflowsConsolidate store reports from other spreadsheets: IMPORTRANGE syntax, permissions and QUERY on imported data.Not started22 min
  9. 9Automating Form ResponsesValidate and summarise Google Form t-shirt orders automatically with ARRAYFORMULA, REGEXMATCH and COUNTUNIQUE.Not started24 min
  10. 10E-commerce KPI DashboardCalculate net revenue, margin, return rate, best channel and period revenue for a shop dashboard.Not started26 min
  11. 11Troubleshooting & OptimisationRepair a colleague’s broken Sheets formulas: QUERY case sensitivity, mismatched ranges and missing exact matches.Not started24 min
  12. 12Final Assessment: Subscription Box AnalyticsPractical assessment: analyse a subscription-box business with REGEX, ARRAYFORMULA, QUERY, FILTER, SORTN, COUNTUNIQUE and LET.Not started32 min