Excel 365 - Spill Formulas and New Functions: Clearer and Faster
Training Description
Overview
This training is designed for individuals who have prior experience with Excel. The course focuses exclusively on features available in Excel 365: spill formulas and the # operator, the dot 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 helper columns and how to leverage dynamic arrays in everyday tasks.
Spill Formulas.
- The # and dot operators.
- New lookup functions (XLOOKUP, XMATCH).
- New sorting and filtering functions (SORT, FILTER, UNIQUE).
- New array handling functions (TOCOL, TOROW, MAKECOL, MAKEROW).
- New text functions (TEXTJOIN, TEXTBEFORE, TEXTAFTER).
- New functions to improve readability and speed up work (LET, LAMBDA, MAP).
Book Your Training
- Format: Remote
- Language: English
- Type: Open training, guaranteed session
- Date: 04.02.2026
- Duration: 1 day (7h/day)
- Difficulty Level: Basic
- Trainer: Tomasz Urbański
Net price per participant. Guaranteed sessions run with just one participant.
No budget? Secure funding!
A program that allows you to easily and quickly obtain funding for individual participants' training.
Why a guaranteed training?
- Delivery guarantee — the training takes place regardless of the number of participants.
- 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