Should You Upgrade to Office 2021? Excel Users MUST Watch...

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

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

🎬 LINKS to related videos:

🚩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!

#excel #microsoftoffice

[LeilaGharani]

Remember: If you have Office 365 you already have all these features. Plus you'll get new features as they roll out.

[michelleaddams]

Thanks for the video!
Where I can get a cheap key for office 2021?

[rudiklein]

Even though I have Microsoft 365, I watched anyway. Some of these features are new to me. There's so much new stuff that it is hard to keep up. The big advantage of less complex formula's is not only the ease of use, but also less chance of errors. Troubleshooting these complex formula's can be so time-consuming. I think Microsoft is doing a great job.

[yash]

1:54 Spilling in Dynamic Array function - no need to dragging. hmm, that seems clean.
4:27 Automatically updating range using tables - wow, that's cool.
10:35 F9 to refresh
11:35 LET function is useful, but what's more amazing is that it took MS soo long to realise and implement this. 😄😆😅
12:45 having such a top level button for autosave is cool 👍

[richardbaron]

I've been using the xlookup function since you highlighted it months ago and it completely blows the normal index-match function away. The sort and filter functions look really handy as well. Thanks for the video.

[donald-parker]

I started creating my own library of macros and UDFs many years ago (probably around 2003 office) and it always surprised me/delighted me/frustrated me how many of my macros became obsolete with the next office release. I'm curious if you have inside view of the direction Microsoft is going. For a while it looked like the writing was on the wall for VBA and VSTO was the next big thing .... but VSTO seems to have faded into the background and VBA is alive an well. Power Query also seemed to be super powerful and made its way from Power BI to Excel fairly fast. I wonder where it is all going.

[ChadrickNurn]

I have 365 at home and at work. I used most of these functions all the time now. I love them. FILTER being my favorite and most used.

[menzoberranzam]

Love when you compare the new functions to the way we used to work without them.

[cassioalexan]

By the fact I've got Office 365, all these new features are not really new to me. However, it's always nice to watch Leila explaining them in video! There's always some example in which I learn how to apply something when I need.

[chrutnz]

Simply brilliant Leila. Your videos are so helpful. I use Excel regularly (& Word, PP, Outlook). Although a regular, basic user, I'm certainly not a power user (wish I was). I now appreciate why Microsoft has MVP's. Your contribution to the community is very much appreciated.

[maimeredith]

To get windows:
Open you internet browser and type bestkey355



Hi there. Very helpful video! However, I have a question. When I boot up my laptop, my laptop isn't able to read my brand new SSD. I already tried different solutions like downloading the F6 drivers into USB drive, initialize the brand new SSD on different computer. However, none of them work. What can I do please?12:12

[SimX]

Love these functions, use them all the time. Love 365 and you're getting constant updates.

[vojtahrabanek]

Dear Leila, I don't think that you'll ever read this comment but I havet to say to you THANK YOU! Your videos are so eyes opening and helpful, not boring long trainings. Information form U saves me so much time every day at work!

[jesus.moreno]

you are awesome ... That Is why I never miss your videos .... Muchas gracias ... Saludos desde Perú

[WowRixter]

Nice summary video of all the new Excel features. 365 is such a great value when you consider how many people you can share it with, the fact that everyone gets 1TB of storage and that you can use your license across multiple PC's. BTW if your company is a Microsoft enterprise customer, you also can get 20% off on a 365 license. I didn't get paid to say all that 😁

[LandscapeInMotion]

Thanks for the update! I did not realize about 2021 release. Must say, the UI is way nicer!

[goszarogala]

Xlookup is great function
But 'let' just blew my mind! Awesome feature when it comes to long complex formulas with the same statements
Thank You for the video

[wxkh]

the filter function is about to change the table I created to keep record of my work load. and I have office 365 ! aka Ive probably had this and simply didn’t know. thank you for teaching us so much, Leila. seriously

[shreyasbogar]

Wow. Just got laptop with MS 2019 and now this amazing 2021 is here.

[rangerfc]

Hello ma'am, our CEO shared one of your morph videos for us to use in our company presentations. I was so mesmerized by it that I had our IT guy upgrade my laptop's MS-Office 2016 to Office 365. I hope there's no constraint of Office 21 being compatible only with Windows 11 or something like that though :P