The Google Sheets Lab
Unleash the power behind every formula and script.
Learn the fastest ways to analyze data, automate reporting, and build tools in Google Sheets with expert guides and real workflows.
150+
Curated functions
15+
In-depth tutorials
Free
Always and forever
Function playbooks
Learn the formulas that turn raw data into real answers.
Automation blueprints
From triggers to workflows, ship repeatable time-savers.
Strategy notes
Design spreadsheets that teams can trust and scale.
Start Here
A 7-step learning path to master Sheets.
Follow a curated path that builds skills in the exact order that real spreadsheet work demands.
View the pathFunctions
Unlock the potential of Google Sheets formulas.
Master the essentials and the advanced patterns that make data feel effortless to analyze and share.
Apps Script
Automate the work that keeps repeating.
Build scripts that send reports, sync data, and keep your spreadsheets running smoothly in the background.
Dive into ScriptingFrom our blog
Practical lessons for real spreadsheets.
Learn the tactics behind dashboards, audits, and team workflows.
Blog
XLOOKUP vs INDEX/MATCH in Google Sheets (2026)
Compare XLOOKUP and INDEX/MATCH, learn when to use each, and see practical lookup patterns for modern spreadsheets.
Blog
How to Use FILTER + XLOOKUP for Dynamic Dashboards
Build dynamic Google Sheets dashboards by filtering data and mapping IDs to readable labels with XLOOKUP.
Blog
Clean Names and Emails in Google Sheets with REGEXEXTRACT and SPLIT
Extract emails, split names, and clean contact data with REGEXEXTRACT, SPLIT, and ARRAYFORMULA.
Blog
Normalize Dates in Google Sheets with DATEVALUE and TEXT
Convert date strings into real dates and standardize formats using DATEVALUE and TEXT.
Blog
Working with Dates in Google Sheets: A Comprehensive Guide
Learn how Google Sheets stores dates, handle date arithmetic, and build time-based formulas that hold up in real reporting.
Blog
How to Use Database Functions in Google Sheets
Use DSUM, DAVERAGE, and other database functions to query structured ranges with criteria — no QUERY formula required.
Blog
Advanced Conditional Formatting Techniques in Google Sheets
Go beyond simple color rules: use custom formulas, multi-condition logic, and cross-column references to make your data visually scannable.
Blog
Performing Number System Conversions in Google Sheets
Convert between binary, octal, decimal, and hex directly in Sheets using built-in conversion functions with practical examples.
Blog
How to Use Logical Functions in Google Sheets: AND, OR, NOT
Write cleaner conditional logic with AND, OR, and NOT — and see how they combine with IF to handle real multi-condition scenarios.