Master NEW Excel Functions in Office 365 & Office 2021+

Descripción

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.

Lo que aprenderás

• Master Excel's NEW Formulas (FILTER, UNIQUE, XLOOKUP, SORT, SORTBY, SEQUENCE, RANDARRAY & More Dynamic Array Functions)
• Replace complex multi-step formulas with single dynamic array formulas that update automatically
• Build interactive Pivot Table-style reports without Pivot Tables and without pressing Refresh
• Create dynamic dashboards, calendars, and loan amortization tables using SEQUENCE and array logic
• Apply Boolean logic inside FILTER to handle complex AND, OR, and combined criteria confidently
• Understand how Excel's new calculation engine affects your existing formulas and legacy files
• Set up dynamic dependent dropdowns, searchable data validation, and array-powered conditional formatting
• Debug dynamic array formulas and understand advanced concepts like array lifting, broadcasting, and implicit intersection

Requisitos

• Microsoft 365 subscription required. Dynamic arrays are not available in Excel 2019, 2016, or earlier versions.
• Basic Excel familiarity needed. If you can use SUM, IF, and VLOOKUP, you have enough to get started.
• Mac users: Dynamic arrays are available in Excel 365 for Mac, but some interface steps shown in the course may look slightly different.
• No programming or advanced Excel experience required. The course starts from the basics of dynamic arrays and builds up.