Master NEW Excel Functions in Office 365 & Office 2021
$0.99
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.
What you’ll 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
Course content
1212 sections • 91 lectures • Total duration 7 hours 7 minutes
Before You Dive In
Dynamic Arrays & Spill (hash) Behavior (What you need to know)
How Legacy Formulas are Impacted by Excel's NEW Calculation Engine
How Excel Features are Impacted by Dynamic Arrays
Becoming Advanced in Excel Dynamic Arrays
THE ONE Theory you NEED to Use Excel FILTER Function Like a Pro
Excel Array Logic & Array Constants in Excel Formulas
Interactive Reports Made Easy with Excel Dynamic Arrays
Advanced Data Analysis in Excel
Advanced to Expert: How Excel Arrays Really Work
More Advanced Excel Dynamic Array Examples
Final Words & More Learning