Google Sheets Course Index — Dataplexa

Google Sheets
Course Index

28 Lessons · 3 Sections

Master Google Sheets for data analytics — the world's most-used collaborative spreadsheet tool. Covers QUERY, XLOOKUP, ARRAYFORMULA, Apps Script automation, BigQuery & Looker Studio integration. Includes 4 builds: sales tracker dashboard, budget planner, Apps Script automated report & KPI dashboard.

Start Course →← Back to Learning Hub

28Lessons

3Sections

4Projects

FreeAccess

Section 1Google Sheets FundamentalsLessons 1–10

Google Sheets for Data Analysis Overview

Google Sheets Interface & Navigation

Formulas Fundamentals: SUM, COUNT, IF & VLOOKUP

XLOOKUP, INDEX-MATCH & Advanced Lookups

Date & Text Functions in Google Sheets

Array Formulas & ARRAYFORMULA

Conditional Formatting for Data Insights

Data Validation, Dropdowns & Named Ranges

Pivot Tables in Google Sheets

Charts & Visualisations in Google Sheets

Section 2QUERY, Automation & IntegrationLessons 11–22

QUERY Function: SQL in Google Sheets

IMPORTRANGE & Cross-Sheet Data

Google Sheets & Google Forms: Data Collection

Google Sheets Apps Script: Automation

Connecting Google Sheets to BigQuery

Looker Studio with Google Sheets

Google Sheets for Financial Modelling

Google Sheets Collaboration & Version Control

Google Sheets Templates for Analytics

Google Sheets vs Excel 2026

Gemini in Google Sheets: AI Features 2026

Google Sheets Shortcuts & Power Tips 2026

Section 3Anti-Patterns, Best Practices & ProjectsLessons 23–28

Google Sheets Anti-Patterns

Google Sheets Best Practices 2026

Build a Sales Tracker Dashboard in Google Sheets

Build a Budget Planner with Google Sheets

Automate a Report with Google Sheets Apps Script

Build a KPI Dashboard with QUERY & Charts

Ready to Start?

Google Sheets Course Index

Start Course →← Back to Learning Hub