Google Sheets

Learn how to use ARRAYFORMULA in Google Sheets to apply one formula across a whole range, with examples and mistakes to avoid.

Set up conditional formatting in Google Sheets. Click Format > Conditional formatting. Choose Single color, Color scale, or a custom formula.

Yes, Google Sheets works as a database, up to a point. See setup steps, exact limits with numbers, and when it's time to move to something built for the job.

Build a Google Sheets project management tracker with the exact columns, status dropdowns, formulas, and a Gantt view, plus where Sheets runs out of room.

Learn how to use the QUERY function in Google Sheets, from SELECT and WHERE to GROUP BY, plus the mistakes that cause a #VALUE! error.

There's no fixed row limit in Google Sheets, just a 20 million cell cap. Here's the exact math, the other hard caps, and how to manage both sides of it.

Turn Google Sheets into an app your team can log in to, with per-record permissions and two-way sync. Plans start at $25/month.

Learn how to create a dashboard in Google Sheets using clean summary tables, the right chart types, interactive filters, and a free copyable template.

Learn how to create a pivot table in Google Sheets to summarize data without formulas. This step-by-step guide covers common mistakes and advanced tips.

Build an inventory list sheet in six steps, with a free template and the mistakes that let counts drift from what's on the shelf.

INDEX MATCH Google Sheets tutorial with a step-by-step example, a VLOOKUP comparison, multiple criteria, lookups across files, and fixes for #N/A errors.

Download a free sales tracker template for Google Sheets, or build your own with the exact columns, dropdown values, and formulas for revenue and win rate.

Learn how to use VLOOKUP in Google Sheets, from the setup that has to be right to the step-by-step formula and why leaving out FALSE causes wrong results.

XLOOKUP in Google Sheets uses the syntax =XLOOKUP(search_key, lookup_range, result_range). See every argument, plus the mistakes that cause #N/A errors.