Gantt Chart Excel Demo
Вставка
- Опубліковано 22 лип 2024
- Chris Croft shows you how to make a Gantt Chart using Excel - it's really easy. Starting with your network diagram you build up an impressive Gantt chart, requiring only basic Excel knowledge. Gantt charts are the key to successful project management so you really need to see this!
Check out the full on-line 'Practical Projects' project management course here • Practical Projects - o...
Please do subscribe to my channel (click on the Subscribe button below) to be notified, for free, of any more videos as I upload them.
And check out my website and blog: www.chriscrofttraining.co.uk
Get my free six part video course on how to be happier and more successful: www.lifeskillscollection.com/i...
Not a excel tech oriented. Best gantt chart I've ever seen in here. Really appreciate!
Stephen Lee thanks Stephen!
Quite possibly the most useful video I've seen on You Tube ever.
Once again, an understated masterclass which draws the observer in. You sir, are a standard setter. Respect
thanks Flash - yes there's ore work and knowledge in this the meets the eye - it's taken me years to work out the best way to make Gantt charts, keeping it simple etc. Plus it's necessary to REALLY understand project management, as well as a bit of Excel. Glad you liked it. Spread the word! regards CC
You're the greatest, Chris! Thank you for this.
OMG. I am in love with this process. Thank you So very much for the clear tutorial. I am throwing away MS Project!
thanks Lucy Lu - glad to hear it!!
Love the SPM Chris you are great, make everything about project management easy to understand. Thank you.
Hi Chris, I am extremely appreciative! Thank you so much for taking the time to teach others how to make a Gantt Chart using Excel. I followed your video step-by-step and within an hour I had a complete Gantt Chart to share with my project team. So incredibly useful, thank you for simplifying the process to make a Gantt Chart and making it easy to learn.
This is the best of its kind. thank you so very much! please keep posting of your wonderful experiences.
Thank you, Chris. I love your tutorials.
I am very grateful to you, Chris, for producing such a clear and articulate explanation of how to draft Gantt charts. I learned more from this video than I thought possible and it is going to save me a lot of time with planning projects. Gifting this to everyone, as you have done, shows that you are a kind and thoughtful soul!
My pleasure, thanks Cider Press!
Hello Chris, I have not only learnt how to draw a Gantt chart, this video helped me with my coursework. You really are a great teacher. Thank You.
Hi Chris, thank you very much for explaining the difficult Gantt Chart in simple way. It is not that easy to explain the complex/difficult thing in simpler way so thank you again for informative yet lighter session.
Your teaching style is really great.
You're very welcome!
Chris, an excellent Gantt video, the best so far...very magnanimous and caring to have given this idea. I wanted a simple yet comprehensive way to manage my upcoming assignment for managing a fun-city project.
Cheers Chris excellent video, very helpful! I made mine in parallel just pausing and rewinding once in a while.
Hi Chris, thank you very much for making this so clear for me so that I have much more confidence while applying for my next job related to project management in the following days. I am refreshed by they way you are showing us and no hesitate to follow your channel and thank you again for your great demo.
Wow! Just wow. So easily done and explained!! Immediately subscribed. Thank you !
Another brilliant piece of instruction. I taught adults for 8 years, myself, and it's great to see something so easy to follow with plenty of powerful details included.
thanks MW - it's great to be appreciated like that!
really helpful video - much simpler than the other interactive Gantt chart examples I've come across - will be implementing this immediately!
Thanks Chris: Very useful, well-explained, practical, functional. I really liked the first step - Post-it Note Plan.
Chris, Thank you very much! I was lost developing and managing my company until I saw this video. Keep on with the good work. Best Regards from Colombia!
Brilliant! This is all the project management I need to run my own start up for now.
Great video. This was very helpful. Thank you for posting this.
This was really useful and i enjoyed making this gantt chart.
Many many thanks Chris. You gave me a very good, excellent, superb lesson to me.
thanks for the kind words Louis!
thanks Louis, glad you liked it! CC
Nice, simple and informative video!! Thanks Chris.
You saved me. My MBA has a section on Project Management and until now I never knew how to prepare a Gantt Chart for a project. Easy and simple to follow. Thanks again.
delighted to hear that Julius! Check out Project Management in under 8 minutes as well, will give you a great overview of thew whole of PM
This is great!. I also saw your lynda course. Thank you!
Thanks for taking the time Chris. Nice and simple!
glad you liked it! - thanks for letting me know
this is amazing, you made it look so easy! and yes i gasped :) i will definitely be checking the rest of the courses , thank you.
Rashed Hiyasat - haha thanks!!
much thank you Chris. this was a great preparation for a course of project management that I am going to take after two days. Thank you again.
check out my video "PM in under 8 minutes" - should help with the course
Thank You for sending this link. The sound is excellent and very clear. You do an awesome job in putting the information together for a clear concise lesson. Your a born teacher. Thank You from all of us that have limited access to information outside of college or corporate training. You have a friend in ST John USVI
Excellent. Detailed and dynamic. Thank you Chris
thanks Nico!
Chris, thank you for creating this vid..
Professional, good explanation, really helped for my dissertation proposal!
Fantastic! This was much help and you explain and show things in an easy, pragmatic way. I just made to cover the remaining work on my wetlands project. This method is going to be put to use from now on with my projects and work. Thanks!
Thanks Yvette! Great to hear that I'm indirectly helping with the wetlands! I do find it amazing how everyone makes it so complicated, when it really doesn't need to be. Glad to have helped.
Chris, THANK YOU!!! Much appreciated my friend 😁👍
Take Care 👍
i am in truly love with u ..! u have explained it with so much of ease !!! thank you ..!! it was awesomeeee
thanks for that comment! Makes it all worthwhile....
I'm getting a masters in strategic communication and will be taking a project management class this summer. Watched your Lynda.com course on Project Management Simplified and thought it was just fantastic! And now I'm making my way through your UA-cam Channel. So much good stuff!! This demo video was so great. I feel like I can totally go make my own GANTT chart now. I don't know how I've survived previous projects without it. Thank you for producing such great work!
Thanks for those nice comments! Please pass the message on to others ...! More courses going onto Lynda soon
Thanks Chris. Quite simply the best Excel tutorial I have seen on UA-cam. Gantt charts just happened to be the topic. Cheers!
thanks Mr B!
Excellent tutorial and very sound advice!!
Hi Chris, I have not long moved into IT Management from a different industry, and your demo is a real eye opener, I will be using it from now on, I have subscribed to you, thank you so much, a breath of fresh air!, I have just started the Prince2 course online through my company, so this will also help there, thanks again Chris, very much appreciated.
thanks Mark, glad to have helped! Good luck with Prince; I think you'll find it's not the answer.....!
Thanks Chris did your course last Friday in Poole and you made it look so easy (which it is really). Thought I would build a Gantt chart why it is still fresh in my mind. Aghhh couldn't remember, this video brough it all flooding back. Now I have my Gantt chart and your video saved in favourites. ThanksKaren
+Karen Travers Brilliant to hear that you're already putting it into action
Way to go Chris. What a nice and effective way to learn the Gantt chart. Of all the videos I have seen, this one is the far most best demonstration of building a Gantt chart. I am also impressed by your videos on Lynda.com for project management simplified as well as Gantt charts. Your way of teaching and demonstration is exceptional. You have made my day!! Adil
Great reminder Chris thanks.
Dear Mr. Chris, what you have share is more then amazing, i am in a process to start a new venture and was completely bogged down by so many different tasks that i have to get done, but after watching your video i am so relieved. I am planning to use post-it notes with my team and i can feel that it would be fun for everyone in the team. Thank you so very much for explaining such a difficult concepts in such easy way. You are great :)
it is my pleasure! thank you so much for your kind message, it makes all the difference to know that people out there are viewing my stuff and finding it helpful!
Thank you !! It was very interesting ....
Nice explanation Chris..Thanks!
fantastic video ... exactly what i was looking for
Thanks. This was really helpful!
You good sir, are brilliant. Many thanks!
Hi Chris, that was a witty and very enjoyable presentation, many thanks. Quite useful indeed those Gantt charts made simple the way you do it.
Erik
thanks Erik! Glad you liked my sense of humour!
Great video's, thank you very much!
excellent!!! Thanks for posting.
Thank you. it's was really helpful
Thank you! Very clear and helped me a lot!
my pleasure Felipe!
Use conditional formatting "Greater than -1" instead of 0 and you will still have the formatting and be able to enter the digit 0 and not the letter O.
You will have to create another rule for the same cell for "Cell contain blank - No format" and then check the box "Stop if true". Make sure that the other rule is above the rule "cell value > -1".
+Markus Degerlund - wow that's really clever! Though i think most people, including me, won't be able to remember it next time they create a chart, whereas my idea of putting in an O is nice and simple.... but agreed, it's a bit of a bodge!
Excellent video very helpful in putting together a Gantt chart for my class. Thanks!
wow, great to hear that it was passed on to a whole class. Thanks Charles!
I agree that most people have Excel so this is really useful in recording information.
I tried to give this video a double thumbs up but it wouldn’t let me. Great video particularly for someone such as myself that is looking to reclassify career to project management.
Double thumbs up! I'm really flattered, thanks Lou
Chris you are not human, you are an Angel. I love you...do you know how easy you made a complex concept for a dumb and duffer person like me. its really useful stuff that you are throwing away for free, I want to call you to say thanks.
Sami Uddin - thanks Sami! It's okay, you don't need to call me, but it is really great to hear from people who I have helped. I know I'm giving it away for free but firstly it doesn't cost me anything to give it away, secondly I benefit hugely from hearing from people like you, and thirdly I hope that in this world you do receive what you deserve in the end, you reap what you sow, so I'm sure I will be rewarded in some way, although the satisfaction alone is pretty good! So thank you for taking the time to leave me a nice comment
Helped, that you have!
And I think that you helped ways more that just a few people, but the realization of projects, maybe even of dreams !
Thank you!
Hi Chris, I've been in the Project vs. Excel debate for a time and in the end have come back to excel with teams I've worked on as its ubiquitous and easy to use. Until watching your video I was unaware you could create such wonderful Gantt charts using Excel. Have enjoyed this video and look forward to using this with my team! And yes... I laughed, and gasped. ;)
thanks Lyndsay!
Thankyou this really helped me heaps ,in my assessment .. easy to understand now.
great, I'm glad to hear that it helped Mari! You'll probably also like my "PM in under 8 minutes" video as well - shows the bigger picture
Chris! thanks for all the good advice! I am using this tool to develop my startup. Let me know if you ever come to Colombia!
thanks RVG! It would be great to meet you one day, over in Colombia! Meanwhile it's great to know that it helped. Check out my "PM in under 8 minutes" video as well - lots of useful stuff there too
Excellent, thanks!
Very good video!
Thank you very much sir for this useful session on Gantt
+Vikram Muralidaran - my pleasure
superthanks for the tutorial!
Whoa!!!!! HE IS AMAZING!!!!!
haha thanks very much!
That was really helpful thank you. I have just used it to create a Gantt Chart for my project. :-)
Great to hear that it helped! Now you can never go back...!
EXCELENTE VIDEO
Legend! thanks mate
Thank you very much!
Thank you!
Thanks Folks, It really help me a lot for the company.
Thanks! Very Useful video :)
This is really excellent ! thank you so much :-)
I would suggest it for anyone who work in project
You're hilarious. Thanks for these videos.
thanks LJ!
All hail the Gant Guru!
thank u this is the best
transposing the chart, i.e. make the vertical axis as time axis, can make the chart more compact and readable
This is wonderful stuff Chris. I have used MS Project for plant maintenance projects and find the software a little unwieldy. There is too much going on in MS Project and can become a full time job just to run it instead of getting on with the project itself.Do many PMs use this approach with Excel ?
Great video, thanks! Extremely useful! :-)
haha thanks Peter! I am indeed The Gantt Guy!
so perfect Christ !!! it so simple and sweet
Thanks so much!
Thanks
Chris could you do more Excel and Access videos please.. you are very good
Thanks Chris for this tutorial. Is there any way I can add dependencies to the tasks?
Good question - not that I know of. but if you start with a post it note diagram - which is a great way to do it - then all you need is what I have shown - the critical path first, and then the dependencies are shown as the vertical lines ion the Gantt chart. So then you don't need to have any other dependencies.
Great ! thanks Chris (and for the "floaters" lol) .
yes, even in Project Management we can find the occasional laugh. I do wonder how many people have spotted those...
thanks Skyrad01!
sick video man good work :) xx
thanks Jack - my distant relative!
Great demo, much easier than battling with MS Project, especially like the idea to sum all of your project time.... By the way, what software did you use to create your video please?
+Stuart Seed - glad you like it Stuart! Not sure how it was done, a friend made it. I used to use Screenr but that has become a pain recently.
this is great!
+Joe Kunzler - thanks Joe, glad you liked it! Have you seen my video called Project Management in under 8 minutes? You'd probably like that one too.....
I will watch it now.
Question: What if I want to query tasks for different projects. For example I want to show all the projects that have a task on N. Main St. Thanks
+Joe Kunzler Ah you're talking Gantt of Gantts - see my two articles on linked in Pulse
Hi Chris. Very nice video to make a gantt chart in a simple way. Thank you. Also, I have a question, As you introduced the bar chart for the weeks or hours, Can we prepare the gant chart itself using excel charts to make it dynamic in nature too, so that when we change the data points like hours etc the gantt chart also updates. in that way we can also add completion timelines as well.
Yes that would certainly work. Although I think it's best to keep it simple even if that makes it a bit slower
Hi Chris, your gantt chart is very useful but i have an assignment that is asking for the cash flow required. Is there anything major i have to do besides making a column for the cash flow. or does it add up like the project? Cheers
Hi Josh
I think I would add a couple of ideas - one is that there is a time lag, so you might incur costs but not have to pay them straight away - one of the differences between cash flow and profit. The other one is that you can look at income as well as costs - when you finish tasks in the project you might get paid stage payments by customers, or start to get income - these can also be added into the cash flow (also with time lags maybe, since you invoice them but there is a delay before you get paid). But all this flows from the Gantt chart, which is the starting point for seeing what happens when. I hope that helps!
Hi ChrisGreat video just a pity you can't over lap the tasks, like start one task halfway through the week and finish halfway through the following week and so on ,have you got any suggestions for this without bulking the charts up by fragmenting it in to days instead of weeks ?
thanks Paul
There's two things there - overlapping tasks - which is easy, and going down into half a week which is more difficult. My suggestion is that longer Projects should never have tasks taking less than a week because in reality everything ends up taking a week. Round them up and you get a bit of safety margin. If you've got a short project, say it's only taking three weeks, then I would use days across the top of my chart rather than weeks. And then again you can't have something taking less than a day. Keep it simple and it will work just fine.
Very nice. I am enjoying your content. However, can you explain or say more about the critical path in the network diagram? What makes it critical? You said it's the longest of path but there's an off shoot in that critical path that makes it longer that is not being highlighted (I.e, find local suppliers of furniture and purchase furniture)
Hi Alex - you're right, the critical path is the longest (slowest) path. The branch involving the furniture is only 2+2 while modifying the buildings is 8, so the critical path goes through the buildings. More information here ua-cam.com/video/fr2-xLTpeHM/v-deo.html
I came here from DePaul Leadership Course - The Hay Project
are they recommending me??
Mr. Croft Thanks you for posting this, its very important for my work
Have you wrote a book?
yes indeed, you can get it on Kindle here www.amazon.co.uk/Project-Management-deliver-successful-projects-ebook/dp/B005MOLEVI/ref=sr_1_1?s=digital-text&ie=UTF8&qid=1396815670&sr=1-1&keywords=chris+croft+project and a paperback from lulu here - www.lulu.com/shop/chris-croft/project-management-instant-guide/paperback/product-21554008.html