TECH-014 - Create a progress tracker with check boxes in Excel

Learn a quick trick to create a progress tracker in Excel with check boxes.

I hope this concept is something you can use in your daily routine so you get more with less effort.

If you have an Excel challenge that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers.

Thank you for watching.

Check out some of our previous videos in the links below:

* TECH-013 - Create a bar chart with conditional formatting in Excel

* TECH-012 - Create links in Excel to places within your spreadsheet and outside of your spreadsheet

* TECH-011 - Create a calendar in Excel that automatically updates colors by event category

[jeanettesefers]

I love how you get to the point without all the blah, blah blah. Thank you for this video. Can't wait to check out more!!

[olufemiajayi]

You make me a super star @ work. Thank you.

[rade]

Amazing, very clear and straight forward

[kabirahmadnazari]

Thank you so much for the precise, clear and concise tutorial. APPRECIATE IT

[handbaglover]

Very easy to follow. Exact instructions in sequence, very helpful thank you!

[pascalbruniaux]

excellent idea !!! your explanation is so simple - thanks !

[sonjaboes]

Great. This is one of the aspects within excel I needed to learn. Thank you so much for sharing! 🌹

[dianemetzloff]

I love you....your a great instructor!

[giapponerosso]

Thanks for the tutorial, it s very simple and clear especially for people that dont have exp in using excel. Would you considering making a tutorial about a mood/enrgy/anxiety/thoughts tracker? I m not even sure it s doable with excel, but that may potentially help lots of people

[senitacraigen]

THIS WAS HELPFUL! You can't imagine how happy I am to have been able to do this. And like the previous comment said, you were so succinct! Love it. 1 question though... My drag and drop formulas don't work. Will we have to do that manually when adding rows?

[belindabeale]

Hi there. Love the progress tracker. How would you do a if it was at stages so if you have an exam so started syllabus =1 then started notes =2 practice question =3 right up to 6 which would be practise exams this would then calculate the sheet at what percentage all 12 topics are complete as a whole and each topic individually?

[mohsenhashemi]

Thank u, so simple but nicely thought

[paradoxpraveen]

Wow just amazing. Thank you for your work. It saved me a lot of time

[lovebaking]

This is so interesting, thanks for the tutorial!

[pearsylmaclang]

This is very useful in monitoring work progress for certain projects. Thank you. Is there a way to show the percentage of work done in relation to your desired duration for a project?

[johnbnde]

Thanks for the tutorial, it's very informative. However, the process of assigning a true or false cell to each check box can get really tedious when creating one for a very long list. Is there a process of auto-linking True/False cells to each row of check boxes. I've tried different copy&paste options with no success, I'm been forced to go to each cells, I'm close to losing my mind

[ashoksathya]

Can we able to create check box all at one shot for a set of line items or to do list activities.

[sunijajoseph]

Very helpful. Thank you for the tutorial

[walid]

Very nice explination sir thank you very much.👌

[msmotivation]

great video- thanks for the tips, just what I needed!