5 Excel Tools Most Users Never Think to Use (Files Included)

6 Excel tools that everyone MUST know how to use to boost productivity.

What if I told you there are Excel tools you're probably not using that could instantly improve your workflow? Hidden within Excel (sometimes in plain sight) are game-changing tools that most users overlook. Today, I'm going to show you how to master them to transform your productivity.

LEARN MORE
===========



⏲ TIMESTAMPS
==============
0:00 Tool №1
1:27 Tool №2
3:08 Tool №3
5:47 Tool №4
8:00 Tool №5
9:48 Tool №6

#Excel #ExcelTools #ExcelTips

[MyOnlineTrainingHub]

❓Which one of the tools is your favorite? Let me know in the comments!

[notesfromleisa-land]

Mon Dieu! Skip Blanks! (hiding from me all of this time!). The Formatting of the up/down custom formatting was the bell ringer for me. I always learn something new. Thanks Mynda!

[KittKatPawz]

Wow!! The skip blanks and multiply ones I’ve never known. Thanks for the updates on how to use! 😊

[hailegtesfa]

What I like most of you is that you are to the point and clear!

[franciscobarillas]

Thank you for such useful videos! I am a data analyst consultant who mostly uses Python or R for Analysis. I stopped using excel because I considered it passé, you’ve shown me that I need to get back and refresh my knowledge for updated functions.

[daves]

There are days when I think I am pretty good with Excel & then I watch one of these clips and realise there are a lot of simple things I miss… 🤦‍♂️😂

[kgadeberg]

I agree with no. 3 being very useful. I use the WIN+V all the time in all applications. Especially if I have a number of items I need to copy from one window to another. Instead of flipping back and forth between the windows using CTRL+C CTRL+V all the time, I pick up all I need from one window using CTRL+C multiple times and then paste them into the other window using WIN+V. Super useful.

[SteveSwanson]

I have long been a user of the Windows Key Paste you discussed. THANK YOU SO MUCH about displaying the clipboard and frequently used special characters! It's a big plus on an already powerful tool

[humansizedaperture]

I love the Visual Basic editor example. I’ve never seen someone whip it out in a handy shortcuts video, which is great because it can look intimidating at first but if normalized unlocks so much opportunity!

[venkatiyer]

I wish I have seen this video 4 hours back .... I was manually entering the data .... the paste special option with skip blanks would have worked for me .. any ways thanks a lot for these wonderful tips .... a big salute for your visualization as to how we work in Excel :)

[yokoyama]

Just when I thought I couldn't be impressed, you did it! All 6 tools are great to know, and now I know. Thank you Mynda!

[aiasaiascon]

Group - Ungroup columns is really helpful for temp use of narrowing focus! Skip Blanks was smth I didnot know!!!

[johnkasongo]

Bravo Mynda, these are tools that are quite useful and I must admit as an everyday excel user I never imagined my work could be simplified with the latter ones. N°3 isvery cool indeed yet I favor N°4 because on a weekly basis I share excel files with my team or colleagues or even my supervisor and am not able to hide some spreadsheets I wouldn't want them to see. Keep it up, your hints and ticks come in very handy at times. Once again thank you I appreciate your teachings which are clearly explained and easy to practise. Regards

[joshuamanampiu]

Honestly the highlighting cells with the triangles and custom format is so good for me. But all the tips in the video are fantastic!

[martyc]

A great tip to hide grouping/outlines is Ctrl 8 - toggles it on and off- it takes up a whack of real estate. Combined with Ctrl shift and F1 you maximize your screen when presenting.

[foulanelson]

Love t No 4! The Very Hidden "hack" has saved me hours of fixing Simple Dashboards that I share with a bigger audience. I simply make my Pivot Sheets Very Hidden and then protect the workbook, but still allow access to select Slicers.... Works like a charm :). Thanks for a GREAT video always learn something new. Today it was the Graphs with the arrows in Tool # 6

[SndfOmar]

Great tips. There is always something new to learn in Excel. Thank you 😊. I liked most No.# 6 @ 11:04. That was totally new to me.

[Mark-Bench]

On Formating Numbers you can also add colors, so there is no need to use conditional formatting.
I like to use the following format to show growth or decline in persentages.

[Color50]0, 0% ▲;[Red]-0, 0% ▼

[ymup]

Oh my goodness the paste special skip blanks is going to be so useful! Thank you so much!!

[kennygee]

I've been using excel for over 25 years and I didn't know about several of these tips. Thank you!