Formulas & Functions
22 articles · sorted newest first
- GROUPBY & PIVOTBY — build pivot-style reports with formulas new
- How to Use MAXIFS and MINIFS in Excel: Find the Highest and Lowest with Conditions
- How to Use COUNTIFS and AVERAGEIFS in Excel: Count and Average with Multiple Criteria
- How to Use SUMPRODUCT in Excel: Multiply, Sum, and Count with Conditions in One Cell
- How to Use SUMIFS to Sum with Multiple Criteria in Excel
- XLOOKUP explained — exact matches, banded lookups, returning whole rows, and the INDEX/MATCH fallback for older Excel versions
- How to Parse and Combine Text with Formulas
- How to Use the SWITCH Function Instead of Nested IF in Excel
- How to Automate Reports with Dynamic Arrays and Tables
- How to Use TEXTSPLIT, TEXTBEFORE, TEXTAFTER, and Combine Them Effectively
- How to Filter Data with the FILTER Function Using One or More Criteria and Dropdown Lists
- What Is a Recursive LAMBDA Function — and How to Use It Effectively
- Budget vs Actual | (Part 04) Variance Report & Ledger
- Formula Analysis
- Budget vs Actual | (Part 03) Actual Cost Matrix
- Budget vs Actual | (Part 02) Building the Cost Baseline
- Budget vs Actual | (Part 01) The Architecture
- LET Function: Faster Monthly Reports
- Cell references in Excel: relative, absolute, mixed, and the special operators $, # and @
- How to use LET: write cleaner and faster formulas
- How to handle errors in Excel formulas — IFERROR, IFNA, ISERROR, ISERR, ISNA and when not to hide errors at all
- Dynamic Arrays: Filter, Sort & Unique