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! 👋
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!
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!
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 😉
@@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"
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 🙂
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.
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 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 UA-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.
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!
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! 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.
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!
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
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)
❓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 so much! Wonderful tips to apply right away to my daily work.
So great to hear 🙏
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!
I love your thumbnail, Mynda.
Thanks, Sergio!
Its 07:54 in the morning for me……and this video has already made my day!!…
So pleased to hear that 😁
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 🙏
Wow!. Always some new good things to learn. Thanks!
Thanks so much, Bill!
Thank you for the helpful tips and the opportunity to practice them in one place. I am looking forward to enrolling in your course.
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!
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!
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!
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 😉
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!
Hi Mynda. Have you updated your monthly budget workbook without pivot tables?
No. Not sure why you'd want this.
nice job!
Thanks!
Nav pane is AWESOME!
Glad you like it!
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"
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
Really helpful tips 😮 … it is the small things that make life easier ❤ … Thank you, Mynda 😊
Glad it was helpful!
So I have to Type E and V from the Keyboard to filter?
Yes, after pressing the Menu key.
Thanks
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 🙂
One of the greatest new things for me is built-in ocr via get data from picture
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.
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.
Thanks Mynda! Awesome as always.
Thanks so much, Marjorie!
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!
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 UA-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.
100th like from me what are the odds
Thanks for your support 😁
Great tips Mynda. I like # 4 as well.
Thanks, Chris! Glad we agree 😁
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!
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.
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!
Interesting video madam ❤❤
Thank you! 😃
All great, of course. My favorite was #4 Custom Filter, 2 thumbs up!
Thanks for voting 😊
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!
Second comment
😁
I literally never knew the navigation pane existed! The things you can learn even after years in excel. Great tip
Glad you enjoyed it!
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.
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.
You are the Queen of Excel 🙂
You’re too kind 🙏😊
Awesome Mynda, simply awesome!!!
Thank you so much!!
👍👍
i like your new videos of shortcuts
Great to hear 🙏
First comment
Thank you! 😁
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.
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! 🙏😊
Hello Mynda! Thank you for these tips. My favourite is the navigation pane which I probably should use more often ...
Great to hear!
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 😊
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!
for me is usefull tip n° 3
Glad to hear that 😊
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 😊
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 😁
I use all of these but I use Filter by Selecyed Cell Value the.most and Navigation Pane second.
Awesome to hear 🙏
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!
All 5 Tools are great but #4 would be my favourite, too. Thank for the awesome video!
Thanks for watching!
❤, thanks for sharing your knowledge. #1 is my fav.
Nice!
This is awesome! I can actually see myself using 3 of the 5 tips for work someday
Great to hear!
good job
Thanks for watching!
Helpful
Glad to hear that 🙏
c'est abusé les pubs!!!!!
A quoi faites-vous référence?
Thanks from Switzerland 🇨🇭
Thanks for watching!
MacOS users: cries in comic sans 😂
I dare thee to press Cmd + Q! 😂
😂
I didn't know about the navigation pane - thanks!
Glad you found something new 😁
My favorite is number5👌
Great to hear!
I'll be using three for sure
Awesome to hear!
Great! Thank you ❤❤
Thanks for watching!
Yes!! Tool №4 is so sweet!!
Glad you like it 🙏
Thank you😍
Pleasure 😊
Great👌
Thank you!
Where is the menu key?
On my keyboard it's in the bottom right, to the left of the CTRL key.
:)
🙏
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.