Excel training workshop – EXCEL 365 New Features for controller and analyst
Controllers and analysts
This training focuses on using dynamic arrays with Excel functions available in Microsoft 365. We will show you how to leverage the power of dynamic arrays to create more efficient and dynamic reports. Thus, analyzing complex data becomes accessible to everyone. You will be able to create reports that seem very complex to set up, but that you can design using simple functions. The introduction of dynamic arrays represents the biggest change in Excel in years.
Technical precision: You must have the Microsoft 365 version of Excel.
Lesson Plan
Review :
- Tables and Named Fields
Introduction
- Formula Spill
- Availability
- Absolute and Relative References ($) - impact
- New Error Messages
Dynamic Functions
- UNIQUE
- SORT
- SORTBY
- FILTER
- SEQUENCE
- RANDARRAY
New Functions
- XLOOKUP
- IFS
- IFS + LET
Multiple Functions
- SUMIFS
- Charts
- Dropdown Lists
- Dependent Dropdown Lists
- Automating an Asset Schedule
$480.00CAD
Difficulty
Intermediate
Language:English
Format:Live Webinar
Prerequisites:None — open to all levels
Last updated : October 1, 2026
No upcoming sessions