Gantt Chart Excel Tutorial - How to make a Basic Gantt Chart in Microsoft Excel
Vložit
- čas přidán 2. 08. 2024
- www.excelfornoobs.com
In this Microsoft Excel tutorial I show you how to make a basic Gantt Chart. This is a basic Gantt Chart that shows the time frame of a project and the time frame of the individual task that are to be performed. This Gantt Chart is basic so it doesn't show the progress of the project. If you would like to see an Excel tutorial on how to create a Gantt Chart that shows the progress of a project you can find it by searching through my videos.
g.page/RoofingTampa?gm
• Gantt Chart Excel Tuto...
/ subjectmoney
roofstampa.com
subjectmoney.com
excelfornoobs.com
If this video has helped you in any way, all I ask in return is to like the video and subscribe to my channel. Your support means a lot!
The video appears pixelated for me. Bummer, I was looking forward to watching this video.
Video is really good just what I needed ,gave you a like!
You skipped how you put in all the data, it's my first time and you completely lost me
@@Garden_fairy143you enter the data part your self.
Thanks for nothing
Probably one of the best tutorials i've ever seen on anything. Great job.
Thanks so much for this! Most Excel tutorials say they are tutorials but zip right through the instructions as if they're meant for intermediate users. You take your time, and the pacing is perfect. I followed through and created a Gantt Chart, no problems. Much appreciated!
you saved my life, every gantt chart software out there is a freakshow of sophistication, not the kind of thing a noob could comprehend. Heck, I've been scared of ms excel all my life, i couldn't for the life of me figure it out. but you not only helped me make my first excel document ever (much of my fear is gone now!), you also helped me get done the gantt chart in time. my degree depends on the documentation i'm working on right now, could never have done this without you, i cannot thank you enough for taking out the time and effort to make such a detailed, short (everything in just 8 minutes!) and to the point tutorial. thank you, thank you.
Appreciate Video! Excuse me for the intrusion, I would love your thoughts. Have you thought about - Weydaniel Organized Dominator (probably on Google)? It is a great one of a kind guide for getting 7000 plus project management and business templates minus the normal expense. Ive heard some super things about it and my friend finally got cool success with it.
This was great, thanks, I have been researching "free printable construction contracts" for a while now, and I think this has helped. Have you heard people talk about - Peyiley Fantastic Paramountcy - (Have a quick look on google cant remember the place now ) ? It is a good exclusive guide for discovering how to download construction document templates without the hard work. Ive heard some great things about it and my brother in law got excellent results with it.
This is just superb, I've been looking for "what is resource management in project management?" for a while now, and I think this has helped. Have you heard people talk about - Biycarlett Astounded Builder - (search on google ) ? It is a good one off guide for discovering how to download thousands of business and project management templates minus the headache. Ive heard some amazing things about it and my buddy got excellent success with it.
lol all these bots smh
This video is fantastic. One of the best excel tutorials I've seen. You made this simple, easy to understand, and you walked through every step not assuming that viewers would automatically know what you were doing.
Your tutorial is just something amazing, very useful. You're a wonderful teacher indeed. Keep up the good work
Thanks a lot, I actually used it once last year in preparation for developing a marketing plan for a company (assignment) and now I’m doing so again for my community service project (solo).
Real appreciative of your simple explanation.
thank you so much for this! this saved me from spending a huuuuuuge amount of time doing Gantt charts on Excel. ❤️
Straight to the point, easily demonstrated and with clear explanations. Thank you for saving me a bunch of time on my thesis (~:
I've watched countless tutorial and explanation videos now on the subject of Gantt charts, and this is by far the best one I've come across. Very clear and easy to follow. I think I've got a grasp on it now. Thank you very much!
Glad it was helpful!
Amazing! After an hour of googling and trying to work it out, I finally looked to CZcams and your vid was fantastic!! Following along, I'm literally done in under 10min.
8 years later and still helpful, thanks man saved me so much effort in trying it myself and also trouble that I would have gotten if i did not make one
exactlyy I mean I could've lost 200 marks
haha 1 year after your comment i'm finding myself here, graduated college 3 years ago couldn't remember a thing about making gantt charts lol
even in 10 years
If my free tutorials have helped you in any way please repay by liking, commenting, sharing and saving the videos to your favorites. Your interaction improves the search ranking of my tutorials which motivates me to keep making more. Thanks for the support!
I've been struggling with changing the date range - thanks for showing the 'numbers' tip!
Just cannot thank you enough for this great tutorial sir. Its very clear, concise and easy to understand. Thank you so very much.
Unlike much information posted online this was the most useful and it is (like MS project management) a complex process for many ways of doing this program. Thanks for your short but effective video.
you've allowed my to pass my class, which has allowed me to graduate. thank you so much!!!!!
Thanks for the video content! Forgive me for chiming in, I am interested in your initial thoughts. Have you considered - Weydaniel Organized Dominator (search on google)? It is a smashing one off guide for getting 7000 plus project management and business templates without the hard work. Ive heard some amazing things about it and my cousin at last got great results with it.
Kudos for the Video clip! Sorry for the intrusion, I would appreciate your thoughts. Have you tried - Weydaniel Organized Dominator (should be on google have a look)? It is an awesome one off guide for getting 7000 plus project management and business templates without the hard work. Ive heard some amazing things about it and my close friend Aubrey after many years got great success with it.
Excellent video content! Forgive me for the intrusion, I am interested in your initial thoughts. Have you heard about - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a good exclusive guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some decent things about it and my friend Sam after a lifetime of fighting got amazing results with it.
Kudos for the video content! Sorry for the intrusion, I would appreciate your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (do a google search)? It is a good exclusive product for getting 7000 plus project management and business templates without the headache. Ive heard some unbelievable things about it and my mate at last got amazing results with it.
Subjectmoney
Excellent video content! Sorry for chiming in, I would love your opinion. Have you heard about - Weydaniel Organized Dominator (should be on google have a look)? It is a great exclusive product for getting 7000 plus project management and business templates minus the headache. Ive heard some decent things about it and my work colleague after many years got great success with it.
This video helped me for my final year project report. THANK YOU!
After a few years away from technical work I was rusty on Gant Charts, your tutorial was very easy to follow and worked for me!! You are now in my favorites. (I also like that your tools did not assume I bought some program or ask me to buy something.
Even though this video was made in 2013, it still continues to help students worldwide with Microsoft Excel on creating a Gantt Chart.
😄 THANK YOU SO MUCH!!!!!
I bet I will meet my fellow classmate here that trying to finish a research proposal that is due tomorrow
Due tommorow 😂
😂😂🎯
Lolll😂 mine too is Due Tomorrow broe 🙆🏾♂️
Due hours from now
Mine is due today and i just can't seem to get it right 😩
I have passed my Project Management course because of you!
you mean they don't even try to teach this in PROJECT MANAGEMENT? who's teaching teachers?
very well simplified. I never knew I could understand it this easily until I watched this clip and even created my own complex one.
When my group gave me a role to do a Gantt chart I nearly quit college,.. but when i watched this and did mine I was thrilled as to how my Chart came out... Thank you so much, stress reliever....!!!!
I may be 6 years late but this has literally saved my ass for EPQ I’ve spent hours trying to work out how to do it
Sick video fam. You saved my life. Big up Said doh
Thank you it was my insight into Gantt charts...will be looking for you advance one to track progress. Very clear and to the point. Less than 10 minutes is the perfect length of time.
Great quick training. I worked along with the instructions and have my Gannt chart ready. Thank you for creating and sharing!
Thank you for this excellent video. I have one question. How can i reverse the order also in the table (which was added at the end of the video) under the gantt chart ?
Thank you very much, very helpful, rewatching the video for every project :D
One question, can someone tell me how to make this table with information below Gantt Chart to show time in reverse?
+Gabrielė Rajauskaitė Did you figure this out?
No :/
Right click the bar below the Gantt Chart and click the Format Chart Area. Under the Axis Option, click "values in reverse order". That's it!
This is awesome. Exactly what I was looking for. Thanks for going every detailed step.
Thank you! This was the clearest explanation on how to make the chart I have found on youtube.
The comments were at 666, so I added mine to "break the chain" 😂😂😂
Good demonstration, Sir.
At the bottom of the gantt chart it says Task 8 to Task 1. How do i flip it around? Thanks! Great help so far
Minute 04:44
hi, sorry. What about when you changed the lay out the table content could be flip it around? Thanks so much, for your time doing the tutorial!
I believe Joyee is asking about the "Bottom Table" as opposed to the "Vertical Axis". Sorry Joyee, I am also trying to work it out and will advise if I succeed. Other than that, this is a great vid, tx.
I know this question was 2 years ago but this is for anyone else who ran into the same issue:
I could not find an actual fix in excel, however I discovered a very roundabout way to reverse the Task order in the bottom table. For my purposes, I needed to print out this gantt chart with the table.
So I...
1.) Unchecked the "Categories in reverse order" box at 4:44.
2.) Took a snap shot of the now correct bottom table using the "Snipping Tool".
3.) Saved it as a jpeg.
4.) Went back and checked the "Categories in reverse order" box.
5.) Moved my Gantt chart to a word document.
6.) Right-clicked the chart --> "Wrap text" --> "Through".
7.) Inserted the jpeg
8.) Right-clicked the jpeg --> "Wrap text" --> "Through".
10.) Then aligned my jpeg over the gantt chart's (incorrect) bottom table.
I hope this helped!
Thanks a lot for this video, exactly what I was looking for. Especially love the tip how to hide blue part of the chart. Brilliant idea!!!!
Thank you very much for this piece. So insightful and time saving. You just saved a soul 💓
I could see that when you've chosen the design, the tasks appear on a different order, how do I put it in the correct order, as you can see you have underneath task 8, task 7, etc.
You ever figure this out? Need help on it now lol
Neither can I...
@@christophervecchio2925 I've used a different design because of it, but how do we change it?
1:21 "You're gonna select insert bar chart, which is like a sideways bar chart"
*hmm yes the floor here is made our of floor*
All jokes aside, great tutorial
Excellent tutorial, thanks for being so clear and thorough!
Thank you so much!!! This was super easy to follow and helpful. Thank you for taking your time in creating this video!!
You also here for a research proposal?
Mmmm think you went abit fast...I lost you afew times n had to keep going back
Thank you so much for this! Very easy to understand and complete! Your a great teacher!
This really helped me! I was having a little panic because I couldn't get the chart to do what I wanted it to. Your voice was very calming and I figured it out right away after your video.
Someone told me that it's the best time to buy Bitcoin, because there will be a huge pump
I saw all this coming I had to switch to Crypto trading and I'm really enjoying the fact I made the right choice because of my weekly earnings
How do you do it please
It's very possible because I make $8300 with my little $1300 weekly
I've been in crypto for about 4 years now and I can tell you that till date I'm still trading under the supervision of my expert Mrs Stacy Griffin kartner
This is not actually the first time I've seen people talk about her but getting her watsapp contact has been my greatest challenge
Every now and then I get a project at uni that requires a GANNT chart and this is the video I always end up coming back to. Very well explained!
Thank you for this very helpful video. After spending hours trying to use other templates on excel and being unsuccessful.. i came across this video. Definitely saved my ass for my communications assignment!
Thank you so much for making this easy to follow and not be overwhelming!
My heartiest thanks to you.....this tutorial was really superb and easy to follow. I was just able to finish my Gantt Chart after a few tried successfully.....Thank you so much.....I'm your new subscriber
FIRST exposure to Gantt. Great job walking me through this!
fast video, straight to the point, great vocal explanation, really good all together. thank you
Thanks a million you helped me turn around a plan so quickly... this basic L1 plan I did was appreciated by my client. Thanks so much!😊
Thank you very much!
Its very helpful and comprehensive.
Very easy to understand.
Keep up the good work!👍🏻
Really appreciated, this helped me a lot. The guide is clear and goes straight to the point
We just did this in the last class, i feel so good coming across this video that will help me practice. Thank you for also explaining how to convert dates to numbers, thank you for the video♥️
Fantastic, very easy to follow. Super informative and easy for someone who is PC inept like myself!
Your walkthrough was straightforward. Thank you! :)
thank you for you'r excel lesson.. ❤️ Now I creat my project gantt chart perfectly. Thank for everything .. 💪 Have a nice day 😊
This is by far THE BEST ! Thank you for posting!
Ditto and +1 to all the other positive comments you've gotten here. Excel is powerful useful versatile software. Most (all?) "gantt chart project management" software isn't good for anything other than making gantt charts. Being able to use EXCEL to build a chart like this is so incredibly useful, even for fields (like Engineering) that may not be the primary focus of your channel. Fantastic video.
Incredibly helpful video. I really enjoyed the explanation about the dates having a serial number!
Thank you so much for this great service. It helps to complete my final year of bachelors 1st Assignment. Good Luck 🍀
First time doing a Gantt chart and your tutorial was very helpful. Thank you!
It's November 25th, 2020 and this Tutorial is still very helpful. Thanks!
this is soo helpful, thank you for explaining the Gantt Chart in a very simple and easy way.
Thank you this was very helpful! I appreciate you taking the time to do this tutorial!
Thank you for the amazing video! You explained every detail I was hoping for!!
Really appreciated, this helped me a lot. The guide is clear and goes straight to the point. +1 like!
Wow! Thank you! Maybe you are the right teacher for me in teaching excel! Very clear, simple and to the point explanation. Thank you very kuch❤❤
very concise and to the point. You are an excellent teacher.
Thanks for this video! I got to know at the last minute that I had to add a gantt chart to my CS documentation and this video really helped me a lot!
Thank you for this tutorial. It just helped my husband with a very urgent presentation, detailed and easy to learn.
Thank you SO MUCH! You made it super easy to understand. Solved my problem today and I thank you so very much for taking the time to create this video! WOO HOO!
Great jobs explaining the small edits - those always take me forever to figure out. Thank you
Thank you so much for the video. it has been of a great help. i was stuck but now i followed the steps and i have completed my chart perfectly. Thank you.
great tutorial! Managed to do each step simultaneously with you! thanks a lot!
this was so helpful and so simple to do.. thank you and God bless!!!
Great tutorial!!! Best I've seen, thank you so much!
Thanks for this....really saved me a lot of time!!!
Keep on with the good work.
Simple straight to the point great presentation! Thanks
Thank you very much for sharing your knowledge. This is exactly what I was looking for.
Wow!! Thanks for uploading this!! Oh and please don't stop making tutorial videos you're too good at this !!
Thank you. God bless you. I just completed one with your help. 🙏
Thanks. Very useful for the setup of timeline in R&D of the process with multiple overlap of physical mechanisms. Cheers!
thank you for sharing this tutorial. it really helped with my PM class.
Lovely tutorial... i did what u did step by step and mine came out just the same. thank you... i even went as far as to take out the example and put it aside and convert it to a number just the same....lol... i never wanted to miss a beat... thanks again
Great tutorial. Appreciate you posting this, it was a lot of help.
Thanks man big help! This serves as a stepping stone for my career being a project manager
OMG YOU JUST CURE MY HEADACHE! YOU SIR ARE A GENIUS !
This is my life saver for my feasibility study! Thank you so much!!
Thanks for a great video and especially the tip about adjusting the start date.
This was a simple yet great video. Thank you.
You are a life saver. God bless you
Thank you very much. You have explained it very well and made it easy. Im so grateful.
Brilliant video explaining each and every step very clearly. I learned a lot from this video.
Thanks a million times, you really helped me. Keep up the good work
MY MAN, IT IS 2020 AND YOUR VIDEO HELPED ME FIGURE THIS OUT!!!
your video helped me go through some project presentations, thank you so much!!!
Thank you very much for the explanaitions. You make a good teacher.
Thank you so much! It's simple but informative! :D