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

Подписаться 55 тыс.

Просмотров 483 тыс.

50% 1

YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
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-013 - Create a ba...
* TECH-012 - Create links in Excel to places within your spreadsheet and outside of your spreadsheet
• TECH-012 - Create link...
* TECH-011 - Create a calendar in Excel that automatically updates colors by event category
• TECH-011 - Create a ca...

Опубликовано:

3 авг 2017

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 164

@jeanettesefers8180 3 года назад

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

@kabirahmadnazari186 4 года назад

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

@rade9242 6 лет назад

Amazing, very clear and straight forward

@handbaglover540 3 года назад

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

@sonjaboes3138 Год назад

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

@williewill0313 6 лет назад

Super helpful! Thanks for sharing.

@giapponerosso 5 лет назад

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

@laszlokovi4719 5 лет назад

eXCELLENT again, thank you!

@lovebaking2503 5 лет назад

This is so interesting, thanks for the tutorial!

@Angexcel 5 лет назад

Excelente, su trabajo, gracias por compartir su conocimiento, saludo desde Bogotá Colombia.

@msmotivation6492 4 года назад

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

@paradoxpraveen3968 3 года назад

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

@sunijajoseph8894 4 года назад

Very helpful. Thank you for the tutorial

@glyn3 3 года назад

This is super helpful. Thank you!

@safmis 3 года назад

Thank you for your effort, Sir.

@dianemetzloff2608 3 года назад

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

@dearbrave4183 3 года назад

Amazing! Thank you♥️

@abidas6087 6 лет назад

Excellent !

@henkas3 5 лет назад

Love this

@MrNoniesingh 3 года назад

Thanks a lot man! Great help!

@mahamohan1 5 лет назад

Simple and informative

@krmotion1522 6 лет назад

a bigger than Best video.....i love it

@pascalbruniaux Год назад

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

@olufemiajayi7356 Год назад

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

@mohsenhashemi2548 4 года назад

Thank u, so simple but nicely thought

@saintmichelbiroki2213 6 лет назад

Hello TECH, thanks a lot for the video

@Steave-M 5 лет назад

Best one. Thanks

@nobaiat5621 3 года назад

Awesome job!

@1531W 3 года назад

Very well done . Thank you

@firstnamelastname8418 3 года назад

Thanks a lot for sharing!

@ashkanahmadi 5 лет назад

Great thank you very much.

@suryaprabhat8073 4 года назад

Love you man!

@MicheleChristensen 2 года назад

This is really clever and useful!

@shellaannasidera3533 6 лет назад

amazing!

@sukeshnawany5336 5 лет назад

Very Useful Great !!

@rasoulkhoshravan5912 4 года назад

I watched this video. It is very informative.

@alpaljl Год назад

I love this.

@pearsylmaclang6306 5 лет назад

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?

@stevehenry6987 3 года назад

Thank you!!

@ThuNguyen-hm7xl 4 года назад

Love it

@edcastaneda9708 2 года назад

Very cool, thanks for this video

@walid933 5 лет назад

Very nice explination sir thank you very much.👌

@Sattva_Construction 2 года назад

Thankyou for this buddy..

@irfaulhaqsani3547 5 лет назад

I got it. Thank you very much

@ioniquw 2 года назад

such a useful video thank you

@prasannasriskantharajahasa1682 5 лет назад

very useful thank you

@MadanKumar-uy4iu 5 лет назад

Excellent video very very useful....

@ramkumargourarajula9528 3 года назад

Excellent

@Teacherman1955 4 года назад

Thanks for the tutorial! I am guessing that when you did the formula for the progress category, you had that cell formatted for "percentage". For fun, I added "IF" statements for each task...Complete" if TRUE and "Not Complete" if FALSE

@MrMohammead 5 лет назад

Thanks a lot

@LinLin2084 3 года назад

Thank you so much.

@erickndonga9316 5 лет назад

Nice one

@Ramdo0 5 лет назад

Thank you from Pakistan

@johnb2nde 5 лет назад

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

@XxSonic2223xX 3 года назад

Thanks for the video, very helpful! I would also like to know how to assign different weights to these tasks instead of having them equal

@misssomod194 4 года назад

thank you

@ahmedabouseeda4549 5 лет назад

Awesome

@christinafrancis713 2 года назад

you are the best

@willyandriwijayawillywijay7765 6 лет назад

The best video tutor ever...

@TheExcelChallenge 5 лет назад

Hello Willy Andri and thanks for your comment. I'm not sure if I'm the best video tutor but what I can guarantee you is that I give my best at creating my videos. I hope you subscribed and stay tuned for future content. T-E-CH

@somaforever 5 лет назад

nice one

@senitacraigen9480 5 месяцев назад

THIS WAS SOOOOOOOO 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?

@lakshmiprasad4026 2 года назад

Lovelyyyyyy

@ShravanKumar-eu4cm 3 года назад

Perfect..

@jozefchromy5644 4 года назад

Fantastic way of relaying your thoughts, however the pace is too fast thanks. I use the automatic calendar and the sequence of order to build it is clear and follow able. thanks a lot. J.C.

@belindabeale2405 7 месяцев назад

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?

@yahyabahami1194 5 лет назад

جميل جدا شكرا لكم

@constantinobarrozo287 2 года назад

Thanks for the informative tutorial. I have a question and I wanted to see if you can point me in the right direction as my experience with Excel is pretty basic. I'm trying to find a way to create a spreadsheet with a main "dashboard" or tab where I can add text information that gets updated in other tabs but those extra tabs cannot edit the text information on the main sheet. Thanks in advance for any tip or guidance.

@rihamturk 3 года назад

Thank you for the great tutorial, Kindly can you help me out if I want the check boxes horizontally not vertically, how can I assign the progress?

@pancholitachiu23 Год назад

Hello. Great video. Is it possible to do the chart cell based like a sparkline? It seems to be a function in GS but not in Excel

@anthonygreene6643 3 года назад

Could you make a progress tracker for logostics? Like from point a to point b. I tracl 18 wheelers and use excel to track progress using manually entered time stamps. So I can see when I updated a unit and were i updated the unit. Any ideas on that?

@joanp7914 2 года назад

Hi very clear presentation. Do you have any examples of a preventative maintenance planner using excel Many thanks

@carollia6402 4 года назад

OMG what kind of sorcery is this?! great video, great tools!

@TheExcelChallenge 4 года назад

Hahaha. Great comments Carollia! Thanks for watching. T-E-CH

@carlosdg2319 5 лет назад

Any suggestion how can I create a day to day tracker for the team, based on a series of list of activities so at the end of the day I can understand how much time the invested on pre sales, invoicing, collection, legal etc

@bulaval 3 года назад

Hi. Thanks for this video. Do you have a video on how to create a template to manage staff availability across multiple work sites? So, I have to manage supervisors availability on 5 different work sites and need to manage capacity across these sites, show when each is on site, on annual leave and in training. The template also needs to account for weekends and public holidays. Any pointers?

@Tata_Santosh 3 года назад

Here equal weightage is given to all the activities...can you post a video in which different activities have different priorities like critical, major, minor and general

@saimanojjaddu2690 4 года назад

Thanks for the tutorial, Can you please show how can we create interactive Kanban board in excel

@jerrypolete5258 4 года назад

Hello. I’m trying to create a spreadsheet to track project hours. I’m a PM and I want the spreadsheet to automatically count the cells for PM hours on the job and technician hours so I can easily look on one form to see where the project is budget wise with hours. Any ideas how to design that?

@rosapadilla1009 4 месяца назад

Love this!! How would I convert this for customer service tracker? So, I would want to have this but then on another sheet I want only the progress bar? Everyone please chime in

@jessicalepitzki9080 4 года назад

This was very helpful. Thank you! I would like to use this with students for self-paced learning. Can I use office 365 to publish a view-only copy for each student?

@TheExcelChallenge 4 года назад

Yes Jessica. You can. T-E-CH

@binderslee7480 6 лет назад

Can you show me how to integrate a countdown for each task based on the target completion date and also in case there is an overrun, you can show the overrun in days and highlight in a red colour with white text?

@raulpena4700 3 года назад

Would I be able to add weight to the true and false? This would really help thanks!

@dennardr3391 3 года назад

Does the value have to state true/false? For instance can it say paid/unpaid? Also this was really help! Sorry I didn't mention that originally.

@rashmiranjan86 4 года назад

Hi, this is helpful. Can you please assist me how to make only one check box select at a time?

@prabhakar8850 3 года назад

👍👍👍👍👍

@normanpeters6465 3 года назад

Can I copy and paste a list of activities into the cells at once or it has to be done individually?

@jaybigx2156 3 года назад

Can we add drop down menus for this progress tracker ? I would like to keep one page and from there clicking the drop down menu to where I can select my choices of tasks

@andrewjarvis3696 Год назад

Looks like your going to be busy If I was you I'd get a weekend job 😆

@khalidam9562 5 лет назад

That was a great tutorial. This is a task that I'm trying to do with no success.. I want to create a daily schedule for one task where operators can tick a checkbox once they are done with their task and there is an option to send a message (WhatsApp) to contact them if there is any observation or urgent remarks that need to be delivered. Can you please explain how to do that?

@melissahollister1405 3 года назад

I want to have Excel automatically add a checkmark to a sheet when an entry is made for a specific item......is there a way to do so without having to add each item in individually? Or will I have to format each item to add a checkmark when that entry is entered into the budget sheet?

@munawarhussain7878 7 лет назад

Best video.

@TheExcelChallenge 7 лет назад

Thanks for the support Munawar. I'm glad to hear you're enjoying our videos.

@nutzv24 6 лет назад

Hi! Is it possible to create an employee activity tracker in excel where breaks will automatically be deducted from 8hours? for example, I entered "break" under the column named "Activity", I want the current time to populate on the next column then when I click a macro module, the timestamp for the end of the break will automatically populate on the next column. Then I want the duration of the break to be automatically deducted from the 8 working hours. Would that be possible and how? Thank you!

@ogwangjoshua695 3 месяца назад

use workday and buy the scanners. time in , break and lunch is automatically populated into excell format

@jozefmatyasek 3 года назад

can you pls tell me how to lock the chart ? . It changing how long it is based on percentage in my case. thank you .

@the592clan3 4 года назад

If I'm creating this for one than one users use at the same time , how can it be saved , since the file will obviously say it's in use ? So what can be done ?

@hankgrimes1806 5 лет назад

I really enjoyed this video. After watching it, I thought it would be very helpful to create a progress tracker for our EFL program. One level has one teacher, and the other level has four teachers presenting the same material. If each teacher reports the last page he finished each day, how can I track them as a group? I tried using a daily average, but I can't figure out how to create a "running" total. Please help!

@TheExcelChallenge 5 лет назад

Hello Hank. Glad to hear you enjoyed this video. Please email me an example of what you currently have and I’ll get back to you. My email address is theexcelchallenge@gmail.com Thanks for watching T-E-CH

@DennisAbad 3 года назад

is this doable in google sheets? great video btw!

@ashoksathya1554 2 года назад

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

@tsayed5735 4 года назад

Thanks for the informative video. How can I create a tracking database? Please assist thanks

@rickthomas7427 Год назад

Can you tell us how to split a cell in Excel? Either vertically or horizontally? Thanks

@jayzgroove 4 года назад

If i want to add this in multiple task with month and year wise please help me...

@ricardoj9958 2 года назад

hi, I have to create a power point with a plan for a department at the logistics warehouse where I work ( Dispatch and pack depart ) I have to implement some new procedures so the team will work more efficient ( implementing operational wise I can and I am already doing it but my manager wants me to to put a PowerPoint together but I have no clue when to start. He needs the tasks, costs, time and all packing/dispatch process steps ( kind of like an project tracker ) he needs to know what's the cost atm how the departments are working and after the improvements. Please let me know if you can help