5 HIDDEN Excel Tools Almost Nobody Is Talking About
Vložit
- čas přidán 30. 07. 2024
- 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 - Věda a technologie
❓Which tool mentioned in the video is your favorite, and why?
Become an Excel expert with my course: bit.ly/htools24course
The navigation pane is a feature I've never used, but super helpful. Thanks for the great content!
Your voice is cool as well.
Your favorite is going to be my new one! Although navigation is new for me too
Navigation is my favorite.
Thank you for the helpful tips and the opportunity to practice them in one place. I am looking forward to enrolling in your course.
Thanks Mynda! Awesome as always.
Thanks so much, Marjorie!
Really helpful tips 😮 … it is the small things that make life easier ❤ … Thank you, Mynda 😊
Glad it was helpful!
Hello Mynda! Thank you for these tips. My favourite is the navigation pane which I probably should use more often ...
Great to hear!
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!
So nice of you 🙏
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! 👋
It sure has!
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.
Glad you can make use of it!
Wow!. Always some new good things to learn. Thanks!
Thanks so much, Bill!
Great tips Mynda. I like # 4 as well.
Thanks, Chris! Glad we agree 😁
Its 07:54 in the morning for me……and this video has already made my day!!…
So pleased to hear that 😁
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)
Great to hear!
❤, thanks for sharing your knowledge. #1 is my fav.
Nice!
For formula paste, I use Alt+H V F
Yeah but that’s pretty well known. It’s neither new nor hidden
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
@@BoraHorzaGobuchul can you somehow save the custom ribbon settings in case you need to reinstall excel or switch to a different computer?
@@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
@@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"
Thanks for another wonderful video. I like the Flash Fill the best, and then the Navigation pane. Didn't know it existed.
Glad you discovered something new 😊
This is awesome! I can actually see myself using 3 of the 5 tips for work someday
Great to hear!
I knew about the navigation pane, but I did not know how to make it useful. Thank you for all the good tips.
So pleased you can make better use of it now.
All 5 Tools are great but #4 would be my favourite, too. Thank for the awesome video!
Thanks for watching!
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.
Glad you liked it!
I love your thumbnail, Mynda.
Thanks, Sergio!
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
Glad you can make use of them 😊
Great! Thank you ❤❤
Thanks for watching!
love the filter/sort shortcut!
Glad you can make use of it 😊
Madam you made excel more easier for us thank you
Great to hear!
Yes!! Tool №4 is so sweet!!
Glad you like it 🙏
Thank you😍
Pleasure 😊
I didn't know about the navigation pane - thanks!
Glad you found something new 😁
You are the Queen of Excel 🙂
You’re too kind 🙏😊
One of the greatest new things for me is built-in ocr via get data from picture
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
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 😉
Great video again, but what is the "menu key" you talked about in tool number 4?
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.
I had never used the Menu key and I didn't even know its importance. Thank you so much for sharing.
Great to hear you can make use of it!
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!
Thanks for sharing!
Great👌
Thank you!
Helpful
Glad to hear that 🙏
nice job!
Thanks!
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?
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.
Thanks from Switzerland 🇨🇭
Thanks for watching!
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!
😁glad there was something new that you can use!
Hi Mynda. Have you updated your monthly budget workbook without pivot tables?
No. Not sure why you'd want this.
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!
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.
@@MyOnlineTrainingHub Thank you!
good job
Thanks for watching!
Interesting video madam ❤❤
Thank you! 😃
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 🙂
i like your new videos of shortcuts
Great to hear 🙏
I'll be using three for sure
Awesome to hear!
for me is usefull tip n° 3
Glad to hear that 😊
I use all of these but I use Filter by Selecyed Cell Value the.most and Navigation Pane second.
Awesome to hear 🙏
My favorite is number5👌
Great to hear!
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.
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.
Nav pane is AWESOME!
Glad you like it!
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.
So great to hear!
In what versions of Excel is the Navigation tool available?
365 😊
My favorite is #5
Glad you liked it!
👍👍
What if I don't have the Navigation Pane, is there an alternative?
You could build your own navigation menu with hyperlinks: www.myonlinetraininghub.com/excel-hyperlink-buttons
So I have to Type E and V from the Keyboard to filter?
Yes, after pressing the Menu key.
Thanks
100th like from me what are the odds
Thanks for your support 😁
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.
Ah, yes Mac doesn't have the menu key unfortunately.
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.
First comment
Thank you! 😁
Second comment
😁
MacOS users: cries in comic sans 😂
I dare thee to press Cmd + Q! 😂
😂
Within the first minute.... "WHAT?!"
As in I was so excited for the shortcut she just showed
So pleased you found some tips you could use 😁
:)
🙏
c'est abusé les pubs!!!!!
A quoi faites-vous référence?
Won't even describe tools in description text. Time to unsubscribe.
Not sure what you're referring to. Care to elaborate so I can understand the issue?
@@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 CZcams 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.
Thanks for the feedback, Richard.
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.
The teacher is AI
Hilarious.
@@MyOnlineTrainingHub Reference to someone as AI
Reference to someone as AI will be a compliment in the future. You are ahead of your time.
Where is the menu key?
On my keyboard it's in the bottom right, to the left of the CTRL key.