Excel SUMPRODUCT with multiple criteria: a working guide
Use Excel SUMPRODUCT to count and sum with multiple criteria, including AND/OR logic and weighted averages — without Ctrl+Shift+Enter. Read on.
Formulas
Google Sheets FILTER function with multiple conditions
Google Sheets FILTER with multiple conditions: AND, OR, REGEXMATCH partial match, dropdown-driven criteria, and the empty-result fix. See the patterns.
Excel LET function: reusable variables in your formulas
Excel LET function lets you name a value once and reuse it through a formula — faster recalcs, cleaner code reviews. See the refactor patterns inside.
Google Sheets array literals: the curly brace guide
Build arrays inline with curly braces in Google Sheets — stack ranges, fix locale errors, feed FILTER or QUERY. Read the patterns that save real time.
Excel remove duplicates vs UNIQUE: when to use which
Excel remove duplicates vs UNIQUE function: which handles blanks, case, edge cases, and large data better, and when each one is the right pick. Read on.
IMPORTHTML in Google Sheets: pull tables from any page
IMPORTHTML in Google Sheets pulls a table or list straight from a URL. See the syntax, the index trick, QUERY slicing, and why some pages just won’t load.
Google Sheets named functions: build your own formula
Google Sheets named functions wrap long formulas behind one call. Build, debug, import, and know when a helper column wins instead. Read on.
Google Sheets REGEXREPLACE: clean messy text columns
REGEXREPLACE in Google Sheets fixes messy text in bulk — strip junk, reformat dates, standardize phones. Patterns, ARRAYFORMULA, RE2 gotchas inside.
GOOGLEFINANCE in Google Sheets: pull live stock prices
Use GOOGLEFINANCE in Google Sheets to pull live stock prices, currency rates, and historical data, with the attributes and fixes that matter. Read on.
Power Pivot DAX measures for beginners, step by step
Power Pivot DAX measures confuse most beginners. Write your first explicit measure, fix wrong grand totals, and learn SUM vs SUMX. Start here.
Excel TEXTSPLIT: split one cell into multiple columns
Excel TEXTSPLIT splits one cell into columns or rows with a single live formula. See the syntax, multi-delimiter tricks, and how to fix #SPILL errors.
Excel dependent dropdown lists: INDIRECT, Tables, or FILTER
Build a dependent dropdown in Excel three ways: INDIRECT named ranges, Excel Tables, or the Excel 365 FILTER function. See which one fits your data.