Griddy / Blog
Spreadsheet how-tos.
Step-by-step guides for Excel and Google Sheets formulas, data cleanup, charts, and more — and how Griddy handles each one in seconds.
Page 2 of 2 · 20 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.