Make a Project Tracker with Excel’s NEW Checkbox Feature

No video

Make a Project Tracker with Excel’s NEW Checkbox Feature

Рет қаралды 72,888

Kenji Explains

Күн бұрын

Пікірлер: 73

@KenjiExplains 9 ай бұрын

🚀10x your Excel with our course: www.careerprinciples.com/courses/excel-for-business-finance

@sbatsia 9 ай бұрын

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/

@peanutnutter1 9 ай бұрын

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.

@hemantchaudharyvlogs02134 9 ай бұрын

Your thinking is better than Microsoft employees 😂😂.

@preshen 9 ай бұрын

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.

@bhaveshsavla7812 9 ай бұрын

Yes. Same thought.

@jcraft100 7 ай бұрын

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

@sabrinawilt4441 6 ай бұрын

Thank you - was so confused!

@lauro7861 6 ай бұрын

Thank you for this answer!

@PonchoScotch 3 ай бұрын

This comment should be pinned

@nhwine 9 ай бұрын

What version of Excel is this in? I have the most recent update to Office 365 and still don't see this feature.

@lauro7861 6 ай бұрын

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

@paulschrieber8590 9 ай бұрын

Can't believe they haven't added this already...its about time

@KenjiExplains 9 ай бұрын

i agree haha

@Queijin84 7 ай бұрын

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.

@michaelallen7172 6 ай бұрын

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.

@benitomate1867 9 ай бұрын

How i add Cell control to Excel? I not find it

@carolinaforbes5020 9 ай бұрын

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!

@1PPPete 9 ай бұрын

This principle is really simplistic, can easy make this from ground up, no need for practice file.

@meniporat3527 6 ай бұрын

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-xq7zi 9 ай бұрын

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_x 4 күн бұрын

Can I automatically create checkboxes by typing in an empty cell? For example: I'm adding a new task to the list.

@giangutierrez5109 9 ай бұрын

Hello, I am wondering if what's the Excel version for this to work? I can't find this option on my excel.

@kossiviaglee2997 9 ай бұрын

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-zz8zt 10 күн бұрын

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

@dalya1436 9 ай бұрын

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?

@ahmedmohammedabdullahi4011 9 ай бұрын

Dear Kenji get knowledge in practice thank you your next video 🙏

@pradipmajhi8636 9 ай бұрын

Dear Kenji sir please bring another video on data cleaning to get deep knowledge of it and upload it's practice file

@GayatriThombre-g8m 21 күн бұрын

Is there any way to link multiple cells at a time?

@margaretmartin664 6 күн бұрын

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"

@camlex6310 9 ай бұрын

What a great feature!

@awaranyc1 9 ай бұрын

I can't find this feature in my office 365??

@Yasharghami 6 ай бұрын

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?

@KenjiExplains 6 ай бұрын

Hey! Where did you get that from ? In my experience the interviews didn’t involve a computer except the initial online assessments.

@arnelpedro4093 9 ай бұрын

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?

@1PPPete 9 ай бұрын

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.

@arnelpedro4093 9 ай бұрын

Ok ty i’ll try this

@coldry 2 ай бұрын

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?

@ajab2012 9 ай бұрын

Kenji You're awesome

@AnilDasari1812 9 ай бұрын

Nice video 👍

@kingdompig1 9 ай бұрын

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-om7yl4dz8h 5 ай бұрын

Anyone know when will it be out of the beta phase and available in the general version?

@johnvak7390 2 ай бұрын

why cant they do it like google sheets, i have to manually do every checkboxes

@mariorossi3626 8 ай бұрын

Work with W10 ? Or only with W11 ??

@schubertpeter79 9 ай бұрын

awesome video once again Kenji! will you have some Xmas discounts on your courses? :)

@patricklonski 9 ай бұрын

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.

@abdelazizallam 9 ай бұрын

thanks

@eng.khalidabbas8882 6 ай бұрын

Why the check box icon is grayed out

@bevik12 2 ай бұрын

After 6 months still no Checkbox. Sad.

@rejwongtana4909 3 ай бұрын

Where can I find "Check box" ?

@Mixolydian74 9 ай бұрын

can you filter out or filter for the strikethroughs in col A?

@1PPPete 9 ай бұрын

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.