Master NEW Excel Functions in Office 365 & Office 2021+

Excel 365 got a new calculation engine. Most Excel users don't know what changed. This course fixes that.

If you use Microsoft 365, your Excel already works differently than it did a few years ago. Dynamic Arrays have fundamentally changed how formulas work.

Tasks that used to require complex multi-step formulas now take one line. Reports that took hours now take minutes.

This course shows you exactly what changed, why it matters, and how to apply it to your real work files.

What you'll be able to do after this course:

• Use FILTER to return multiple match results dynamically, replacing complex VLOOKUP and INDEX MATCH setups

• Replace VLOOKUP with XLOOKUP for faster, more flexible lookups in any direction

• Build Pivot Table-style reports using dynamic arrays without needing to press Refresh

• Create dynamic dashboards, calendars, and loan amortization tables using SEQUENCE

• Use UNIQUE, SORT, and SORTBY to build self-updating sorted lists automatically

• Set up dependent dropdown lists, searchable data validation, and conditional formatting powered by dynamic arrays

• Understand how Excel's new calculation engine affects your existing formulas and legacy files

• Apply Boolean logic inside FILTER to handle complex AND and OR conditions confidently

• Debug dynamic array formulas and understand array lifting, broadcasting, and implicit intersection

Why this course goes deeper than most:

Most Excel courses show you what a new function does. This one shows you how Excel's calculation engine actually works underneath. You'll understand why spill behavior happens, what implicit intersection means for your legacy formulas, and how to think through any dynamic array problem you haven't seen before.

That's the difference between knowing a few new functions and actually being advanced in modern Excel.

What's inside:

• Complete coverage of all major dynamic array functions: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY, XLOOKUP

• How dynamic arrays interact with existing features: charts, data validation, conditional formatting, named ranges

• Advanced topics: array constants, Boolean logic, lifting and broadcasting, CSE formula deprecation

• Interactive report building: KPI selectors, dynamic calendars, loan tables, searchable dropdowns

• Practice workbooks and solution files for every section

• Course notes covering the most important concepts

• Challenges and quizzes throughout

Important: This course requires Excel for Microsoft 365 or Excel on the web. Dynamic arrays are not available in Excel 2019, 2016, 2013, or 2010.

Taught by Leila Gharani, Microsoft MVP and trusted by 515,000+ students across 11 courses on Udemy.

Enroll now and start with whichever function you need most at work today.