# Master NEW Excel Functions in Office 365 & Office 2021

Master NEW Excel Functions in Office 365 & Office 2021

Last updated 8/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.39 GB | Duration: 7h 8m

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

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

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

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

*** HOW TO CHECK IF YOUR EXCEL VERSION HAS DYNAMIC ARRAYS ***

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.

*** WHY TAKE THIS SPECIFIC EXCEL COURSE? ***

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