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

  Рет қаралды 76,794

MyOnlineTrainingHub

MyOnlineTrainingHub

Күн бұрын

6 Excel tools that everyone MUST know how to use to boost productivity
👩‍🏫 Download the FREE "Custom Number Formats" cheatsheet: bit.ly/tools24cheatsheet
⬇️ Download the example file here and follow along: bit.ly/tools24file
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
===========
📰 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
1:27 Tool №2
3:08 Tool №3
5:47 Tool №4
8:00 Tool №5
9:48 Tool №6
#Excel #ExcelTools #ExcelTips

Пікірлер: 200
@MyOnlineTrainingHub
@MyOnlineTrainingHub 15 күн бұрын
❓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 12 күн бұрын
I am new here someone help me guide where to start in this channel, which playlist to which? 🙏🙏🙏
@shakiraasfoor7599
@shakiraasfoor7599 12 күн бұрын
@@SAI-xn7yq all these videos are useful, myanda is MPV.
@shakiraasfoor7599
@shakiraasfoor7599 12 күн бұрын
Tool №3 Clipboard
@daves902
@daves902 14 күн бұрын
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 14 күн бұрын
So glad you found some new tips you can use 😊
@bobgreenfield9158
@bobgreenfield9158 9 күн бұрын
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 2 күн бұрын
I feel the same... I appreciate these clips
@notesfromleisa-land
@notesfromleisa-land 14 күн бұрын
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 14 күн бұрын
😁glad you can make use of some of these techniques.
@KittKatPawz
@KittKatPawz 14 күн бұрын
Wow!! The skip blanks and multiply ones I’ve never known. Thanks for the updates on how to use! 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Glad you like them!
@sandratruax715
@sandratruax715 14 күн бұрын
#2. Paste Special (Convert Values) is my favorite. Love your videos and your teaching style.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Thanks for your kind words 🙏😊
@SissasHeART
@SissasHeART 13 күн бұрын
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 13 күн бұрын
Love that! 😁👏
@chrism9037
@chrism9037 14 күн бұрын
Great video Mynda! I agree, 3 is the best
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Cheers, Chris! Glad we agree 😁
@therealjeffg
@therealjeffg 14 күн бұрын
More gold, thanks Mynda. No. 3 if my favourite.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
Great to hear 🙏
@bobmoorehead8553
@bobmoorehead8553 14 күн бұрын
You are SOOO AMAZING! Tip #3 was my favorite, too. Thank you for continuing to share your tips. Have a fabulous day!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
You're so welcome! Hope you have a fabulous day too 😊
@Quidisi
@Quidisi 14 күн бұрын
Oh, this was great. Some was new, and some were things that I once knew, but had forgotten. Thanks!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
That's a double win! 😁
@SteveSwanson999
@SteveSwanson999 8 күн бұрын
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 8 күн бұрын
So pleased you can make use of it.
@yokoyama7590
@yokoyama7590 14 күн бұрын
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 14 күн бұрын
😁 awesome to hear!
@alfredoluwatomi6899
@alfredoluwatomi6899 11 күн бұрын
This is fantastic, always having to learn a new simple yet powerful excel function. Many thanks.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 күн бұрын
So pleased to hear that 😁
@nour-eddineoumakhlouf5296
@nour-eddineoumakhlouf5296 8 күн бұрын
Endless learning ! Thank you so much for all your efforts
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 күн бұрын
Happy to hear that!
@benhaze1010
@benhaze1010 4 күн бұрын
Love, love these useful tips!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 күн бұрын
So glad!
@TrocarSlushWeasel
@TrocarSlushWeasel 14 күн бұрын
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 14 күн бұрын
Yes, another great reason to use them. Thanks for sharing.
@kgadeberg
@kgadeberg 13 күн бұрын
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 13 күн бұрын
Great use case for Win+V. Thanks for sharing.
@rubysnailbar4460
@rubysnailbar4460 3 күн бұрын
Brilliant thank you 🙏🏽
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 күн бұрын
Glad you enjoyed it!
@sjshar1510
@sjshar1510 6 күн бұрын
Thank you for this excellent video!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 күн бұрын
Glad it was helpful!
@mohammadalbizri2013
@mohammadalbizri2013 13 күн бұрын
Thank you for usual efforts.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
Always welcome 😊
@PritamPaul717
@PritamPaul717 14 күн бұрын
Thanks a lot for this information
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
You're welcome 😊
@alexandercato7400
@alexandercato7400 6 күн бұрын
Great list of tips! Appreciate how easy the video was to follow along.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 күн бұрын
Glad you enjoyed it! 🙏😊
@martyc5674
@martyc5674 14 күн бұрын
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 14 күн бұрын
Great tips 🙏
@power-reconcile
@power-reconcile 13 күн бұрын
Wow, thanks for sharing! ❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
Thanks for watching! 😁
@user-lf6yc6tq1f
@user-lf6yc6tq1f 7 күн бұрын
Thank you so much
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 күн бұрын
You're most welcome 😊
@lauphyon
@lauphyon 13 күн бұрын
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 13 күн бұрын
Great to hear you can make use of them! 😊
@2bczar4u
@2bczar4u 14 күн бұрын
Brilliant as always. Love #1
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Great to hear 🙏😁
@joshuamanampiu6489
@joshuamanampiu6489 13 күн бұрын
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 13 күн бұрын
Glad you like them!
@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!
@majidbawazirlive
@majidbawazirlive 9 күн бұрын
Thanks dear !!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 күн бұрын
You're welcome 😊
@Mark-Bench
@Mark-Bench 14 күн бұрын
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 14 күн бұрын
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.
@tony586ful
@tony586ful 14 күн бұрын
Numeber 3... A real new world for me.. Thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Awesome to hear!
@christiang1878
@christiang1878 13 күн бұрын
very good. thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
My pleasure!
@kayespedal10
@kayespedal10 5 күн бұрын
Saw this one video and I immediately subscribed. I'll try some these tmw when I log in. A+
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 күн бұрын
Wonderful to hear 🙏
@SndfOmar
@SndfOmar 14 күн бұрын
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 14 күн бұрын
Glad you enjoyed it and discovered something new!
@aiasaiascon3894
@aiasaiascon3894 9 күн бұрын
Group - Ungroup columns is really helpful for temp use of narrowing focus! Skip Blanks was smth I didnot know!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 күн бұрын
So pleased it was helpful 😊
@karolinab9749
@karolinab9749 14 күн бұрын
#2 😀 and I love custom formatting! Thank you for this video!😀
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
My pleasure! Thanks for watching 😁
@BureBluetooth
@BureBluetooth 14 күн бұрын
Great tips! I think #5 can be very useful😃
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Thank you! Be sure to download the custom number format cheat sheet here: bit.ly/tools24cheatsheet
@SirArsalanExcelTips
@SirArsalanExcelTips 3 күн бұрын
Excellent
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 күн бұрын
Thank you so much 😀
@fayyaztabussam8611
@fayyaztabussam8611 5 күн бұрын
I like No.4 the most. Any how all numbers are super. Great stuff of course.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 5 күн бұрын
Thanks for voting 😊
@BuckeyeNut123
@BuckeyeNut123 14 күн бұрын
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 14 күн бұрын
So pleased you can make use of this feature.
@TalShaba
@TalShaba 14 күн бұрын
As I already know the most tricks , the 4th one is very useful. Great one
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Glad you can make use of it 😁
@archonmax
@archonmax 12 күн бұрын
多谢老师。
@MyOnlineTrainingHub
@MyOnlineTrainingHub 12 күн бұрын
My pleasure 😊
@_logicking
@_logicking 5 күн бұрын
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 5 күн бұрын
That's great to hear 🙏
@silvo4880
@silvo4880 10 күн бұрын
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 10 күн бұрын
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.
@madlarch
@madlarch 3 күн бұрын
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 3 күн бұрын
So pleased to hear you found some new ideas 😁
@daoudathiaw
@daoudathiaw 14 күн бұрын
Hide a sheet from its properties, just great. Thanks !
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
😉you're welcome!
@tazguy371
@tazguy371 9 күн бұрын
Skip Blanks is a good one! 👍
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 күн бұрын
Glad you liked it!
@rjbush7955
@rjbush7955 14 күн бұрын
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 14 күн бұрын
Nice to know you use it too 😁
@melantha1982
@melantha1982 13 күн бұрын
Never tried skip Blanks so will give it a go..cheers
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
So pleased to hear you found something new you can use 😁
@brighttriangle
@brighttriangle 12 күн бұрын
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 12 күн бұрын
Ah, the Mac strikes again. Another reason I will never own a Mac. 😔
@richardhay645
@richardhay645 14 күн бұрын
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 14 күн бұрын
Great to hear, Richard. I'm a fan of Alt > E > S too 😁
@cathyfrankland9158
@cathyfrankland9158 13 күн бұрын
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 13 күн бұрын
Awesome to hear 😁
@JeffLittle-bi5jd
@JeffLittle-bi5jd 14 күн бұрын
#3 is great ... didn't know this one! Also think #4 is excellent!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Cheers, Jeff! Glad you like them.
@doberg3191
@doberg3191 14 күн бұрын
I also use the "Paste Special" multiply by 1 when numbers are formatted as text.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Yes, another great use case. Thanks for sharing.
@GraeHunter
@GraeHunter 14 күн бұрын
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 14 күн бұрын
Awesome to hear, Grae!
@1348kourosh
@1348kourosh 8 күн бұрын
Skip blanks is very interesting thanks
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 күн бұрын
Glad you think so!
@clairezhang7351
@clairezhang7351 14 күн бұрын
5. Customer number format.❤❤
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Great to hear 🙏
@colinekszczecin
@colinekszczecin 11 күн бұрын
Skip blanks is my new favourite thing
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 күн бұрын
Awesome to hear 😁
@TheNeilsolaris
@TheNeilsolaris 8 күн бұрын
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 8 күн бұрын
Nice.
@TheNeilsolaris
@TheNeilsolaris 8 күн бұрын
@@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.
@UlfatSahil
@UlfatSahil 14 күн бұрын
Unbelievable way to design and do the things, like using shortcuts
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Glad you liked it 🙏
@Rice0987
@Rice0987 14 күн бұрын
Conditional formatting has one silly property. When i delete rows inside of formatted range, it starts to separate conditions on several parts. Why cant it just simply keep whole range from the beginning to the end i cant get. :/ And if my memory doesnt let me down in office XP we didnt have such mess with conditions.🤔
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Yes, that is annoying. Thankfully, in 365 they have fixed that issue.
@Rice0987
@Rice0987 14 күн бұрын
@@MyOnlineTrainingHub maybe i have bad 365 version, so the same problem there.🤔
@martins8587
@martins8587 14 күн бұрын
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 14 күн бұрын
Glad the CTRL + C * 2 might be handy to you 😁
@martins8587
@martins8587 14 күн бұрын
@@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 🙂
@michaelallan108
@michaelallan108 14 күн бұрын
Tool 2, Example 3 🎉 But yes tool 3 is amazing
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
😁so pleased you liked it!
@ahmedshalaby9343
@ahmedshalaby9343 14 күн бұрын
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 13 күн бұрын
Great question. I don't think there's an easy way to do that, sorry. Better to change both columns at the same time.
@pakipower
@pakipower 14 күн бұрын
Great tools indeed and i am sure the 7th one is the Camera tool.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
😁yes, the camera tool is another cool feature!
@sherryfox227
@sherryfox227 13 күн бұрын
4 & 6
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
😁🙏
@alambraga
@alambraga 14 күн бұрын
about the formats of cel using date. Are you have any trouble when the excel is in another language? like spanish?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Excel should automatically display dates in the format for the region the file is opened in (assuming you're using the default date format). If that's not what you meant, please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@alambraga
@alambraga 13 күн бұрын
@@MyOnlineTrainingHub Thank you . i will post.
@JJ_TheGreat
@JJ_TheGreat 12 күн бұрын
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 11 күн бұрын
No. Very hidden sheets can only be un-hidden via the VB editor.
@amzibell
@amzibell 14 күн бұрын
wow Skip Blanks is a game changer
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
So pleased you liked it 😁
@SAI-xn7yq
@SAI-xn7yq 12 күн бұрын
I am new here someone help me guide where to start in this channel, which playlist to which? 🙏🙏🙏
@MyOnlineTrainingHub
@MyOnlineTrainingHub 12 күн бұрын
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 12 күн бұрын
@@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 12 күн бұрын
@@MyOnlineTrainingHub can i learn power bi or power query without knowledge of excel in your playlist
@user-dn5gd1rn9f
@user-dn5gd1rn9f 12 күн бұрын
Jeez…How many times have I ignored the options on the paste special menu? Thank you!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 12 күн бұрын
So easy to miss 🫣
@MrLear1976
@MrLear1976 11 күн бұрын
I never use vlookup it’s such a pain. I’ve had to rebuild a file I took over from someone who used all vlookup. The issue is if you change the structure you have to change all references so it’s not dynamic. Xlookup if far better and dynamic. Given how much you would have to complicate a vlookup to make it dynamic is the reason I never use it and after 20 years of working with data I’ve never found a use for vlookup that other methods didn’t solve more effectively.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 күн бұрын
I agree, VLOOKUP is more restrictive, but it's super easy to learn and use, so I don't discount it outright because it's great for beginners to get a taste for more powerful functions which in turn motivates them to learn more. That said, now that we have XLOOKUP there really is no need to learn VLOOKUP anymore, unless you're on an old version of Excel....or inheriting legacy files.
@joloblog9834
@joloblog9834 14 күн бұрын
I have a question: Is it possible to sort numbers formatted as text as numbers. Like '10 and '1000 and '200 are sorted '10,'1000,'200 but I like them sorted as '10, '200, '1000.? Thanks in advance :-)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
No, the best fix for this is to convert the numbers to actual numbers instead of text.
@niveketihw1897
@niveketihw1897 14 күн бұрын
The multi-storage clipboard is disabled by my company with no way to enable it. Too bad. EDIT: I'm able to add the Developer tab and go into Visual Basic, however xlSheetVeryHidden is disabled -- I get "Unable to set the Visible property of the Worksheet class."
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
hmmm, I wonder if your admin has disabled VBA.
@simonhodges6084
@simonhodges6084 14 күн бұрын
MS used to give security warnings to users when docs received etc had vba code in them. Does it still do that?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Yes, it still does that.
@emsartori1
@emsartori1 13 күн бұрын
The negative sign on the percentage went away, how do you keep it?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
Just change the custom number format to include a minus sign before the negative format i.e. after the semi colon: 0%; -0%
@jamesbennett5421
@jamesbennett5421 8 күн бұрын
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 8 күн бұрын
Yes, another great use 👍 thanks for sharing.
@kenstav1
@kenstav1 9 күн бұрын
HMMMMM No 3 is a game changer
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 күн бұрын
Great to hear!
@williamarthur4801
@williamarthur4801 14 күн бұрын
Really liked the % format, I always get annoyed when say have 10 and want 10% and end up 1000.00%, also ctrl cc for clipboard, I was hoping it might work from within PQ but no such luck.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Ah yeah, the PQ window seems to prevent lots of functionality. You should still be able to copy to the clipboard and maybe use the Windows clipboard instead.
@williamarthur4801
@williamarthur4801 14 күн бұрын
@@MyOnlineTrainingHub Yes, Win V, does work in query, 😊😊😊😊
@carolynneccles823
@carolynneccles823 14 күн бұрын
When I try to add a second group, it keeps adding it to the first group. Does anyone know why it would be doing this? TIA
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
You need to leave a row/column ungrouped in between groups.
@sureshthongati1532
@sureshthongati1532 14 күн бұрын
Yeah ma'am need your classes first one Starting Excel first episode videos if possible please help me
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
You can start with this video on Excel for beginners: kzfaq.info/get/bejne/nOCUoZSnyK60o3U.html
@ajaydas-go1pk
@ajaydas-go1pk 10 күн бұрын
Dear ma'am, in excel I used to Alt + = to use sum formula. But unfortunately I changed few things from Excel option. After doing this I can't use Alt + = to sum formula. Would you please help me out of the situation. (From India)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 күн бұрын
Hmm, not sure why that would be disabled, sorry. I tried a few settings in Options and couldn't replicate the problem. You could re-install Excel to revert to the default build.
@ajaydas-go1pk
@ajaydas-go1pk 10 күн бұрын
@@MyOnlineTrainingHub Thank you ma'm
@rdadamo1
@rdadamo1 14 күн бұрын
Why are all of the Change numbers positive when some of them should be negative?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Because I'm using up/down triangles to indicate the direction of the change. If you prefer, you can modify the number format to also show the minus sign.
@josh_excel
@josh_excel 13 күн бұрын
# ?/?? = great!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
😁🙏
@bobert8618
@bobert8618 7 күн бұрын
OK, I love her accent....
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 күн бұрын
Thank you 😊
@seanys
@seanys 14 күн бұрын
I don’t think I’d ever have a use for it by I do like “very hidden.” 😂
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
😁
@chubbers_uk
@chubbers_uk 13 күн бұрын
the clipboard
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
Glad you liked it!
@markwoodward9922
@markwoodward9922 14 күн бұрын
Any one else having issues downloading the cheatsheet?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 14 күн бұрын
Not that they've reported, Mark. Please reach out via email: website @ MyOnlineTrainingHub.com and we'll help you out.
@robertcooper3759
@robertcooper3759 6 күн бұрын
You're still lovely...
@SnooniSnoo
@SnooniSnoo 10 күн бұрын
OHNOOOOO my way of hiding sheet is exposed!!!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 күн бұрын
🫣
@jonk3361
@jonk3361 14 күн бұрын
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 14 күн бұрын
😁too many to choose from! Thanks for watching and sharing your favourites.
@alexrosen8762
@alexrosen8762 13 күн бұрын
All of them are useful but my favourite would be number 2
@MyOnlineTrainingHub
@MyOnlineTrainingHub 13 күн бұрын
😁glad you liked it!
Interactive Excel Dashboards & ONE CLICK Update!
52:26
MyOnlineTrainingHub
Рет қаралды 10 МЛН
World’s Deadliest Obstacle Course!
28:25
MrBeast
Рет қаралды 122 МЛН
1❤️#thankyou #shorts
00:21
あみか部
Рет қаралды 88 МЛН
Final muy inesperado 🥹
00:48
Juan De Dios Pantoja
Рет қаралды 18 МЛН
Дибала против вратаря Легенды
00:33
Mr. Oleynik
Рет қаралды 2,7 МЛН
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 196 М.
7 HIDDEN Apps in Microsoft 365 that will EXPLODE Productivity
28:35
Jonathan Edwards
Рет қаралды 143 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 74 М.
The SIMPLEST Way to Organize Your Files and Folders
10:14
Lea David
Рет қаралды 36 М.
Two Powerful Methods to Limit Scrolling in Excel #excel #vba
1:32
I Got Hacked in an Unusual Way | Tips to Protect Yourself
9:31
MyOnlineTrainingHub
Рет қаралды 124 М.
Interactive Excel Dashboard Tutorial in 3 Steps (+ FREE Template)
18:57
MyOnlineTrainingHub
Рет қаралды 98 М.
Create Dependent Drop Down List in Excel - EASY METHOD
12:10
Kevin Stratvert
Рет қаралды 34 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 442 М.
PivotTable Tricks That Will Change the Way You Excel (Free File)
17:47
MyOnlineTrainingHub
Рет қаралды 108 М.
Asus  VivoBook Винда за 8 часов!
1:00
Sergey Delaisy
Рет қаралды 1 МЛН
Ждёшь обновление IOS 18? #ios #ios18 #айоэс #apple #iphone #айфон
0:57
cute mini iphone
0:34
승비니 Seungbini
Рет қаралды 4,3 МЛН
Samsung Galaxy 🔥 #shorts  #trending #youtubeshorts  #shortvideo ujjawal4u
0:10
Ujjawal4u. 120k Views . 4 hours ago
Рет қаралды 9 МЛН
Телефон в воде 🤯
0:28
FATA MORGANA
Рет қаралды 1,2 МЛН