Speed up, simplify, and improve your Excel work with powerful new features in Microsoft Excel 365
Unlock your potential with a Free coupon code
for the "Excel Professional: Dynamic Array for Microsoft Excel 365" course by Niccolò Abate on Udemy.
This course, boasting a 5.0-star rating from 65 reviews
and with 1,753 enrolled students, provides comprehensive training in Microsoft.
Spanning approximately
2 hour(s)
30 minute(s)
, this course is delivered in Italian
and we updated the information on May 31, 2025.
To get your free access, find the coupon code at the end of this article. Happy learning!
Do you already have an excellent level of Excel but would like to learn more?
Maybe discovering all the great innovations brought by Microsoft 365 including the new Dynamic Array formulas and the let and lambda programming ones?
Then this is the course for you! Sign up now to start your learning journey!
Excel has revolutionized the way you work on your spreadsheets, making the experience much more efficient in the latest versions (2021 and 365).
I will guide you to discover the main advanced features of Excel through videos and guided exercises.
So, what are we waiting for? I am waiting for you!
NB: to follow this course you must have Excel version 365 or 2021. Versions prior to these do not support the innovative features covered by this course.
Subjects:
Thanks and some information before starting
Dynamic Array practical demonstration
The world of Dynamic Arrays
The importance of tables
Unique Function, DataSort and "#"
Dynamic drop-down menus
Filter function
XLookup
Transposed Matr
XLookup: further information
2nd Example
3rd Example
XLookup
Filter function in-depth analysis
Choose Col - Backslash
Filter ranges of numbers
Example with Transpose
Unique
Sort
Sort by
Sequence
Random matr
A Col
Stack Vert - Stack Oriz
Split text
Read function
Lambda function