How to track progress with checkboxes in Excel!

[@unoriginalname3442]

For the first time, I feel like I’m actually learning something from shorts rather than getting brain rot

[@mercury9641]

This and random videos about sword fighting that pop up occasionally

[@DanorDave]

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

[@infinity_awesome_mapping]

@@DanorDave I cant trust tiktok

[@DanorDave]

@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

[@justlivinglife6315]

This sort of work is something you would rarely use unless if your work is related But nevertheless it's still nice to know

[@angelicbeast]

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

[@Alegend03]

The ONLY thing that matters is if other people can understand your work. Otherwise, your aren't doing anything important with the program....

[@astrangeperson9305]

This is the most unhinged class ever holy

[@vintage-radio]

Joe Biden and Optimus Prime

[@Alegend03]

Says two people stealing oxygen.

[@ochaun]

I love how the alternating color scheme on the checkboxes is just a reflex for you at this point

[@jeffclassics]

This is not Excel, This is Google Sheets

[@adaniels4326]

I was wondering why his Excel and my Excel were not the same.

[@nickm1816]

he said “for google sheets” in the video

[@bruuhh]

​@@nickm1816 The title says excel

[@abyssmage6979]

Honestly glad he is also doing google sheet tutorials. He should show more cool google sheet content as well.

[@domxem5551]

Click bait?

[@cmcb102]

If Ted wasnt in class on 2/7, what was he doing? 😮

[@meme-ville]

Murder

[@quartermaster2809]

Never ask Ted what he was doing 😩

[@preach9]

Prolly hitting on girls... literally

[@Anguu777]

Doing me

[@cmcb102]

@@Anguu777 that's hot 🥵

[@P__L.]

God I wish I were a nerd in high school. It absolutely would have prepared me for my current corporate life.

[@vyasinfotechvs9200]

Is this an Excel or Google Sheet ? because we have insert Tab facility in excel instead of this insert menu

[@Snowiiix]

Incredibly useful and practical shorts, first subscription ever through shorts! Keep up, this will no longer be underrated soon

[@nicholasricci8342]

Discovered checkboxes a while back, and they are absolutely awesome

[@michaelhayden413]

Super cool, thanks!

[@kyuutatsu]

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!

[@quxilin1993]

you are talent!

[@itogi]

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

[@Imperial_Squid]

COUNTIF([range], "=X") does exactly the same thing, no booleans required

[@olifante1035]

True, but requires everyone using the sheet to know that they should enter exactly what the formula expects

[@Imperial_Squid]

@@olifante1035 This might be a google sheets only feature iirc but you can turn boxes into dropdowns to restrict the input

[@bigstanky2037]

thats one hell of a roster you got

[@raiwet]

I love how you said this was Excel, but it’s Sheets

[@JoeMama-1diot]

Need.. Subway Surfers.. Gameplay..

[@Kiterunner]

?

[@Hermit1O1]

@@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

[@sonerkamer2678]

I’m sorry that you’re 8 🥲🥲

[@gamingwithshobby9803]

Is there anyway I can put an entry which makes a new workbook automatically

[@quickgirl80]

I’ve been looking for this. Thank you!!!

[@datachamp145]

kzbin.infoqSomHtKXCcs?si=P8uIwelBBiZ3G4Cy

[@philippiansfourseven]

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

[@1966Dobbo]

Thanks, George Clooney

[@p.h.3987]

So great!

[@adarshadan]

Are we gonna ignore the fact that Ted Bundy is mentioned on top of that excel.list

[@Roni_mcconi]

Bugs bunny💀 Optimus prime💀

[@VSN-wb2ly]

The best crossover 💀

[@Alex_dlc]

I wish Excel had built in checkboxes, date picker…etc.

[@easy_sheets]

Same! They do have checkboxes but they aren't great tbh.

[@OlaftheSavage]

Cool trick. I normally just use countif "x" to do the same thing, but this looks nicer and less typing.

[@somethingmadd2745]

Wow, this channel is recommended rught by the time i need it. Love the short man

[@morosiakadiallo1648]

Great insights

[@BenDieselBasicAutomotive]

Thank you very much for the technique....

[@GEB_Rosee_PPS]

that is some crazy class wth

[@RAMBUK1989]

this man is incredible

[@ajreukgjdi94]

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

[@moofurg]

I like that it says excel in the title but it’s in sheets

[@danjones4978]

That was amazing. Thanks

[@yrekosik]

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. ;)

[@RudraPratapSinghLearning]

Awesome Man

[@chrismuke606]

When an alien visited the world bro you are from another planet.

[@AmazonsVA]

Sir I am an Amazon Professional & Management Service Provider. I like your shorts. True Knowledge...❤❤❤🎉🎉🎉

[@misteruniverse3061]

Great vids 👍

[@ancientferretlive8204]

i trust you with my whole heart to be the best at this because of your voice

[@MarcioSouza1]

Or just use 1/0 for yes/no checked/unchecked.

[@rosyrr1012]

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 😂

[@ehab2601]

Excellent, direct and simple language ❤

[@datachamp145]

kzbin.infoqSomHtKXCcs?si=P8uIwelBBiZ3G4Cy

[@jumpinjoint]

i really couldve used this channel at my last job, it wouldve been so much faster than self teaching via google

[@tech_obsessed]

Good tip, thanks for sharing.

[@RuPaulCharley]

Make one for how to even get to this point. Like how you have all the names listed and checking the attendance box

[@cool-aquarian]

You have interesting students.

[@channelparadize5972]

You are awesome

[@Alloneword-cp2xw]

OK, I've subscribed!

[@skylerpaulsen3660]

you dont need check marks for that, it just makes it faster.

[@kishormagar3160]

Nice tricks

[@islandlogic4744]

this guy is a excell wizard

[@jeandenys7]

Thank you!

[@datachamp145]

kzbin.infoqSomHtKXCcs?si=P8uIwelBBiZ3G4Cy

[@mr.hassan3746]

In India mostly people use 2013 and 2019 Ms Excel

[@user-js3ln8jt9u]

Thanks this post help me

[@zarniwhite6249]

Thank you 🙏

[@areenboy8742]

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

[@nicholasthope]

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. 😅

[@momomimimumu]

I've been following you and subscribe your channel since, you really help me with excel, thank you, love you 💕

[@silvestrecamposano6317]

Thank you...

[@JackDaniels-xq2hu]

great tip...Im gonna do it in excel though

[@davewojtowicz2246]

Oh the drag down of the top cell, casing the single border to repeat is killing me

[@datachamp145]

kzbin.infoqSomHtKXCcs?si=P8uIwelBBiZ3G4Cy

[@abeltahik5671]

Great stuff. But i've try it in excel, but fhe formulas didnt work.. Give me tutorial in excel.. Thhnks..

[@sadia1740]

Game-changer.

[@prajwalsrb755]

You missed to mention about linking the cells

[@thailieu5448]

Thank you

[@shelkarumesh]

Great tip

[@Annexsohn]

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

[@tranquocthanh949]

amazing

[@Koolkole27]

Cool!

[@DH-ts6ho]

"Though shall use check boxes before going to bros ." Shu Tzu

[@nessa8615]

Thaaaank you. Question, is this option available in Excel as well? I’ve been going nuts trying to find it

[@nikkojohnyutuc206]

I've been watching your videos about excel and you know what? You made me subscribe to your channel.

[@mostafaeltriki]

When you focus on the names 😂

[@Psiros]

For some reason, I really want to see Michael Scott and Optimus Prime in the same class/meeting.

[@micacas2683]

Honestly, I think the X's looked better. May take a few more seconds to input, but it looks better

[@nadinebh1232]

This man invented the excel 😂

[@DjAGray]

More google sheets videos please

[@rubyal9045]

I love this trick. I will use it tomorrow morning for my tracker 🤓

[@Jdan0114]

How would you reference those in a different formula? Is it similar in excel for max?

[@Trever101]

The names 😭😭😊

[@siheonseong5920]

I strongly felt that i should subscribe him

[@vEractiv]

There is even Andre Tate at the bottom

[@TeuKyu]

really helpful thanks

[@kouani1995]

NICE

[@marodso26011]

My man Ted Bundy with high attendance score!

[@KN-dv4be]

Thanks, pls could you create a video on how to use AI and ChartGPT in excel.

[@LethalLuggage]

That answer doesn't even use the boolean as a boolean. It's cleaner UI but Y/N would be practically the same formula

[@sequoia1171]

Just want to make sure Ted Bundy and Optimus prime made it to work😅

[@Penfold8]

Windings 2 check.

[@christnhvv256]

Wowww

[@lanlaxire3546]

Excel wizard 🙏🙏🙏

[@Daddypotential]

What’s Ted Bundy doing on a list with Bugs Bunny?

[@mansiyonsokayembe2527]

This checkbox button is available on which version of Ms Excel

[@Zesty.013]

I swear i saw "Andrew Tate"

[@javieralejandrotrianapaz6343]

Checking the list again I saw no one by the name of Andrew Tate

[@sjoerdmeijer3116]

​@@javieralejandrotrianapaz6343it is at the start when he briefly scrolls down

[@Campy-dCamper]

Handsome and smart your wifey is so lucky

[@rustey222]

I thought this was George Clooney

[@zahrasalami773]

How did you split one cell like that? Anyone who knows how I'll be appreciated if you tell me really need it right now

[@prerna5581]

What if I wanna put a filter and see all the cells in a certain column that have checked values ? Its not coming in the usual filter options

[@user-zm4dc8fi6l]

I was of thinking what exel you using 😅 in Google sheet is more sample to create check box than in exel

[@keramodi]

hello, thanks for the video. How did you copy the checkboxes incl. reference. Have found only instructions by VBA.