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.
Excel
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.
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.
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.
Excel freeze panes vs split window: when to use which
Excel freeze panes locks one fixed strip; split window opens two scrollable views. Here’s when to pick each and the gotchas guides skip. Read on.
Excel waterfall chart for profit and loss, step by step
An Excel waterfall chart turns a P&L into a visual cumulative trail. Get the data layout, the Set as total clicks, and the floating-bar fix below.
Excel Flash Fill: extract patterns without writing formulas
Excel Flash Fill extracts patterns from text without a single formula. See how to feed it examples, fix silent misses, and when a formula is faster.
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.