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?
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
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?
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?
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
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
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
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
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?
I have a question, my progress both on the sheet and chart is in decimals instead of percentage how can I fix it? Thank you so much for this tutorial! Helps me on tracking my school work.
I figured it out!! Highlight the decimal and when the box appears with the bold, font size etc, there is a % icon. Click on it and it will change you figure to a percentage.
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?
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
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.
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.
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
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?
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
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?
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?
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?
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
HI, i need help to develop a template with work assign to my staff and be able to track if it's done by them or not. task would be simple like call Patient XZY, task ordered by, task completed by. i would like to color code the row with response of the staff like it been done, or still waiting.
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?
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!!
You make me a super star @ work. Thank you.
excellent idea !!! your explanation is so simple - thanks !
I love you....your a great instructor!
Amazing, very clear and straight forward
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?
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
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?
Thank you so much for the precise, clear and concise tutorial. APPRECIATE IT
Very easy to follow. Exact instructions in sequence, very helpful thank you!
Thank you for your effort, Sir.
Very well done . Thank you
Awesome job!
I love this.
This is really clever and useful!
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?
Great. This is one of the aspects within excel I needed to learn. Thank you so much for sharing! 🌹
Super....🎉
Thank u, so simple but nicely thought
Thanks a lot man! Great help!
Very cool, thanks for this video
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
Hi, For those who still need it, you can do VBA auto-linking all the checkboxes with one drag. You can find it easily on UA-cam.
such a useful video thank you
This is so interesting, thanks for the tutorial!
Love you man!
Thankyou for this buddy..
Simple and informative
The best video tutor ever...
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
eXCELLENT again, thank you!
Super helpful! Thanks for sharing.
a bigger than Best video.....i love it
Wow just amazing. Thank you for your work. It saved me a lot of time
This is super helpful. Thank you!
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
Very helpful. Thank you for the tutorial
Thank you!!
Excellent
you are the best
Thank you so much.
Excelente, su trabajo, gracias por compartir su conocimiento, saludo desde Bogotá Colombia.
Nice one
Amazing! Thank you♥️
Perfect..
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
Excellent video very very useful....
Love it
Lovelyyyyyy
very useful thank you
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?
I watched this video. It is very informative.
Can you tell us how to split a cell in Excel? Either vertically or horizontally? Thanks
OMG what kind of sorcery is this?! great video, great tools!
Hahaha. Great comments Carollia!
Thanks for watching.
T-E-CH
Love this
Can we able to create check box all at one shot for a set of line items or to do list activities.
Hi very clear presentation. Do you have any examples of a preventative maintenance planner using excel
Many thanks
great video- thanks for the tips, just what I needed!
Hello TECH, thanks a lot for the video
Very Useful Great !!
I have a question, my progress both on the sheet and chart is in decimals instead of percentage how can I fix it?
Thank you so much for this tutorial! Helps me on tracking my school work.
Mine too is coming up as decimals too! I'm trying to fix it, if I find out I will let you know.
I figured it out!! Highlight the decimal and when the box appears with the bold, font size etc, there is a % icon. Click on it and it will change you figure to a percentage.
Excellent !
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.
Great thank you very much.
Thank you from Pakistan
Very nice explination sir thank you very much.👌
Best one. Thanks
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
Thanks a lot
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?
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?
Yes Jessica. You can.
T-E-CH
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
Hi, this is helpful. Can you please assist me how to make only one check box select at a time?
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
I got it. Thank you very much
Looks like your going to be busy If I was you I'd get a weekend job 😆
Thanks for the tutorial, Can you please show how can we create interactive Kanban board in excel
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.
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.
Would I be able to add weight to the true and false? This would really help thanks!
Awesome
Thanks for the informative video.
How can I create a tracking database?
Please assist thanks
Can I copy and paste a list of activities into the cells at once or it has to be done individually?
amazing!
can you pls tell me how to lock the chart ? . It changing how long it is based on percentage in my case. thank you .
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
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?
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
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?
nice one
Is there a way to auto fill the cell links?
جميل جدا شكرا لكم
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?
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?
How can you get positive values instead of negative in the total cell, can you please tell me
Its total true (plus) total false. I did total true (minus) total false the first time around as well.
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
how would you go about not showing the true and false cells before the progress %.
just to make it look neater really
thank you
HI, i need help to develop a template with work assign to my staff and be able to track if it's done by them or not. task would be simple like call Patient XZY, task ordered by, task completed by. i would like to color code the row with response of the staff like it been done, or still waiting.
Can the value from the Check box be other than "True" or "False"?
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?
Is there a way to change the true/false to complete/incomplete?