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

Рет қаралды 275,489

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
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 ► 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: www.xelplus.com/office-2021-n...
🎬 LINKS to related videos:
Office 2021 official info: support.microsoft.com/en-us/o...
Excel Functions in 2021: • 5 Excel Functions EVER...
How to Use XLOOKUP: • How to Use the NEW & I...
The New FILTER function: • Excel FILTER Function ...
The LET function: • When You Should Use th...
Dynamic Calendar with SEQUENCE: • Create Easy Yearly Cal...
Outlook Search: • How to Use SEARCH 🔎 in...
How to make a video in PowerPoint: • How to Easily Make a V...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / 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

Пікірлер: 424

@LeilaGharani 2 жыл бұрын

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter Remember: If you have Office 365 you already have all these features. Plus you'll get new features as they roll out.

@halishahar4544 2 жыл бұрын

Thanks and your video is always helpful, I learned some new formulas today.

@medasbabu 2 жыл бұрын

I have O365, as you were showing the features, i was thinking, i have these features in O365, then what 2021, thanks for this note.

@FutureCommentary1 2 жыл бұрын

So I don't understand why my IT doesn't want the 365 option... So I JUST got 2019 this week. Is there a way to convince them that 365 is a better option? What risk are they trying to manage exactly?

@jtmoleleki3604 2 жыл бұрын

Thanks, I have learned so much and I'm so glad to have someone who able explain things so clearly, I even tried macro, and that for was amazing. Thank you again.

@jtmoleleki3604 2 жыл бұрын

Also have O365.

@michelleaddams8455 2 жыл бұрын

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

@mikerobinson5006 2 жыл бұрын

Yes, I got a key from some website, extraordinarily cheap, and it worked perfectly.

@mikerobinson5006 2 жыл бұрын

BNH-Software

@richardbaron7106 2 жыл бұрын

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.

@chrutnz 2 жыл бұрын

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.

@hometechsolutionsja4112 2 жыл бұрын

That unique and sort function is so great . Thanks for your insight. I definately appreciate your work

@rudiklein 2 жыл бұрын

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.

@LeilaGharani 2 жыл бұрын

That's true. It's not easy to troubleshoot those long formulas.

@Seawolf159 2 жыл бұрын

Except still no python...

@raphaelfrontier6245 2 жыл бұрын

Always clear and straight to the point. Thank you Leila !

@jasonipfatsiong2062 2 жыл бұрын

Truly amazing update….thank you Leila. Keep safe and take care, Jason

@jesus.moreno 2 жыл бұрын

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

@cassioalexan 2 жыл бұрын

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.

@wxkh1193 2 жыл бұрын

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

@roberthollander6826 2 жыл бұрын

I love your clear explanation, keep up the good work!

@donald-parker 2 жыл бұрын

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.

@VishwasKadrolli 2 жыл бұрын

Xmatch and LET function was something new to me. Thanks for brining this to my awareness, hopefully i can use this

@osham5206 2 жыл бұрын

You were right about getting office 365 rather than any other new versions. I have it and I enjoy it so much. Thanks for keeping us always in the loop Leila and good luck to you :)

@phillknight1 2 жыл бұрын

Fantastic videos Leila, you are improving my work streams daily

@SimX9000 2 жыл бұрын

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

@yash1152 2 жыл бұрын

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 👍

@LeilaGharani 2 жыл бұрын

Great! Thank you for sharing.

@michebernier5298 2 жыл бұрын

Thank you so much, that filter function will help alot I started during the video building it into a few sheets as you were speaking ... Amazing !

@LeilaGharani 2 жыл бұрын

Great to hear!

@menzoberranzam 2 жыл бұрын

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

@RBASB10 2 жыл бұрын

Hi Leila, thank you kindly. I absolutely love your executions. Do you have any idea how many KZfaqrs love the sound of their own voices? Thank you for your time and Effort in making this video. I’ve personally found you to be extremely informative. Thank you kindly. I’ve now subscribed to your channel. 🙏🏻

@Theportraitdude 2 жыл бұрын

I just want to say THANK YOU for all of the amazing and informative. You are hands down my go to source for Excel and gave helped me make some “beautiful monsters” of spreadsheets. My boss heard me talking about the “Awesome Excel lady” on KZfaq and I got him hooked as well. Thank you for taking the time to teach and know you are appreciated!

@LeilaGharani 2 жыл бұрын

Thanks for your support!

@wojciechm2428 2 жыл бұрын

Tahnks for sharing this. I think in the old version, the same role as the SEQUENCE function is to grab the cell with the first date in the lower right corner and pull down from the first date to the last.

@SalihArtAndTech 2 жыл бұрын

Awesome Video. I love these new Excel features 👍 Thanks

@jwf3148 2 жыл бұрын

Thank you !!! Unique and Filter will definitely become part of my habitually used tool-kit.

@LeilaGharani 2 жыл бұрын

👍

@ProjectNJ 2 жыл бұрын

GREAT information, you're the best. Keep up the good work

@HusseinKorish 2 жыл бұрын

This is valuable video that clears the new specifications ... thanks Leila

@LeilaGharani 2 жыл бұрын

You're welcome 😊

@ChadrickNurn 2 жыл бұрын

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.

@LeilaGharani 2 жыл бұрын

Thanks for sharing, Chad!

@Maximus8112 2 жыл бұрын

Thank you for your useful explanation!

@SyedMuzammilMahasanShahi 2 жыл бұрын

This is amazing. Thanks for the share.

@jelajahsebanten 2 жыл бұрын

Thanks for your support, information, so great sharing👍

@davebarnhart9624 2 жыл бұрын

Thanks Leila! I watch all of your videos and use all of these on massive stock trading datasets (400K+ entries) for an Excel app that I developed. Combining sort/unique/filter is the best!

@WowRixter 2 жыл бұрын

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 😁

@spnayagam3689 2 жыл бұрын

As usual, You educate us in your way... Thanks and keep going. All the best 👍

@LeilaGharani 2 жыл бұрын

Thanks, will do!

@LandscapeInMotion 2 жыл бұрын

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

@kensawh 2 жыл бұрын

Thanks for all your great videos

@IMQ567 2 жыл бұрын

Excellent knowledge, command and presentation.... 👍

@HamidurRahman 2 жыл бұрын

Thanks Leila" for giving such a helpful information

@abdullahalnoman4112 2 жыл бұрын

Thanks for nice explanation.

@rahulrustagi6119 2 жыл бұрын

That filter function is much appreciated. 👍👍

@markborao6144 2 жыл бұрын

Nice video ! Your content is excellent Leila. The SEQUENCE and RANDARRAY functions are very helpful. Do you have any videos on the SOLVER function ?

@Ruthless_Mind 2 жыл бұрын

I have been waiting for this like crazy ....

@anshuiway 2 жыл бұрын

The new function Let is very good it's easy our work to write formula. Nice to know about all new functions.

@christianatkin9371 2 жыл бұрын

Another great vid. Thanks

@niles_stone2540 2 жыл бұрын

Awesome video thank you

@goszarogala8322 2 жыл бұрын

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

@LeilaGharani 2 жыл бұрын

Thanks for sharing!

@zainulabdin3504 2 жыл бұрын

Once again, one of the best knowledgeable videos we see. Great work.

@LeilaGharani 2 жыл бұрын

Thank you very much!

@NJLS 2 жыл бұрын

I love your videos. they are super helpful. thank you so much :)

@LeilaGharani 2 жыл бұрын

Glad you like them, Neil!

@Rice0987 Жыл бұрын

I liked crazy old functions, cause you looked in others eyes crazy smart! :)

@alimaleki217 2 жыл бұрын

Another first-class video, Leila (hamvatan)!

@yash1152 2 жыл бұрын

niice, the chapter thumbnails are looking super neat. cool. cute QOL little thing, but adds so much to Xp. (13:38 oops, Powerpoint's one -missed- is not showing the correct one)

@philont3427 2 жыл бұрын

Great features, thank you !

@battle.gamers 2 жыл бұрын

thnks for automating my many critical reports

@k.m.zahangiralam2715 2 жыл бұрын

Very Informative ❤❤👌👌

@Tomas_F. 2 жыл бұрын

Thank you, Leila, we missed you 🤗

@surajnirankari7623 2 жыл бұрын

Super quick updates 😊👍🏻👍🏻👌🏻

@surajnirankari7623 2 жыл бұрын

@@zodiacoffshore9134 whr is question?

@rangerfc1307 2 жыл бұрын

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

@patrickschardt7724 2 жыл бұрын

Even though I won’t be switching back from 365, I’m glad Microsoft is adding some of the dynamic array functions to one and done licenses

@gospelmoto2833 2 жыл бұрын

I like it Leila. Thanks!

@vernonprevatt-usmc 2 жыл бұрын

Awesome explanation and demonstration! Thanks.

@LeilaGharani 2 жыл бұрын

Glad you enjoyed it!

@billk9856 2 жыл бұрын

Honestly, you're the best!

@rofreemail3921 2 жыл бұрын

Hi leila, I love your videos I always learn so much do you know if the new office has one note? I don’t like the 365 version I prefer the old version. Thank you for always keeping us informed

@lukmanayodeji9563 2 жыл бұрын

This is really Amazing. Keep it up Leila.

@LeilaGharani 2 жыл бұрын

Thank you so much!

@barrywalker1288 2 жыл бұрын

Brilliant as always

@Sanj803 2 жыл бұрын

There must be a SUPER LIKE button for such videos. Like always, awesome.

@surauar-raudhahkempadangse5478 2 жыл бұрын

Hi Leila, I would be very honored if any video comparison 2021 and 365 Apps for Enterprise especially for Excel user.

@wayneedmondson1065 2 жыл бұрын

Hi Leila. Microsoft 365 is the way to go. Anything else already feels dated. Thanks for sharing :)) Thumbs up!!

@flicksonj 2 жыл бұрын

Superb! Keep creating more cool content...

@DChamp56 2 жыл бұрын

Awesome video...! I wonder though, why MS doesn't put Outlook in the basic Office 2021. I've been using Outlook on my personal PC since Office XP! And, to get Outlook, it cost $100 more!

@shreyasbogar7114 2 жыл бұрын

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

@RJ-rk9nm 2 жыл бұрын

Thanks for posting this video. Looking forward to new office 2021. Would these new features, formulas, (excel) be available for those who use Mac? Thanks.

@bayusaputro4196 2 жыл бұрын

you are very awesome, thak you for sharing Laila

@garyhanson4133 2 жыл бұрын

I upgraded to office 365, with 6 licenses, but only had windows 7 machines, except for my laptop. Now I've upgraded my machines and Microsoft is telling me I only have family 365. So I just moved over to office19. Guess I'll have to make another jump. Looks fantastic. Thanks for the advice.

@TeunHam 2 жыл бұрын

Those new functions look amazing! Maybe I'm asking to much...but wouldn't it be great if you automatically create a named range based upon a "spill function" like the UNIQUE function?

@khaledsolieman1704 2 жыл бұрын

amazing as usual

@OrangeGeemer 2 жыл бұрын

"Let" is awesome!

@Amithchandr 2 жыл бұрын

Great thanks

@uniQue_XL 2 жыл бұрын

You are the best!!

@cmonster67 2 жыл бұрын

Love it, ALL of it!!!

@mlt3105 2 жыл бұрын

I'm so enlightened.

@aymannabawi2233 2 жыл бұрын

Thanks a lot, Leila

@dstaedeli 2 жыл бұрын

Thanks!!

@tjj5259 2 жыл бұрын

Hi, I like your videos, so much information very easily made understandable. Can I request you to make a video about the Windows Subsystem for Android, if possible?

@furious-choehaalen1525 2 жыл бұрын

Yes New UI Feels Nice and smooth

@johnborg5419 2 жыл бұрын

Thanks for the video Leila. Although I cannot get the latest functions because when I sign in for BETA my excel garbles especially with Data Validation. The newest functions are a handfull and fun to use too. PITY

@Soupie62 2 жыл бұрын

As a person who never uses Office 365 (for those times when I have No Internet Connection), it's good to see that there's still a full suite available to buy. Aside: where did you get the Xlookup Coffee Cup?

@manideepak6820 2 жыл бұрын

Thank you ❤️

@vojtahrabanek4185 2 жыл бұрын

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!

@LeilaGharani 2 жыл бұрын

Thank you! That’s very kind. I’m glad the videos give you ideas to save time at work 👍

@markb1935 2 жыл бұрын

As an engineering surgeryor I found this helpful, thank you.

@OhDannyboy7 2 жыл бұрын

Great video. I have excel 2010, would it be better to just upgrade to 2021 or get one of the excels in between? I have a small business but also wouldn't mind learning newer versions.

@dadofnog 2 жыл бұрын

Love your blonde hair/highlights. The more the better. Learning lots about Excel, etc.

@chrism9037 2 жыл бұрын

Thanks Leila. Glad I have 365. Worth every penny.

@LeilaGharani 2 жыл бұрын

Me too!

@tml2375 2 жыл бұрын

What would really be nice is if the sequence function also did alpha characters. Sometimes I have data in columns that I’d like to see in a row format. An example would be revenues listed by month. To do this I have to build a formula based on the column and row of the data I want to see. I have a workbook that has alpha characters stored on it. I copy what I need from here such as (C-F) and paste it into cells G25-G28 then in the next column over I add the row number in H25-H28. Let’s say the data I’m pulling from is on Row 5. From here I build the following text formula “X”&G25&H25 so it reads XC5 through XF5. I then select the range and do a copy paste special value to change the formula into text, then do a replace all on the X to change it into an equal sign ( = ) so I now have a formula that now pulls data from (Columns C-F) (Row 5) listing the data from (Jan-Apr) in a single column. I’m basically creating a transposed dynamic formula that updates when I update my spreadsheet.

@Jan.99 2 жыл бұрын

You've got an awesome voice!

@freakylocz14 Жыл бұрын

I found I was able to download my copy of Office Home & Student 2013 that I had forgotten about years ago.

@vincenzocalvo5618 2 жыл бұрын

Thank you very much, very interesting explanation. However, according to Microsoft Office support and in my experience, it seems that UNIQUE and FILTER functions are currently available only to Microsoft 365 subscribers, even if you are using Office 2021.

@mustafaemad4156 2 жыл бұрын

As usual a useful and great video, but I have one question I upgraded my office from 2019 to 2021 and I found only 3 functions : XLOOKUP, XMATCH and FILTERXML so do u think where's the problem.. Thnx in advance

@khanraseed347 2 жыл бұрын

Thanks ❤️

@henriksloth3938 2 жыл бұрын

The xlookup function already is considered an old friend. Recently I combined the Unique function with a data validation list to get the filter function behave as a pivot table (only with one filter though). A much faster performance:)

@LeilaGharani 2 жыл бұрын

👍

@lokeshchaudhari2571 2 жыл бұрын

Heyy lelia I just love ur lessons which help me a lot I hv the same request for guys like me who hv to communicate mostly in writting official mails so will u plz make a vdo where u must share ur carrer in it and how can we improve our mail writing skills