A course by David Webster
Excel 365
Information technology (IT)Controllers and analysts
Technologies
Microsoft ExcelMicrosoft 365
Learn how to create smarter, more efficient spreadsheets with Excel 365 dynamic array functions.
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
Curriculum
$360
Lessons
51
Difficulty
Beginner
Modules:9
Language:English
Duration:6h
Format:Online
Certificate:Upon completion of the course
Prerequisites:None — open to all levels
Last updated : August 22, 2025
Book for your team