How to Create a Progress Tracker Controlled with Checkboxes in Excel

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
Thank you! 👍👍

In this Microsoft Excel video tutorial, I show you how to create a progress tracker controlled with checkboxes in Excel. This progress tracker can be used to track the progress of a project or task, and it's easy to create!

00:00 Introduction
00:46 Track non-weighted project phases
00:50 Insert checkboxes
01:43 Link checkbox to cell to return TRUE or FALSE
02:42 Hide TRUE and FALSE values
03:18 Count checked checkboxes + calculate % checked
04:20 Create progress bars using conditional formatting
05:03 Create progress bar using a bar chart
07:37 Track weighted project phases (weighted by work hours)

[transcendingthedyad]

Man with that amazing voice you should be recording audiobooks.

[IvanCortinas_ES]

Excellent analysis Chester. Absolutely essential for controlling processes. Thank you Chester!!!

[sdewviljoen]

Thanks! We are tracking UAT case completion - each step is a row - so this works perfectly!

[shakilanjum]

Exactly what i was looking for. I saw an implementation of this using sparkline, however this one seems easier. Thanks

[aquacanleo]

OMG THANK YOU YOU ARE AMAZING! INSTANT SUBSCRIBE ♥

[Puneeth-dclv]

Hi there, so if there are multiple check boxes say 30 rows and 10 columns, do we have to go into each one for the formating to attach the cell link or is there a short cut for it? Any advise would be appreciated. Thanks!

[israelderas]

Hi Chester, thank you for all your videos, they help a lot. I wonder is you be kind to share a formula that I cannot make to work yet, I need to add total value of one code between dates, If I do it separayly just looking between dates it give the how many Code do I have, but no count the quantity of the code, the columns are DATE, CODE and QUANTITY. Can you help me with that, please?? thanks

[aldonegeldenhuys]

Is there a way to get around the "you've entered too many arguments" error

My check boxes aren't all in a single row/ column

[muomi.]

Thank you very much for this Video.
Do you know, do i have to link every checkbox seperatly, or is there a way to do a lot of them at once?

[KristelYee]

Hello! I am wondering if we can use the progress bar be controlled by a dropdown list. Thank you!

[BryanM-xjrp]

I've downloaded the sample. Try as I might, I simply cannot add more rows instantly to add to the spreadsheet. When I do, the new row and its check boxes interact with the above row, I figured there was a way to mass produce lines. Bummer.