5 HIDDEN Excel Tools Almost Nobody Is Talking About

[@MyOnlineTrainingHub]

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

[@KristieMyers-g8z]

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

[@johnguarnero4084]

Your voice is cool as well.

[@gdboone]

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

[@naresh200]

Navigation is my favorite.

[@OleksiyKozubenko]

Just can't stop watching your videos and finding insights. Thank you

[@MyOnlineTrainingHub]

Glad you like them! 🙏

[@johnkasongo4762]

Awesome Mynda, simply awesome!!!

[@MyOnlineTrainingHub]

Thank you so much!!

[@marjoriefrancis4560]

Thanks Mynda! Awesome as always.

[@MyOnlineTrainingHub]

Thanks so much, Marjorie!

[@chrism9037]

Great tips Mynda. I like # 4 as well.

[@MyOnlineTrainingHub]

Thanks, Chris! Glad we agree 😁

[@billgillaspey9036]

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

[@MyOnlineTrainingHub]

Thanks so much, Bill!

[@sandrakyoutube]

🤩Thank you so much! Wonderful tips to apply right away to my daily work.

[@MyOnlineTrainingHub]

So great to hear 🙏

[@stculp]

All great, of course. My favorite was #4 Custom Filter, 2 thumbs up!

[@MyOnlineTrainingHub]

Thanks for voting 😊

[@happymystic9800]

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

[@MyOnlineTrainingHub]

Glad it was helpful!

[@garydunken7934]

For formula paste, I use Alt+H V F

[@mr.gk5]

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

[@BoraHorzaGobuchul]

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]

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

[@BoraHorzaGobuchul]

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

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

[@SegueGreene]

love the filter/sort shortcut!

[@MyOnlineTrainingHub]

Glad you can make use of it 😊

[@lucaslegz]

Thank you so much for all the great videos you create and caring that we use Excel in a more effective manner. I have been watching your videos for a while and just now subscribed. Not sure why I didn’t hit that button sooner. I appreciate your teachings. Stay blessed!

[@MyOnlineTrainingHub]

Wonderful to hear! 🙏😊

[@walkingentropy]

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]

Thanks for sharing!

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

[@eli-ge5be]

As a designer, I love the tips, thank you! How I can put the navigation to the Left? I can't do it (working with a Mac). Thank you!

[@MyOnlineTrainingHub]

Thank you! In Excel for Windows, you left click the top of the navigation pane and drag it across to the left. Not sure if this also works in Excel for Mac.

[@BestJerome]

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

[@stefankirst3234]

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

[@MyOnlineTrainingHub]

Thanks for watching!

[@LivingGuy484]

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

[@MyOnlineTrainingHub]

Great to hear!

[@enriquefernandezaraujo3943]

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]

Great to hear!

[@sandratruax715]

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

[@MyOnlineTrainingHub]

Glad you discovered something new 😊

[@sheerazhussain6875]

Madam you made excel more easier for us thank you

[@MyOnlineTrainingHub]

Great to hear!

[@olivierissaverdens6916]

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

[@MyOnlineTrainingHub]

Great to hear!

[@DianHrozek]

Great! Thank you ❤❤

[@MyOnlineTrainingHub]

Thanks for watching!

[@westleyempeigne6541]

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]

Glad you can make use of them 😊

[@SergioAlejandroCampos]

I love your thumbnail, Mynda.

[@MyOnlineTrainingHub]

Thanks, Sergio!

[@BoraHorzaGobuchul]

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

[@ugonnabriggs5019]

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

[@MyOnlineTrainingHub]

Nice!

[@cngz_hsvr]

You are the Queen of Excel 🙂

[@MyOnlineTrainingHub]

You’re too kind 🙏😊

[@Tom37323]

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

[@MyOnlineTrainingHub]

So pleased you can make better use of it now.

[@goodone05004]

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

[@MyOnlineTrainingHub]

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.

[@kirk1968]

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]

It sure has!

[@ΕλευθέριοςΠάντος]

Yes!! Tool №4 is so sweet!!

[@MyOnlineTrainingHub]

Glad you like it 🙏

[@elieg.8920]

Great video. The right click menu in Excel online doesn't seem to have any underline words , so no shortcuts can be used.

[@MyOnlineTrainingHub]

Thank you!

[@MGE0007]

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

[@MyOnlineTrainingHub]

So pleased to hear that 😁

[@j_orpz]

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

[@MyOnlineTrainingHub]

Glad you found something new 😁

[@izkamarkizka]

Thank you😍

[@MyOnlineTrainingHub]

Pleasure 😊

[@sbon4771]

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]

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]

@@MyOnlineTrainingHub Thank you!

[@solvesonkd]

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]

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.

[@heinzthedutch]

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]

Glad you liked it!

[@TheArcass]

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]

Glad you can make use of it!

[@shahjee-q1s]

good job

[@MyOnlineTrainingHub]

Thanks for watching!

[@tomtom5821]

I literally never knew the navigation pane existed! The things you can learn even after years in excel. Great tip

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@777kiya]

Helpful

[@MyOnlineTrainingHub]

Glad to hear that 🙏

[@billgyrotech]

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

[@MyOnlineTrainingHub]

No. Not sure why you'd want this.

[@danielmanahan7081]

I'll be using three for sure

[@MyOnlineTrainingHub]

Awesome to hear!

[@opiodenis9665]

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

[@MyOnlineTrainingHub]

Great to hear you can make use of it!

[@georgesinkinson682]

In what versions of Excel is the Navigation tool available?

[@MyOnlineTrainingHub]

365 😊

[@deebradford4026]

@@MyOnlineTrainingHub I have 365 but navigation is not shown where it is supposed to be. Any ideas why? I can't find it in the customize ribbon either. I do see something called Smart Document Pane under customize, but it doesn't show when I'm working in my file.

[@srider33]

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]

😁glad there was something new that you can use!

[@solimbinanas8717]

Interesting video madam ❤❤

[@MyOnlineTrainingHub]

Thank you! 😃

[@Igor_Ashurkov]

nice job!

[@MyOnlineTrainingHub]

Thanks!

[@richardhay645]

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

[@MyOnlineTrainingHub]

Awesome to hear 🙏

[@Firemission-qw3lj]

New subscriber here. How do private investigators use excel to solve or review cases?.

[@MyOnlineTrainingHub]

Thanks for the sub! That’s a great question but I don’t have any insights into that 🤔

[@waadtlander_ch8802]

Thanks from Switzerland 🇨🇭

[@MyOnlineTrainingHub]

Thanks for watching!

[@ahmedshalaby9343]

i like your new videos of shortcuts

[@MyOnlineTrainingHub]

Great to hear 🙏

[@chahineatallah2636]

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]

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 😉

[@vaibhavdahival6397]

Great👌

[@MyOnlineTrainingHub]

Thank you!

[@MohammadAshooryan]

My favorite is number5👌

[@MyOnlineTrainingHub]

Great to hear!

[@michaeldavenport9268]

Nav pane is AWESOME!

[@MyOnlineTrainingHub]

Glad you like it!

[@frachiar4444]

for me is usefull tip n° 3

[@MyOnlineTrainingHub]

Glad to hear that 😊

[@BaSYaVSkI]

My favorite is #5

[@MyOnlineTrainingHub]

Glad you liked it!

[@jimbo9247]

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]

So great to hear!

[@sledgehammer-productions]

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 🙂

[@RieRiePie]

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

[@MyOnlineTrainingHub]

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

[@enlighten92]

I wanted something like the navigation pane for so long. Feel stupid to have missed it all this while. I literally enter “View” tab everyday to remove grid lines and zooming to selection but I never bothered to check the NAVIGATION PANE option

[@MyOnlineTrainingHub]

😁glad you can use it. It hasn't been around for that long, so don't feel too bad.

[@DrDamoStrikesBack]

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]

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.

[@holycat8312]

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

[@MyOnlineTrainingHub]

Yes, after pressing the Menu key.

[@holycat8312]

Thanks

[@mohamadrezakhatibi596]

hi, why i can't see the navigation in my excel?

[@MyOnlineTrainingHub]

It's only available in 365.

[@mohamadrezakhatibi596]

@@MyOnlineTrainingHub thank you.

[@ANS-zn1pr]

👍👍

[@SportsHunterArea]

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]

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]

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

[@RudraEatingShow]

First comment

[@MyOnlineTrainingHub]

Thank you! 😁

[@rafiullah-zz1lf]

100th like from me what are the odds

[@MyOnlineTrainingHub]

Thanks for your support 😁

[@VVeiQuek]

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

[@MyOnlineTrainingHub]

😂

[@aljaume3466]

Second comment

[@MyOnlineTrainingHub]

😁

[@jakel3333]

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

[@jakel3333]

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

[@MyOnlineTrainingHub]

So pleased you found some tips you could use 😁

[@RichardGreco]

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

[@MyOnlineTrainingHub]

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

[@RichardGreco]

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

Thanks for the feedback, Richard.

[@geoffkendall2006]

Honestly, this is one of the rudest, most ungrateful and downright inexcusable criticisms I have read in a long while. Personally, I learned something extremely useful in the first sixty seconds. What has Mynda ever learned from you? Nothing.

[@valapo80800]

c'est abusé les pubs!!!!!

[@MyOnlineTrainingHub]

A quoi faites-vous référence?

[@JuanGarcia-os4uy]

:)

[@MyOnlineTrainingHub]

🙏

[@TrevorGopaul-jo1om]

The teacher is AI

[@MyOnlineTrainingHub]

Hilarious.

[@TrevorGopaul-jo1om]

@@MyOnlineTrainingHub Reference to someone as AI

[@TrevorGopaul-jo1om]

Reference to someone as AI will be a compliment in the future. You are ahead of your time.

[@bathroombuddy17]

Where is the menu key?

[@MyOnlineTrainingHub]

On my keyboard it's in the bottom right, to the left of the CTRL key.