@infinityawesome-obbycreato6186 i mean you cant trust anything really, tiktok just tells u the most recent thing thats happening, its really up to you to research the subject in any platform
I’ve been wanting to learn more about excel because it’s a rather handy skill to add to my resume. This channel is just a prime way to learn. Thank you!
@@Kiterunnerit’s one of the zoombies, their attention span have been conditioned to only last for more than 10 seconds for videos with gameplay over content, thanks for the hours of tik tok videos and short they browse hours per day
How do I create those mini multiple columns within the main attendance column so that I can add the checkboxes. I can’t figure out how to do that in Google sheets…. I have such tons and tons of videos and there’s nothing
At my old job I had to take attendance/minutes especially during Covid all of our meetings were virtual since we were at home. I would have loved knowing this back then 😂
At first there might be no difference except for it looking better but the storage of the boolean values can help if there are bigger collums of check boxes
For the first time, I feel like I’m actually learning something from shorts rather than getting brain rot
This and random videos about sword fighting that pop up occasionally
Yeah thats why tiktoks algorithm is way better, if you want facts and tips, boom you get vids like this, unlike yt shorts where its completely random
@@DanorDave I cant trust tiktok
@infinityawesome-obbycreato6186 i mean you cant trust anything really, tiktok just tells u the most recent thing thats happening, its really up to you to research the subject in any platform
This sort of work is something you would rarely use unless if your work is related
But nevertheless it's still nice to know
God I wish I were a nerd in high school. It absolutely would have prepared me for my current corporate life.
you can use countif with "x"s too though. the real value of checkboxes is if you're sharing the sheet with other people to use so it's user friendly
The ONLY thing that matters is if other people can understand your work. Otherwise, your aren't doing anything important with the program....
I love how the alternating color scheme on the checkboxes is just a reflex for you at this point
This is the most unhinged class ever holy
Joe Biden and Optimus Prime
Says two people stealing oxygen.
If Ted wasnt in class on 2/7, what was he doing? 😮
Murder
Never ask Ted what he was doing 😩
Prolly hitting on girls... literally
Doing me
@@Anguu777 that's hot 🥵
This is not Excel, This is Google Sheets
I was wondering why his Excel and my Excel were not the same.
he said “for google sheets” in the video
@@nickm1816 The title says excel
Honestly glad he is also doing google sheet tutorials. He should show more cool google sheet content as well.
Click bait?
Incredibly useful and practical shorts, first subscription ever through shorts! Keep up, this will no longer be underrated soon
Is this an Excel or Google Sheet ? because we have insert Tab facility in excel instead of this insert menu
Super cool, thanks!
Discovered checkboxes a while back, and they are absolutely awesome
I like that it says excel in the title but it’s in sheets
you are talent!
I’ve been wanting to learn more about excel because it’s a rather handy skill to add to my resume. This channel is just a prime way to learn. Thank you!
I love how you said this was Excel, but it’s Sheets
I’ve been looking for this. Thank you!!!
czcams.com/users/shortsqSomHtKXCcs?si=P8uIwelBBiZ3G4Cy
thats one hell of a roster you got
Need.. Subway Surfers.. Gameplay..
?
@@Kiterunnerit’s one of the zoombies, their attention span have been conditioned to only last for more than 10 seconds for videos with gameplay over content, thanks for the hours of tik tok videos and short they browse hours per day
I’m sorry that you’re 8 🥲🥲
thanks JoeMama
COUNTIF([range], "=X") does exactly the same thing, no booleans required
True, but requires everyone using the sheet to know that they should enter exactly what the formula expects
@@olifante1035 This might be a google sheets only feature iirc but you can turn boxes into dropdowns to restrict the input
So great!
You can also replace the integer number of boxes with the function to count the amount of boxes in one row. It's more universal that way
Wow, this channel is recommended rught by the time i need it. Love the short man
Great vids 👍
Thanks, George Clooney
Great insights
Are we gonna ignore the fact that Ted Bundy is mentioned on top of that excel.list
Bugs bunny💀
Optimus prime💀
The best crossover 💀
Thank you very much for the technique....
Cool trick. I normally just use countif "x" to do the same thing, but this looks nicer and less typing.
Is there anyway I can put an entry which makes a new workbook automatically
that is some crazy class wth
OK, I've subscribed!
Thank you...
this man is incredible
Thanks this post help me
Awesome Man
That was amazing. Thanks
No it's not! Better use COLUMNS (C3:G3) instead of 5. Our world is not constant...same as number of exel columns filled with data. ;)
Excellent, direct and simple language ❤
czcams.com/users/shortsqSomHtKXCcs?si=P8uIwelBBiZ3G4Cy
You have interesting students.
Cool!
You are awesome
Wowww
Nice tricks
i really couldve used this channel at my last job, it wouldve been so much faster than self teaching via google
this guy is a excell wizard
How do I create those mini multiple columns within the main attendance column so that I can add the checkboxes. I can’t figure out how to do that in Google sheets…. I have such tons and tons of videos and there’s nothing
I wish Excel had built in checkboxes, date picker…etc.
Same! They do have checkboxes but they aren't great tbh.
When you focus on the names 😂
Hay quá ❤
Sir I am an Amazon Professional & Management Service Provider. I like your shorts. True Knowledge...❤❤❤🎉🎉🎉
Great tip
Thank you 🙏
"Though shall use check boxes before going to bros ."
Shu Tzu
At my old job I had to take attendance/minutes especially during Covid all of our meetings were virtual since we were at home. I would have loved knowing this back then 😂
You can countif(range,"X") which is less typing than true and you dont have to do special formatting. Or counta(range) to get any that aren't blank
Good tip, thanks for sharing.
How would you reference those in a different formula? Is it similar in excel for max?
NICE
i trust you with my whole heart to be the best at this because of your voice
This man invented the excel 😂
Game-changer.
great tip...Im gonna do it in excel though
I was so excited, I was like I can finally do checkboxes that don't look like dog crap in excel but then bro was using google sheets
amazing
Thank you!
czcams.com/users/shortsqSomHtKXCcs?si=P8uIwelBBiZ3G4Cy
Thank you
I've been following you and subscribe your channel since, you really help me with excel, thank you, love you 💕
What’s Ted Bundy doing on a list with Bugs Bunny?
For some reason, I really want to see Michael Scott and Optimus Prime in the same class/meeting.
There is even Andre Tate at the bottom
Just want to make sure Ted Bundy and Optimus prime made it to work😅
Or just use 1/0 for yes/no checked/unchecked.
Great stuff. But i've try it in excel, but fhe formulas didnt work.. Give me tutorial in excel.. Thhnks..
When an alien visited the world bro you are from another planet.
In India mostly people use 2013 and 2019 Ms Excel
you dont need check marks for that, it just makes it faster.
I strongly felt that i should subscribe him
I've been watching your videos about excel and you know what? You made me subscribe to your channel.
The names 😭😭😊
Checkbox is great. But if you have massive quantity of data, they slow the pc down. I ended up using 1 or blank at the end of the day. 😅
My man Ted Bundy with high attendance score!
Make one for how to even get to this point. Like how you have all the names listed and checking the attendance box
I swear i saw "Andrew Tate"
Checking the list again I saw no one by the name of Andrew Tate
@@javieralejandrotrianapaz6343it is at the start when he briefly scrolls down
❤❤❤
Oh the drag down of the top cell, casing the single border to repeat is killing me
czcams.com/users/shortsqSomHtKXCcs?si=P8uIwelBBiZ3G4Cy
hello,
thanks for the video.
How did you copy the checkboxes incl. reference.
Have found only instructions by VBA.
More google sheets videos please
Thaaaank you. Question, is this option available in Excel as well? I’ve been going nuts trying to find it
Excel wizard 🙏🙏🙏
You missed to mention about linking the cells
really helpful thanks
Nice names you've put here haha
How did you add the tiny columns in the attendance?
Man’s going to jail for assisting in human trafficking.
I love this trick. I will use it tomorrow morning for my tracker 🤓
Thanks, pls could you create a video on how to use AI and ChartGPT in excel.
At first there might be no difference except for it looking better but the storage of the boolean values can help if there are bigger collums of check boxes
how did you manage to add them all at once and plus you add them colored
It makes sense time wise that ted Bundy was in the same class as joe Biden
👏🏻
Honestly, I think the X's looked better. May take a few more seconds to input, but it looks better