Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 11 of 11 · 128 posts
How to Use Conditional Formatting in Excel
Conditional formatting highlights cells automatically based on rules you set — values, text, dates, formulas. Here's how to set it up, use formula-based rules, and manage rules that conflict.
Excel Date Formulas: TODAY, DATE, DATEDIF, EDATE, and More
The essential Excel date functions: get today's date, calculate days between dates, find end-of-month dates, add months, and count working days — with examples for each.
How to Make a Drop-Down List in Excel
Create data validation dropdown lists in Excel from a manual list, a cell range, or a named range — plus how to make dependent dropdowns where the second list changes based on the first selection.
How to Use VLOOKUP in Excel
VLOOKUP finds a value in a table by searching the first column and returning a result from another column. Here's exactly how it works — and when to use XLOOKUP instead.
How to Split Text in Excel (Text to Columns, TEXTSPLIT, and More)
Four ways to split text in Excel: Text to Columns wizard, TEXTSPLIT function, LEFT/MID/RIGHT formulas, and Flash Fill. The right method depends on whether you need it to stay live.
How to Use IMPORTRANGE in Google Sheets
IMPORTRANGE pulls data from one Google Sheet into another — live, automatically updated. Here's the syntax, how to grant access, common errors, and how to combine it with other functions.
Google Sheets QUERY Function: SQL for Your Spreadsheet
The QUERY function lets you filter, sort, group, and aggregate data using SQL-like syntax — without pivot tables or complex formulas. Here's how it works with practical examples.
How to Use the FILTER Function in Excel
The FILTER function returns only the rows that meet a condition — live, no manual filtering needed. Here's the syntax, single and multi-condition examples, and how to combine it with SORT.