Excel FIND vs SEARCH: case sensitivity and wildcards
Excel FIND vs SEARCH decoded: FIND is case sensitive and takes characters literally, SEARCH ignores case and reads wildcards. See where each wins.
Excel FORECAST.ETS: seasonal forecasting with confidence
Excel FORECAST.ETS predicts seasonal data with one formula. Walk through the six arguments, the seasonality recipe, confidence bands, and errors — read on.
Excel OFFSET function: dynamic ranges without slowdown
Excel OFFSET function builds ranges that shift and resize as your data changes. Learn the syntax, the volatility trap, and when to skip it entirely.
Excel INDIRECT function: build dynamic references safely
Excel INDIRECT function turns text into live cell and sheet references. See when to use it, the volatility cost, and cleaner alternatives — read on.
Excel WRAPCOLS and WRAPROWS: reshape any long list
WRAPCOLS and WRAPROWS reshape a single column of Excel data into a two-dimensional grid. Practical examples, spill traps, and how to reverse it.
Google Sheets slicers vs filter views: when to use each
Google Sheets slicers vs filter views: which one filters your dashboard, which one saves a personal slice, and how to combine them on a shared sheet. Read on.
Excel custom number formats for currency and dates
Excel custom number formats let you display currency, dates, and negatives cleanly without changing the underlying value. Here’s the code you need.
Excel PIVOTBY function: dynamic pivot in one formula
Excel PIVOTBY builds a live pivot from one formula — grouped rows, columns, aggregated values, no Refresh needed. Read on for the argument tour.
Excel TAKE and DROP: slice dynamic arrays cleanly
Excel TAKE and DROP slice any dynamic array by rows or columns from either end. Build live top-N views, strip headers, and chain them for middle slices. Read on.
Excel SCAN function: running totals in one formula
Excel SCAN function replaces sliding SUM anchors with one dynamic-array running total. See the syntax, category resets, and error traps inside.
Excel DATEDIF: calculate age and tenure the right way
Excel’s DATEDIF returns years, months, or days between two dates. Learn every unit code, the MD bug, and the tenure formula HR reports actually want.
Excel AGGREGATE function: ignore errors and hidden rows
Excel’s AGGREGATE function skips errors and hidden rows in one formula — no IFERROR wrapper, no SUBTOTAL swap. See when to reach for which option.