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: 30.09.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 quickly and easily obtain funds for courses for individual participants.
Why choose a guaranteed course?
- Execution guarantee — the course takes place regardless of the number of participants.
- Knowledge exchange and networking with professionals from various industries.
- Interactive, live-led classes — not just theory, but also exercises and discussions.
- Flexible online form — 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 Touchwroclaw@nobleprog.pl or +48 (22) 103 3718