Excel 365
Information technology (IT)Controllers and analysts
Using Dynamic Array Functions in Excel
Overview:
With dynamic array functions, analyzing complex data is now easier than ever, enabling users to create powerful reports with simple formulas. This training introduces dynamic arrays—one of Excel’s most significant advancements in recent years.
Objectives:
- Introduction to Excel 365’s dynamic array capabilities
- Explore new functions designed for dynamic arrays
- Understand the impact of dynamic arrays on existing functions
- Learn about new functions compatible with dynamic arrays
- Review practical examples and use cases
Last updated : September 24, 2026
Curriculum
Prerequisites
None — open to all levels
$480.00CAD
Lessons
51
Difficulty
Beginner
Modules:9
Language:English
Duration:6m
Format:On-Demand
Certificate:Upon completion of the course