Best NEW Excel Features EVERYONE Needs

Подписаться 2,6 млн

Просмотров 379 тыс.

50% 1

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

Опубликовано:

18 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 447

@LeilaGharani 9 месяцев назад

Get your copy of our Cheat Sheet for the best New Excel features here 👉 pages.xelplus.com/new-features-cheat-sheet

@skeptical_bystander 10 месяцев назад

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

@euleesys 9 месяцев назад

Thank you, Leila. What is the version of Excel for this vid?

@TractorUlagam 8 месяцев назад

365

@abdulsaidmkamara7305 10 месяцев назад

Dynamic Arrays as a Power Query source is a game changer i didn't know that 😭😭😭 Thanks Leila.😍 This is Massive News !!

@mar4kl 10 месяцев назад

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.

@user-nt8od7we6o 8 месяцев назад

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

@frebarpark 10 месяцев назад

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!

@bvezos 10 месяцев назад

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

@sledgehammer-productions 10 месяцев назад

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

@senbagaganesh 10 месяцев назад

Cool stuff and to the point - as usual!! Hats off. Another content of yours for me now to share with my friends and colleagues.

@64mustangfan 10 месяцев назад

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.

@wagnerfontes2 10 месяцев назад

The Navigation pane is indeed the best for me. I've been struggling with tabs and that will help a lot. Thanks for showing!

@MarkFreemanYVR 10 месяцев назад

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?

@tonyruba3175 10 месяцев назад

Nicely done Leila! As well as I know Excel, I always learn something new from your videos - well done!!!

@christophwissing4877 10 месяцев назад

I’m new to power Querry and this new excel options - very helpful !!! Greta content !!!

@kijker1234 10 месяцев назад

I love them all! Thank you Leila.

@vida1719 10 месяцев назад

Great overview. Navigation bar and paste values shortcut are the best for me.

@zaidsultan7310 10 месяцев назад

These are amazing new features. Very useful. Making Excel more powerful and useful. Thanks for sharing such wonderful tips.

@westleyempeigne6541 10 месяцев назад

Thanks Leila. Mine is the last 2 Dynamic arrays for PQ and for charts.

@vikaasb2016 10 месяцев назад

its awesome ! @leila PLEASE POST TUTORIALS ON MS word AND PPT..Would immensely appreciate it.. a comprehensive and simplified tutorial

@komanguy 10 месяцев назад

Excellent! Thanks for the great tips!

@SaptakDutta 10 месяцев назад

Your channel is so knowledgeable, Leila. As a technologist I highly appreciate your content and effort to make us understand it.

@toniright4932 10 месяцев назад

Great! The Automate option is pure Gold.

@sazzarello 10 месяцев назад

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!

@clairerovic 10 месяцев назад

That was a wonderful concise video. Thanks

@ktfivanova248 10 месяцев назад

Uraaaaa! ctrl+shift+v works in my Excel 365))) It's amazing and comfortable to use this shortcut. Thank you Leila 👌

@user-ny1ym5xm3g 10 месяцев назад

Thanks Leila! I liked the Navigation feature.

@Barbie.7884 10 месяцев назад

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.

@TheYadeThrrr 10 месяцев назад

Thank you (again) Leila, still incredibly helpful as ever...

@Eltrissi 10 месяцев назад

Wow, just great. Thanks

@analistadesistemas 10 месяцев назад

Wonderful... Thanks!

@HenricAndersen 10 месяцев назад

Thanx Leila. Great tips. I think I simply like them all 🙂

@xaquison 10 месяцев назад

Excellent videos. Using scripts and navigation panes is my next stop.

@AngelEstebanVlog 10 месяцев назад

This is really amazing and useful for my work!

@arbazahmad7177 10 месяцев назад

Great 👍.. search option is awesome 👌

@bingxiao1008 10 месяцев назад

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

@zaydarendse2812 10 месяцев назад

loved it thanks for sharing :)

@GavinMaree 10 месяцев назад

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!

@Ticky66MN 10 месяцев назад

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.

@sadmanonatraintoo9781 10 месяцев назад

Love the menu search and navigator

@sherryfox227 10 месяцев назад

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

@BookreviewDG 10 месяцев назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wFISH9cPpn0.html

@maxdonysius1346 10 месяцев назад

I like them all...thank you!

@taizoondean689 10 месяцев назад

Thank you and I think Navigation Tab is very useful

@hemalshahorigamilove 10 месяцев назад

You are always on the top for new updates.😊

@TheSpanishCollection 10 месяцев назад

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

@poketipscr 10 месяцев назад

That Scripts options is similar to the Record Macro but seems to be super useful for shared files. Thank Leila for sharing this info.

@quentinbricard 10 месяцев назад

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

@Hortster 10 месяцев назад

Interesting new features, I think I'll be using the search and navigation ones a lot. Thanks for sharing!

@MissPickles1980 10 месяцев назад

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

@peterostertag4882 10 месяцев назад

Danke, Leila! Navigation pane is my favourite, I will use this a lot !

@LeilaGharani 10 месяцев назад

Good choice!

@ryanbartlett672 10 месяцев назад

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!

@alexdenton1073 10 месяцев назад

Thanks it’s awesome

@drewsoffice 10 месяцев назад

Great video! Excellent!

@pavelpyshkov7668 10 месяцев назад

Leila, thanks a lot! It was super usefull ❤

@ExcelFormulasHacks 10 месяцев назад

Again very useful video. Keep educating us.

@pongy5714 10 месяцев назад

quite valuable hints, thank you Leila btw. nice hair color :)

@rxepdmgm9523 10 месяцев назад

Wonderful 🙏🏻

@mostafaabdalla9636 8 месяцев назад

Thanks alot, Leila. You are 😍super Excel guru

@adnanakram2217 10 месяцев назад

Thanks for sharing ma,am❤❤

@fissh_01 10 месяцев назад

Great!!! thks... 😃😃

@augustodemelo915 10 месяцев назад

Great as usual!

@mohammedelraeis623 10 месяцев назад

Thank you 🙏

@payamjafarzade5531 10 месяцев назад

Leila jan, You nailed it!!!🎉 Just like always.

@ZombieBrainz 10 месяцев назад

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

@LeilaGharani 10 месяцев назад

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.

@memphisartguy2 10 месяцев назад

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

@borstenpinsel 10 месяцев назад

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

@memphisartguy2 10 месяцев назад

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

@theanalogkidmodular 10 месяцев назад

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.

@thanhhohai9737 10 месяцев назад

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!

@iankr 10 месяцев назад

Now that it's native, I can get rid of my ++-fired macro that does the same!

@YoucefYoucef-ft9ce 10 месяцев назад

Thank you teacher

@clangerbasher 10 месяцев назад

I am always amazed they find more things to do. Excel is probably the most important package on the planet.

@syrophenikan 10 месяцев назад

Dynamic Array results being fed to Power Query: LOVE IT!!!!!

@petersabaya 10 месяцев назад

I love the Automate Tab which works like a Macro. I like its simplicity and effectiveness in saving time.

@rwfrench66GenX 10 месяцев назад

Thank you for another wonderful tutorial! Several features look like they’ll be useful for what I do, and a few others I want to check out for personal projects. My concern is the stability of Excel on larger files. It just seems like the more MS adds the more often my files crash. If we can search the Navigation bar, and we’ve had the ability to make our own toolbar for a while, let’s get rid of the bulk of the Navigation bar. Why have 3 different ways of doing the same command? MS needs to put Excel on a diet if they’re adding new features.

@TongkiNgaceng 8 месяцев назад

value preview tooltip is very great. no need press F9 anymore, thankyou leila

@awesh1986 10 месяцев назад

As usual your videos are just awesome

@venkateshbirru7437 10 месяцев назад

Thanks for new video in Excel namaste

@zarniwhite6249 10 месяцев назад

Thanks 🙏

@ashokkhegde 7 месяцев назад

Superb. Explained Nicely too.

@LeilaGharani 7 месяцев назад

Thank you! Glad you enjoyed it.

@peteramutungire9576 10 месяцев назад

Hi Leila, Thanks for the great work. Appreciated

@LeilaGharani 10 месяцев назад

My pleasure!

@lochadi 8 месяцев назад

Supper Cool!

@binnawas 10 месяцев назад

Great 👍 as usual 👏.

@rsudakar 10 месяцев назад

Thank you Leila for sharing wonderful tips. I do not see search menu option in my excel version. Do we need to enable it?

@bijaytanty8434 10 месяцев назад

Thanks

@212george212 10 месяцев назад

Thanks:)

@gnome53 10 месяцев назад

I will use the Dynamic Arrays as Chart Source. (I am already achieving this functionality via named dynamic ranges.) I will also use the Value Preview in Tooltip. Thanks for this video!

@LeilaGharani 10 месяцев назад

This feature is still in beta. It's been there for a bit now so hopefully it will get rolled out to monthly soon.

@davidfung888 10 месяцев назад

I love the "Navigation Pane". Always working on a file with lots of tabs.

@capnmark4 6 месяцев назад

Looking forward to seeing what Automate can do, once it comes out for Excel 365 for MacOS. I have a workbook with a VBA script built around a power query. I also share this with a team that only uses the Web interface. It would/will be nice to open up the workbook to more people.

@AJ-alt 10 месяцев назад

Now I remember where I first found the X logo!

@LeilaGharani 10 месяцев назад

🤣 it's where the good ideas originated from 😇😉

@power-reconcile Месяц назад

Interesting updates to Excel! It's like watching a masterclass in efficiency. Great video!

@LeilaGharani Месяц назад

Glad you think so!

@rachael8223 10 месяцев назад

Been waiting for the paste values shortcut for a long time!🎉

@stevewindisch2882 10 месяцев назад

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

@kayvankoohestani1889 10 месяцев назад

Awesome tips, thanks Leila Jaan 👍

@LeilaGharani 10 месяцев назад

You're so welcome!

@carlolebrun 7 месяцев назад

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.

@bk3460 9 месяцев назад

Great as always!😇

@LeilaGharani 9 месяцев назад

Thank you so much 😀

@chh8860 10 месяцев назад

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

@LeilaGharani 10 месяцев назад

You're welcome - published a bit too late for your Thursday morning coffee so I'm happy you enjoyed it regardless 😊

@chh8860 10 месяцев назад

@@LeilaGharani 🤣🤣😂😂🤣🤣😂😂🤣🤣😂😂 ... 👍👍

@user-fy4yd9tz4w 10 месяцев назад

As always, many sincere thanks for all your work. I have used the search feature before and when you click on the info, it brings you to the function. I would like to see Microsoft show the shortcut to activate the function so I do not have to keep looking for it.

@ssigitas69 10 месяцев назад

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😉

@djl8710 10 месяцев назад

FromArray - FINALLY!!!! Thank the gods!

@gospelmoto2833 10 месяцев назад

Lovable!

@sachinrv1 10 месяцев назад

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

@LeilaGharani 10 месяцев назад

My pleasure 😊

@barttitulaerexcelbart9400 10 месяцев назад

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

@Krypto_Knight_33 10 месяцев назад

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.

@dougidoug 10 месяцев назад

I will definitely be using the script tool

@RakeshYadav-jn9ng 10 месяцев назад

Been waiting for a long time

@dawnbroadbent 7 месяцев назад

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!

@LeilaGharani 7 месяцев назад

That is awesome!