Тёмный
MyOnlineTrainingHub
MyOnlineTrainingHub
MyOnlineTrainingHub
Подписаться
Teaching you Excel and Power BI skills that will get you noticed and promoted. For more, check out my courses here: www.myonlinetraininghub.com/courses
How to Add & Use Checkboxes in Excel in 2024
10:55
6 месяцев назад
Комментарии
@georgesinkinson682
@georgesinkinson682 11 часов назад
In what versions of Excel is the Navigation tool available?
@sabesta
@sabesta 11 часов назад
Is it possible to create a button that takes you to the "Insert Hyperlink" dialogue box? I want users to have the freedom to insert a document link to anything on our server with the click of a button.
@Flicka-z3g
@Flicka-z3g 12 часов назад
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.
@garydunken7934
@garydunken7934 13 часов назад
For formula paste, I use Alt+H V F
@amushkamohammed2064
@amushkamohammed2064 14 часов назад
Thank you so much for this tutorial I love it but am so confused, when I download the sample data it seems all mixed up. Kindly advice me on this 😢
@JayantGattani-mk8vp
@JayantGattani-mk8vp 14 часов назад
sdv
@sbon4771
@sbon4771 14 часов назад
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!
@sahralsahri7180
@sahralsahri7180 14 часов назад
Very very nice. Thanks! 🌹
@IS-L
@IS-L 15 часов назад
I am finding face recognition as a means of two-stage authentication useful. Banking, logging onto my accountant's portal and much more are using this. THey can hack a PW, but they cannot hack your face.
@RieRiePie
@RieRiePie 15 часов назад
What if I don't have the Navigation Pane, is there an alternative?
@ANS-zn1pr
@ANS-zn1pr 16 часов назад
👍👍
@SegueGreene
@SegueGreene 16 часов назад
love the filter/sort shortcut!
@Talisyen
@Talisyen 17 часов назад
Hail to Ctrl + Shit + V! :)
@goodone05004
@goodone05004 18 часов назад
Great video again, but what is the "menu key" you talked about in tool number 4?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 16 часов назад
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.
@TrevorGopaul-jo1om
@TrevorGopaul-jo1om 18 часов назад
The teacher is AI
@MyOnlineTrainingHub
@MyOnlineTrainingHub 18 часов назад
Hilarious.
@TrevorGopaul-jo1om
@TrevorGopaul-jo1om 15 часов назад
@@MyOnlineTrainingHub Reference to someone as AI
@TrevorGopaul-jo1om
@TrevorGopaul-jo1om 15 часов назад
Reference to someone as AI will be a compliment in the future. You are ahead of your time.
@sadeemalolayan1568
@sadeemalolayan1568 19 часов назад
Thank you for your helping
@MyOnlineTrainingHub
@MyOnlineTrainingHub 18 часов назад
My pleasure!
@waadtlander_ch8802
@waadtlander_ch8802 19 часов назад
Your Excel Periodic Table is a genious as the Table of Dimitry Mendéléev, indeed.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 18 часов назад
Thank you!
@gstregistration4165
@gstregistration4165 19 часов назад
Hello Minda, your explanation is flawless and initially i was able to get the desired output but once i saved the file as .xlsm and closing and reopening the list disappears. tha defined name and formula are properly saved but the return data shows as blank cell. Even on pressing F9 the data cell returns as blank. What can de done to resolve this error? thank you for the write up and all the help you provide. Regards RITESH BAFNA
@MyOnlineTrainingHub
@MyOnlineTrainingHub 18 часов назад
Hi Ritesh, I replied to your duplicate question on our blog.
@MGE0007
@MGE0007 21 час назад
Its 07:54 in the morning for me……and this video has already made my day!!…
@MyOnlineTrainingHub
@MyOnlineTrainingHub 21 час назад
So pleased to hear that 😁
@chahineatallah2636
@chahineatallah2636 День назад
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
@MyOnlineTrainingHub
@MyOnlineTrainingHub 21 час назад
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 😉
@leerv.
@leerv. День назад
"Now in order to use my arrow keys inside this field we have to press F2 to go into Edit mode" --- OMG....I've been using Excel for over 10 years professionally and I always HATED how you couldn't use arrow keys in conditional formatting formulas and the like..... I can't believe the wall was only as high as a single key press this entire time. *forehead smack -- THANK YOU!!!! So many awesome tips in this video! I can't wait to apply them at work and show my colleagues <3
@MyOnlineTrainingHub
@MyOnlineTrainingHub 21 час назад
So pleased to hear I could solve that decade long mystery for you 😁
@solvesonkd
@solvesonkd День назад
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?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 21 час назад
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.
@kirk1968
@kirk1968 День назад
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! 👋
@MyOnlineTrainingHub
@MyOnlineTrainingHub 21 час назад
It sure has!
@manisherande4568
@manisherande4568 День назад
you are cool........learnt a lot
@MyOnlineTrainingHub
@MyOnlineTrainingHub 21 час назад
Great to hear!
@srider33
@srider33 День назад
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!
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
😁glad there was something new that you can use!
@walkingentropy
@walkingentropy День назад
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!
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Thanks for sharing!
@adrianconnolly8568
@adrianconnolly8568 День назад
would it not be better to use a database unless you want quick calculations
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Sure, if you have the infrastructure and budget for managing databases. Most small businesses don't have this luxury.
@adrianconnolly8568
@adrianconnolly8568 20 часов назад
@@MyOnlineTrainingHub sorry but if you have office 365 for business you have ms access sub
@brighttriangle
@brighttriangle День назад
Excellent tips. Thanks for sharing. I hadn't checked for a while, but I was pleasantly surprised to see that Searchable Drop-Down Lists are finally available in the main Microsft 365 channel for Mac (I have version 16.86).
@MohammadAshooryan
@MohammadAshooryan День назад
My favorite is number5👌
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Great to hear!
@billgillaspey9036
@billgillaspey9036 День назад
Wow!. Always some new good things to learn. Thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Thanks so much, Bill!
@JuanGarcia-os4uy
@JuanGarcia-os4uy День назад
:)
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
🙏
@michaeldavenport9268
@michaeldavenport9268 День назад
Nav pane is AWESOME!
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Glad you like it!
@danielmanahan7081
@danielmanahan7081 День назад
I'll be using three for sure
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Awesome to hear!
@heinzthedutch
@heinzthedutch День назад
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.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Glad you liked it!
@bathroombuddy17
@bathroombuddy17 День назад
Where is the menu key?
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
On my keyboard it's in the bottom right, to the left of the CTRL key.
@ugonnabriggs5019
@ugonnabriggs5019 День назад
❤, thanks for sharing your knowledge. #1 is my fav.
@MyOnlineTrainingHub
@MyOnlineTrainingHub День назад
Nice!