Course Code: exspiform
Duration: 7 hours
Prerequisites:
Overview:
This course is designed for participants who have previously worked with Microsoft Excel. We focus exclusively on functions available in Excel 365: spill formulas and the # operator, the dot (.) operator, new lookup functions, sorting and filtering functions, array helpers, text functions, and functions that improve readability and speed. Participants will learn practical patterns for building short, readable formulas without helper columns and for using dynamic arrays in everyday tasks.
Course Outline:
- Spill formulas.
- The # operator and the dot (.) operator.
- New lookup functions (XLOOKUP, XMATCH).
- New sorting and filtering functions (SORT, FILTER, UNIQUE).
- New array helpers (VSTACK, HSTACK, TOCOL, TOROW).
- New text functions (TEXTJOIN, TEXTBEFORE, TEXTAFTER).
- Functions that improve readability and performance (LET, LAMBDA, MAP).
Overview in Category: