🚀10x your Excel with our course: www.careerprinciples.com/courses/excel-for-business-finance
@sbatsia9 ай бұрын
Great presentation. Thank you! I don't have a "Check Box" under the "Insert" tab. When trying to insert a new tab via the Customize Ribbon, I got only a "Check Box (Form Control)" which is different from what you showed. I even tried via "Microsoft Insider", but that didn't get me the Check Box either. I'd be appreciative of your advice / support/
@peanutnutter19 ай бұрын
I was searching for this 17 years ago and was disappointed to find they didn't have it, congrats to them on bringing out the 'beta' version, it's a real achievement. Nobel prize incoming.
@hemantchaudharyvlogs021349 ай бұрын
Your thinking is better than Microsoft employees 😂😂.
@preshen9 ай бұрын
Excellent new feature, for the strikethrough, I suggest the conditional formatting is done if tracker=100% to avoid the error if only stage 4 is checked.
@bhaveshsavla78129 ай бұрын
Yes. Same thought.
@jcraft1007 ай бұрын
want to make this clear to people - unless you are enrolled in the BETA testing program from Windows for Office 365 you will NOT have that command on the INSERT Tab.. You will have to use the Developer Tab and put in a check mark from there.. NO THEY are not the same.. and they behave differently.. this NEW feature is NOT available to most people.. Nice video.. but most of us can't do it this way..
@sabrinawilt44416 ай бұрын
Thank you - was so confused!
@lauro78616 ай бұрын
Thank you for this answer!
@PonchoScotch3 ай бұрын
This comment should be pinned
@nhwine9 ай бұрын
What version of Excel is this in? I have the most recent update to Office 365 and still don't see this feature.
@lauro78616 ай бұрын
Same here and this question was done 2 months Ago... i dont see this option
@erictsang789Ай бұрын
@@lauro7861 i also can not find this feature, today is July 2024
@klay4708Ай бұрын
its is google sheet
@paulschrieber85909 ай бұрын
Can't believe they haven't added this already...its about time
@KenjiExplains9 ай бұрын
i agree haha
@Queijin847 ай бұрын
The best video explaining the feature. Step by step guide and easy to understand. Thank you very much.
@toyclydeАй бұрын
It is nice to know that Google Sheets has this as a standard feature.
@michaelallen71726 ай бұрын
Hello my MS Office 365 is busines premium license. It's the highest license but i can't see the new checkbox in the Insert tab. I even updated my Office 365 but I still cannot see it. Please advise.
@benitomate18679 ай бұрын
How i add Cell control to Excel? I not find it
@carolinaforbes50209 ай бұрын
thank you so much for this tutorial,kenji! though as much as i want to follow along ,there is no data where i can apply this valuable knowledge...hope there will be link for the practice file...more power!
@1PPPete9 ай бұрын
This principle is really simplistic, can easy make this from ground up, no need for practice file.
@meniporat35276 ай бұрын
About the Tracker formula in cell C3: 1) you don't need to put TRUE in quotes 2) A much simpler formula to count the number of TRUE values in a range of checkboxes: instead of =COUNTIF(D3:G3,TRUE) Simply write: =SUM(--D3:G3) 3) instead of dragging the formula from C3 all the way to C12, you can use the following formula: =BYROW(D3:G12,LAMBDA(x, SUM(--x)))
@DarrenFall-xq7zi9 ай бұрын
Great video Kenji. However, I have activated the Insider option on my account, downloaded all the updates, and the Checkbox feature is still not available (apart from the old one). I got it working as per your instructions, but frustrating none the less.
@aa6x_x4 күн бұрын
Can I automatically create checkboxes by typing in an empty cell? For example: I'm adding a new task to the list.
@giangutierrez51099 ай бұрын
Hello, I am wondering if what's the Excel version for this to work? I can't find this option on my excel.
@kossiviaglee29979 ай бұрын
Thanks for the video but in my 365 office, I do have the Checkbox tab but not the command. Please, what should I do?
@GSC-zz8zt10 күн бұрын
Is there any way to assign a macro to these forms of checkboxes? I can do it when it's a Developer tab checkbox. I don't know how to do it for one created under the Insert checkbox.😀
@dalya14369 ай бұрын
Good morning, I am looking for how to do such a method, but I cannot find checkbox, the same method as yours, but I found the lite available in the developer. Can you explain the other method?
@ahmedmohammedabdullahi40119 ай бұрын
Dear Kenji get knowledge in practice thank you your next video 🙏
@pradipmajhi86369 ай бұрын
Dear Kenji sir please bring another video on data cleaning to get deep knowledge of it and upload it's practice file
@GayatriThombre-g8m21 күн бұрын
Is there any way to link multiple cells at a time?
@margaretmartin6646 күн бұрын
Can you change the check mark to and X
@emmanueldagogo1253Ай бұрын
How do i edit the "True or False" text to what i need? For example "Paid or unpaid"
@camlex63109 ай бұрын
What a great feature!
@awaranyc19 ай бұрын
I can't find this feature in my office 365??
@Yasharghami6 ай бұрын
Hey Kenji, big fan of the channel. In many investment banking interviews, they ask not to use mouse! Do you have any tips for preparation?
@KenjiExplains6 ай бұрын
Hey! Where did you get that from ? In my experience the interviews didn’t involve a computer except the initial online assessments.
@arnelpedro40939 ай бұрын
Thank you Ken you are amazing, the only thing that i want to know is how to grey out the stage 2 when stage 1 isn't complete and only make it available when stage 1 is checked, the same thing for stage 3 when stage 2 isn't complete?
@1PPPete9 ай бұрын
Thru conditional formating. You choose the "Formula option" where you put format cells which following formula is true and put in D3=FALSE (unchecked cell) and apply it to remaining cells E3:G12 and apply grey background.
@arnelpedro40939 ай бұрын
Ok ty i’ll try this
@coldry2 ай бұрын
Hold up, this is 7 months on and I still don't see this in my Excel Desktop App. It's the latest version that comes with my M365 License. When I first heard about this feature I realised it was only available to the insider folks, but surely 7 months on I should see it in GA no?
@ajab20129 ай бұрын
Kenji You're awesome
@AnilDasari18129 ай бұрын
Nice video 👍
@kingdompig19 ай бұрын
Is this available for excel 365? I just updated my software, and this option don't exist between the "Comment" and "Text Box" sections. When I go to Options > Customize Ribbon > Main Tabs, the "Cell Controls" section is empty
@user-om7yl4dz8h5 ай бұрын
Anyone know when will it be out of the beta phase and available in the general version?
@johnvak73902 ай бұрын
why cant they do it like google sheets, i have to manually do every checkboxes
@mariorossi36268 ай бұрын
Work with W10 ? Or only with W11 ??
@schubertpeter799 ай бұрын
awesome video once again Kenji! will you have some Xmas discounts on your courses? :)
@patricklonski9 ай бұрын
It's frustrating for me that have been in the Insider program for years and I never get these new features until they seem to be available to all 365 owners. I thought Python was also available with Excel. What happened.
@abdelazizallam9 ай бұрын
thanks
@eng.khalidabbas88826 ай бұрын
Why the check box icon is grayed out
@bevik122 ай бұрын
After 6 months still no Checkbox. Sad.
@rejwongtana49093 ай бұрын
Where can I find "Check box" ?
@Mixolydian749 ай бұрын
can you filter out or filter for the strikethroughs in col A?
@1PPPete9 ай бұрын
You can apply filter from the DATA tab to the table. I am not aware of option for filtering for strikethroughs but you can filter by text or fill color... so in this case for green font or you can add like green cell fill to completed tasks.
@irishdancercm29 күн бұрын
Still not showing!
@aaronvesselsАй бұрын
I am sitting in july and still don't have this
@williamarthur48019 ай бұрын
Has this been released fully or is it insider as I don't seem to have it, just the old developer insert
@KenjiExplains9 ай бұрын
i explained in the video....
@williamarthur48019 ай бұрын
@@KenjiExplains Thanks, I'll watch in full tomorrow
@solpheus52742 ай бұрын
🤣 Alternative way! No, thanks!
@roseisubana43494 ай бұрын
You are Soo handsome
@willzinner88139 ай бұрын
wednesday upload?
@KenjiExplains9 ай бұрын
mixing it up!
@ashishbhasin19269 ай бұрын
Really helpful, thanks kenji
@KenjiExplains9 ай бұрын
Glad it was helpful!
@nishanth43239 ай бұрын
What took them so many years......🥴
@johnvak73902 ай бұрын
Uhh this way is so slow
@vara69229 ай бұрын
🤗
@KenjiExplains9 ай бұрын
:)
@wac558 ай бұрын
Is this only on the paid version? I don't have it on the 365 free version