Join 400,000+ professionals in our courses here 👉 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 ► 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: xelplus.com/office-2021-new-features/
🎬 LINKS to related videos:
Office 2021 official info: support.microsoft.com/en-us/office/what-s-new-in-office-2021-43848c29-665d-4b1b-bc12-acd2bfb3910a
Excel Functions in 2021: youtu.be/_EWcAR_Hkvg
How to Use XLOOKUP: youtu.be/4c0CLUER6nw
The New FILTER function: youtu.be/Eehk6PC0oGs
The LET function: youtu.be/D5HgyE06pXs
Dynamic Calendar with SEQUENCE: youtu.be/xmw1ydfpo_Q
Outlook Search: youtu.be/z_-Zn5e7asQ
How to make a video in PowerPoint: youtu.be/hisnhKK94nI
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz/
🎥 RESOURCES I recommend: xelplus.com/resources/
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: 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
- Should You Upgrade to Office 2021 Excel Users MUST Watch... ( Download)
- Office 2021 vs Microsoft 365: what's the difference & what's new ( Download)
- What Microsoft doesn’t want you to know about Microsoft Office ( Download)
- Office 2021: All the NEW Features ( Download)
- How to install or upgrade Microsoft Office 2021 ( Download)
- 💥Microsoft Office 2021: Is it a HIT or a Miss [Explained] ✅ ( Download)
- Whats The Difference Office 2021 vs Microsoft 365 ( Download)
- How to Upgrade From Office Pro 2021 to Microsoft 365 Apps Without Re-Installing Office ( Download)
- What Your Boss Can TRACK About YOU with Microsoft Teams ( Download)
- Office 2021 vs Microsoft 365: what are the differences ( Download)
- 🔥 Office 2021 vs Office LTSC 2021 - What's the Difference ( Download)
- Use Some Creativity In Excel Sheet 😎🔥🔥 || Subscribe for More Tips and Tricks 🔥🙌 ( Download)
- How To Insert A Signature ✍️ On A PDF File #shorts ( Download)
- How to Install only specific Apps of MS Office 2021 or Office 365 ( Download)
- ⭐ Office 2021 vs Microsoft 365: Which one is right for you (Updated) ( Download)
