Microsoft just released Office 2021 which is available for both macOS and Windows. It’s made for those who do not want to enroll in the subscription model of Microsoft 365. For Excel users this is a huge jump from Excel 2016 or Excel 2019. At least 9 new functions were introduced which will change the way you use Excel. This includes XLOOKUP, FILTER, UNIQUE, and SEQUENCE.
In this video I’ll quickly explain these new functions and also which additional features you can look forward to in PowerPoint, Word and Outlook.
(Note: What’s NOT included in Excel for Office 2021 are the new Lambda and Lambda helper functions).

🌍 My Online Excel Courses β–Ί

00:00 What’s New in Office 2021
01:20 The UNIQUE Function
02:15 The FILTER Function
03:37 The SORT Function
04:58 The SORTBY Function
05:36 The XLOOKUP Function
07:33 The XMATCH Function
08:50 The SEQUENCE Function
10:09 The RANDARRAY Function
11:07 The LET Function
12:05 New Features in Excel 2021
13:38 What’s New in PowerPoint 2021
14:17 What’s New in Word 2021
14:31 What’s New in Outlook 2021
14:44 Wrap Up
14:58 My Recommendation

Link to Blog post:

🎬 LINKS to related videos:
Office 2021 official info:
Excel Functions in 2021:
How to Use XLOOKUP:
The New FILTER function:
The LET function:
Dynamic Calendar with SEQUENCE:
Outlook Search:
How to make a video in PowerPoint:

πŸŽ’ Get the Official XelPlus MERCH:

πŸŽ“ Not sure which of my Excel courses fits best for you? Take the quiz:

πŸ“š Excel RESOURCES I Recommend:

πŸŽ₯ GEAR I use:

More resources on my Amazon page:

Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #microsoftoffice