What's New - Excel 365

Learn Excel 365: use Dynamic Arrays and XLOOKUP for data analysis. Master new functions and stay updated for improved productivity.

Request a Quote ↗

Platform:

Online

In-class

Date	Venue	Duration
06 October 2026	Live/Online	1 Day

Course Introduction

Excel 2021 for Windows allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions. In mid-2020, Microsoft 365 launched a series of new formulas and functions for Excel, focusing on the capabilities on Dynamic Arrays (Excels new calculation engine)

Microsoft 365 (previously known and packaged as Office 365) is the way most organisations now subscribe to continuous updates of versions of Excel, Word, and the other “Office” products. Data analysis in Excel for Microsoft 365 has become simpler than ever. Powerful new functions that are available including:

XLOOKUP
FILTER
UNIQUE
SORT
SORTBY

Course Objectives

Upon completion of Excel 365 course, participants will be able to:

Stay Updated: Excel 365 frequently introduces new tools and features. Understanding these updates ensures you’re leveraging the latest capabilities, staying current with technological advancements.
Enhanced Productivity: New features often aim to streamline workflows and improve efficiency. Learning these updates can significantly boost productivity by introducing more efficient ways to accomplish tasks.
Advanced Data Analysis: Excel 365 updates might include more advanced data analysis tools, enabling users to perform complex analyses and visualize data in innovative ways.
Cloud Integration: Excel 365 often integrates more seamlessly with cloud services. Learning these updates allows for better collaboration and accessibility of spreadsheets across devices and locations.

Who should attend?

All Excel users. Anyone interested in saving huge amounts of time in their daily use of Excel. Business professionals who use Excel to analyse data and create reports. Managers that want to learn how to create interactive reports using dynamic array formulas.

Training Methodology

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.

Training Outline

The new Excel Engine (Dynamic Array Excel)

How you write formula will change forever
XLOOKUP, why it will kill off VLOOKUP and INDEX MATCH
Understanding impacts of using the new functions
FILTER
UNIQUE
SORT
SORTBY
SEQUENCE
#
How to handle #SPILL errors

Other Recent Features Plus Tips & Tricks

Stock and Geography Data Types
TEXTJOIN, AGGREGATE, SWITCH
Stacked Chart Totals
How to add Traffic Light Icons
Why to use Tables whenever you can
Much more…

Our Categories

View all Course Categories

Success Stories

Discover how our courses enhance professionals’ effectiveness in their workplaces.

No reviews found. Add reviews from the dashboard or switch source to Manual.

FAQs – What's New - Excel 365

Find answers about course content, certification, registration, and AI skills for executive assistants.

What is the main objective of the What's New in Excel 365 training?

This modern program is designed to bridge the gap between legacy Excel habits and the powerful, cloud-enabled features of Microsoft 365. It highlights new dynamic array engines, collaboration workflows, advanced data cleaning shortcuts, and AI-assisted functions that completely change how spreadsheet models are designed and executed.

Who should attend this modern Microsoft 365 Excel update course?

This course is built for everyday Excel users, managers, analysts, accountants, and administrators who have recently migrated (or are currently migrating) to Microsoft 365 and want to fully utilize modern features rather than relying on outdated workarounds.

What specific new features, dynamic formulas, and AI functions are covered?

The curriculum provides hands-on coverage of modern formulas (XLOOKUP, LET, LAMBDA, and VSTACK), dynamic array behaviors, the checkbox cell feature, real-time cloud co-authoring, automatic data profiling tools, Excel's integrated Python capabilities, and AI-driven data analysis functions.

How long is the program and what delivery models are available?

The training is structured as an intensive, highly visual professional development update course. It is accessible globally via live, interactive online virtual classrooms and is also hosted as an in-person, hands-on workshop for corporate groups in major business districts such as Sandton.

Does Prospen offer customized corporate or in-house workshops for this program?

Yes. Prospen offers tailored, in-house corporate training sessions specifically customized to match your organization's exact Microsoft 365 licensing tier, update channels, and security parameters, using your actual templates to modernize legacy spreadsheets.

Is there certification or post-training update materials provided?

Yes, all successful delegates receive an official Prospen Africa Certificate of Completion. Participants are also provided with an interactive Microsoft 365 cheat sheet containing formula syntax comparison guides, keyboard shortcuts for modern features, and ongoing advisory support.