Excellent video it really help to clear my concepts of Gantt chart and how effectively we can prepare the same chart using MS excel tool too. Thankyou so much.
Thank you for such an easy and quick Gantt Chart technique in Excel. I have a question related to the above video. What if we want our project to start from Monday ? Also how can we highlight the weekends(Saturday & Sunday) and other holidays during the project tenure? Would appreciate if you can come up with a solution. Thanks once again for your efforts.
Oh thank you very much bro for the shot valuable and educative video. I am still thinking about how to establish the critical path on the schedule? Thank you very much
Hi, good work. I have 3 questions. 1) I would like to make friday as weekend, so in duration it will deduct Fridays. Saturday to Thursday are working days. 2) Highlightng bar for Actual, it doesnt get hilighted till we put end date. what i want to see is it highlight based till todays date from actual start, till i dont put end date. once i put end date, it should highlight from actual start to actual end date. 3) i want to add % colum, for plan and actual. Please assist me on this, appriciated.
Appreciate video content! Excuse me for the intrusion, I would love your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates without the headache. Ive heard some amazing things about it and my work buddy after many years got cool results with it.
This is a great video. Can you explain how to level this schedule with available manning? For example; maybe you only have 4 people to complete all of these tasks.
I've set up a Gantt Chart like the one you created and wonder now if it is possible to set up so that planned and actual duration can exclude weekend dates?
Challenge - I have sheet1, sheet2, sheet3, sheet4 and sheet5, every sheet contains date and time of the 12months, for example Sept. 09, I put an agenda on the 9am, then in sheet 2 I put agenda on 12nn, next sheet, 2pm, sheet 4 3pm and sheet 5 5pm. Then in Sheet 6 it shows all the activity I made on different sheet. I hove you notice my comments, because It is very big help to manage the class activity of 5 section handle. Thank you so much :) very helpful videos you always content :)
very good video, thanks for helping me to make my timeline, but just a doubt how does it work with two different months on the same timeline? as soon as i change the date it seems not to work. thanks
Hi. That is what I'm looking for but to be 100% happy I looking to add for your planer some like: I'm handyman, Example I'm add kitchen project when I know that will be around 3 weeks. I want type kitchen on my task and excel should automatically mark this 3 weeks on my calendar. That will give me batter look of my free time to arrange next project. Are this criteria will be possible to put in your sheet. Thank you.
This will only work if you have an actual finish date, how can you keep a running bar on the actual till its complete, for activities that have a longer duration. Like your tutorials, so informative and easy to follow.
Hello. Thanks for the video. Do you have something similar but with tasks which are taking few hours, not days? I want to prepare something for my job, taking in consideration that i am working 8h/day and consider this 8h one day. Did you got my point? I want to track all my tasks and by the end of the month to see if I am doing my job better than the estimation. Let's say I estimate one task for 5h and i will finish in 4h, then I have cost saving for 1h. Thank you for your response!
Thanks a lot for this video. SUPER USEFUL. One follow up Question though. Is it possible to highlight the amount a task slips in a different color(say RED) to flag the amount of delay in days ?, especially in the ACTUAL row. Sounds like this might need a slightly more complicated conditional formatting.
Thank you, please help me if there are multiple users in Project and their activities are not dependable, in such scenario can Grantt Chart helpful? What will be the other solution?
@The Excel Challenge Thanks for your great advise. I have an excel challenge for the Gantt Chart. I wanna add the manpower in each cell with the conditional formatting and manpower graphic below the Gantt Chart. Please help me find a solution. :)
This excellent presentation, the demonstration is easy to understand!!! I learned a lot. What I want to know if we can combined the value of the actual completion in PERCENTAGES with same in the time line.
Thankyou for your tutorial.. it means a lot.. but can u help me, for controlling inventory, when to reorder, how long that inventory enough to use until it runs out..
super thank you - i added this too to the Gantt chart - thank you. I was able to take out the weekend dates in the calender - but i dont know how i should do so that taskduration takes in conderation weekend dates - now if i have 3 days and 1 of them would fall on a saturday or sunday it doesnt show the 3th day - would be great to get some help on this too - in any case i am very thankfull for this video!
thanks for the video - just to clarify why did the formula calculate 6 days colored boxes when you enter 5 days - when you put 6 days - it colored 7 boxes
just going through your tutorials, which are great by the way; on this one (TECH-018 - Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in Excel) how would you proceed to populate the chart, if you had one or more tasks that could be performed at the same time as others, meaning that they are not dependent one from each other? thank you in advance.
Hey Thanks for this video this is very Useful. But I should have need a bit more detailing in it, like I have to track the schedule and find out how many days I delay in my work, then how will they do it? Please can you Help me?
I am one of the people who really thank you so much for your help and showing very clear steps. You the best
Thanks for your comment Salem. It’s nice to hear you find my videos helpful. Stay tuned for more.
Thanks for watching.
T-E-CH
Thank you so much. This is one of the best tutorials ever.
This was probably the best Excel video I have seen, AWESOME!
Many thanks. It looks very professional and nice. I just followed your instruction to finish my report.
how to we automatically exclude the weekend? let's say the allowed working days are monday to friday?
Your videos are so helpful thank you!
Excellent video it really help to clear my concepts of Gantt chart and how effectively we can prepare the same chart using MS excel tool too. Thankyou so much.
Great solution. I´d spent ages trying to modify the IF(AND... formula, but couldn´t get it to work. So this is a really practical solution. Nice one.
One of the Top Rated Video.. great
I don't know how to thank you but the info you have put here was very great and from the bottom of my allow me say thank you very much.
You are a life saver bro! Thank you so much
You are life saver !!Thanks a ton.
Thank you very much for clear explanation.....very usefull video
Thank you so much for sharing this helpful tips！
Thank you so much for such clear instruction - and for the template...soooo useful!!!!
Awesome , you made it look so easy,
Awesome thanks for sharing, this is going to great for my task list
Superb really excellent Job to explain and is really very useful. Finally I got it . Thank You so much Bro!
You are a gem Sir!
You saved my absolute bacon. Thank you sir!
Thank you for such an easy and quick Gantt Chart technique in Excel. I have a question related to the above video. What if we want our project to start from Monday ? Also how can we highlight the weekends(Saturday & Sunday) and other holidays during the project tenure? Would appreciate if you can come up with a solution. Thanks once again for your efforts.
in actual condition, im working from monday to friday, could you tell me how to make off day on the timeline, and make calculate correctly sir ?
Good video. How would you create one that avoids weekends and only does work M-F?
Thank you Sooo much !! Thats sooo Awesomw !! Ofcourse I will try it
Amazing❤
Impressive！Great to watch these videos👍😊
Great videos!!! Looking forward that you make more of them =)
Oh thank you very much bro for the shot valuable and educative video. I am still thinking about how to establish the critical path on the schedule?
Thank you very much
Thank you... This is the Idea I was looking for...
Hi, good work. I have 3 questions. 1) I would like to make friday as weekend, so in duration it will deduct Fridays. Saturday to Thursday are working days. 2) Highlightng bar for Actual, it doesnt get hilighted till we put end date. what i want to see is it highlight based till todays date from actual start, till i dont put end date. once i put end date, it should highlight from actual start to actual end date. 3) i want to add % colum, for plan and actual. Please assist me on this, appriciated.
This is awesome
this is your last video. I hope you comeback making videos because yours are better than the rest.
trust me I’ve checked them all.
Wow I wish you upload more..
Thanks this video is really helpful
Appreciate video content! Excuse me for the intrusion, I would love your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates without the headache. Ive heard some amazing things about it and my work buddy after many years got cool results with it.
This was very useful, thank you!
great job
Actually helpful.
this is very helpful. thank you very much. makes my work easier so much.
Hi Sir! I really appreciate the tutorial ❤ Can you also make a video on how to apply Scurve for this ?
You are in my mind, thank you
Thanks Arteo. Glad you liked it.
This is a great video. Can you explain how to level this schedule with available manning? For example; maybe you only have 4 people to complete all of these tasks.
I Thank for your clear steps, my question is why we would add 1 on finish date to get the next start date?
hi ' thanks for this amazing explanation ! what if I add a holydays and days off ?
Thank you >>>> How can Add or show progress bar ?
Thank you so much for this tutorials it is very helpful .How can we combine to create a yearly plan in one spreadsheet.
Duden awesome work !
Thanks Zirael !!
Sir I appreciate you're hardwork, you are doing very will, Sir I kindly request u to create a tracking sheet for expenses of a project.
is there a way to still include all Sundays? great video BTW!
Exactly what I was looking for. Thank you.
I want to do this in Google sheets too. Don't know how it works out.
I've set up a Gantt Chart like the one you created and wonder now if it is possible to set up so that planned and actual duration can exclude weekend dates?
Awesome & Tqsm
Challenge - I have sheet1, sheet2, sheet3, sheet4 and sheet5, every sheet contains date and time of the 12months, for example Sept. 09, I put an agenda on the 9am, then in sheet 2 I put agenda on 12nn, next sheet, 2pm, sheet 4 3pm and sheet 5 5pm. Then in Sheet 6 it shows all the activity I made on different sheet. I hove you notice my comments, because It is very big help to manage the class activity of 5 section handle. Thank you so much :) very helpful videos you always content :)
hi. thanks for very helpful guide, but how to exclude the weekends? i already marked sundays as weekend
Thank you for the very informative gantt chart but Please will you include a progress percent for this gantt chart.
Please master, can one make the Plan Gantt chart run concurrently? eg. Two activities run at the same time. Thank you
Nice...Please make a video on Daily, weekly and monthly plaaner in xls.
Why are you not active nowadays..?
You're doing great brother..!
very thanks bro. it was very helpfull
very good video, thanks for helping me to make my timeline, but just a doubt how does it work with two different months on the same timeline? as soon as i change the date it seems not to work. thanks
Thanks a lot
Your methods are amazing and simple to implement, is there a way you create Critical path method(CPM) from project management point of view
Hi. That is what I'm looking for but to be 100% happy I looking to add for your planer some like:
I'm handyman,
Example I'm add kitchen project when I know that will be around 3 weeks. I want type kitchen on my task and excel should automatically mark this 3 weeks on my calendar. That will give me batter look of my free time to arrange next project. Are this criteria will be possible to put in your sheet.
Thank you.
Thank you very much.. can you help to show if we want to get percentage(%) for the planned vs actual? Thank you in advance..
duration 2 days on the chart showing 3 days?
What happen? Duration and the chart were not the same?
Thank you form Pakistan
This will only work if you have an actual finish date, how can you keep a running bar on the actual till its complete, for activities that have a longer duration. Like your tutorials, so informative and easy to follow.
Very nice sir
So helpful
Hello. Thanks for the video. Do you have something similar but with tasks which are taking few hours, not days? I want to prepare something for my job, taking in consideration that i am working 8h/day and consider this 8h one day. Did you got my point? I want to track all my tasks and by the end of the month to see if I am doing my job better than the estimation. Let's say I estimate one task for 5h and i will finish in 4h, then I have cost saving for 1h. Thank you for your response!
Thanks a lot for this video. SUPER USEFUL. One follow up Question though. Is it possible to highlight the amount a task slips in a different color(say RED) to flag the amount of delay in days ?, especially in the ACTUAL row. Sounds like this might need a slightly more complicated conditional formatting.
I want to be able to use hours and minutes with dates. I'm using it to track manufacturing processes.
Hope you find solutions
Super sir clear we want More updates
Do you have website? I wish you have online course for this.
Thank you
Can links be included to create critical paths?
Thank you, please help me if there are multiple users in Project and their activities are not dependable, in such scenario can Grantt Chart helpful? What will be the other solution?
Thank you for sharing. can you show sample of FTTH fiber deployment template ?
Thanks for the sample time plan in excel.
Can we add the progress percentage to the Gantt chart along with the responsible person
Excellent make more videos
Thanks for this. But how best can you help me as a beginner? I have a project assignment for a duration of 15months. It's a construction project
This is great.. How do we add the milestones?
What would be the quickest way to do this by hours instead of days?
useful vedio thanks
excellent kindly share the template download link that you make ???
Question: Is there a way to remove the weekend dates in Row 5 so only workdays are listed? Great videos, very helpful!
I was also thinking about this question... It would be a salvation for me and the team of our department.
@The Excel Challenge Thanks for your great advise. I have an excel challenge for the Gantt Chart. I wanna add the manpower in each cell with the conditional formatting and manpower graphic below the Gantt Chart. Please help me find a solution. :)
This excellent presentation, the demonstration is easy to understand!!! I learned a lot.
What I want to know if we can combined the value of the actual completion in PERCENTAGES with same in the time line.
Thankyou for your tutorial.. it means a lot..
but can u help me, for controlling inventory, when to reorder, how long that inventory enough to use until it runs out..
Excellent! How can we adjust the formula to make more than 1 “start/end” date in the same row. Please help!
Good video
Hello..Please how do I assig resources using this Gantt Chart you created?
do u have construction schedule
super thank you - i added this too to the Gantt chart - thank you.
I was able to take out the weekend dates in the calender - but i dont know how i should do so that taskduration takes in conderation weekend dates - now if i have 3 days and 1 of them would fall on a saturday or sunday it doesnt show the 3th day - would be great to get some help on this too - in any case i am very thankfull for this video!
thanks for the video - just to clarify why did the formula calculate 6 days colored boxes when you enter 5 days - when you put 6 days - it colored 7 boxes
Can you show how to toggle with prev and next button if there is several months and years??
just going through your tutorials, which are great by the way; on this one (TECH-018 - Compare Estimated Time vs Actual Time in a Time Line (Gantt Chart) in Excel) how would you proceed to populate the chart, if you had one or more tasks that could be performed at the same time as others, meaning that they are not dependent one from each other? thank you in advance.
Very good
Hey Thanks for this video this is very Useful.
But I should have need a bit more detailing in it, like I have to track the schedule and find out how many days I delay in my work, then how will they do it?
Please can you Help me?
Wow it is great but can you please post example this table weekly plan vs actual
Can you explain please why do we see 2 blocks in the time line for a duration of one day?
very usefull