Best NEW Excel Features EVERYONE Needs
HTML-код
- Опубликовано: 6 июн 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Here is my list of the best new features and improvements in Microsoft Excel that can really make a difference for you. This includes the new Search the menus feature, the new navigation pane for large workbooks, how to check your formula with the value preview tooltip, dynamic arrays and more.
⬇️ Get your copy of the Cheat Sheet for the best New Excel features here: pages.xelplus.com/new-feature...
🔍 Highlights of the Video:
- Discover Excel's right-click search feature for effortless command access.
- Explore the new Navigation pane, your key to managing complex spreadsheets.
- Learn about Excel's latest keyboard shortcuts, including one for Power Query and quick value pasting.
- Get introduced to the Automate tab for creating and running Office Scripts.
- See the Value Preview tooltip in action, simplifying formula debugging.
- Find out how to use Dynamic Arrays as a source in Power Query and in charts.
💡 Takeaways:
- Leverage new features to simplify and enhance your Excel projects.
- Discover innovative ways to manage and analyze data.
- Stay current with the evolving landscape of Excel functionalities.
00:00 Best New Excel Features You Need to Know About
00:17 Easy Search in Excel
01:39 Navigation Pane in Excel
03:02 New Excel Keyboard Shortcuts
03:54 Automate Tab
05:56 Value Preview Tooltip
06:41 Dynamic Arrays in Power Query
08:23 Dynamic Arrays as Charts Source
08:51 Wrap Up
🎬 LINKS to related videos:
Introduction to Office Scripts ► • Introduction to Office...
Automatically Move Completed Tasks to an Archive ► • Automatically Move Com...
Do You Need to SWITCH from Excel VBA Macros to Office Scripts? ► • Do You Need to SWITCH ...
➡️ 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
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
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 !!
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.
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!
Cool stuff and to the point - as usual!! Hats off. Another content of yours for me now to share with my friends and colleagues.
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).
Nicely done Leila! As well as I know Excel, I always learn something new from your videos - well done!!!
I love them all! Thank you Leila.
The Navigation pane is indeed the best for me. I've been struggling with tabs and that will help a lot. Thanks for showing!
These are amazing new features. Very useful. Making Excel more powerful and useful. Thanks for sharing such wonderful tips.
Excellent! Thanks for the great tips!
Great! The Automate option is pure Gold.
Wow, just great. Thanks
Your channel is so knowledgeable, Leila. As a technologist I highly appreciate your content and effort to make us understand it.
That was a wonderful concise video. Thanks
Thanks Leila! I liked the Navigation feature.
I’m new to power Querry and this new excel options - very helpful !!! Greta content !!!
Thank you (again) Leila, still incredibly helpful as ever...
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 ❤.
Thanx Leila. Great tips. I think I simply like them all 🙂
Excellent videos. Using scripts and navigation panes is my next stop.
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!)
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
loved it thanks for sharing :)
its awesome ! @leila PLEASE POST TUTORIALS ON MS word AND PPT..Would immensely appreciate it.. a comprehensive and simplified tutorial
quite valuable hints, thank you Leila
btw. nice hair color :)
Leila jan,
You nailed it!!!🎉
Just like always.
Great overview. Navigation bar and paste values shortcut are the best for me.
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.
Great 👍.. search option is awesome 👌
Thanks it’s awesome
This is really amazing and useful for my work!
+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.
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.
Great video! Excellent!
Again very useful video. Keep educating us.
Love the menu search and navigator
I like them all...thank you!
Great!!! thks... 😃😃
Wonderful... Thanks!
Thanks alot, Leila. You are 😍super Excel guru
You made my day ! Thanks
Hi Leila,
Thanks for the great work. Appreciated
My pleasure!
Danke, Leila! Navigation pane is my favourite, I will use this a lot !
Good choice!
Great as usual!
Thanks for new video in Excel namaste
Thanks Leila.
Mine is the last 2 Dynamic arrays for PQ and for charts.
You are always on the top for new updates.😊
Leila, thanks a lot! It was super usefull ❤
Great as always!😇
Thank you so much 😀
Thank you 🙏
Thank you and I think Navigation Tab is very useful
Uraaaaa! ctrl+shift+v works in my Excel 365))) It's amazing and comfortable to use this shortcut. Thank you Leila 👌
Superb. Explained Nicely too.
Thank you! Glad you enjoyed it.
I am always amazed they find more things to do. Excel is probably the most important package on the planet.
Supper Cool!
Awesome tips, thanks Leila Jaan 👍
You're so welcome!
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?
Dynamic Array results being fed to Power Query: LOVE IT!!!!!
Great Video Leila - have a nice weekend - greetings from Germany
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!
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 🤣🤣😂😂🤣🤣😂😂🤣🤣😂😂 ... 👍👍
Interesting updates to Excel! It's like watching a masterclass in efficiency. Great video!
Glad you think so!
Wonderful 🙏🏻
FromArray - FINALLY!!!! Thank the gods!
As usual your videos are just awesome
Great 👍 as usual 👏.
EXCEL-lent explanations! 🙌
Glad you liked it!
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 🤣
value preview tooltip is very great. no need press F9 anymore, thankyou leila
Thank you teacher
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. 😓
Wow, thank you for this video!
Scripts recording can be very interesting, for sheet pre-formating (dashboards for example). Better than templates.
Debuging features are awesome too!
And dynamic array for Power Query!
And easy search!
And navigation pane!
😂
Thanks 🙏
That Scripts options is similar to the Record Macro but seems to be super useful for shared files. Thank Leila for sharing this info.
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!
Nice to know new tricks to keep it interesting. Long ago I set Paste Values is the first slot on my QAT, alt 1, done, moving on. I’ve done it that way for so long I don’t think about it. Button on my keyboard is set to Alt F10 single keystroke there. Dynamic Arrays as data source for PQ seems like a good idea.
great video
Thanks! Search settings will be used all day long. Reminds me of similar functionality in VSCode I love so much. All others look great, but a marriage between dynamic ranges and Power Query?! Yes!
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
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!
Thanks for sharing ma,am❤❤
Now I remember where I first found the X logo!
🤣 it's where the good ideas originated from 😇😉
Thanks:)
I love the "Navigation Pane". Always working on a file with lots of tabs.
First of all, thank you for your very knowledgeable content. I love that you know sooo much about so many applications and I find your channel VERY useful. Maybe you have specified somewhere, and maybe I have not seen it but I would find it very useful if you mentioned in which versions of Excel these features are available. For example I am using excel 2021 and I don't see some of these new features so do they need to be switched on or are they only available in 365? TIA
I love the Automate Tab which works like a Macro. I like its simplicity and effectiveness in saving time.
Been waiting for a long time
Lovable!
Thanks
I will definitely be using the script tool
Ctrl+Shift+V my new best friend, thank you!!
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 😊
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😉
Thank you Leila for sharing wonderful tips. I do not see search menu option in my excel version. Do we need to enable it?
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
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.
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
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.