Formulas & Functions
14 articles · sorted newest first
- 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