5 HIDDEN Excel Tools Almost Nobody Is Talking About

Рет қаралды 32,483

Күн бұрын

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

Пікірлер: 133

@MyOnlineTrainingHub 9 күн бұрын

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

@user-pf8lb9vy1z 8 күн бұрын

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

@johnguarnero4084 8 күн бұрын

Your voice is cool as well.

@gdboone 7 күн бұрын

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

@garydunken7934 7 күн бұрын

For formula paste, I use Alt+H V F

@mr.gk5 4 күн бұрын

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

@BoraHorzaGobuchul 3 күн бұрын

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 3 күн бұрын

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

@BoraHorzaGobuchul 3 күн бұрын

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

@SergioAlejandroCampos 6 күн бұрын

I love your thumbnail, Mynda.

@MyOnlineTrainingHub 6 күн бұрын

Thanks, Sergio!

@MGE0007 7 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

So pleased to hear that 😁

@BoraHorzaGobuchul 3 күн бұрын

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

@cngz_hsvr 7 күн бұрын

You are the Queen of Excel 🙂

@MyOnlineTrainingHub 6 күн бұрын

You’re too kind 🙏😊

@happymystic9800 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

Glad it was helpful!

@marjoriefrancis4560 8 күн бұрын

Thanks Mynda! Awesome as always.

@MyOnlineTrainingHub 8 күн бұрын

Thanks so much, Marjorie!

@kirk1968 7 күн бұрын

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 7 күн бұрын

It sure has!

@patrick1972seb Күн бұрын

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 Күн бұрын

So nice of you 🙏

@chrism9037 8 күн бұрын

Great tips Mynda. I like # 4 as well.

@MyOnlineTrainingHub 8 күн бұрын

Thanks, Chris! Glad we agree 😁

@billgillaspey9036 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

Thanks so much, Bill!

@DianHrozek 6 күн бұрын

Great! Thank you ❤❤

@MyOnlineTrainingHub 5 күн бұрын

Thanks for watching!

@BestJerome 5 күн бұрын

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

@TheArcass 12 сағат бұрын

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 10 сағат бұрын

Glad you can make use of it!

@user-xx5et3fj7b 7 күн бұрын

Yes!! Tool №4 is so sweet!!

@MyOnlineTrainingHub 6 күн бұрын

Glad you like it 🙏

@izkamarkizka 8 күн бұрын

Thank you😍

@MyOnlineTrainingHub 7 күн бұрын

Pleasure 😊

@ugonnabriggs5019 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

Nice!

@olivierissaverdens6916 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

Great to hear!

@SegueGreene 7 күн бұрын

love the filter/sort shortcut!

@MyOnlineTrainingHub 6 күн бұрын

Glad you can make use of it 😊

@Tom37323 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

So pleased you can make better use of it now.

@enriquefernandezaraujo3943 8 күн бұрын

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 7 күн бұрын

Great to hear!

@777kiya 4 күн бұрын

Helpful

@MyOnlineTrainingHub 3 күн бұрын

Glad to hear that 🙏

@sandratruax715 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

Glad you discovered something new 😊

@vaibhavdahival6397 8 күн бұрын

Great👌

@MyOnlineTrainingHub 7 күн бұрын

Thank you!

@Igor_Ashurkov 8 күн бұрын

nice job!

@MyOnlineTrainingHub 7 күн бұрын

Thanks!

@heinzthedutch 8 күн бұрын

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 7 күн бұрын

Glad you liked it!

@j_orpz 8 күн бұрын

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

@MyOnlineTrainingHub 8 күн бұрын

Glad you found something new 😁

@waadtlander_ch8802 8 күн бұрын

Thanks from Switzerland 🇨🇭

@MyOnlineTrainingHub 8 күн бұрын

Thanks for watching!

@stefankirst3234 6 күн бұрын

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

@MyOnlineTrainingHub 6 күн бұрын

Thanks for watching!

@danielmanahan7081 8 күн бұрын

I'll be using three for sure

@MyOnlineTrainingHub 7 күн бұрын

Awesome to hear!

@solimbinanas8717 8 күн бұрын

Interesting video madam ❤❤

@MyOnlineTrainingHub 8 күн бұрын

Thank you! 😃

@sledgehammer-productions 4 күн бұрын

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 🙂

@srider33 7 күн бұрын

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 7 күн бұрын

😁glad there was something new that you can use!

@walkingentropy 7 күн бұрын

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 7 күн бұрын

Thanks for sharing!

@chahineatallah2636 7 күн бұрын

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 7 күн бұрын

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 😉

@jimbo9247 6 күн бұрын

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 5 күн бұрын

So great to hear!

@opiodenis9665 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

Great to hear you can make use of it!

@ahmedshalaby9343 7 күн бұрын

i like your new videos of shortcuts

@MyOnlineTrainingHub 6 күн бұрын

Great to hear 🙏

@MohammadAshooryan 7 күн бұрын

My favorite is number5👌

@MyOnlineTrainingHub 7 күн бұрын

Great to hear!

@DrDamoStrikesBack 6 күн бұрын

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 6 күн бұрын

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.

@goodone05004 7 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

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.

@solvesonkd 7 күн бұрын

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 7 күн бұрын

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.

@billgyrotech 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

No. Not sure why you'd want this.

@michaeldavenport9268 8 күн бұрын

Nav pane is AWESOME!

@MyOnlineTrainingHub 7 күн бұрын

Glad you like it!

@sbon4771 7 күн бұрын

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 6 күн бұрын

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 5 күн бұрын

@@MyOnlineTrainingHub Thank you!

@richardhay645 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

Awesome to hear 🙏

@BaSYaVSkI 8 күн бұрын

My favorite is #5

@MyOnlineTrainingHub 7 күн бұрын

Glad you liked it!

@georgesinkinson682 7 күн бұрын

In what versions of Excel is the Navigation tool available?

@MyOnlineTrainingHub 6 күн бұрын

365 😊

@ANS-zn1pr 7 күн бұрын

👍👍

@RieRiePie 7 күн бұрын

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

@MyOnlineTrainingHub 6 күн бұрын

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

@holycat8312 8 күн бұрын

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

@MyOnlineTrainingHub 7 күн бұрын

Yes, after pressing the Menu key.

@holycat8312 6 күн бұрын

Thanks

@SportsHunterArea 8 күн бұрын

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.

@rafiullah-zz1lf 8 күн бұрын

100th like from me what are the odds

@MyOnlineTrainingHub 8 күн бұрын

Thanks for your support 😁

@duncandavies1966 6 күн бұрын

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 5 күн бұрын

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

@RudraEatingShow 8 күн бұрын

First comment

@MyOnlineTrainingHub 8 күн бұрын

Thank you! 😁

@aljaume3466 8 күн бұрын

Second comment

@MyOnlineTrainingHub 8 күн бұрын

😁

@VVeiQuek 8 күн бұрын

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

@MyOnlineTrainingHub 8 күн бұрын

😂

@jakel3333 7 сағат бұрын

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

@jakel3333 7 сағат бұрын

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

@MyOnlineTrainingHub 6 сағат бұрын

So pleased you found some tips you could use 😁

@JuanGarcia-os4uy 8 күн бұрын

@MyOnlineTrainingHub 7 күн бұрын

🙏

@RichardGreco 2 күн бұрын

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

@MyOnlineTrainingHub 2 күн бұрын

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

@RichardGreco 2 күн бұрын

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