Excel 365 - Spill Formulas and New Functions: Clearer and Faster
Training Description
Overview
This training is designed for individuals who have previously worked with Excel. The course exclusively covers functions available in Excel 365: spill formulas and the # operator, the range operator, new lookup, sorting, and filtering functions, array operations, text functions, and functions that enhance readability and workflow efficiency. Participants will learn practical patterns for building concise, readable formulas without using helper columns, leveraging dynamic arrays in daily tasks.
Spill Formulas.
- The # operator and range operators.
- New lookup functions (XLOOKUP, XMATCH).
- New sorting and filtering functions (SORT, FILTER, UNIQUE).
- New array manipulation functions (TOCOL, TOROW, TRANSPOSE, TOROW).
- New text functions (TEXTJOIN, TEXTBEFORE, TEXTAFTER).
- New functions to improve readability and accelerate work (LET, LAMBDA, MAP).
Book the Training
- Format: remote
- Language: Polish
- Type: open course, guaranteed
- Date: September 30, 2026
- Duration: 7 hours
- Difficulty Level: basic
- Trainer: Tomasz Urbański
Net price per participant. Guaranteed courses run with at least one participant.
No budget? Obtain funding!
A program that allows you to easily and quickly obtain funding for individual participants' training.
Why a Guaranteed Course?
- Execution guarantee — the training takes place regardless of participant numbers.
- Knowledge exchange and networking with professionals from various industries.
- Interactive, live-led sessions — not just theory, but also 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 Touchwroclaw@nobleprog.pl or +48 (22) 103 3718