Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Master Excel Functions in Office 365 – Excel Dynamic Arrays

Learn to Use Excel's NEW Functions (FILTER, UNIQUE, SORT, XLOOKUP...) to Dramatically Simplify the Work You Do in Excel.
(1,798 reviews)
10,566 students
Created by


CourseMarks Score®







Platform: Udemy
Video: 7h 8m
Language: English
Next start: On Demand

Top Excel Formulas and Functions courses:

Detailed Analysis

CourseMarks Score®

9.8 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 10/2021 .

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

9.4 / 10
We analyzed factors such as the rating (4.8/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.5 / 10
Video Score: 8.6 / 10
The course includes 7h 8m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 3 hours 28 minutes of 54 Excel Formulas and Functions courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

17 articles.
30 resources.
0 exercise.
0 test.

Table of contents


Data analysis in Excel for Microsoft 365 has become simpler than ever.
We have NEW Excel functions like XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE and MORE!
PLUS: Microsoft has changed Excel’s calculation engine.
This change impacts EVERYONE who uses Microsoft 365 version: Beginner to Advanced Excel users.
There are MULTIPLE ways you can apply Dynamic Arrays and the NEW Excel Functions to YOUR Files.
This course shows you how to MAXIMIZE the NEW Potential in Excel 365!
For example:
•Use Excel’s new FILTER Function to find multiple match results
•Use Excel’s new XLOOKUP function for complex lookups (no more VLOOKUP or Index Match)
•Create Excel Dashboard reports in MINUTES instead of HOURS
•Create Pivot Table style reports, without using Pivot Tables – no need to press “refresh” this way
•Quickly create dynamic loan amortization reports in Excel or dynamic calendars
•Master the new UNIQUE, SORT & SORTBY Excel Functions
•Use the brand new Excel RANDARRAY Function to randomly sort lists
•Use VLOOKUP, IF and SUMIFS together with Excel Dynamic Arrays formulas
In addition you’ll learn:
•How to add Interactivity to your Excel reports as never done before
•How to use the new Dynamic Arrays formulas in your files
•How Excel’s calculation engine has changed and how this impacts all existing formulas
•Compatibility & how older files behave in the new Excel and New Excel files in the old Excel
•Do Dynamic Arrays make our spreadsheets faster or slower?
•Use Dynamic Array referencing as Excel chart ranges
•Solve difficult problems – such as split text and numbers from alphanumeric values & much more…
•Most importantly – how to think outside the box to solve any challenges you come across
But First:
Do you have Excel for Microsoft 365? Then you already have dynamic arrays and the new Excel functions.
Check out the free preview video called “Do you have Dynamic Arrays?” and do the test outline in the video.
If you don’t have dynamic arrays BUT you have Excel for Microsoft 365 run the latest update to install the new features.
But please note: Excel dynamic arrays will NOT be a part of Excel 2010, Excel 2013, Excel 2016 or EVEN Excel 2019. Only in Excel 365 or Excel on the web.

Excel Dynamic Arrays are brand-new. Complex tasks will now be done with SIMPLE Excel formulas.
Everything you wished Excel could do, can now be done!
In this course you’ll solve dozens of practical real-world examples. They’ll help you think outside the box so you can work smarter not harder.
In the course you will get:
⯆ Excel Practice & Solutions Workbooks for each section
⯆ Course notes outlining the MOST IMPORTANT Concepts
⯆ Quiz questions to test your understanding

Excel can do so much for your career. It’s just one program but it’s the one hiring managers are interested in.
That’s why basic Excel skills is a mandatory requirement for most office-based professionals today.
Superior Microsoft Excel skills can get you a promotion. Some jobs require that to begin with.

The course is applicable ONLY for Excel for Microsoft 365 (Also available for Excel on the Web).
Dynamic Arrays will NOT be part of Excel 2019 perpetual license.

*** Feedback from our students ***
★★★★★ “I highly recommend this well-organized course for anyone whose work/projects involve data analysis. The knowledge I’ve gained on the new dynamic array functions will raise the level of my analysis while making my work easier at the same time. The new functions are well explained with business examples, and the course notes will be a great reference!” Jennifer

★★★★★ “This course is magical. I am sure everyone using Excel will have to upgrade their knowledge soon. Thanks for the enlightening journey.” Dheeraj

★★★★★ “Very well organized and implemented course. It was easy to follow along yet challenging enough to learn. As an example, I had never used the CHOOSE function which was your solution in one of the advanced challenges. Still wanting to try and figure out the solution on my own (without seeing yours first), I tried watching a video from another YouTube instructor on that specific function. Unfortunately, I didn’t really get it until I watched your instruction. The way you break down the components of a complex formula, showing various examples of how they work, before building up to the complete solution is a great method of teaching. Your advice for spilling component results next to the source data is an excellent method for troubleshooting formula problems…if I could only get the hang of it and remember to do it!” Stephanie

★★★★★ “I give you a big 10 for the explanation of this course, I learned a lot from it.” Jos

There’s a 100% money back guarantee. You have nothing to lose. Check out the lectures inside and see if you can apply the techniques to your work.
The course comes with lifetime access. Buy now. Watch anytime.

You will learn

✓ Master Excel’s NEW Formulas (FILTER, UNIQUE, XLOOKUP, SORT, SORTBY, SEQUENCE, RANDARRAY & More Dynamic Array Functions)
✓ Learn how to think outside the box to solve ANY Excel challenge you come across
✓ Be the FIRST to unlock the power of Microsoft Excel’s BRAND-NEW calculation engine
✓ Add INTERACTIVITY to your Excel reports as NEVER seen before (Create Pivot Table style reports, without using Pivot Tables)
✓ Maximize the NEW potential in Excel and learn how to apply the new DYNAMIC ARRAYS Formulas to make YOUR files better
✓ Get lifetime access to a proven and State-Of-The-Art Excel course including challenges, quizzes & exercises


• You HAVE Microsoft 365 & the NEW Excel Dynamic Array formulas (see the 3rd Preview lecture)You currently use Excel and are familiar with SUM, IF & VLOOKUP functions
• MAC USERS: Excel Dynamic arrays are also available in Excel for Microsoft 365 for Mac. Please note: The course is taught for Excel on Windows. If you have a Mac, I wouldn’t be able to help you if you run into problems.

This course is for

• Business Professionals who use Excel to analyze data & create reports
• You’d like a complete course to understand ALL there is to Excel’s NEW Calculation engine
• You’d like to learn how to create interactive reports with Excel dynamic array formulas

How much does the Master Excel Functions in Office 365 - Excel Dynamic Arrays course cost? Is it worth it?

The course costs $17.99. And currently there is a 82% discount on the original price of the course, which was $99.99. So you save $82 if you enroll the course now.
The average price is $12.1 of 54 Excel Formulas and Functions courses on Udemy.

Does the Master Excel Functions in Office 365 - Excel Dynamic Arrays course have a money back guarantee or refund policy?

YES, Master Excel Functions in Office 365 – Excel Dynamic Arrays has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Master Excel Functions in Office 365 - Excel Dynamic Arrays course, but there is a $82 discount from the original price ($99.99). So the current price is just $17.99.

Who is the instructor? Is Leila Gharani a SCAM or a TRUSTED instructor?

Leila Gharani has created 9 courses that got 72,655 reviews which are generally positive. Leila Gharani has taught 235,641 students and received a 4.7 average review out of 72,655 reviews. Depending on the information available, Leila Gharani is a TRUSTED instructor.
Microsoft MVP, Bestselling Instructor
Leila Gharani is a Microsoft MVP (Most Valuable Professional) dedicated to helping you create outstanding tools and reports in Excel & Google Sheets. Her courses are for those who want to shine at work, accelerate their careers and achieve more in less time.

Leila’ background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert & Project Manager. For over 15 years she has worked in the Finance and IT departments implementing reporting systems based on Oracle and SAP. All the while using Excel VBA to automate and improve processes.

Since 5 years, Leila runs her own site and has an active YouTube channel with many engaging, high quality videos. She provides customized spreadsheet dashboard seminars and enhanced visualization techniques to large corporations. She also teaches at the University of Applied Sciences in Upper Austria.

Her courses include examples based on her experience as well as  the consulting work she has done for international companies. Many of the Excel tips and tricks she shares is based on the questions received from experienced professionals in her Excel training sessions.

She places great value on keeping her courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.

Leila’s passion is learning, sharing and solving difficult data analysis problems.


CourseMarks Score®







Platform: Udemy
Video: 7h 8m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Master Excel Functions in Office 365 - Excel Dynamic Arrays
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/excel-dynamic-arrays-beginner-to-expert-microsoft-365/" target="_blank" title=" Master Excel Functions in Office 365 – Excel Dynamic Arrays on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/98.svg" width="200px" alt=" Master Excel Functions in Office 365 – Excel Dynamic Arrays rating"/></a>