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! 👋
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
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.
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.
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!
@@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"
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)
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.
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!
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'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!
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?
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!
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 😉
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.
@@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.
@@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 TH-cam 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.
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.
❓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.
I love your thumbnail, Mynda.
Thanks, Sergio!
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!
Thanks Mynda! Awesome as always.
Thanks so much, Marjorie!
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 😊
Really helpful tips 😮 … it is the small things that make life easier ❤ … Thank you, Mynda 😊
Glad it was helpful!
Its 07:54 in the morning for me……and this video has already made my day!!…
So pleased to hear that 😁
Great tips Mynda. I like # 4 as well.
Thanks, Chris! Glad we agree 😁
Thank you for the helpful tips and the opportunity to practice them in one place. I am looking forward to enrolling in your course.
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 🙏
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!
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!
🤩Thank you so much! Wonderful tips to apply right away to my daily work.
So great to hear 🙏
Awesome Mynda, simply awesome!!!
Thank you so much!!
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!
Wonderful to hear! 🙏😊
All great, of course. My favorite was #4 Custom Filter, 2 thumbs up!
Thanks for voting 😊
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"
Hello Mynda! Thank you for these tips. My favourite is the navigation pane which I probably should use more often ...
Great to hear!
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!
You are the Queen of Excel 🙂
You’re too kind 🙏😊
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!
This is awesome! I can actually see myself using 3 of the 5 tips for work someday
Great to hear!
One of the greatest new things for me is built-in ocr via get data from picture
I literally never knew the navigation pane existed! The things you can learn even after years in excel. Great tip
Glad you enjoyed it!
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.
Yes!! Tool №4 is so sweet!!
Glad you like it 🙏
love the filter/sort shortcut!
Glad you can make use of 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 ❤❤
Thanks for watching!
❤, thanks for sharing your knowledge. #1 is my fav.
Nice!
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 😊
Madam you made excel more easier for us thank you
Great to hear!
Thank you😍
Pleasure 😊
I'll be using three for sure
Awesome to hear!
I didn't know about the navigation pane - thanks!
Glad you found something new 😁
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 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!
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!
Great video. The right click menu in Excel online doesn't seem to have any underline words , so no shortcuts can be used.
Thank you!
My favorite is #5
Glad you liked it!
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.
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!
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.
Thanks from Switzerland 🇨🇭
Thanks for watching!
Interesting video madam ❤❤
Thank you! 😃
Hi Mynda. Have you updated your monthly budget workbook without pivot tables?
No. Not sure why you'd want this.
Nav pane is AWESOME!
Glad you like it!
Helpful
Glad to hear that 🙏
good job
Thanks for watching!
nice job!
Thanks!
My favorite is number5👌
Great to hear!
i like your new videos of shortcuts
Great to hear 🙏
for me is usefull tip n° 3
Glad to hear that 😊
Great👌
Thank you!
I use all of these but I use Filter by Selecyed Cell Value the.most and Navigation Pane second.
Awesome to hear 🙏
In what versions of Excel is the Navigation tool available?
365 😊
@@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.
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
hi, why i can't see the navigation in my excel?
It's only available in 365.
@@MyOnlineTrainingHub thank you.
First comment
Thank you! 😁
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.
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.
👍👍
100th like from me what are the odds
Thanks for your support 😁
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 TH-cam 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.