Master NEW Excel Functions in Office 365 & Office 2021

Learn to Use Excel's NEW Functions (FILTER, UNIQUE, SORT, XLOOKUP...) to Dramatically Simplify the Work You Do in Excel.

Created by: Leila Gharani
Microsoft MVP, Bestselling Instructor

What Will I 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

Requirements

• 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.

Target audience

• 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