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.
Formulas
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.
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.
Excel MAXIFS and MINIFS: conditional max and min values
Excel MAXIFS and MINIFS return the highest or lowest value that matches your criteria. See the syntax, common traps, and the row-lookup pattern.
Excel SEQUENCE function: dynamic number and date lists
Excel SEQUENCE function generates number and date series in one formula — no dragging, no re-fills when your data grows. See how it works in practice.