Not a excel tech oriented. Best gantt chart I've ever seen in here. Really appreciate!

@theChrisCroft

5 жыл бұрын

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

@theChrisCroft

5 жыл бұрын

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.

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!

@theChrisCroft

5 жыл бұрын

My pleasure, thanks Cider Press!

OMG. I am in love with this process. Thank you So very much for the clear tutorial. I am throwing away MS Project!

@theChrisCroft

Жыл бұрын

thanks Lucy Lu - glad to hear it!!

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.

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.

@theChrisCroft

7 жыл бұрын

thanks MW - it's great to be appreciated like that!

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.

@theChrisCroft

11 ай бұрын

You're very welcome!

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.

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 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.

Cheers Chris excellent video, very helpful! I made mine in parallel just pausing and rewinding once in a while.

This is the best of its kind. thank you so very much! please keep posting of your wonderful experiences.

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!

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.

@theChrisCroft

9 жыл бұрын

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

Love the SPM Chris you are great, make everything about project management easy to understand. Thank you.

Thank you, Chris. I love your tutorials.

This is great!. I also saw your lynda course. Thank you!

really helpful video - much simpler than the other interactive Gantt chart examples I've come across - will be implementing this immediately!

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.

@theChrisCroft

9 жыл бұрын

thanks Mark, glad to have helped! Good luck with Prince; I think you'll find it's not the answer.....!

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 KZread 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!

@theChrisCroft

9 жыл бұрын

Thanks for those nice comments! Please pass the message on to others ...! More courses going onto Lynda soon

Thanks Chris: Very useful, well-explained, practical, functional. I really liked the first step - Post-it Note Plan.

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

Brilliant! This is all the project management I need to run my own start up for now.

This was really useful and i enjoyed making this gantt chart.

Wow! Just wow. So easily done and explained!! Immediately subscribed. Thank you !

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 :)

@theChrisCroft

7 жыл бұрын

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!

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.

@theChrisCroft

7 жыл бұрын

Rashed Hiyasat - haha thanks!!

Great video. This was very helpful. Thank you for posting this.

Thanks for taking the time Chris. Nice and simple!

@theChrisCroft

7 жыл бұрын

glad you liked it! - thanks for letting me know

Many many thanks Chris. You gave me a very good, excellent, superb lesson to me.

@theChrisCroft

5 жыл бұрын

thanks for the kind words Louis!

@theChrisCroft

5 жыл бұрын

thanks Louis, glad you liked it! CC

Nice, simple and informative video!! Thanks Chris.

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.

@theChrisCroft

4 жыл бұрын

check out my video "PM in under 8 minutes" - should help with the course

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

@theChrisCroft

8 жыл бұрын

+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

Thanks Chris. Quite simply the best Excel tutorial I have seen on KZread. Gantt charts just happened to be the topic. Cheers!

@theChrisCroft

10 жыл бұрын

thanks Mr B!

Excellent. Detailed and dynamic. Thank you Chris

@theChrisCroft

4 жыл бұрын

thanks Nico!

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!

@theChrisCroft

9 жыл бұрын

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.

Professional, good explanation, really helped for my dissertation proposal!

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!

@theChrisCroft

10 жыл бұрын

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

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. ;)

@theChrisCroft

10 жыл бұрын

thanks Lyndsay!

Excellent tutorial and very sound advice!!

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.

@theChrisCroft

7 жыл бұрын

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

@RAQdrian

7 жыл бұрын

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!

Chris, thank you for creating this vid..

i am in truly love with u ..! u have explained it with so much of ease !!! thank you ..!! it was awesomeeee

@theChrisCroft

7 жыл бұрын

thanks for that comment! Makes it all worthwhile....

Great reminder Chris thanks.

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".

@theChrisCroft

8 жыл бұрын

+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!

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.

@theChrisCroft

5 жыл бұрын

Double thumbs up! I'm really flattered, thanks Lou

Chris, THANK YOU!!! Much appreciated my friend 😁👍 Take Care 👍

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

@theChrisCroft

10 жыл бұрын

thanks Erik! Glad you liked my sense of humour!

Nice explanation Chris..Thanks!

Thank you !! It was very interesting ....

fantastic video ... exactly what i was looking for

Thank you! Very clear and helped me a lot!

@theChrisCroft

4 жыл бұрын

my pleasure Felipe!

Thanks. This was really helpful!

Very good video!

Thanks Chris for this tutorial. Is there any way I can add dependencies to the tasks?

@theChrisCroft

7 жыл бұрын

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.

excellent!!! Thanks for posting.

I would suggest it for anyone who work in project

Thank you. it's was really helpful

Great video's, thank you very much!

transposing the chart, i.e. make the vertical axis as time axis, can make the chart more compact and readable

That was really helpful thank you. I have just used it to create a Gantt Chart for my project. :-)

@theChrisCroft

9 жыл бұрын

Great to hear that it helped! Now you can never go back...!

Excellent video very helpful in putting together a Gantt chart for my class. Thanks!

@theChrisCroft

9 жыл бұрын

wow, great to hear that it was passed on to a whole class. Thanks Charles!

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 ?

You good sir, are brilliant. Many thanks!

Thank you very much sir for this useful session on Gantt

@theChrisCroft

8 жыл бұрын

+Vikram Muralidaran - my pleasure

I agree that most people have Excel so this is really useful in recording information.

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?

@MrBrift

8 жыл бұрын

+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.

Thankyou this really helped me heaps ,in my assessment .. easy to understand now.

@theChrisCroft

9 жыл бұрын

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 could you do more Excel and Access videos please.. you are very good

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.

@theChrisCroft

8 жыл бұрын

Yes that would certainly work. Although I think it's best to keep it simple even if that makes it a bit slower

superthanks for the tutorial!

Whoa!!!!! HE IS AMAZING!!!!!

@theChrisCroft

6 жыл бұрын

haha thanks very much!

Excellent, thanks!

Legend! thanks mate

EXCELENTE VIDEO

thanks LJ!

Mr. Croft Thanks you for posting this, its very important for my work Have you wrote a book?

@theChrisCroft

10 жыл бұрын

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

Thank you very much!

Thanks! Very Useful video :)

This is really excellent ! thank you so much :-)

You're hilarious. Thanks for these videos.

Great ! thanks Chris (and for the "floaters" lol) .

@theChrisCroft

9 жыл бұрын

yes, even in Project Management we can find the occasional laugh. I do wonder how many people have spotted those...

Thank you!

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)

@theChrisCroft

5 жыл бұрын

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 kzread.info/dash/bejne/mKZmj9qFhNPLeLA.html

haha thanks Peter! I am indeed The Gantt Guy!

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

@theChrisCroft

7 жыл бұрын

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.

All hail the Gant Guru!

Chris, your video was so informative! I have been so lost on how to use the CPM. I still have one problem. When I enter my first two dates, instead of the rest of the cells following the week timeframe, it automatically adjust to give a daily time frame. Meaning that instead of it following June 11th, June 18th, etc. it adjust to say June 11th, June 12th, June 13th How do I fix this?

@theChrisCroft

10 жыл бұрын

Hi Tomiko - I think the answer is that you have to put in the first TWO dates, with the second one being a week later than the first. Then select both of them and then drag the little dot in the bottom right corner. then Excel knows you want them to have gaps of a week.

Thanks Folks, It really help me a lot for the company.

Hey everybody, if you want to see the bigger picture of project management, and how Gantt charts fit into that, then have a look at my video called 'Project Management in under 8 minutes' - tells you everything you need to know.

@janishaswin

4 жыл бұрын

just watched, was very useful Chris, thanks!

thank u this is the best

Great video, thanks! Extremely useful! :-)

Thanks for this excellent tutorial, it is as simple as that. But... is there a way, in the "hours" sheet to differentiate between type of employees in order to see in the chart below what type of employees you are needing at what time and how many?

@theChrisCroft

9 жыл бұрын

Good question Dorina, and it's a tricky one! The core problem is that we have a cube of projects, resources/people, and time, and on a spreadsheet you can only view two out of the three. A database could do all three but gets too complicated to use for what-ifs etc. I think the answer is to choose your key resource, whatever is your bottleneck, and put that on the resource gantt, and plan around that. If you can manage the required resource for your bottleneck then you're OK

@theChrisCroft

9 жыл бұрын

The other useful technique is to copy the Gantt onto a different sheet for each resource, and just put in their hours - so many tasks might be zeros if this resources isn't involved with them. Then you can see the resource profile for each person or team and check that they are OK with the project. It is then the responsibility of each person or group to shout if all of the projects add up to too much for them. They would probably manage this by putting the workload into their diary.

@dorinaclaessens3689

9 жыл бұрын

Thank you Chris, about time they invent a 3D excel sheet ;-)

Thanks

thanks Skyrad01!

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

@theChrisCroft

10 жыл бұрын

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!

so perfect Christ !!! it so simple and sweet

@theChrisCroft

3 жыл бұрын

Thanks so much!