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.
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?
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.
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.
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 👍
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.
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.
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.
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.
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!
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
The index match function is still the most powerful function I use. It’ pretty hard to beat an index double match function. Once you’ve mastered how to write one of these you won’t even consider using VLookup. Index match functions go hand-and-hand with tables. The key is naming the table and your columns. Just come up with a good naming convention. My naming convention is _Tbl_Data the next one could be _Tbl_2022 This way they all sort in order when looking up named ranges. Another one is _List_Month for my lists. When I start writing an index match function I start with the Match part first such as =Match(B4,_Tbl_Data[Month],0)) Then I go to the beginning right after the equal sign and add the index part Index(_Tbl_Data[Work_Days], Remembering to add a comma separator. With the finished function looking like this. =Index(_Tbl_Data[Work_Days],Match(B4,_Tbl_Data[Month],0)) The more you write them the more familiar you’ll be with. I have several workbooks that change all with the selection of the month from a drop down list. Updating two years of data for comparative analysis is nice.
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 😁
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?
I just realized this is why I haven't felt the need to upgrade Word 2013. Microsoft puts almost all it's efforts into improving Excel. I just need the word processor and would upgrade it they just added the ability to change Ribbon icons and edit right-click menus. Sorta the stuff I was able to do in word 20 years ago.
Hi Leila, thank you kindly. I absolutely love your executions. Do you have any idea how many UA-camrs 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. 🙏🏻
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
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 :)
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.
LET function has inherent issue, which is..... you cannot evaluate through F9 inside the LET function, it through error. However, it works well in the dialogue box "formula evaluation". I have bring this in the notice of Microsoft and hopefully, it will be resolved in upcoming updates.
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.
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.
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
And if you get Microsoft 365, you will (or already have if you are on insider beta) get a function called lambda, which is a total game changer even though the implementation is not on par with real lambda yet.
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:)
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 UA-cam and I got him hooked as well. Thank you for taking the time to teach and know you are appreciated!
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.
Question: Alot of our users are using Excel 2016, some 2019, we are upgrading to 2021 with the E3 licenses. The majority of the teams affected are finance. My question is can 2016 and 2019 COexist with 2021? What is the best approach to upgrade and have them adopt?
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!
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
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.
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?
im stuck at 2013 not because i can't afford it, but im worried when i share my database, no one else can use it. at the same time, im jealous with all this new features.
150 euros infinite version or 7 euros a month for 365 version. In 2021 I paid just for 3 months as I had longer holidays (not forget turn off auto subscription) . I was waiting for 2021 to make a big purchase, but now I think I will just stick with 365 on the months I have to use Ms office specifically.
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.
I may want to wait until Office 2021 becomes available in the Professional edition. Sometimes it takes a lady to make things go straight. Leila Gharani, you did a nice job in the way you presented Microsoft Office 2021 on UA-cam.
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!
I was hoping that 2021 would be similar to 2007 and allow me to get files and data where I need and have done for so long. Now 365 doesnt allow many of the data links and file open procedures I need.... oh my. Can you comment on those features ? Always great to see these hints and helper videos.
I have not worked with formulas, functions, lookups etc in Excel yet, but based on what I saw in the video simple representation sure looks better and easy to get our head around. Quick Note for Excel: AutoSave does not work locally, so you need to need sign into your account - which should not be the case. I want it saved locally.
Mr Calvo below is correct. AND the fact that many of the upgrades you demo here are really fixes for things which did not work optimally and the usual bucket load of fancy effects -- which most people do not know about because M'soft is habitually bad at giving information as it used to do 20 years ago. There is far better software available for operations you show and it tends to be far cheaper than M'soft's ludicrous prices. Calc in Libre Office seems to fulfil most basic accountancy needs in ordinary commerce but it also contains Math, which allows formula building to a sophisticated degree beyond anything M'soft has. This applies to basic CAD as well. Those of us who have long worked in education pay heed to too many glitches and students getting confused by badly described changes across MS Office. It is if M'soft's shallow gene pool is drying up and its badly damaged DNA is showing through. This perhaps helps to explain why when we review procurement we do not slavishly follow Windows any more. We assess fitness for purpose and the utter scam over Windows 11 on grounds of "added security" made us look more closely. Did MS expect the education systems of hundreds of countries to buy new machines just to run 11 instead of the superior and adaptable Win 10? By the time W10 support ceases in 2025 M'soft might not even exist and "unsupported" means nothing to IT experts in large organizations and government departments such as education, health, energy etc. As for MS Office, purchases/renewals of subscriptions are in steep decline in Europe, the UK and Commonwealth countries. Eastern Europe, the Netherlands and German speaking states have been dumping Office for years and Libre Office is well ahead on proper language alternatives and not half-hearted ones MS has always tried to sell at greedy prices. Microsoft Corp also snoops far too much and we in Europe dislike that. If we buy a product we have transacted ownership of something we expect to work for a long time without being linked outside our control to a huge corporation of increasingly dubious practices in tax, finance, privacy and product support.
Hi Leila, obviously a fan of yours. Just a worrying question... If we upgrade from Office 2019 to Office 2019, will this corrupt the formulas already created in our source tables and will there be any issues when we start using the new Office 2021 Pivot/ Power Pivot functions with excel data that was created in Office 2019? Thanks for any help you can offer.
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
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
MS has withdrawn the LAMBDA function from Excel 2021. Excel 2021 had LAMBDA and LET working during 2022. The availability of LAMBDA was always fluid but LET was always promised functionality. In late 2022, MS seems to have withdrawn support for those functions from Excel 2021. Here is a quote from an email from MS support about this issue: "Unfortunately, LAMBDA, LET and the new text functions are not available in the Office 2021 One-time purchase (perpetual) license. They are only available with a Microsoft 365 Subscription. We believe that there were issues with Excel's license authentication that may have caused these functions to appear in non-365 versions." The issue might have been an excessive interest in customer benefit, which appears to have been rectified.
Hii Leila! Glad to hear your voice..... I'm Installed windows 11.... When I watched your video I'm started to download and install Windows 11..... It's super fast and more graphics and performance so cool....... And very thank you so much for your windows 11 installation video!!!!💖💖😍💻🖥️
Sure, but unique function may be used whenever You want and it'a a function so anytime You change the data it updates automatically Remove duplicates is better if You do not need such updates
Half of these functions don't appear to be in Excel 2021 for Mac. I am missing, UNIQUE, SORT, FILTER and others. I do have XLOOKUP and LET Is there a clear list somewhere of functional availability for each version by platform? Does Microsft 365 for Mac have these?
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)
i have not used Excel much, but I know somethings and I am a computer developer. Seems like Excel is missing a general use of so called higher order functions (i.e. functions that can be sent as values and executed later). LET had it specifically, but could be used elsewhere. For instance instead of sorting a list ascending and descending order, it would be better to send a function that decides the order (you would then have functions called ascending and descending built in) which gives you even more freedom. Lots of the new stuff here exists in programming and I am a bit surprised Excel didn't get them earlier. Would have been very useful. Anyway better late than never and I hope they copy more from the programming world (probably from functional programming languages as that suits Excel best).
I have O 365, yet I only use word and publisher. Would it be better for me to just buy the individual software than keep the Residual every year? Thanks
I really need a reference for which functions and features are only in Microsoft 365, so I can avoid those functions and features to remain compatible with older Excel and Word uses.
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.
Thanks and your video is always helpful, I learned some new formulas today.
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.
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?
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.
Also have O365.
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.
That's true. It's not easy to troubleshoot those long formulas.
Except still no python...
Thanks for the video!
Where I can get a cheap key for office 2021?
Yes, I got a key from some website, extraordinarily
cheap, and it worked perfectly.
BNH-Software
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 👍
Great! Thank you for sharing.
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.
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.
Thanks for sharing, Chad!
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.
Love when you compare the new functions to the way we used to work without them.
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.
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.
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!
Thank you! That’s very kind. I’m glad the videos give you ideas to save time at work 👍
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
Love these functions, use them all the time. Love 365 and you're getting constant updates.
Yes New UI Feels Nice and smooth
Wouuuuuuu you are awesome ... That Is why I never miss your videos .... Muchas gracias ... Saludos desde Perú
Thanks for the update! I did not realize about 2021 release. Must say, the UI is way nicer!
Hi Leila. Microsoft 365 is the way to go. Anything else already feels dated. Thanks for sharing :)) Thumbs up!!
The index match function is still the most powerful function I use. It’ pretty hard to beat an index double match function. Once you’ve mastered how to write one of these you won’t even consider using VLookup. Index match functions go hand-and-hand with tables. The key is naming the table and your columns. Just come up with a good naming convention. My naming convention is _Tbl_Data the next one could be _Tbl_2022 This way they all sort in order when looking up named ranges. Another one is _List_Month for my lists. When I start writing an index match function I start with the Match part first such as =Match(B4,_Tbl_Data[Month],0)) Then I go to the beginning right after the equal sign and add the index part Index(_Tbl_Data[Work_Days], Remembering to add a comma separator.
With the finished function looking like this. =Index(_Tbl_Data[Work_Days],Match(B4,_Tbl_Data[Month],0))
The more you write them the more familiar you’ll be with. I have several workbooks that change all with the selection of the month from a drop down list. Updating two years of data for comparative analysis is nice.
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 😁
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?
I just realized this is why I haven't felt the need to upgrade Word 2013. Microsoft puts almost all it's efforts into improving Excel. I just need the word processor and would upgrade it they just added the ability to change Ribbon icons and edit right-click menus. Sorta the stuff I was able to do in word 20 years ago.
Hi Leila, thank you kindly. I absolutely love your executions.
Do you have any idea how many UA-camrs 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. 🙏🏻
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
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 :)
Hi Leila, I would be very honored if any video comparison 2021 and 365 Apps for Enterprise especially for Excel user.
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.
LET function has inherent issue, which is..... you cannot evaluate through F9 inside the LET function, it through error. However, it works well in the dialogue box "formula evaluation". I have bring this in the notice of Microsoft and hopefully, it will be resolved in upcoming updates.
Wow. Just got laptop with MS 2019 and now this amazing 2021 is here.
Fantastic videos Leila, you are improving my work streams daily
I still use MS Office 2007. Works without any problems whatsoever.
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.
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.
When do we get a new and updated outlook for windows? Outlook on MacOs is much nicer to use than the windows equivalent.
Truly amazing update….thank you Leila. Keep safe and take care, Jason
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
Thanks for sharing!
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
And if you get Microsoft 365, you will (or already have if you are on insider beta) get a function called lambda, which is a total game changer even though the implementation is not on par with real lambda yet.
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:)
👍
Super quick updates 😊👍🏻👍🏻👌🏻
@@zodiacoffshore9134 whr is question?
That filter function is much appreciated. 👍👍
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 UA-cam and I got him hooked as well. Thank you for taking the time to teach and know you are appreciated!
Thanks for your support!
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.
Question: Alot of our users are using Excel 2016, some 2019, we are upgrading to 2021 with the E3 licenses. The majority of the teams affected are finance. My question is can 2016 and 2019 COexist with 2021? What is the best approach to upgrade and have them adopt?
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!
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 !
Great to hear!
That unique and sort function is so great . Thanks for your insight. I definately appreciate your work
As an engineering surgeryor I found this helpful, thank you.
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
Xmatch and LET function was something new to me. Thanks for brining this to my awareness, hopefully i can use this
Who voted thumbs down on this video? Stop trolling this is a video I would share with my staff on new Excel features.
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.
Nice video ! Your content is excellent Leila. The SEQUENCE and RANDARRAY functions are very helpful. Do you have any videos on the SOLVER function ?
Always clear and straight to the point. Thank you Leila !
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?
im stuck at 2013 not because i can't afford it, but im worried when i share my database, no one else can use it. at the same time, im jealous with all this new features.
150 euros infinite version or 7 euros a month for 365 version. In 2021 I paid just for 3 months as I had longer holidays (not forget turn off auto subscription) . I was waiting for 2021 to make a big purchase, but now I think I will just stick with 365 on the months I have to use Ms office specifically.
The new function Let is very good it's easy our work to write formula.
Nice to know about all new functions.
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.
I liked crazy old functions, cause you looked in others eyes crazy smart! :)
I may want to wait until Office 2021 becomes available in the Professional edition. Sometimes it takes a lady to make things go straight. Leila Gharani, you did a nice job in the way you presented Microsoft Office 2021 on UA-cam.
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!
Love your blonde hair/highlights. The more the better. Learning lots about Excel, etc.
Thank you, Leila, we missed you 🤗
Excellent knowledge, command and presentation.... 👍
Please make a video on difference between Office 2021 & Office 2021 LTSC.
Thanks Leila. Glad I have 365. Worth every penny.
Me too!
3:14 , we already have FILTER option in , as a function i don't it makes a big difference
As usual, You educate us in your way... Thanks and keep going. All the best 👍
Thanks, will do!
Thank you !!! Unique and Filter will definitely become part of my habitually used tool-kit.
👍
I was hoping that 2021 would be similar to 2007 and allow me to get files and data where I need and have done for so long. Now 365 doesnt allow many of the data links and file open procedures I need.... oh my. Can you comment on those features ?
Always great to see these hints and helper videos.
I have not worked with formulas, functions, lookups etc in Excel yet, but based on what I saw in the video simple representation sure looks better and easy to get our head around.
Quick Note for Excel: AutoSave does not work locally, so you need to need sign into your account - which should not be the case. I want it saved locally.
Awesome Video. I love these new Excel features 👍 Thanks
Another first-class video, Leila (hamvatan)!
Mr Calvo below is correct. AND the fact that many of the upgrades you demo here are really fixes for things which did not work optimally and the usual bucket load of fancy effects -- which most people do not know about because M'soft is habitually bad at giving information as it used to do 20 years ago.
There is far better software available for operations you show and it tends to be far cheaper than M'soft's ludicrous prices. Calc in Libre Office seems to fulfil most basic accountancy needs in ordinary commerce but it also contains Math, which allows formula building to a sophisticated degree beyond anything M'soft has. This applies to basic CAD as well.
Those of us who have long worked in education pay heed to too many glitches and students getting confused by badly described changes across MS Office. It is if M'soft's shallow gene pool is drying up and its badly damaged DNA is showing through.
This perhaps helps to explain why when we review procurement we do not slavishly follow Windows any more. We assess fitness for purpose and the utter scam over Windows 11 on grounds of "added security" made us look more closely. Did MS expect the education systems of hundreds of countries to buy new machines just to run 11 instead of the superior and adaptable Win 10? By the time W10 support ceases in 2025 M'soft might not even exist and "unsupported" means nothing to IT experts in large organizations and government departments such as education, health, energy etc.
As for MS Office, purchases/renewals of subscriptions are in steep decline in Europe, the UK and Commonwealth countries. Eastern Europe, the Netherlands and German speaking states have been dumping Office for years and Libre Office is well ahead on proper language alternatives and not half-hearted ones MS has always tried to sell at greedy prices.
Microsoft Corp also snoops far too much and we in Europe dislike that. If we buy a product we have transacted ownership of something we expect to work for a long time without being linked outside our control to a huge corporation of increasingly dubious practices in tax, finance, privacy and product support.
Hi Leila, obviously a fan of yours. Just a worrying question... If we upgrade from Office 2019 to Office 2019, will this corrupt the formulas already created in our source tables and will there be any issues when we start using the new Office 2021 Pivot/ Power Pivot functions with excel data that was created in Office 2019? Thanks for any help you can offer.
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
I love your clear explanation, keep up the good work!
GREAT information, you're the best. Keep up the good work
Once again, one of the best knowledgeable videos we see. Great work.
Thank you very much!
"Let" is awesome!
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
MS has withdrawn the LAMBDA function from Excel 2021. Excel 2021 had LAMBDA and LET working during 2022. The availability of LAMBDA was always fluid but LET was always promised functionality. In late 2022, MS seems to have withdrawn support for those functions from Excel 2021. Here is a quote from an email from MS support about this issue: "Unfortunately, LAMBDA, LET and the new text functions are not available in the Office 2021 One-time purchase (perpetual) license. They are only available with a Microsoft 365 Subscription. We believe that there were issues with Excel's license authentication that may have caused these functions to appear in non-365 versions." The issue might have been an excessive interest in customer benefit, which appears to have been rectified.
The new fluet design is the part of office 2021 ? , or it is for insiders of office 365 or 2021.
New Fluet design is much cleaner and refresh
This is valuable video that clears the new specifications ... thanks Leila
You're welcome 😊
Hii Leila! Glad to hear your voice.....
I'm Installed windows 11....
When I watched your video I'm started to download and install Windows 11.....
It's super fast and more graphics and performance so cool.......
And very thank you so much for your windows 11 installation video!!!!💖💖😍💻🖥️
Wonderful! Glad you found it useful :)
So great sharing
Good Video as always. But Sheet View is grayed out and won't work.
You can also use the "remove duplicate values" function to get unique values.
Sure, but unique function may be used whenever You want and it'a a function so anytime You change the data it updates automatically
Remove duplicates is better if You do not need such updates
Half of these functions don't appear to be in Excel 2021 for Mac. I am missing, UNIQUE, SORT, FILTER and others. I do have XLOOKUP and LET Is there a clear list somewhere of functional availability for each version by platform? Does Microsft 365 for Mac have these?
Me too I just found xlookup, filterxml and xmatch only
I have been waiting for this like crazy ....
There must be a SUPER LIKE button for such videos. Like always, awesome.
UNIQUE was the only reason I bought it.
The one I'm most interested in didn't make it to the 2021 release 😢. It is the Lambda function.
Kindly have a video on installation of Microsoft 365 on mac
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)
Hi Leila.. Thanks for sharing this.. you're amazing.. one question on XLOOKUP how does it behave with duplicate values..?
Bump for interest
i have not used Excel much, but I know somethings and I am a computer developer. Seems like Excel is missing a general use of so called higher order functions (i.e. functions that can be sent as values and executed later). LET had it specifically, but could be used elsewhere. For instance instead of sorting a list ascending and descending order, it would be better to send a function that decides the order (you would then have functions called ascending and descending built in) which gives you even more freedom. Lots of the new stuff here exists in programming and I am a bit surprised Excel didn't get them earlier. Would have been very useful. Anyway better late than never and I hope they copy more from the programming world (probably from functional programming languages as that suits Excel best).
Great job. What about us the Microsoft Access users?
You've got an awesome voice!
I have O 365, yet I only use word and publisher. Would it be better for me to just buy the individual software than keep the Residual every year? Thanks
I really need a reference for which functions and features are only in Microsoft 365, so I can avoid those functions and features to remain compatible with older Excel and Word uses.