Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses
Microsoft 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 ► https://www.xelplus.com/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: https://www.xelplus.com/office-2021-new-features/
LINKS to related videos:
Office 2021 official info: https://support.microsoft.com/en-us/office/what-s-new-in-office-2021-43848c29-665d-4b1b-bc12-acd2bfb3910a
Excel Functions in 2021: https://youtu.be/_EWcAR_Hkvg
How to Use XLOOKUP: https://youtu.be/4c0CLUER6nw
The New FILTER function: https://youtu.be/Eehk6PC0oGs
The LET function: https://youtu.be/D5HgyE06pXs
Dynamic Calendar with SEQUENCE: https://youtu.be/xmw1ydfpo_Q
Outlook Search: https://youtu.be/z_-Zn5e7asQ
How to make a video in PowerPoint: https://youtu.be/hisnhKK94nI
️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
RESOURCES I recommend: https://www.xelplus.com/resources/
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
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!
#excel #microsoftoffice