5 HIDDEN Excel Tools Almost Nobody Is Talking About

Подписаться 622 тыс.

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

50% 1

5 hidden Excel tools that will make you look like an expert
👩‍🏫 Become an Excel expert with my course: bit.ly/htools24course
⬇️ Download the example file here and follow along: bit.ly/htools24file
Excel is full of hidden tools that can completely transform the way you work, but most people never discover them. Today, I'm revealing 5 hidden Excel tools that will improve productivity and make your life easier. By the end of this video, you’ll be wondering how you ever managed without them.
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
==============
0:00 Tool №1
2:22 Tool №2
3:33 Become an Excel expert
4:06 Tool №3
5:06 Tool №4
6:22 Tool №5
#Excel #ExcelTools #ExcelTutorial

Наука

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

21 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@MyOnlineTrainingHub 28 дней назад

❓Which tool mentioned in the video is your favorite, and why? Become an Excel expert with my course: bit.ly/htools24course

@user-pf8lb9vy1z 26 дней назад

The navigation pane is a feature I've never used, but super helpful. Thanks for the great content!

@johnguarnero4084 26 дней назад

Your voice is cool as well.

@gdboone 26 дней назад

Your favorite is going to be my new one! Although navigation is new for me too

@naresh200 14 дней назад

Navigation is my favorite.

@BestJerome 23 дня назад

Thank you for the helpful tips and the opportunity to practice them in one place. I am looking forward to enrolling in your course.

@marjoriefrancis4560 26 дней назад

Thanks Mynda! Awesome as always.

@MyOnlineTrainingHub 26 дней назад

Thanks so much, Marjorie!

@kirk1968 26 дней назад

Thank you so much for these Excel tool videos! I've been using Excel since the early 90s, and it continues to surprise me with features I'm not too familiar with. It's really come a LONG way, hasn't it? Blessings from Phoenix, Arizona! 👋

@MyOnlineTrainingHub 26 дней назад

It sure has!

@happymystic9800 26 дней назад

Really helpful tips 😮 … it is the small things that make life easier ❤ … Thank you, Mynda 😊

@MyOnlineTrainingHub 26 дней назад

Glad it was helpful!

@westleyempeigne6541 5 дней назад

No 4 and No 5 are my favourites! 4 is super quick to filter and 5, a good way to find things, especially if you’ve inherited a file with lots of names ranges, charts, tables, etc

@MyOnlineTrainingHub 5 дней назад

Glad you can make use of them 😊

@billgillaspey9036 26 дней назад

Wow!. Always some new good things to learn. Thanks!

@MyOnlineTrainingHub 26 дней назад

Thanks so much, Bill!

@chrism9037 26 дней назад

Great tips Mynda. I like # 4 as well.

@MyOnlineTrainingHub 26 дней назад

Thanks, Chris! Glad we agree 😁

@patrick1972seb 20 дней назад

What a pleasure to watch your videos 🤩 The way you present and explain everything. I've learned so much new things over the past few days. Thank you!

@MyOnlineTrainingHub 19 дней назад

So nice of you 🙏

@olivierissaverdens6916 26 дней назад

Hello Mynda! Thank you for these tips. My favourite is the navigation pane which I probably should use more often ...

@MyOnlineTrainingHub 26 дней назад

Great to hear!

@garydunken7934 25 дней назад

For formula paste, I use Alt+H V F

@mr.gk5 23 дня назад

Yeah but that’s pretty well known. It’s neither new nor hidden

@BoraHorzaGobuchul 22 дня назад

I just made a custom ribbon with all the buttons I really need... Took some effort but now I rarely need to look for stuff across various ribbons

@mr.gk5 22 дня назад

@@BoraHorzaGobuchul can you somehow save the custom ribbon settings in case you need to reinstall excel or switch to a different computer?

@BoraHorzaGobuchul 21 день назад

@@mr.gk5 ribbons can be created in xml. There are tools like "Ribbon XML editor" that allow you to do this. It's still rather obscure and not exactly user friendly. Also, not all excel functions are accessible as ready-made buttons (e.g. if I'm not mistaken, you can't make a ribbon button for "filter by the contents of the current cell"), so in some cases I had to write code. After that, the ribbon is saved as an excel addon, the code goes there as well. I've been doing that since office 2007, it still works with o365 without problems - I just add the xlam file to the add-ons, and it's good to go

@LivingGuy484 6 дней назад

@@mr.gk5I have no idea if this will work, but I would try messing with the default book Excel file and using that to replace the book file in whichever new computer you plan to use You can keep it in a flash drive or in any free cloud service under been easy to find folder structure. something like "Important / Templates / Excel Templates"

@MGE0007 26 дней назад

Its 07:54 in the morning for me……and this video has already made my day!!…

@MyOnlineTrainingHub 26 дней назад

So pleased to hear that 😁

@TheArcass 19 дней назад

Tip 5! A revelation. Makes navigating around tabs and their content so much easier. I present models build in Excel and being ablet to have a Word like navigation panel is a game changer.

@MyOnlineTrainingHub 18 дней назад

Glad you can make use of it!

@enriquefernandezaraujo3943 26 дней назад

Thank You for sharing your knowledge, My favorite is the 5th, the navigation pane, since I used to deal with several worksheets in one workbook (all cost centers by month)

@MyOnlineTrainingHub 26 дней назад

Great to hear!

@ugonnabriggs5019 26 дней назад

❤, thanks for sharing your knowledge. #1 is my fav.

@MyOnlineTrainingHub 26 дней назад

Nice!

@sandratruax715 26 дней назад

Thanks for another wonderful video. I like the Flash Fill the best, and then the Navigation pane. Didn't know it existed.

@MyOnlineTrainingHub 26 дней назад

Glad you discovered something new 😊

@LivingGuy484 6 дней назад

This is awesome! I can actually see myself using 3 of the 5 tips for work someday

@MyOnlineTrainingHub 6 дней назад

Great to hear!

@DianHrozek 24 дня назад

Great! Thank you ❤❤

@MyOnlineTrainingHub 24 дня назад

Thanks for watching!

@Tom37323 26 дней назад

I knew about the navigation pane, but I did not know how to make it useful. Thank you for all the good tips.

@MyOnlineTrainingHub 26 дней назад

So pleased you can make better use of it now.

@SegueGreene 25 дней назад

love the filter/sort shortcut!

@MyOnlineTrainingHub 25 дней назад

Glad you can make use of it 😊

@stefankirst3234 24 дня назад

All 5 Tools are great but #4 would be my favourite, too. Thank for the awesome video!

@MyOnlineTrainingHub 24 дня назад

Thanks for watching!

@heinzthedutch 26 дней назад

That navigation pane is far easier than scrolling through sheets and/or setting up hyperlinks in a separate sheet! thanks again and greetings from the NL.

@MyOnlineTrainingHub 26 дней назад

Glad you liked it!

@777kiya 22 дня назад

Helpful

@MyOnlineTrainingHub 22 дня назад

Glad to hear that 🙏

@walkingentropy 26 дней назад

4:24 For tool 3, when auto-fill down, I get a little handle at the end with a little plus sign which gives a few options including to "fill without formatting". Not sure if this might be helpful to others also!

@MyOnlineTrainingHub 26 дней назад

Thanks for sharing!

@izkamarkizka 26 дней назад

Thank you😍

@MyOnlineTrainingHub 26 дней назад

Pleasure 😊

@user-xx5et3fj7b 25 дней назад

Yes!! Tool №4 is so sweet!!

@MyOnlineTrainingHub 25 дней назад

Glad you like it 🙏

@sbon4771 25 дней назад

This is great info! I'm working on the practice tab Quick Analysis 2 and when I go to Totals -> Average, the averages display at the bottom of the columns. How can I get them to display to the right as you show in the tutorial? Thank you!

@MyOnlineTrainingHub 25 дней назад

Scroll across to the right where you'll find the Totals for the rows. They are the icons with yellow. The icons with blue are for column totals.

@sbon4771 23 дня назад

@@MyOnlineTrainingHub Thank you!

@solvesonkd 26 дней назад

Great tutorial as always. On the Flash Fill tab, lines 43-50, which deal with formatted dates; when I selected cell C45 and press Ctrl-E it just copies the value in cell C44 down. It doesn't use the data in column B at all. Suggestions?

@MyOnlineTrainingHub 26 дней назад

It's probably a locale issue. My dates are formatted dd/mm/yyyy. If yours are mm/dd/yyyy, try reentering the date in cell C44 and then flash fill.

@goodone05004 25 дней назад

Great video again, but what is the "menu key" you talked about in tool number 4?

@MyOnlineTrainingHub 25 дней назад

Thank you! There was an image of it on screen. On my keyboard it's to the left of the right-hand CTRL key. It looks like a piece of paper with lines on it.

@BoraHorzaGobuchul 22 дня назад

One of the greatest new things for me is built-in ocr via get data from picture

@SergioAlejandroCampos 25 дней назад

I love your thumbnail, Mynda.

@MyOnlineTrainingHub 25 дней назад

Thanks, Sergio!

@sheerazhussain6875 16 дней назад

Madam you made excel more easier for us thank you

@MyOnlineTrainingHub 15 дней назад

Great to hear!

@j_orpz 26 дней назад

I didn't know about the navigation pane - thanks!

@MyOnlineTrainingHub 26 дней назад

Glad you found something new 😁

@vaibhavdahival6397 26 дней назад

Great👌

@MyOnlineTrainingHub 26 дней назад

Thank you!

@Igor_Ashurkov 26 дней назад

nice job!

@MyOnlineTrainingHub 26 дней назад

Thanks!

@billgyrotech 26 дней назад

Hi Mynda. Have you updated your monthly budget workbook without pivot tables?

@MyOnlineTrainingHub 26 дней назад

No. Not sure why you'd want this.

@cngz_hsvr 25 дней назад

You are the Queen of Excel 🙂

@MyOnlineTrainingHub 25 дней назад

You’re too kind 🙏😊

@chahineatallah2636 26 дней назад

Nice video and great hidden features (I think advanced filter could be added as 6 😀) I use frequently flash fill , but one problem with it , it doesn’t refresh 🤦‍♂️, if new data is added

@MyOnlineTrainingHub 26 дней назад

Thank you! Yes, good idea, Advanced Filter is another great hidden feature. If you need to refresh data you've cleaned with Flash Fill, then it's time for Power Query 😉

@opiodenis9665 26 дней назад

I had never used the Menu key and I didn't even know its importance. Thank you so much for sharing.

@MyOnlineTrainingHub 26 дней назад

Great to hear you can make use of it!

@ahmedshalaby9343 25 дней назад

i like your new videos of shortcuts

@MyOnlineTrainingHub 25 дней назад

Great to hear 🙏

@shahjee-q1s 23 часа назад

good job

@MyOnlineTrainingHub 8 часов назад

Thanks for watching!

@solimbinanas8717 26 дней назад

Interesting video madam ❤❤

@MyOnlineTrainingHub 26 дней назад

Thank you! 😃

@waadtlander_ch8802 26 дней назад

Thanks from Switzerland 🇨🇭

@MyOnlineTrainingHub 26 дней назад

Thanks for watching!

@srider33 26 дней назад

I'm not sure if this makes me look smart or oblivious, but I knew most of these but I REALLY liked learning what that button was that has been staring at me all these years and it can simulate a right click. VIt's like the time when that other excel expert made an off-handed remark about editing named ranges with the arrow key by hitting f2~! Very cool!

@MyOnlineTrainingHub 26 дней назад

😁glad there was something new that you can use!

@danielmanahan7081 26 дней назад

I'll be using three for sure

@MyOnlineTrainingHub 26 дней назад

Awesome to hear!

@georgesinkinson682 25 дней назад

In what versions of Excel is the Navigation tool available?

@MyOnlineTrainingHub 25 дней назад

365 😊

@jimbo9247 24 дня назад

I also use Tool #4 a lot. However, watching this video, I'm going to start using Tool #1 a lot more. But #4 will still probably be my favorite.

@MyOnlineTrainingHub 24 дня назад

So great to hear!

$@frachiar4444$

@frachiar4444 14 дней назад

for me is usefull tip n° 3

@MyOnlineTrainingHub 14 дней назад

Glad to hear that 😊

@richardhay645 26 дней назад

I use all of these but I use Filter by Selecyed Cell Value the.most and Navigation Pane second.

@MyOnlineTrainingHub 26 дней назад

Awesome to hear 🙏

@sledgehammer-productions 22 дня назад

Dragging formules in a table column is okay, in any other situation the outcome sometimes surprises me (negatively). As a result I'm advocating against dragging unless you know what you're doing 🙂

@MohammadAshooryan 26 дней назад

My favorite is number5👌

@MyOnlineTrainingHub 26 дней назад

Great to hear!

@DrDamoStrikesBack 25 дней назад

No criticism here, but I prefer CTRL+ALT+V (to invoke Paste Special) then clicking on the relevant key to select the appropriate function. E.g. CTRL+ALT+V-F-Enter to paste formulas. This is very, very fast set of key strokes so i prefer this to any mouse operation. Combined with CTRL+SPACE to select an entire column makes this a great shortcut for long datasets. Learning the shortcuts for pasting values ("V" instead of "F") or transposing or multiplying etc puts a host of different capabilities at ones finger tips based on the same shortcut set.

@MyOnlineTrainingHub 24 дня назад

Thanks for sharing! I also use ALT > E > S > F > ENTER sometimes for copying formulas. Depends on what mood I'm in 😁but now that we have CTRL+SHIFT+V for paste special, I never use the ALT shortcuts.

@michaeldavenport9268 26 дней назад

Nav pane is AWESOME!

@MyOnlineTrainingHub 26 дней назад

Glad you like it!

@RieRiePie 25 дней назад

What if I don't have the Navigation Pane, is there an alternative?

@MyOnlineTrainingHub 25 дней назад

You could build your own navigation menu with hyperlinks: www.myonlinetraininghub.com/excel-hyperlink-buttons

@BaSYaVSkI 26 дней назад

My favorite is #5

@MyOnlineTrainingHub 26 дней назад

Glad you liked it!

@ANS-zn1pr 25 дней назад

👍👍

@holycat8312 26 дней назад

So I have to Type E and V from the Keyboard to filter?

@MyOnlineTrainingHub 26 дней назад

Yes, after pressing the Menu key.

@holycat8312 25 дней назад

Thanks

@SportsHunterArea 26 дней назад

Create a video on click product add the value or price to the total results Like click on pizza picture 🍕 add the price of pizza.

@duncandavies1966 24 дня назад

Tool #4 doesn't work for me, presumably because I'm using Excel on a mac. No shortcut keys for filter/filter by value. Shame as I'd use this a lot.

@MyOnlineTrainingHub 24 дня назад

Ah, yes Mac doesn't have the menu key unfortunately.

@rafiullah-zz1lf 26 дней назад

100th like from me what are the odds

@MyOnlineTrainingHub 26 дней назад

Thanks for your support 😁

@RudraEatingShow 26 дней назад

First comment

@MyOnlineTrainingHub 26 дней назад

Thank you! 😁

@aljaume3466 26 дней назад

Second comment

@MyOnlineTrainingHub 26 дней назад

😁

@VVeiQuek 26 дней назад

MacOS users: cries in comic sans 😂 I dare thee to press Cmd + Q! 😂

@MyOnlineTrainingHub 26 дней назад

😂

@jakel3333 18 дней назад

Within the first minute.... "WHAT?!"

@jakel3333 18 дней назад

As in I was so excited for the shortcut she just showed

@MyOnlineTrainingHub 18 дней назад

So pleased you found some tips you could use 😁

@JuanGarcia-os4uy 26 дней назад

@MyOnlineTrainingHub 26 дней назад

🙏

@RichardGreco 21 день назад

Won't even describe tools in description text. Time to unsubscribe.

@MyOnlineTrainingHub 21 день назад

Not sure what you're referring to. Care to elaborate so I can understand the issue?

@RichardGreco 21 день назад

@@MyOnlineTrainingHub Sure. That the tools you explained in your video are not described at all in the video description. Thank god you provided time stamps in the the video description but hid the tool under your alias "Tool No 1", etc. It would have been a convenient resource to have the tool named appropriately in the video description along with the timestamp for ease of future reference. I have found it useful in the past to add your videos and others to my Excel RU-vid playlist. But no worries, I was able to create my own notepad text document listing what each tip was and how to use it. Now at least instead of going to your video as a reference to rewatch I can instead find more info online.

@MyOnlineTrainingHub 16 дней назад

Thanks for the feedback, Richard.