| Date | Venue | Duration | |
|---|---|---|---|
| 06 October 2026 | Live/Online | 1 Day |
Please note: This is not a final registration, one of our team members will contact you shortly to finalise your registration.
Microsoft 365 (previously packaged as Office 365) is how most organisations now receive continuous updates to Excel, Word and the other Office applications — which means Excel keeps changing, and it’s easy for even experienced users to fall behind on capabilities that could be saving them hours every week. This course brings participants up to date with Excel’s modern calculation engine, built around Dynamic Arrays, and with the newer functions and AI-powered tools that have followed it.
Dynamic Arrays reshaped how formulas are written and remain the foundation of modern Excel: functions such as XLOOKUP, FILTER, UNIQUE, SORT and SORTBY have become the standard, more efficient replacement for older approaches like VLOOKUP and INDEX/MATCH. Building on that foundation, this course also covers what’s genuinely new for 2026 — including the GROUPBY and PIVOTBY aggregation functions, which let users build dynamic, formula-driven reports without a traditional PivotTable, and the growing role of Copilot and Python in Excel for AI-assisted analysis.
Upon completion of the What’s New – Excel 365 course, participants will be able to:
All Excel users — anyone interested in saving significant time in their daily use of Excel. Business professionals who use Excel to analyse data and create reports. Managers who want to learn how to build interactive reports using dynamic array formulas and modern aggregation functions.
Our diverse instructional approaches ensure effective learning:
– Lectures & Presentations: Engage with expert-driven, stimulating content.
– Course Material: Access well-crafted supporting resources.
– Group Work: Collaborate on discussions and case studies for practical insights.
– Workshops & Role-Play: Participate in immersive, scenario-based activities.
– Practical Application: Focus on applying theoretical knowledge in real situations.
– Post-Training Support: Receive extensive support after training for skill implementation.
Discover how our courses enhance professionals’ effectiveness in their workplaces.
No reviews found. Add reviews from the dashboard or switch source to Manual.
Discover what’s new in Excel 365, learning dynamic arrays, modern XLOOKUP formulas, real-time collaboration features, automated workflows, and enhanced data analysis tools for updated productivity.
Please check your email for confirmation
