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

  Рет қаралды 267,306

MyOnlineTrainingHub

MyOnlineTrainingHub

Күн бұрын

Пікірлер: 381
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
❓Which one of the tools is your favorite? Let me know in the comments! Download the FREE "Custom Number Formats" cheatsheet: bit.ly/tools24cheatsheet
@SAI-xn7yq
@SAI-xn7yq 6 ай бұрын
I am new here someone help me guide where to start in this channel, which playlist to which? 🙏🙏🙏
@shakiraasfoor7599
@shakiraasfoor7599 6 ай бұрын
@@SAI-xn7yq all these videos are useful, myanda is MPV.
@shakiraasfoor7599
@shakiraasfoor7599 6 ай бұрын
Tool №3 Clipboard
@mademoiselleaqua
@mademoiselleaqua 2 ай бұрын
#3! but also learned a lot from the rest as well.
@kgadeberg
@kgadeberg 6 ай бұрын
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.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Great use case for Win+V. Thanks for sharing.
@franciscobarillas8500
@franciscobarillas8500 3 ай бұрын
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.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Excel has come a long way with the introduction of dynamic arrays, Power Query and more. Have fun with it!
@daves902
@daves902 6 ай бұрын
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… 🤦‍♂️😂
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
So glad you found some new tips you can use 😊
@bobgreenfield9158
@bobgreenfield9158 6 ай бұрын
My Excel was fighting with me. I was trying to insert columns. It would do a few and it stopped. A big ribbon would come up. I couldn't use that. I had to really fight with it to do as I asked. It was exhausting. What is the solution to this? ​@@MyOnlineTrainingHub
@nbjamspice
@nbjamspice 6 ай бұрын
I feel the same... I appreciate these clips
@UpcomingJedi
@UpcomingJedi 4 ай бұрын
Thats better than thinking im pretty good then i realise i have no idea how to do something so stupid simple like adding a second axis to a line graph
@notesfromleisa-land
@notesfromleisa-land 6 ай бұрын
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!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
😁glad you can make use of some of these techniques.
@kevinmahernz
@kevinmahernz 4 ай бұрын
You can also add colours to the up and down symbols so e.g. the up arrow appears green and down red. I've yet to watch Mynda's custom formats video, but it's more than likely in there somewhere.
@shirsN
@shirsN 5 ай бұрын
I watch content about excel from many other channels i like theirs and yours too. But the way you speak so peacefully sets it apart 😃
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
Thanks so much 🥰 I appreciate that!
@SissasHeART
@SissasHeART 6 ай бұрын
I totally watched this with my morning coffee this morning, and then my hubby had a situation tonight where I got to use your tips! Thank you for sharing your knowledge and very cool hacks. ... and bonus, I got to be the Excel Hero with my hubbs! Whoot.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Love that! 😁👏
@sandratruax715
@sandratruax715 6 ай бұрын
#2. Paste Special (Convert Values) is my favorite. Love your videos and your teaching style.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Thanks for your kind words 🙏😊
@jonk3361
@jonk3361 6 ай бұрын
Best one for me was grouping, Skipping blanks, using VBA option to hide sheet and the OG is changing numbers to %. Many thanks🤝🤝🤝
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
😁too many to choose from! Thanks for watching and sharing your favourites.
@KittKatPawz
@KittKatPawz 6 ай бұрын
Wow!! The skip blanks and multiply ones I’ve never known. Thanks for the updates on how to use! 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad you like them!
@hailegtesfa7540
@hailegtesfa7540 3 ай бұрын
What I like most of you is that you are to the point and clear!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Much appreciated 🥰
@SteveSwanson999
@SteveSwanson999 6 ай бұрын
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
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
So pleased you can make use of it.
@venkatiyer7459
@venkatiyer7459 3 ай бұрын
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 :)
@FsoOmar
@FsoOmar 6 ай бұрын
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.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad you enjoyed it and discovered something new!
@foulanelson2006
@foulanelson2006 3 ай бұрын
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
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Awesome to hear! 😁
@tikchyeoon8486
@tikchyeoon8486 2 күн бұрын
Thank You for the tutorial.
@MyOnlineTrainingHub
@MyOnlineTrainingHub Күн бұрын
You are welcome!
@martyc5674
@martyc5674 6 ай бұрын
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.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Great tips 🙏
@Mark-Bench
@Mark-Bench 6 ай бұрын
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% ▼
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Yes, good point 👍 I always find the colour formatting a bit of a hassle cause you have to find the colour codes of anything other than the standard red, green, blue etc.
@kennygee2715
@kennygee2715 4 ай бұрын
I've been using excel for over 25 years and I didn't know about several of these tips. Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
So pleased you discovered some new tips 😊
@joshuamanampiu6489
@joshuamanampiu6489 6 ай бұрын
Honestly the highlighting cells with the triangles and custom format is so good for me. But all the tips in the video are fantastic!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad you like them!
@lauphyon
@lauphyon 6 ай бұрын
Tools number 2 & 3 absolutely! The money platform report is always time time-consuming workload and converted into our company's report. Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Great to hear you can make use of them! 😊
@LouzyNL
@LouzyNL Ай бұрын
Paste special skip blanks is a game changer for me !
@MyOnlineTrainingHub
@MyOnlineTrainingHub Ай бұрын
Great to hear you make use of it!
@humansizedaperture
@humansizedaperture 6 ай бұрын
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!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
That's great to hear 🙏
@CajOosters
@CajOosters 3 ай бұрын
As always with your tips, very usefyl Mynda. Thanks a lot. My favorite is tip 2 but I think that I'll use tip 3 more often. Please keep up the good work to help me use Excel better every day.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Thank you! Glad you found some ideas you can use 😊
@yokoyama7590
@yokoyama7590 6 ай бұрын
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!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
😁 awesome to hear!
@johnkasongo4762
@johnkasongo4762 3 ай бұрын
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
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
So pleased you found some tips you can use 😊
@anv.4614
@anv.4614 2 ай бұрын
Thank you very much. The best tool I like is conditional formatting.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 ай бұрын
You are welcome!
@aiasaiascon3894
@aiasaiascon3894 6 ай бұрын
Group - Ungroup columns is really helpful for temp use of narrowing focus! Skip Blanks was smth I didnot know!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
So pleased it was helpful 😊
@TrocarSlushWeasel
@TrocarSlushWeasel 6 ай бұрын
At my old job, Group Data was super useful when multiple people worked with the same spreadsheets. Hidden rows/columns aren't obvious but when you group data and hide rows/columns, it is obvious to other users that there is data hidden.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Yes, another great reason to use them. Thanks for sharing.
@flightforge30
@flightforge30 2 ай бұрын
bravo! ive learned a lot from this video and come to think of it that I'll be needing these techniques on conditional formatting
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 ай бұрын
Wonderful to hear!
@Flicka-z3g
@Flicka-z3g 5 ай бұрын
I didn't know about #4 and I love that! Will definitely be super hiding some sheets from nosy folk. As for ones I use a ton, #5 (Custom formatting). I use this to bypass conditional formatting which can really bog down a large worksheet (and also gets messy with pivot tables and copy/pasted cells). Finally, thanks for pointing out using purple as an alternative for people with certain visual impairments. I love that you use icons as well.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
So pleased you found some new ideas you can use 😊
@cathyfrankland9158
@cathyfrankland9158 6 ай бұрын
OMG, I'm only part of the way into the video, but - WOW, column grouping and skip blanks, thank you, they will be SO helpful ❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Awesome to hear 😁
@marybellandry2975
@marybellandry2975 4 ай бұрын
Thank you Mynda! Always fun and most importantly useful tips!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
So glad!
@JJ_TheGreat
@JJ_TheGreat 6 ай бұрын
7:50 Question: So if you hide a sheet that way so that it is "very hidden", and then you were to go back to Excel and hide a different sheet the usual way by right- clicking it, would it allow you to "Unhide..." it in that situation - considering that the very hidden method looks like it greys out that option? I am just curious. Thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
No. Very hidden sheets can only be un-hidden via the VB editor.
@12drbe
@12drbe 3 ай бұрын
Great videos. I want to create a form and fill in the data from an existing excel spreadsheet
@BuckeyeNut123
@BuckeyeNut123 6 ай бұрын
Grouping. I create very large and ever expanding sheets in my books. I wish I had known about this many years ago. Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
So pleased you can make use of this feature.
@fayyaztabussam8611
@fayyaztabussam8611 6 ай бұрын
I like No.4 the most. Any how all numbers are super. Great stuff of course.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Thanks for voting 😊
@eversut1
@eversut1 4 ай бұрын
Each and every second of the video is important and helpful, thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
That's wonderful to hear 🙏
@rjbush7955
@rjbush7955 6 ай бұрын
Hiding sheets by VBA properties is a favourite of mine. Useful to hide lookup sheets from being tampered with in a shared workbook.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Nice to know you use it too 😁
@melantha1982
@melantha1982 6 ай бұрын
Never tried skip Blanks so will give it a go..cheers
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
So pleased to hear you found something new you can use 😁
@TheNeilsolaris
@TheNeilsolaris 6 ай бұрын
With the very hidden worksheet property, you can also password protect it, so nobody else can access the objects in the developer section without entering a password. That's what I do with one of my files.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Nice.
@TheNeilsolaris
@TheNeilsolaris 6 ай бұрын
@@MyOnlineTrainingHub In case anyone is wondering how, in the developer tab, click on tools, then select VBA Project Properties, then Protection, and enter your password.
@ym10up
@ym10up 4 ай бұрын
Oh my goodness the paste special skip blanks is going to be so useful! Thank you so much!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Great to hear!
@madlarch
@madlarch 6 ай бұрын
Wow. I use conditional formatting with formulas all the time - although I tend to prefer doing a background fill on the cell in order to make it really stand out. I have also seen the symbols thing in another video (of yours, I think). However, I did not know any of the first four! VERY useful video. Thanks !!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
So pleased to hear you found some new ideas 😁
@FarhanMerchant
@FarhanMerchant 6 ай бұрын
Some really amazing insights ; although I have been using these... but you have made it more effective and optimized. Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad it was helpful!
@chandan5908
@chandan5908 5 ай бұрын
So far the best vdo for learning excel . Thanks a lot.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
So glad to hear that 🙏
@chrism9037
@chrism9037 6 ай бұрын
Great video Mynda! I agree, 3 is the best
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Cheers, Chris! Glad we agree 😁
@kevinmahernz
@kevinmahernz 4 ай бұрын
Thank you for this, wasn't aware of the clipboard being available in Excel. Did know of Win-V but wasn't aware of the tabs within it. Never used Paste Special Multiply either, so good to know that exists!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Awesome to hear!
@vikastiwari7134
@vikastiwari7134 5 ай бұрын
last tip was awesome Mynda, I didn't knew that one, Love from India, please always surprise us with these tips and tricks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
Thank you! Will do!
@MissPickles1980
@MissPickles1980 5 ай бұрын
Hiding sheets! OMG, this is a game changer for me! Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
You're so welcome!
@sagar360m
@sagar360m 2 ай бұрын
Great learning, thanks for sharing ❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 2 ай бұрын
Glad you found it helpful 😊
@GraeHunter
@GraeHunter 6 ай бұрын
Great video! - 1 & 3 are competting for favorutes. But in all honesty - I'll be using all of these from now on. I already used conditional formatting, but had never thought about how utilising a colourblind palette would more accessible. Time to review old templates
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Awesome to hear, Grae!
@trebor6v418
@trebor6v418 4 ай бұрын
That windows+V short cut is extremely useful! Thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Glad it was helpful!
@alexandercato7400
@alexandercato7400 6 ай бұрын
Great list of tips! Appreciate how easy the video was to follow along.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad you enjoyed it! 🙏😊
@RoelVinkes
@RoelVinkes 3 ай бұрын
Totally forgot about Number 1. Started reusing it, thanks.
@alfredoluwatomi6899
@alfredoluwatomi6899 6 ай бұрын
This is fantastic, always having to learn a new simple yet powerful excel function. Many thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
So pleased to hear that 😁
@tony586ful
@tony586ful 6 ай бұрын
Numeber 3... A real new world for me.. Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Awesome to hear!
@doberg3191
@doberg3191 6 ай бұрын
I also use the "Paste Special" multiply by 1 when numbers are formatted as text.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Yes, another great use case. Thanks for sharing.
@masoudsalami
@masoudsalami 5 ай бұрын
Good stuff you are teaching us. Thank you very much and you speak so peacefully and very easy to understand. But I was able to make the up arrow green and the down one red. Then I copied and continued your instructions. But the colors come all black and not the red or green!
@jimbarton5253
@jimbarton5253 5 ай бұрын
The in-excel clipboard could be useful. Currently I use Ditto which doesn't have the clip limit and can sync clipboard on multiple PCs.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
Great to hear!
@amjan
@amjan 4 ай бұрын
#2 -> MIND = BLOWN, thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Awesome 😁
@silvo4880
@silvo4880 6 ай бұрын
I’d not thought to put symbols in the custom format before, that’s neat. I have been using the text colour in custom format rather than conditional formatting for a wile now as the conditional formatting ranges often need a tidy up on larger spreadsheets with multiple users.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad you liked it! I know what you mean about CF. Fortunately, in 365 they've finally fixed the issue of fragmented CF ranges 😅 I prefer CF because the colours are easier to choose. With custom number formats you have to lookup the colour code if it's not one of the standard colours.
@therealjeffg
@therealjeffg 6 ай бұрын
More gold, thanks Mynda. No. 3 if my favourite.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Great to hear 🙏
@brighttriangle
@brighttriangle 6 ай бұрын
Thank you for another great video. I love to show folks the power of Paste Special, so that is probably my favorite. I would love that Clipboard Pane, but sadly it is unavailable on Mac. 🤷‍♂
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Ah, the Mac strikes again. Another reason I will never own a Mac. 😔
@elogaziesmith7855
@elogaziesmith7855 Күн бұрын
Beautiful tutorial. thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub Күн бұрын
I'm glad you found it helpful! 😊
@ahmedshalaby9343
@ahmedshalaby9343 6 ай бұрын
Hello Very useful tips , I want to ask question about copy and paste operations if I have 2 columns with the same numbers of 100 rows , I filtered one of them and changed some data now I want to copy the changed data to the first column how I can do that ?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Great question. I don't think there's an easy way to do that, sorry. Better to change both columns at the same time.
@mllawhorn5584
@mllawhorn5584 4 ай бұрын
Great tips! I particularly like the vb method of hiding worksheet. I was unaware of that one.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Glad it was helpful!
@remuslupinhp
@remuslupinhp 3 ай бұрын
The custom # format trick is epic!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Glad you like it 😁
@bobmoorehead8553
@bobmoorehead8553 6 ай бұрын
You are SOOO AMAZING! Tip #3 was my favorite, too. Thank you for continuing to share your tips. Have a fabulous day!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
You're so welcome! Hope you have a fabulous day too 😊
@nour-eddineoumakhlouf5296
@nour-eddineoumakhlouf5296 6 ай бұрын
Endless learning ! Thank you so much for all your efforts
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Happy to hear that!
@karolinab9749
@karolinab9749 6 ай бұрын
#2 😀 and I love custom formatting! Thank you for this video!😀
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
My pleasure! Thanks for watching 😁
@therealjeffg
@therealjeffg 3 ай бұрын
Thank Myda...yes no. 3 for me
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Great to hear!
@kylelane630
@kylelane630 3 ай бұрын
One I never 'noticed' Paste Special: Skip Blanks! And interestingly, I was thinking about that concept the other day...
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
So glad it was helpful 😊
@thomas_didymus
@thomas_didymus 5 ай бұрын
Thank you. I like and now use Tip 1, column groups. Very handy! I need more groups, I'll bet some day soon there will be more available.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
Great to hear!
@jamesbennett5421
@jamesbennett5421 6 ай бұрын
My favorite Paste Special? when you have numbers but somehow they are represented as Text. Copy 1, then Paste Special Multiply. Poof, all of your numbers that were Text are now Numbers.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Yes, another great use 👍 thanks for sharing.
@mariateresabuenavista8560
@mariateresabuenavista8560 4 ай бұрын
Skip blanks and multiply are my new faves!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Awesome to hear!
@yeldix123
@yeldix123 5 ай бұрын
That paste special is very useful 😀. Thanks for sharing
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
Great to hear!
@richardhay645
@richardhay645 6 ай бұрын
I'm a be fan of Grouping columns and of Paste Special I normally use keyboard shortcuts to apply the appropriate Paste Special option.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Great to hear, Richard. I'm a fan of Alt > E > S too 😁
@Cindanela
@Cindanela 5 ай бұрын
Thank you for great videos. Love these tips. I have used excel for many years and did not know about the buildt in clipboard. Had seen the paste special before but forgot about it. I have red green color deficiency but those two colours you used together here are worse than red and green together for me, had to go very close to the screen to see the difference, but maybe my eyes are just weird. My Favourite custom format I've used lately is ;;; since it hides the cell value; learned it from a Swedish Microsoft MVP, can't remember the name, he does some short weekly Swedish videos and newsletter. Thank you again and have a lovely day:)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
Thanks for watching! Glad you found some helpful tips. Good to know about the purple and green 🙏 will keep it in mind.
@tomfontanella6585
@tomfontanella6585 4 ай бұрын
Never thought to click on that little arrow to expand the Clipboard menu item... I mean, what could possibly be there of value? :) I've used Excel for many years and thanks to your videos have moved from being befuddled by custom number formats to incorporating regular use of them.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Wow, that's great to hear, Tom!
@MonikaR2006
@MonikaR2006 4 ай бұрын
Gosh, this is brilliant! Thank you so much. I have a new subscriber 🙂
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Awesome! Thank you!
@JeffLittle-bi5jd
@JeffLittle-bi5jd 6 ай бұрын
#3 is great ... didn't know this one! Also think #4 is excellent!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Cheers, Jeff! Glad you like them.
@ShirleiBarnes
@ShirleiBarnes 4 ай бұрын
No wonder why I love Excel ❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Me too 😁
@kayespedal10
@kayespedal10 6 ай бұрын
Saw this one video and I immediately subscribed. I'll try some these tmw when I log in. A+
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Wonderful to hear 🙏
@Quidisi
@Quidisi 6 ай бұрын
Oh, this was great. Some was new, and some were things that I once knew, but had forgotten. Thanks!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
That's a double win! 😁
@SAI-xn7yq
@SAI-xn7yq 6 ай бұрын
I am new here someone help me guide where to start in this channel, which playlist to which? 🙏🙏🙏
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Welcome! You can start with any playlist. They're organised by topic as opposed to beginning to end. If you want to follow a logical path to mastering Excel, please consider my Excel Expert course: www.myonlinetraininghub.com/excel-expert-upgrade
@SAI-xn7yq
@SAI-xn7yq 6 ай бұрын
@@MyOnlineTrainingHub mam i am lower middle class person can't pay can you guide me how to follow the playlists 🙏🙏🙏🙏please
@SAI-xn7yq
@SAI-xn7yq 6 ай бұрын
@@MyOnlineTrainingHub can i learn power bi or power query without knowledge of excel in your playlist
@MikeFicher
@MikeFicher 3 ай бұрын
Oh, yes, tip 3 is a game-changer...thank you!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Glad it was helpful!
@daoudathiaw
@daoudathiaw 6 ай бұрын
Hide a sheet from its properties, just great. Thanks !
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
😉you're welcome!
@TalShaba
@TalShaba 6 ай бұрын
As I already know the most tricks , the 4th one is very useful. Great one
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad you can make use of it 😁
@tazguy371
@tazguy371 6 ай бұрын
Skip Blanks is a good one! 👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad you liked it!
@andrewwinmill1672
@andrewwinmill1672 5 ай бұрын
Great extras for Excel, but I dont have clipboard icon in the bottom right, so no use to me?
@_SurferGeek_
@_SurferGeek_ 5 ай бұрын
Hello... I have a sheet with 12 columns for the months of the year with JAN thru DEC as the headers. I would like to have the cell containing the column header change color at the end of that month. As my headers don't include a full date (01-01-24), I've been unable to use any of the Conditional Formatting tools. Any help would be appreciated. Thank you.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 ай бұрын
Hard to give you a solution without knowing exactly what you have in those cells. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@charnh.4360
@charnh.4360 4 ай бұрын
Thank you for this vid. I had know idea about these functions. I shared the link with my colleagues so they could watch and learn, too. :) One thing with regards to your conditional formatting using the up/down and up/down/dash rules (loooooove this). When you have a 0% change, excel displays it as an up arrow regardless of which of the above rules you use. Any ideas on how to correct this? I note your spreadsheet in your vid did not have any rows with 0% change, so the problem didn't "crop up". Thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Thank you! You can choose the format with the yellow horizontal bar and set the icon to display yellow when it's =0 changing the 'Type' to 'Number'. If you get stuck, please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@charnh.4360
@charnh.4360 4 ай бұрын
@@MyOnlineTrainingHub Thanks for the quick reply. 😊 I figured out both the issues. It required a bunch more coffee in my system. Lol. For your first custom number format, if you use “0$ ▲;0% ▼;0% ▬” it will populate the ▬ for 0 values. Thank you for your “custom number format cheat sheet” as that was what allowed me to understand the requirement for that last bit of the custom format to push the dash for a 0 value. And as a side note and because this happened with a colleague of mine and I had to google the solution, if anyone does not see the subsets drop-down menu, make sure that you do not have "ASCII (decimal)" or "ASCII (hex)" selected in the “from” drop-down menu at the very bottom right of the pop-up window as the subsets will not display if you have either of them selected. For your second example with the icon set, change the first “value is” (for the up arrow) to only “>”. When you use “>=” it conflicts with the second line (the dash). Once this change is made, the dash will display properly for 0 values. Again, just want to say thank you very much for these instructional videos. I am learning so much stuff that I had no idea even existed. You get used to doing things a certain way, with certain tools in Excel and don’t realize or forget there are so many other methods than can help. /runs off to learn more from your other videos.
@hailegtesfa7540
@hailegtesfa7540 3 ай бұрын
You are fantastic!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
You're very kind 🙏
@clairezhang7351
@clairezhang7351 6 ай бұрын
5. Customer number format.❤❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Great to hear 🙏
@BureBluetooth
@BureBluetooth 6 ай бұрын
Great tips! I think #5 can be very useful😃
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Thank you! Be sure to download the custom number format cheat sheet here: bit.ly/tools24cheatsheet
@martins8587
@martins8587 6 ай бұрын
Windows V is very primitive on Win 10. The functionality you displayed (that I didn't know existed!) appears to be Win 11. To be honest, I am a big fan of the Excel clipboard. Just didn't know the Ctrl C * 2 shortcut. Nice 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad the CTRL + C * 2 might be handy to you 😁
@martins8587
@martins8587 6 ай бұрын
@@MyOnlineTrainingHub I've already shared it with a colleague, and in my line of work (data analytics) it will be a HUGE timesaver, so thank you 🙂
@TH-vw4qn
@TH-vw4qn 4 ай бұрын
1 and 3 for me. Liked your video!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 ай бұрын
Great to hear 🙏
@imadmohammed1031
@imadmohammed1031 4 ай бұрын
many thanks teacher
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
You are welcome 😊
@hazemali382
@hazemali382 4 ай бұрын
always great always Simple
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Thank you! Cheers!
@sjshar1510
@sjshar1510 6 ай бұрын
Thank you for this excellent video!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Glad it was helpful!
The Excel Tool That Does What PivotTables Can’t (File Included)
13:59
MyOnlineTrainingHub
Рет қаралды 165 М.
The Excel Trick I Use EVERY DAY (and you should too!)
11:21
MyOnlineTrainingHub
Рет қаралды 243 М.
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 45 МЛН
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 700 М.
BAYGUYSTAN | 1 СЕРИЯ | bayGUYS
36:55
bayGUYS
Рет қаралды 1,9 МЛН
Excel's NEW Checkboxes Are Incredibly Cool! Here's why
14:24
Leila Gharani
Рет қаралды 551 М.
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
12:29
Kenji Explains
Рет қаралды 113 М.
Excel's dirty little secrets - 5 things it does you don't expect!
11:25
Excel Off The Grid
Рет қаралды 51 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 593 М.
7 Excel Features EVERYONE Should Know
13:53
MyOnlineTrainingHub
Рет қаралды 33 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 269 М.
The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)
10:29
MyOnlineTrainingHub
Рет қаралды 113 М.
PivotTable Tricks That Will Change the Way You Excel (Free File)
17:47
MyOnlineTrainingHub
Рет қаралды 155 М.
Make Excel Formulas Dynamic with the This Trick
10:54
Kenji Explains
Рет қаралды 238 М.
Quando A Diferença De Altura É Muito Grande 😲😂
00:12
Mari Maria
Рет қаралды 45 МЛН