Leila, May I suggest, when you are talking about features, please mention version of Excel you are using. My version of Excel 365 enterprise does not have half of mentioned in this video
I can't believe it took MS Excel that long to have Ctrl + Shìt + V shortcut, this shortcut has been literally everywhere except Excel for ages. Great video, thank you Leila!
+1! PQ being able to handle spill results. This feels for me the workaround for tables not being able to handle spill. Usually that is only the first column that the rest builds on.
Hey Leila - Thank you for keep us all aware of coming features! Can you tell us - 1.) Which Excel version are these new feature active in now? 2.)Is there a trickle down schedule to all releases?
The best 9 minutes and 19 seconds of my day! ... and so good that I will likely watch several times ... a cornucopia of ideas. Thank you ... thank you ... thank you ... 😍😍😍
Thanks Leila for sharing. They are such useful features, I followed with you step by step, regarding the first tip, for some reason the list came out with duplicate values. I would like to know what cause that problem. I do have the 365 version but I could not see the Navigation pane anywhere. 😓
Hi Leila, I discovered your site accidentally and love it, including your style of educating as it is helping me get better at using Excel. I have seen in your videos and others that the use of merged columns is discouraged and wanted to know how to handle this when I need to group a series of rows that collectively form a unit of transaction. e.g., if I am tracking expenses across multiple events across multiple sites, I am using a sheet where individual expenses are grouped under a single event id, which along with other event-level details are shown as a merged row (e.g., event id, event location, total expenses etc).
The navigation pane one is a game changer for me, and the search will be game changing for when I'm training other Excel users (mostly because I've customised my Excel ribbon and can never remember where the default menu options are!)
Thank you for this video. Very usefull. I would like to see a feature where ppl could center across selection vertically. I can't stand those merged cells.
Navigation is my favorite. I just learned about it from this video. I have a workbook with 26 sheets so navigation is going to make my life so much better!
Thanks Leila, always my go-to for Excel etc. I never even noticed some of these, like automate and navigate, using it already 😊 Anyone remember Quatro Pro years ago? I loved it, ahead of the pack back then I thought, had a quick record, once off or saveable, used it often, seems automate is similar.
I like the use of spill ranges into power query! To copy and paste removing formula, I select the range, right the any edge or border, drag away and return to the same location. A popup appears with selections and select copy here as values only!
This is always exciting to try new features and thank you for introducing them to us. What is frustrating for me is some are available on my home computer and not at work and sometimes the opposite. Some very useful tips as always, thank you.
Hi Leila, I enjoy very much your cristal clear tutorials. Thanks for sharing so much valuable information. What software do you use to create a spot light when you want to highlight a point on the screen ? All the best for you.
Hey Leila, thanks 4 the content what version of Office you use, me for example have 365 everything updated and even enrolled on the Insider thingy and not being able to enjoy those features. Can you clarify a lil bit more?
The Office apps have long suffered from two issues: 1) discoverability and 2) menu hell. The search will certainly help IF you know what you’re looking for but discovering new capabilities in the awesome products is still a challenge. I don’t know what the solution is but it’s something that should be addressed. Normal users may use 5-10% of a product’s features. As pros, we probably use 20-30%.
I agree. Microsoft is aware of this issue and they're trying hard experiment with different methods. It's not easy to find a solution that is helpful and not annoying (or in the way) of getting your work done. For example, popups inside the app can be seen as helpful for some, but annoying for others.
Normal users can barely open the file with all the security warnings and popups. Even worst is I use to chare a command bar with 90% of the features i use with in a month. Microsoft a few years ago made the importing of the bar non-functional, even if I save my current one it reset to default on import. The Search function is a game changer if you know what you are searching for. The Navigation panel hasn't made it through the cooperate filters yet. But i would love for them to fix the mountain of bugs than add new features. Overly inflating file sizes, constant unrecoverable crashes, cells getting stuck with the updating % overlay. Adding new feature to a plague program is like giving cough medicine to some one with lung cancer. FIX the F'ing Program! I've been dealing with rampant file sizes issue for over 20 years now. Guess what, Pandas don't like xlsb file types....
And rebar was Microsoft's solution to menu hell to begin with. Yeah of course I want my buttons to shrink or vanish when I resize my window. That's why you see the title bar littered with shortcuts on many PCs
@@borstenpinsel Any idea why they are killing the command bar, the ribbon can be hidden but taking away the ability to share command bars is just sloppy.
The fact that there is a "Commands not in the ribbon" section when you customize the Quick Access Toolbar is prime example of this. Most of them are garbage, but there are some that are super useful, in PowerPoint for example there are a Pick Up Style and Apply Style commands that are WAY more powerful than the Format Painter shortcut, if anything because they store the style and you can later apply it without having to worry about mis-clicking.
I don’t use power queries but navigation and office scripts are going to help me do much. Thank you! I wish Microsoft had a better way of notifying users about new features. That’s why I love your channel ❤.
I am watching many of your videos and sometimes jealous that Microsoft Office has so amazing teacher 😁 I would want that Libre Office would have so amazing teacher like Leila😉
Hi Leila, never realized all these features are already ready in my Excel version. Thank you for making this video :) Do you know why I am not seeing Automate Menu in my Excel version? I have Microsoft 365 Family Subscription - Microsoft® Excel® for Microsoft 365 MSO (Version 2307 Build 16.0.16626.20028) 64-bit Is my version isn't suported?
Ctrl-Alt-V already works to bring up the "Paste Special" dialog. you still have to specify values only, but it's at least a little faster than the ribbon
Office 365 has impressed me more than I expected. These new features are amazing and especially good for those who cannot remember keyboard shortcuts. Thanks Leila for sharing :)
Leila, thanks for sharing your favorite new features. After watching, I cannot choose a favorite, I love them all! The navigation is way cool, and the office scripts is going to be a lot of fun!!!🦊
thank you for sharing your expertise with the world and for making my Excel experience so much better. One small little question, how the automate feature differs from macros?
Leila can you help or make video on how to easy assess xcel as Google sheets in browser, simpl easy to use and can link other sheets by copying address . Most awaited videos
Thanks Leila. I did not use the "search menu" yet. Just tried it. You can type "Form" to use this (hidden in the menu) . That's nice. But this does not work for "Camera" (also not in the menu).
Thanks, Leila! As usual, you're right here with good information just when I need it most. I've been working on a large project estimate for a client, and, of course, it's been quite some time since I was seriously busy in Excel. I will be putting video's search, navigation and debugging tips to good use.
Great content as usual! But whenever you mention "new" features I would suggest to mention the Excel version which was used, as any feature might depend on age of the version in use.
Hi Leila - Thanks for sharing this updates. I have been using the paid versions Excel 2019 where I have noticed that the Navigation click is not available in view tab along with paste as value shortcut is not not working in my excel workbook. Additionaly I also can't see the Automate tab in my excel. Can you please advise me?
Thanks for the Video.But wenn I use tip number 1 DataValidation dropdown, then all entries apear in my dropdown list. In your video each entrie appears only once. Can you explane how to do that? Many thanks. Regards from Germany. Uwe
Is there a way to use pivot tables as a source in PowerQuery? or would the workaround be to do a filter/offset range from the pivot table and load it as an array to PowerQuery? Thank you! Amazing video as always
@@SolidSnake59 lol maybe I should've explained more. I have multiple tables connected and created a report from columns from different tables + a measure. I would now like to take that and export it or extract it somehow as a flat file. Doing this with a macro/script rn, but won't be able to do it when rows exceed the Excel limit.
Nice video as usual. I loved the Navigation Pane... not so sure about the ALT_F12 on, whereas copy past special value did not work... For the Automate menu: which Excel version is it?, the dynamic array thing requires some extra studying on your video..
Get your copy of our Cheat Sheet for the best New Excel features here 👉 pages.xelplus.com/new-features-cheat-sheet
Leila, May I suggest, when you are talking about features, please mention version of Excel you are using. My version of Excel 365 enterprise does not have half of mentioned in this video
Thank you, Leila. What is the version of Excel for this vid?
365
Dynamic Arrays as a Power Query source is a game changer i didn't know that 😭😭😭 Thanks Leila.😍
This is Massive News !!
I love the search bar when I right click! I didn't even notice the updates until this video! Thanks for bringing such valuable videos to all of us!
5:06 - you can also generate 10 consecutive dates via =SEQUENCE(10,,TODAY()) and appropriate formatting.
Please make video for JIRA tool too.
I can't believe it took MS Excel that long to have Ctrl + Shìt + V shortcut, this shortcut has been literally everywhere except Excel for ages. Great video, thank you Leila!
Now that it's native, I can get rid of my ++-fired macro that does the same!
The Navigation pane is indeed the best for me. I've been struggling with tabs and that will help a lot. Thanks for showing!
+1! PQ being able to handle spill results. This feels for me the workaround for tables not being able to handle spill. Usually that is only the first column that the rest builds on.
00:55 The Data Validation makes now the List as unique list of values - cool ...
Great Catch!
I am using a Personal Microsoft 365 Version (Annual Subscription). This isn't working yet for Me.
Cool stuff and to the point - as usual!! Hats off. Another content of yours for me now to share with my friends and colleagues.
Your channel is so knowledgeable, Leila. As a technologist I highly appreciate your content and effort to make us understand it.
Hey Leila - Thank you for keep us all aware of coming features!
Can you tell us -
1.) Which Excel version are these new feature active in now?
2.)Is there a trickle down schedule to all releases?
Great! The Automate option is pure Gold.
I am always amazed they find more things to do. Excel is probably the most important package on the planet.
Danke, Leila! Navigation pane is my favourite, I will use this a lot !
Good choice!
The best 9 minutes and 19 seconds of my day! ... and so good that I will likely watch several times ... a cornucopia of ideas.
Thank you ... thank you ... thank you ... 😍😍😍
You're welcome - published a bit too late for your Thursday morning coffee so I'm happy you enjoyed it regardless 😊
@@LeilaGharani 🤣🤣😂😂🤣🤣😂😂🤣🤣😂😂 ... 👍👍
Dynamic Array results being fed to Power Query: LOVE IT!!!!!
Thanks Leila for sharing. They are such useful features, I followed with you step by step, regarding the first tip, for some reason the list came out with duplicate values. I would like to know what cause that problem. I do have the 365 version but I could not see the Navigation pane anywhere. 😓
Navigation will be my favorite with the 150-tab spreadsheet I have to work with. Automate will come in a close 2nd. Thanks for the video!
Hi Leila,
I discovered your site accidentally and love it, including your style of educating as it is helping me get better at using Excel. I have seen in your videos and others that the use of merged columns is discouraged and wanted to know how to handle this when I need to group a series of rows that collectively form a unit of transaction. e.g., if I am tracking expenses across multiple events across multiple sites, I am using a sheet where individual expenses are grouped under a single event id, which along with other event-level details are shown as a merged row (e.g., event id, event location, total expenses etc).
Uraaaaa! ctrl+shift+v works in my Excel 365))) It's amazing and comfortable to use this shortcut. Thank you Leila 👌
Thanks Leila.
Mine is the last 2 Dynamic arrays for PQ and for charts.
Do we already get Ctrl+shift+v shortcut in normal office 365 rather than 365 beta program?
I think a week ago, I tested it but still not working.
the same(
Interesting new features, I think I'll be using the search and navigation ones a lot. Thanks for sharing!
The navigation pane one is a game changer for me, and the search will be game changing for when I'm training other Excel users (mostly because I've customised my Excel ribbon and can never remember where the default menu options are!)
value preview tooltip is very great. no need press F9 anymore, thankyou leila
Thank you for this video. Very usefull. I would like to see a feature where ppl could center across selection vertically. I can't stand those merged cells.
That would be nice.
Thanks Leila! I liked the Navigation feature.
OMG!!! The Navigation Pane is a LIFE SAVER!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I know, right? Great addition!
These are amazing new features. Very useful. Making Excel more powerful and useful. Thanks for sharing such wonderful tips.
Navigation is my favorite. I just learned about it from this video. I have a workbook with 26 sheets so navigation is going to make my life so much better!
That is awesome!
Excellent videos. Using scripts and navigation panes is my next stop.
its awesome ! @leila PLEASE POST TUTORIALS ON MS word AND PPT..Would immensely appreciate it.. a comprehensive and simplified tutorial
Thanks Leila, always my go-to for Excel etc. I never even noticed some of these, like automate and navigate, using it already 😊 Anyone remember Quatro Pro years ago? I loved it, ahead of the pack back then I thought, had a quick record, once off or saveable, used it often, seems automate is similar.
Nicely done Leila! As well as I know Excel, I always learn something new from your videos - well done!!!
It seems like the Automate tab is like Macros which is great. Or are there any differences?
I can see myself using this quite a bit.
Leila jan,
You nailed it!!!🎉
Just like always.
I’m new to power Querry and this new excel options - very helpful !!! Greta content !!!
I love them all! Thank you Leila.
Thanx Leila. Great tips. I think I simply like them all 🙂
I like the use of spill ranges into power query! To copy and paste removing formula, I select the range, right the any edge or border, drag away and return to the same location. A popup appears with selections and select copy here as values only!
Loved all of them. I also noticed a Python function in your Excel ribbon. Could you please tell us more about that?
That also caught my eye - keen to know as well
Out now about month later: Introducing Python in Excel
Thank you (again) Leila, still incredibly helpful as ever...
quite valuable hints, thank you Leila
btw. nice hair color :)
Great Video Leila - have a nice weekend - greetings from Germany
This is always exciting to try new features and thank you for introducing them to us. What is frustrating for me is some are available on my home computer and not at work and sometimes the opposite. Some very useful tips as always, thank you.
Hi Leila, I enjoy very much your cristal clear tutorials. Thanks for sharing so much valuable information. What software do you use to create a spot light when you want to highlight a point on the screen ? All the best for you.
Power Toys - Find my mouse. Many great tools there: ruclips.net/video/ZlyxesiiC6U/видео.html
I love the Automate Tab which works like a Macro. I like its simplicity and effectiveness in saving time.
Amazing stuff! I’m definitely tapping into most of these today! Also, I can listen to you say the word “data” all day. Lol! #hopethatsnotcreepy 🤣
Thanks alot, Leila. You are 😍super Excel guru
Love the menu search and navigator
Great overview. Navigation bar and paste values shortcut are the best for me.
Hey Leila, thanks 4 the content what version of Office you use, me for example have 365 everything updated and even enrolled on the Insider thingy and not being able to enjoy those features. Can you clarify a lil bit more?
Usually Microsoft rolls out features slowly, even to Insiders. I often have new features only on 1 of my 5 machines in the beginning.
Excel keeps improving. It has no limit!
Agree! It's difficult to keep up.
I loved Excel from the very beginning.
@@LeilaGharani
Leila, let Microsoft know to improve the Lambda function
definition box.
The Office apps have long suffered from two issues: 1) discoverability and 2) menu hell. The search will certainly help IF you know what you’re looking for but discovering new capabilities in the awesome products is still a challenge. I don’t know what the solution is but it’s something that should be addressed. Normal users may use 5-10% of a product’s features. As pros, we probably use 20-30%.
I agree. Microsoft is aware of this issue and they're trying hard experiment with different methods. It's not easy to find a solution that is helpful and not annoying (or in the way) of getting your work done. For example, popups inside the app can be seen as helpful for some, but annoying for others.
Normal users can barely open the file with all the security warnings and popups. Even worst is I use to chare a command bar with 90% of the features i use with in a month. Microsoft a few years ago made the importing of the bar non-functional, even if I save my current one it reset to default on import. The Search function is a game changer if you know what you are searching for. The Navigation panel hasn't made it through the cooperate filters yet. But i would love for them to fix the mountain of bugs than add new features. Overly inflating file sizes, constant unrecoverable crashes, cells getting stuck with the updating % overlay. Adding new feature to a plague program is like giving cough medicine to some one with lung cancer. FIX the F'ing Program! I've been dealing with rampant file sizes issue for over 20 years now. Guess what, Pandas don't like xlsb file types....
And rebar was Microsoft's solution to menu hell to begin with. Yeah of course I want my buttons to shrink or vanish when I resize my window. That's why you see the title bar littered with shortcuts on many PCs
@@borstenpinsel Any idea why they are killing the command bar, the ribbon can be hidden but taking away the ability to share command bars is just sloppy.
The fact that there is a "Commands not in the ribbon" section when you customize the Quick Access Toolbar is prime example of this. Most of them are garbage, but there are some that are super useful, in PowerPoint for example there are a Pick Up Style and Apply Style commands that are WAY more powerful than the Format Painter shortcut, if anything because they store the style and you can later apply it without having to worry about mis-clicking.
I don’t use power queries but navigation and office scripts are going to help me do much. Thank you! I wish Microsoft had a better way of notifying users about new features. That’s why I love your channel ❤.
Thank you Leila for sharing wonderful tips. I do not see search menu option in my excel version. Do we need to enable it?
Superb. Explained Nicely too.
Thank you! Glad you enjoyed it.
That Scripts options is similar to the Record Macro but seems to be super useful for shared files. Thank Leila for sharing this info.
FromArray - FINALLY!!!! Thank the gods!
Thank you Leila for yet another amazing video.
I, however, could not find "Navigation Pane" through the New Search feature. May it's just me.
I am watching many of your videos and sometimes jealous that Microsoft Office has so amazing teacher 😁 I would want that Libre Office would have so amazing teacher like Leila😉
Interesting updates to Excel! It's like watching a masterclass in efficiency. Great video!
Glad you think so!
Hi Leila,
Thanks for the great work. Appreciated
My pleasure!
Awesome tips, thanks Leila Jaan 👍
You're so welcome!
Excellent! Thanks for the great tips!
I love the "Navigation Pane". Always working on a file with lots of tabs.
Hi Leila, never realized all these features are already ready in my Excel version. Thank you for making this video :)
Do you know why I am not seeing Automate Menu in my Excel version?
I have Microsoft 365 Family Subscription - Microsoft® Excel® for Microsoft 365 MSO (Version 2307 Build 16.0.16626.20028) 64-bit
Is my version isn't suported?
Mine is not supported too. I cannot see the Automate Tab. I am on the BETA Channel
Been waiting for the paste values shortcut for a long time!🎉
Ctrl-Alt-V already works to bring up the "Paste Special" dialog. you still have to specify values only, but it's at least a little faster than the ribbon
Capturing the data in Power Query editor from a spilled array is the best thing so far!
👍
Office 365 has impressed me more than I expected. These new features are amazing and especially good for those who cannot remember keyboard shortcuts. Thanks Leila for sharing :)
My pleasure 😊
2:55 how did you get a unique list in your Data Validation? Am I missing some feature in my Excel? Your source has multiple Productivity listed..
That was a wonderful concise video. Thanks
Leila, thanks for sharing your favorite new features. After watching, I cannot choose a favorite, I love them all! The navigation is way cool, and the office scripts is going to be a lot of fun!!!🦊
ruclips.net/video/wFISH9cPpn0/видео.html
Again very useful video. Keep educating us.
Hi Leila, what version of the Excel has these features as I cannot find the navigation pane that you highlighted here.
thank you for sharing your expertise with the world and for making my Excel experience so much better.
One small little question, how the automate feature differs from macros?
Macros (VBA) cannot be executed on Excel Online, Office Scripts can, on both Desktop and Online
Hi Leila, I use excel 365 Mac, updated yesterday and I do not have any of these new features. Any suggestions on how to add them?
Thanks for new video in Excel namaste
Now I remember where I first found the X logo!
🤣 it's where the good ideas originated from 😇😉
Leila can you help or make video on how to easy assess xcel as Google sheets in browser, simpl easy to use and can link other sheets by copying address . Most awaited videos
HI Laila, another great production letting us mortals know what is new in Excel! Hope you're well.
Thank you and I think Navigation Tab is very useful
Thanks Leila. I did not use the "search menu" yet. Just tried it. You can type "Form" to use this (hidden in the menu) . That's nice. But this does not work for "Camera" (also not in the menu).
Thanks, Leila! As usual, you're right here with good information just when I need it most. I've been working on a large project estimate for a client, and, of course, it's been quite some time since I was seriously busy in Excel. I will be putting video's search, navigation and debugging tips to good use.
Great content as usual! But whenever you mention "new" features I would suggest to mention the Excel version which was used, as any feature might depend on age of the version in use.
Hi Leila - Thanks for sharing this updates. I have been using the paid versions Excel 2019 where I have noticed that the Navigation click is not available in view tab along with paste as value shortcut is not not working in my excel workbook. Additionaly I also can't see the Automate tab in my excel. Can you please advise me?
These new features are only added to Office 365, the subscription version.
Thanks for the Video.But wenn I use tip number 1 DataValidation dropdown, then all entries apear in my dropdown list. In your video each entrie appears only once. Can you explane how to do that? Many thanks. Regards from Germany. Uwe
You made my day ! Thanks
I will definitely be using the script tool
Thanks, Leila! How to enable Automate Tab
Is there a way to use pivot tables as a source in PowerQuery? or would the workaround be to do a filter/offset range from the pivot table and load it as an array to PowerQuery? Thank you! Amazing video as always
Have mercy on my soul!😢
Just use raw data in PQ and use pivot function, so data looks like in the pivot.
@@SolidSnake59 lol maybe I should've explained more. I have multiple tables connected and created a report from columns from different tables + a measure. I would now like to take that and export it or extract it somehow as a flat file. Doing this with a macro/script rn, but won't be able to do it when rows exceed the Excel limit.
This is really amazing and useful for my work!
Well that search feature is pretty awesome I must say..
EXCEL is as insanely capable as it is bad documented. Awesome videos, as always :)
Thank you!
Leila, thanks a lot! It was super usefull ❤
As usual your videos are just awesome
Thank you 🙏
Nice video as usual. I loved the Navigation Pane... not so sure about the ALT_F12 on, whereas copy past special value did not work... For the Automate menu: which Excel version is it?, the dynamic array thing requires some extra studying on your video..
Great as usual!