TECH-005 - Create a quick and simple Time Line (Gantt Chart) in Excel

  Рет қаралды 3,286,494

The Excel Challenge

The Excel Challenge

Күн бұрын

Пікірлер: 1 500
@henriekiio9943
@henriekiio9943 3 жыл бұрын
the wonders of internet...5 years later this video has saved me from a very sticky situation. Thanks man God BLESS YOU!!
@impatientyellow7259
@impatientyellow7259 Күн бұрын
This is one of the best simple and straight to the point tutorial i have seen
@shahrahman7160
@shahrahman7160 2 жыл бұрын
Man you've explained it smoothly with literal ease. This is by far one of the easiest video to follow and understand thoroughly. Great job!
@braintubeguy
@braintubeguy Жыл бұрын
I must admit I was super excited watching you video as I have been looking for something like this for some time now, Then when I saw the work that went behind creating knowing how bad I am with excel- I thought I just wish he can just share that template. And then, there it is the first thing in your description... Thank you very very much for this, You made this lady very happy...
@sbastian1978
@sbastian1978 3 жыл бұрын
Man, 10 years I worked on the construction time schedule, recently I saw Excel doing automatic things, I think it can only be in MS Project, rock you man..
@MsProjectAlaSyafriandi
@MsProjectAlaSyafriandi 3 жыл бұрын
Benar baget pak
@Bigboibremmer
@Bigboibremmer 2 жыл бұрын
I must say one of the best teaching videos on KZbin, i thank you so much.
@gangberry1317
@gangberry1317 3 жыл бұрын
Thank you so much. You’ve saved so many poor students and newbies with this tutorial.
@johnnyelias7282
@johnnyelias7282 Жыл бұрын
Dude, First of all, I would like to thank you for your hard work, but most importantly, I would like to thank you for making all your spreadsheets available for free. My life has been made so much easier and more efficient by this.
@premps75
@premps75 Жыл бұрын
Best video on gantt chart so far
@rajatjaiswal8808
@rajatjaiswal8808 4 жыл бұрын
Very helpful Tutorial. Explained the concept in a very easy to understand manner. I am an Architect and was looking for a tutorial to help me schedule my projects in execution and this tutorial has exactly what I was looking for. Thanks for this. Keep up the good work...
@aaarif2
@aaarif2 3 жыл бұрын
Ditto but I am Mechanical Engineer
@lockin3698
@lockin3698 3 жыл бұрын
It is the same for me. I am a project manager responsible for curriculum for an online educational provider and this tutorial was perfect - thank you
@heshamhaboob3285
@heshamhaboob3285 2 ай бұрын
Thank you very much, excellent explanation, sir. However, I have a question: If I have two days off during the activity period, is there an equation to add those two days to the activity period?
@kristinewells961
@kristinewells961 3 жыл бұрын
Oh my goodness you’re a life saver!!!
@yuhanceporter3543
@yuhanceporter3543 3 жыл бұрын
I needed to get a project done in 1 hour😆 Your comment said it all😆😆
@freddiemalakorjoe4311
@freddiemalakorjoe4311 2 жыл бұрын
Most effective video. I learn something new today. Thank you
@Alfedaih
@Alfedaih 3 ай бұрын
Man this is the simples/easies way, great job in explaining each step but in same time the video is not long. like follow done
@Alfedaih
@Alfedaih 3 ай бұрын
I have a challenge for you 😅 How can I make a gantt chart on google sheets but instead of days for month for example a project for about 24 months or 48 month ? I was able to build up the code but it was long line. Plus how can I make real updated data, meaning the more we get to the end of the project the more we get closer to the end of the project the line will increase. It will be kinda percentages with time.
@yaashinikanesan4981
@yaashinikanesan4981 2 жыл бұрын
it took me a while but its worth watching your video. Finally I got to know how to do this like a pro!!! thank you
@csutka8
@csutka8 4 жыл бұрын
You have no idea how much this helped me! This is exactly what I needed to create a super effective timeline for my project. Thank you very much! Needless to say, I am a new subscriber.
@MariePeggalineTaylor
@MariePeggalineTaylor 2 ай бұрын
I must give thanks to you on creating all these templates. You really are remarkable and really save me so much time to do this. God Bless you friend!
@laurahulland
@laurahulland 5 жыл бұрын
This video has changed my life!!! Thank you so much! ❤️🥰❤️
@EventBaksa-b2c
@EventBaksa-b2c Жыл бұрын
Thank you for this video sir, it was a wonderful thing to learn with your seamless explanations. Love from India.
@andrewzeegers
@andrewzeegers 7 жыл бұрын
you are a true Excel wizard. it's the real thing.
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
Thank you Andrew and thanks for watching.
@abdulkarimalhalwani8026
@abdulkarimalhalwani8026 3 жыл бұрын
Nothing to say but PERFECT
@sophiaillingworth1664
@sophiaillingworth1664 7 жыл бұрын
The easiest and best explanation I've seen on how to set up a Gantt Chart. Thank you TECH.
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
Hello Sophia. Thank you very much for your kind note. It is really nice to hear this type of comments from viewers and subscribers. I invite you to check out some of the other videos I've posted in my channel. Thanks for watching.
@IAMBELEVEN
@IAMBELEVEN 3 жыл бұрын
I got mixed up looking for Gantt charts tutorial, this video of yours really got me what i need...thank u a lot for making life so easy.
@kfossi1986
@kfossi1986 4 жыл бұрын
Great video. The most helpful one I've seen. However, how do I block out weekends and holidays?
@marinfragic8335
@marinfragic8335 3 жыл бұрын
You make list of holidays in separate sheet and use workday function which will automaticly exclude those days. Also if you have project going on in countries that have other weekend days (friday & saturday) keep that on mind.
@nessi1559
@nessi1559 2 жыл бұрын
great presentation, practiced & now I'm a genius
@acavarchitect3069
@acavarchitect3069 5 жыл бұрын
concerns regarding saturdays and sundays? what if there is now work on these days? how do you adjust? thanks
@Daeon108
@Daeon108 5 жыл бұрын
You need to use the workday function. Instead of +1 (at 8:26) you use =workday(G5,1). This will automatically calculate out the weekends. You also have the added benefit of figuring in holidays that need to be excluded. IF there is work on some of those days you may need add a cutout with an OR function or XOR.
@kurtdeleeuw7189
@kurtdeleeuw7189 4 жыл бұрын
@@Daeon108 Hi Daeion - this works - but then in the startdate / enddate how can i make the calculation - now it takes out the weekends, so i did a test with 7 working days, and since there are no weekends anymore it only shows 5 workingdays - you have maybe a solution for this too? Super gratefull for your help!
@paulkishwaliaula1533
@paulkishwaliaula1533 2 жыл бұрын
Man you"ve really saved me today. I had no option but to hit subscribe. Awesome, thank you.
@MatiShirizly
@MatiShirizly 3 жыл бұрын
Like it a lot, Can you make the timeline based on the weeks of the year?
@JustFun257
@JustFun257 9 ай бұрын
Thank you so much for making things simple in a straight forward ways .
@stevenrabson937
@stevenrabson937 3 жыл бұрын
Great work. There are now a few good Gantt Chart templates available on exel for those of us less skilled at formating.
@bigunt6861
@bigunt6861 2 жыл бұрын
Cheers to the Legend who made this Video
@peterpetropoulos3679
@peterpetropoulos3679 3 жыл бұрын
How do I delete Saturday, Sundays, and Holidays from the construction schedule? I am just trying to create work days from Monday through Friday.
@saramarzouq1887
@saramarzouq1887 2 жыл бұрын
١٣؛
@junirox1
@junirox1 2 жыл бұрын
Use =workday() formula
@MrLittleman32
@MrLittleman32 Жыл бұрын
Peter did you figure this out? I’m trying now myself
@altafshake8274
@altafshake8274 2 ай бұрын
​@MrLittleman32 - where do you add the formula to exclude Saturday, sundays, and holidays
@dananthonycorda4563
@dananthonycorda4563 4 жыл бұрын
I LOVE YOU SIR COZ OF YOUR WORK IM GOING TO GRADUATE ON COLLEGE THANKYOU SO MUCH SIR (MARAMING SALAMAT SIR)-PHILIPPINES
@koushiksen9353
@koushiksen9353 5 жыл бұрын
Really wonderful video. I found that the end date should require adjustment. I guess the end date should be start date + Task Duration - 1.
@harshadkondalkar1502
@harshadkondalkar1502 4 жыл бұрын
SIR, If I learn most of the project management tool on excel along with good experience (3 years) in engineering drafting for which profile & position I can give try?
@TheExcelChallenge
@TheExcelChallenge 4 жыл бұрын
Project Manager
@ashenafiregassa1427
@ashenafiregassa1427 4 жыл бұрын
start date + Task Duration - 1 that mean it includes start date
@justinbancayrin3549
@justinbancayrin3549 4 жыл бұрын
@@harshadkondalkar1502 Thanks for your comment, I find this helpful.
@harshadkondalkar1502
@harshadkondalkar1502 4 жыл бұрын
@@justinbancayrin3549 as always
@sameeralomari2703
@sameeralomari2703 Жыл бұрын
best video i have ever seen
@tanisha_24gg19
@tanisha_24gg19 4 жыл бұрын
Thank you so much for this! It has helped me complete my dissertation for final year of University
@CEPI_Cameroon
@CEPI_Cameroon 2 жыл бұрын
I wish you were my primary school teacher. You're excellent and I the video is beyond useful for anyone who needs a refresher or simply wants to learn.
@TheExcelChallenge
@TheExcelChallenge 2 жыл бұрын
Hello Henri. Thanks for the kind and rewarding words. I do put a lot of effort in creating this content and it is nice to hear it is actually helping you guys :)
@MrR1gth
@MrR1gth 6 жыл бұрын
Very helpful tutorial! Question: how can I integrate into the formula to leave blank the timeline when the date falls in a saturday and sunday?
@bakedutah8411
@bakedutah8411 5 жыл бұрын
You could do that by modifying two of his formula, using Excel functions WEEKDAY() and WORKDAY(). It's not hard to do, and takes two steps. STEP ONE ======== First, you'd add something to the formula used in the timeline cells (the one he starts building it at 5:10) to prevent the green blocks appearing on the weekend. So his formula looks like this: =IF(AND(F$5>=$D6,F$5
@Marskocoro
@Marskocoro 5 жыл бұрын
@@bakedutah8411 It worked for saturdays but not for sundays. I still have the green squares on SUNDAY. :( How can I take it away?
@bakedutah8411
@bakedutah8411 5 жыл бұрын
Marskocoro, oops, I had a typo. My check for not-Sunday (the big formula in STEP ONE) had 71 instead of just 1. It’s now fixed.
@pinkzeppelin5343
@pinkzeppelin5343 4 жыл бұрын
@@bakedutah8411 Great work !! Immense help... But it will be the best formula if you can help me include holidays too..what syntax, formula to add as logical test if i have a table array/ list of national holidays that i dont want the timeline tracker to add ?? Please help..am stuck and it is a work-related issue... Looking forward to your tip :)
@bakedutah8411
@bakedutah8411 4 жыл бұрын
Ateesh Hazra, the WORKDAY() function has an optional third argument - a list of days to ignore, oftend used for holidays. So just add the range where your national holidays are, and that will take them into account. More here: support.office.com/en-us/article/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33
@samtaufao
@samtaufao 3 жыл бұрын
God bless you for sharing your knowledge and skills.
@vikramkapade7006
@vikramkapade7006 4 жыл бұрын
Amazing, thank you so much, this really helped me a lot
@azersamaali2016
@azersamaali2016 3 жыл бұрын
Excellent video content! Apologies for butting in, I would love your opinion. Have you tried - Weydaniel Organized Dominator (google it)? It is a smashing one off product for getting 7000 plus project management and business templates without the hard work. Ive heard some unbelievable things about it and my mate after many years got amazing success with it.
@piyak.4774
@piyak.4774 4 жыл бұрын
Once I seen this video in a minute then subscribed immediately. Very good job and useful video.
@gcredaroli
@gcredaroli 4 жыл бұрын
This was SO helpful! Thank you so much for taking the time to make this video. Your tips, formulas, layout, etc. were all really easy to follow. I really appreciate it!
@27forreal43
@27forreal43 Ай бұрын
W video bro u just help me to do my assignment 😂❤ u the goat 2024
@efriamagarza7148
@efriamagarza7148 6 жыл бұрын
Thanks so much! How do you set the work week for MON-FRI?
@Daeon108
@Daeon108 5 жыл бұрын
You need to use the workday function. Instead of +1 (at 8:26) you use =workday(G5,1). This will automatically calculate out the weekends. You also have the added benefit of figuring in holidays that need to be excluded.
@kurtdeleeuw7189
@kurtdeleeuw7189 4 жыл бұрын
@@Daeon108 Hi Daeion, this works perfectly! but now its doesnt count all the days - ex if there are 17 workingdays only 5 blocks are shown and it doesnt continue after the weekend - do you have a solution for this please?
@keanalauren
@keanalauren Жыл бұрын
You are so kind sharing your excel files
@servinabuurs8683
@servinabuurs8683 5 жыл бұрын
A real good and inspiring tutorial; this is very useful. I struggled with similar challenges. Calculating with durations and dates is a bit tricky. Could it be that for calculating the end date you have to add the duration minus one (i.e. =D6+C6-1)? A one-day job has then the same start and end date. Apart from that really great and very useful! Thank you very much.
@MilindBorkar_MENTOR
@MilindBorkar_MENTOR 3 жыл бұрын
Agree. Have to add one
@vishnusoman5904
@vishnusoman5904 2 жыл бұрын
Yes, I too realized that the days considerations are incremented by one.
@ahmadthelearner8583
@ahmadthelearner8583 2 жыл бұрын
I just love you man. I learnt excel(Conditional formating, conditional formula) and Gantt chart together. Kudos to you. Keep uploading these amazing stuffs
@spiralout_
@spiralout_ 3 жыл бұрын
There are mistakes.. for example task id 1 demolition has task duration of 4 days.. the difference of July 5 and July 1 is 4 days too.. but if you count the cells its 5 green cells which means the duration is 5 days. And the project duration calculation should be (end date - start date + 1) No doubt the video is very helpful to me. Thanks. 😊
@rizwanshah7720
@rizwanshah7720 2 жыл бұрын
Thanks for highlighting. at 2:24 the formula must be "start date + task duration - 1" then the highlighted cells would be equal to duration.
@geni911
@geni911 2 ай бұрын
@@rizwanshah7720 I agree with you for example the demolition started on May 01 and it has a duration of 4 days and it must be ended on May 04 because May 01 is the first day of work.
@subramaniamarumugam2433
@subramaniamarumugam2433 Жыл бұрын
True Champion 🎉
@mmmrc
@mmmrc 7 жыл бұрын
Really well explained! Thanks TECH
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
Thanks for you comment Marce and thanks for watching. Stay tuned for more videos in our channel.
@amooboardgamechi
@amooboardgamechi 2 ай бұрын
I can not thank you enough dear friend. you helped me a lot and I wish you the best.
@ameliepallier6767
@ameliepallier6767 6 жыл бұрын
I've been trying to find a good tutorial for ages and I stumbled on this and it was just what I needed! Thank you! :)
@sadaqatisl
@sadaqatisl 5 жыл бұрын
Same here i was also searching searching gantt charts and always lost.
@thomasferreira7818
@thomasferreira7818 4 жыл бұрын
Take a look this one : kzbin.info/www/bejne/q5-bm2mHptWMl5I
@janjohansenmusic
@janjohansenmusic 4 жыл бұрын
I had an idea to make a timeline for classical music 5 minutes ago. Now I’m here.
@YostManufacturing
@YostManufacturing Жыл бұрын
Great instructional video, well done. I do have one question; how do you eliminate weekends within the schedule? As it stands now your example works as if you are working every day, seven days a week.
@justinsiebuhr9577
@justinsiebuhr9577 3 жыл бұрын
When locking a cell, you can also use F4 to cycle through the vertical, horizontal and both locks.
@sbernardo9846
@sbernardo9846 2 жыл бұрын
How? It's not working for me
@seanrobertsuat2673
@seanrobertsuat2673 Жыл бұрын
Thank you so much, sir!!! My exam is related to this and it was a big help for me.
@theresag.4272
@theresag.4272 4 жыл бұрын
Exactly what I needed, thank you so much!!!
@walaazain229
@walaazain229 11 ай бұрын
Thaaank you , I really do appreciate , you just make it simple like piece of cake
@jarvisdali9690
@jarvisdali9690 6 жыл бұрын
Hi TECH. Thank you for the great simple guide, But I notice that e.g. the 4 days duration project ended up being 5 days. As a fix, Cell E6 formula should be ' =D6+(C6-1) before the fill down. :)
@prabhadeenaraju659
@prabhadeenaraju659 2 жыл бұрын
And the project duration also increases by 1 right
@marinievesfernandez3267
@marinievesfernandez3267 4 жыл бұрын
Very clever way to create a Gantt chart!!
@vaibhavkhode684
@vaibhavkhode684 7 жыл бұрын
Thanks, it was helpful. Could you please advise how to deal with weekend when no task activity will happen.
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
Hello Vaibhav, I'm glad you found this video helpful. In regards of weekends, use the recommendation I put in the example but customize per your needs. For example, in the top of the table where I put the whole 31 days of the month, simply enter weekdays and skip weekends. Give it a try and that should help. Let me know if you need more help.
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
For example, if you want to use July of 2017, your top header would show July 3, 4, 5, 6, 7, 10, 11, 12, 13, 14, 17, 18, 19, 20, 21, 24, 25, 26, 27, 28 and 31.
@vaibhavkhode684
@vaibhavkhode684 7 жыл бұрын
Thanks for explanation. Agree that skipping weekend in the header would solve this issue. But is there any trick where weekends are included in the header and still the tasks are shown excluding weekends?
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
I think you can customize your Gantt chart, combining the formula IF that showed in the example with the formula WEEKDAY. The formula WEEKDAY can identify Saturdays and Sundays, just combine that with IF and that should do the job. Trust that helps.
@brownguy8223
@brownguy8223 7 жыл бұрын
incase the below didnt help, starting each function off as =workday will select only dates with weekdays
@mphomokoaqa2855
@mphomokoaqa2855 3 жыл бұрын
Thank you so much. I have been struggling with my Project until i come across this Video
@mrbahadirrodoplu
@mrbahadirrodoplu 6 жыл бұрын
end date will be D6+C6-1 ex: may 1-2-3-4 duration will be 4 day
@m1ha1mateescu
@m1ha1mateescu 5 жыл бұрын
How the formulae change if I have half a day for a specific task ? Do I have to use per hour calculations ?
@samsegueni9123
@samsegueni9123 2 жыл бұрын
A very impressive tutorial! Many thanks for the demonstration...
@nancyrosales6674
@nancyrosales6674 5 жыл бұрын
thanks a million! I'd been looking for an understandable tutorial of how to do a Gantt Chart and you just made such a great video that anyone can understand how to creat a chart, eventhough they don't have a clue of how to use excel like in my case haha...
@imrantambat6757
@imrantambat6757 2 жыл бұрын
very clear and simple teaching. thank you very much
@shahrulakoi9051
@shahrulakoi9051 5 жыл бұрын
Hi, how to skip certain date? Can u teach me how to use the formula.. ty
@iamse7en222
@iamse7en222 11 ай бұрын
2024 and still you are a life saver! thanks for the free templates as well. New subscriber here :)
@evelynhengeveld-bidmon7473
@evelynhengeveld-bidmon7473 4 жыл бұрын
Oh my gosh! This was a very helpful tutorial! It walked me through creating my own timelilne. Thank you. I just wish I knew more about these types of formulas so that I wouldn't have to be walked through one step by step.
@lanreolokun4464
@lanreolokun4464 Жыл бұрын
Thank you very much! This timeline is exactly what I need for my team!
@TheExcelChallenge
@TheExcelChallenge Жыл бұрын
Glad it was helpful!
@MickPsyphon
@MickPsyphon 5 жыл бұрын
Good solution for a simple Gantt chart. How would you handle something more esoteric, where certain tasks may need to begin BEFORE one (or more) previous task(s)? Also, how would you handle taking weekends out of the timeline, for such cases that require tasks to only be performed on weekdays? Lastly (and this is a bit if a challenge), is it possible to create such a chart in Excel, which allows for some tasks that be performed only on weekdays, while other tasks can also be performed throughout the weekend? Can it also include tasks that can only be performed on the weekends AND span across multiple weekends?
@AhmedDaabis
@AhmedDaabis 5 жыл бұрын
I had the same question too, I developed it to take out the weekends but it doesn't work with me for the schedule
@MickPsyphon
@MickPsyphon 5 жыл бұрын
@@AhmedDaabis It must be possible, but I really haven't had the time to devote to working towards a solution. Been swamped with other tasks. That's why I was hoping someone might post an answer. 🤗
@sarona7721
@sarona7721 Жыл бұрын
You are God's sent. Thank you very much. Was struggling on that for weeks. In 9 mins you saved me. Do you have any gatt chart with start date , finish date, start and actual finish date combine? Would be really helpfull
@TheExcelChallenge
@TheExcelChallenge Жыл бұрын
Hello @sarona7721. Try my video TECH-018 You can also download the files for free at www.theexcelchallenge.com Enjoy!
@danterusso6354
@danterusso6354 6 жыл бұрын
That was well done, sir! You explained that process perfectly. Thank you very much for sharing. 😀
@TLnetpilot
@TLnetpilot 5 жыл бұрын
MASTER OF EXCEL!
@TheExcelChallenge
@TheExcelChallenge 5 жыл бұрын
LOL!! Thanks Tom. T-E-CH
@SagarJotani
@SagarJotani 4 жыл бұрын
In 1st task (demolition), the task duration is 4, but in time line it fills 5 box (from Jun 1 to Jun 5). As one green cell shows 1 day, so as per that, there should be only 4 cells to be filled with green. So is there any changes? Or correction?
@naganathbhadole2657
@naganathbhadole2657 Жыл бұрын
1. Maybe Weekend comes within. 2.After formula )-1 it works
@lotusashok
@lotusashok 4 жыл бұрын
Amazing, very simple way to make Gantt chart. Thanks
@Caersy
@Caersy 5 жыл бұрын
Thank you very much, this is what I was looking for. Saved me. Thumbs up!
@BasitKhan-bl9qy
@BasitKhan-bl9qy 3 жыл бұрын
Excellent teaching style... Very simple
@tengkuizanirajamustafa674
@tengkuizanirajamustafa674 5 жыл бұрын
how to exclude weekends from the timeline?
@Daeon108
@Daeon108 5 жыл бұрын
You need to use the workday function. Instead of +1 (at 8:26) you use =workday(G5,1). This will automatically calculate out the weekends. You also have the added benefit of figuring in holidays that need to be excluded.
@equesadava
@equesadava 3 жыл бұрын
Your TECH-018 is amazing !!! help me setting a project for legal clinics in no time ! Thanks
@salahsaada9561
@salahsaada9561 4 жыл бұрын
Amazing, thank you so much, this really helped me a lot, stay blessed
@vincentle8857
@vincentle8857 Жыл бұрын
Super helpful. You just saved me a ton of time. Thank you sir.
@SchmakDog
@SchmakDog 5 жыл бұрын
I love this tutorial! Can you think of an easy way to modify this so that some of the tasks could run concurrently?
@abdourobust2890
@abdourobust2890 4 жыл бұрын
Many thanks, I've been looking for "project management resource plan template" for a while now, and I think this has helped. Have you heard people talk about - Seyily Substratal Smasher - (do a search on google ) ? It is an awesome one off product for discovering how to get amazing project management and business templates without the headache. Ive heard some great things about it and my colleague got excellent results with it.
@simongondo6025
@simongondo6025 2 жыл бұрын
I find the video quite useful. Just what i needed to solve an issue at work. Deeply appreciate it.
@paulknight6237
@paulknight6237 5 жыл бұрын
Thankyou so far, but I would like to consider the 2 day weekend where no work can be carried out
@Daeon108
@Daeon108 5 жыл бұрын
You need to use the workday function. Instead of +1 (at 8:26) you use =workday(G5,1). This will automatically calculate out the weekends. You also have the added benefit of figuring in holidays that need to be excluded.
@minsupark9246
@minsupark9246 3 жыл бұрын
Bro this vid really helps me realize how I should manage my time~! Thx for this wonderful inspirational video~!
@Bishoff03
@Bishoff03 7 жыл бұрын
Hello sir, love your chart, my issue is my chart is over a 8 month period and when I use the Min function it picks the lowest month value not the earliest date, ideas please.
@Bishoff03
@Bishoff03 7 жыл бұрын
No worries my mistake, it worked thanks!
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
Hello Shawn. It is good to hear you loved the chart. I see you've resolved the issue. If you ever want me to check out your spreadsheet, I'll be glad to do that if you email me at theexcelchallenge@gmail.com Thanks for watching.
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
Shawn, I'm glad you resolved the issue. If it's worth for the community to know how you resolve it, I invite you to please share the solution, so others can get that knowledge too. Just a thought... T-E-CH
@marcustwala3829
@marcustwala3829 7 жыл бұрын
Hello Shawn; I'm struggling with the same initial problem you had, I see you've managed to win, please assist me champ.
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
Hello Marcus. Try this: Refer back to the video at the 8:28 mark where I show a formula F5+1. In my example, +1 means next day. For your project, do everything the same but instead of F5+1 type F5+7. In this case, +7 means next week. Then simply fill the formula to the right the same way I do in the 8:35 mark. And finally, enter your time duration in column C and your dates in column D. This will resolve your issue and you will be able to present your 5-month project in a one-pager or in one-screen. I trust this answers your question. Thanks for watching and I hope you check out our other videos. T-E-CH
@ninojosephbullen4585
@ninojosephbullen4585 4 жыл бұрын
SUPER HELPFUL DUDE! YOUR VIDEO IS THE BEST TUTORIAL :)
@sravankumar5950x
@sravankumar5950x 6 жыл бұрын
Can you provide link in the description to download this file?
@TheExcelChallenge
@TheExcelChallenge 5 жыл бұрын
Hello Sravan, Please send me an email to theexcelchallenge@gmail.com and I will send you the file. I don’t have a portal yet for viewers to download the files but that is something I have in mind for the future. T-E-CH
@kshirodacl5474
@kshirodacl5474 2 жыл бұрын
It's very useful to biginers. Thankyou 🙏
@1flybyguy
@1flybyguy 4 жыл бұрын
Logical error in calculating the project duration. The start and end dates need to be inclusive or you're gonna always be off by 1.
@yassin4173
@yassin4173 4 жыл бұрын
Actually that's cool, finishing 1day before deadline gives you enough time to reconcider and perfect your work or just Rest.
@MrWaqas313
@MrWaqas313 Жыл бұрын
You are best best teacher thanks a lot thanks a lot , love you , appreciate your hard work specially you give all sheets in excell forms on your website , its help me a lot thanks again
@reubencoertzen7103
@reubencoertzen7103 3 жыл бұрын
Every time I try this exact same formula, excel tells me my formula is incorrect?
@bonkyyumena8582
@bonkyyumena8582 3 жыл бұрын
so do I
@forestriver7180
@forestriver7180 2 жыл бұрын
dont use control F4 to lock the F5 ,D6E6, use the dollar sign instead
@sidrahaider246
@sidrahaider246 2 жыл бұрын
Formula to lock is =If(AND(F$5>=$D6,F$5
@anjuy8413
@anjuy8413 7 ай бұрын
Thank you so much for the simple and clear explanation. God bless you
@richardallan3245
@richardallan3245 7 жыл бұрын
Sorry this doesn’t compute. For example the demolition task is 4 days but 5 days are highlighted on the timeline. Project duration is different to the days on task (even taking into account that you start next task on next day)
@TheExcelChallenge
@TheExcelChallenge 7 жыл бұрын
Hello Richard. I'm afraid you're right. I made a mistake in the 2:30 mark, where I should have entered a -1 in the formula. Using the same example you are using, if I am counting May 1 as day 1, and the task duration is 4 days, then the end date should be May 4. The formula should read =D6+C6-1 instead of =D6+C6 That's an easy fix. Sorry about the mistake. I hope you still were able to learn something new from the video. Thanks for your comment. T-E-CH
@Harlin67
@Harlin67 6 жыл бұрын
Haha, sat there for five minutes thinking wth, and of course, started to think is this weekends?, is it me?....thanks for posting ;)
@victor9999hugo
@victor9999hugo 6 жыл бұрын
Once I used the new formula (D6+C6-1). The formula at 5:17 doesnt work. Help
@stefanjeffriesm.lauron1988
@stefanjeffriesm.lauron1988 6 жыл бұрын
Also, your Project duration formula would change from =E2-D2 to =E2-D2+1...
@Mbelova100
@Mbelova100 Жыл бұрын
That is amazing! Have never thought it might be so simple!
@omgl0lx
@omgl0lx 3 жыл бұрын
OMG, EXACTLY WHAT I NEEDED -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- i got resources from 💜 FROE.BAR/RGGUYT 💜
@neena_gems5223
@neena_gems5223 4 жыл бұрын
This was an excellent step by step demo. I have a lot of users who do not have Project so they can't access Gannt charts, this was my alternative. Thanks!
@perryquick9775
@perryquick9775 3 жыл бұрын
Every step worked perfectly. Thank You!
@eikky2
@eikky2 8 ай бұрын
This was very helpfull and very short. I have a question, is the possibility that all the column can updated one row depending on how far is the date?
@aaarif2
@aaarif2 3 жыл бұрын
Excellent and most simplest explanation
@Dodo.en112
@Dodo.en112 2 жыл бұрын
you're awesome man. just a question what if you don't want to include sundays? thanks
Make This Awesome Gantt Chart in Excel (for Project Management)
17:13
Kenji Explains
Рет қаралды 464 М.
How to Make a Gantt Chart in Excel
12:54
Vertex42
Рет қаралды 3,8 МЛН
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
How to Make the BEST Gantt Chart in Excel (looks like Microsoft Project!)
15:59
📊 How to Build Excel Interactive Dashboards
19:21
Kevin Stratvert
Рет қаралды 2,6 МЛН
Make a Gantt Chart in Excel - Part 2: Working with Work Days
9:01
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 8 МЛН
TECH-001 - Compare data in charts selecting values from dropdown menus
8:36
The Excel Challenge
Рет қаралды 13 М.
Project Plan(Gantt Chart) in excel
17:18
PK: An Excel Expert
Рет қаралды 991 М.