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