Google Sheets SPARKLINE: inline mini charts done right
Master Google Sheets SPARKLINE to build inline mini charts inside a single cell. Options by chart type, common errors, and when to switch to a full chart.
Formulas
Excel LAMBDA: build reusable functions without VBA
Excel LAMBDA turns a duplicated formula into a named function you can call from anywhere. Learn the syntax, the traps, and how to save one — read on.
Fix the Excel #SPILL! error: 6 dynamic array causes
Excel #SPILL! error in a dynamic array formula? Here are the six causes and the exact fix for each, from blocked cells to full-column lookups.
Excel GROUPBY function: a pivot table alternative
Excel GROUPBY turns a pivot table into a single formula that updates with the source. See when to use it, the eight arguments, and common errors.
Excel Goal Seek: solve any formula backward in seconds
Excel Goal Seek reverse-solves any formula so a target value matches what you want. Step-by-step setup, common errors, and the PMT trap. Read on.
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.
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.