Excel 365 - Spill Formulas and New Functions: Clearer and Faster
Course Description
Characteristics
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 program
- 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).
Book the course
- Format: remote
- Language: Polish
- Type: public course, guaranteed
- Date: 11.02.2026
- Duration: 1 day (7h/day)
- Difficulty level: basic
- Trainer: Tomasz Urbański
Net price per participant. Guaranteed courses require only one participant.
No Budget? Get Funding!
A program that allows you to easily and quickly obtain funds for individual training participants.
Why a Guaranteed Course?
- Guaranteed implementation – the course takes place regardless of the number of participants.
- Knowledge exchange and networking with professionals from various industries.
- Interactive, live sessions – not just theory, but also practical exercises and discussions.
- Flexible online format – join from anywhere.
Need Help?
Reach out to learn more about our team and the kinds of tailored solutions we can offer your organization.
Get in Touch