You’ve Been Filtering Google Sheets Data the Hard Way

An old edison style lightbulb

Every few months, someone discovers the Google Sheets QUERY function and has the same reaction: why did nobody tell me about this? Here is what it does and why it changes how you work with data.

How to Use the Gemini Sidebar in Google Sheets (And When to Use =AI() Instead)

An accountant with a butler next to him, serving a cup of tea.

The Gemini sidebar and the AI function look related because they’re both powered by Gemini. But they work in fundamentally different ways, serve different use cases, and produce results you have to handle differently. Using the wrong one for a task is like using a calculator when you needed a notebook.

How To Highlight Duplicates in Google Sheets

Highlight duplicates in Google Sheets with a single formula.

Highlighting duplicates in Google Sheets takes one formula and a conditional formatting rule. This guide shows how to do it in a single column, across multiple columns, and for entire duplicate rows, including how to flag only the second occurrence, combine multiple conditions, and fix the two most common reasons the formula stops working.