Project Plan(Gantt Chart) in excel
Вставка
- Опубліковано 27 жов 2017
- Hello Friends,
In this video you will learn how to create a good looking Project Plan or a Gantt chart in excel. I have not used any kind of Chart or macro. It has been created by using conditional formatting in excel.
Please download this excel file from below given link:
www.pk-anexcelexpert.com/proj...
Learn how to enable camera functionality in excel:
• How to use Picture eff...
Dynamic graphs with the help of camera:
• Dynamic graph with Cam...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Website:
www.PK-AnExcelExpert.com
Pinterest:
/ pkanexcelexpert
Follow me on Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
blogger:
pk-anexcelexpert.blogspot.in/
Twitter:
/ priyendra_kumar
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
I was assigned a task to prepare gnatt chart, I don't know ABCD of it, but by following you class I prepared Gnatt chart successfully. Wonderful teaching. Clear explanation. Thanks sir.
My friend, you are truly an Excel expert. I am hopeless when it comes to Excel, but what you did in this video (3 years ago!!) has suddenly re-kindled my interest. You are ridiculously good at this stuff! Thanks
Thanks for your valuable feedback
Nice Video! Excuse me for the intrusion, I would love your opinion. Have you tried - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a good one off product for getting 7000 plus project management and business templates minus the hard work. Ive heard some decent things about it and my cooworker after a lifetime of fighting got amazing success with it.
I love excel
Please sir, I need your help. Is there a formula to use If I want to schedule an event every 5 or 6 weeks Gantt. Such as; excavator to be on sight or asphalt trucks. Thank you.
Thank you for the tutorial, it was very very helpful and very straight forward, very easy to understand. completed my report while you were guiding, very very easy to understand, you will make a good trainer or instructor or teacher, your students will understand very easily.
Thanks for your valuable feedback
thank you for making this video. This is very helpful. You explain things in simplistic manner . Great job.
Thanks for providing information on how to make a project plan using Excel
.
Thanks for your valuable feedback
This is fantastic stuff! Thank you very much!
Really very helpful...Thanks for this video
Thanks for watching
Wonderful presentation !! you have covered so many excel tricks in one session. Thanks a lot
Thanks for your valuable feedback
Hey, I appreciate your doing.
Thank you so much for this. It was easy to follow. Helped give my boring excel sheets a boost and makes them presentation ready for higher level viewing.
Thanks for watching and sharing your valuable feedback
Thanks sir for this much help
Due to this I am able to complete my last year project
😀Thank you 😀
Thanks for your valuable feedback
This was very helpful. Thank you! A valuable addition to this would be indicating which days are weekends.
Excellent video content! Excuse me for the intrusion, I would appreciate your thoughts. Have you considered - Weydaniel Organized Dominator (do a search on google)? It is a good one off product for getting 7000 plus project management and business templates without the headache. Ive heard some super things about it and my work colleague after many years got great results with it.
Thank you!!! This is what i was looking for. I needed to change the color of the cell depending the owner of the task
Cheers for the Video! Excuse me for the intrusion, I would love your thoughts. Have you considered - Weydaniel Organized Dominator (do a search on google)? It is a great exclusive guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some unbelievable things about it and my good mate called Gray got excellent success with it.
Great video content! Apologies for the intrusion, I would love your thoughts. Have you considered - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates minus the headache. Ive heard some pretty good things about it and my work colleague finally got excellent results with it.
You are a saviour, you have no clue how many lives are you helping around, god bless
Thanks
This video is an absolute gem, I finished my assignment in half the time I expected to because of you. thank you!
can you tell how to show completed/incomplete status as in my case it is not showing
Thanks very much for this! At the last minute on a Friday my boss wanted me to create an interactive GANNT chart and so I was panicking a bit but this was awesome! Thanks.
Thanks for your valuable feedback. Please share this with your friends and colleagues.
@@PKAnExcelExpert How to show actual progress on it?
Winner of a video, I've been looking for "construction checklist excel" for a while now, and I think this has helped. Have you heard people talk about - Peyiley Fantastic Paramountcy - (do a google search ) ? It is a great exclusive guide for discovering how to download construction document templates without the normal expense. Ive heard some awesome things about it and my neighbour got great success with it.
Lovely Video! Excuse me for butting in, I am interested in your opinion. Have you heard about - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a good exclusive guide for getting 7000 plus project management and business templates without the headache. Ive heard some awesome things about it and my mate finally got astronomical success with it.
Nice Video! Forgive me for chiming in, I would appreciate your thoughts. Have you heard about - Weydaniel Organized Dominator (erm, check it on google should be there)? It is a great exclusive guide for getting 7000 plus project management and business templates minus the headache. Ive heard some incredible things about it and my work colleague after a lifetime of fighting got cool success with it.
Thank you so much. It was very thorough, straight forward and easy to follow. It was very helpful in creating my own workplan.
Thanks for your valuable feedback
WOW - Thank You - I will be saving this link for the walk through again. I'm sure I'll have to extend my dates But this was great & so helpful! Thank you!
Thanks Tami,
For watching and sharing your valuable feedback.
I manage to make it, thank you so much!!
Thank you very much Bro..!!!!! very helpful presentation!!!
Excellent, clear and concise instruction - thank you.
Thanks for your valuable feedback
Extremely helpful! Thank you
Thanks for your valuable feedback
Outstanding job. Very clear and easy to follow. Thank you.
Thanks for your valuable feedback.
Very helpful for creating a Gantt chart. Thank you.
Thanks for your valuable feedback
This was super helpful, thank you!
Thanks for your valuable feedback
Thanks for making this video! It was really easy to follow along and create my own Gantt chart
It isn’t working well here. The AND function isn’t working
Thank you for your help. This video contains exactly what i was looking for.
Thanks for your valuable feedback
Easy to follow and of high quality. Great work!
Thanks for your valuable feedback
This is the most helpful tutorial I found in all of YOuTube. Thank you for your assistance with my work tasks!.
Thanks for your valuable feedback
Lovely Video clip! Sorry for chiming in, I would love your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (search on google)? It is an awesome one of a kind guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some pretty good things about it and my old buddy Taylor at last got cool success with it.
Thank you, PK. I enjoyed your tutorial
Thanks for your valuable feedback
Brilliant I love it this is what I have been trying to figure out for ages
Thanks for your valuable feedback
omg! you are so good in explaining and showing what is a complicated thing in a simple manner.... your speed of talking is just nice and you are v clear.. gd video
Thanks for your valuable feedback
Thank u very much , Great presentation !!!!!
It's helps a lot. Thanks
Thanks for your valuable feedback
Incredibly helpful! many thanks.
Thanks for your valuable feedback
This is amazing and helps me a lot with my problem! Thank you!
Thanks for your compliment. A humble request please share it in your friends circle on social media so that everyone can make the most of it.
@@PKAnExcelExpert Will do, thanks
Thanks for your support
@@PKAnExcelExpert i had a discrimination bout the subject but your expertise flows correctly i shared on my page
Thank you very much. This is a very helpful presentation.
Thanks for watching and sharing your valuable feedback
This was amazing and very helpful.
Thanks for your valuable feedback
Thanks for the video content! Apologies for chiming in, I am interested in your opinion. Have you heard about - Weydaniel Organized Dominator (google it)? It is a smashing exclusive guide for getting 7000 plus project management and business templates without the hard work. Ive heard some unbelievable things about it and my cousin got cool results with it.
Many thanks, I've been looking for "simple template for project timeline in excel" for a while now, and I think this has helped. You ever tried - Biycarlett Astounded Builder - (Have a quick look on google cant remember the place now ) ? It is a smashing one off product for discovering how to download thousands of business and project management templates minus the headache. Ive heard some decent things about it and my brother in law got excellent success with it.
This was great, I've been looking for "how do i add a resource to microsoft project?" for a while now, and I think this has helped. Ever heard of - Seyily Substratal Smasher - (search on google ) ? It is a good exclusive product for discovering how to get amazing project management and business templates without the hard work. Ive heard some awesome things about it and my m8 got amazing results with it.
PK, Thanks for very nice tutorial, just one thing in case duration of an acivity is increased or a new activity is added or overall duration goes beyond planned days then how the dates in row will automatically be adjusted accordingly.
Thank you for your post. I wonder how you could get the bar to reflect % of task completion in a different color ("in progress" color)
It's useful for me. Thank you.
Thanks for watching and sharing your valuable feedback
very grateful brother....Thank you and God bless
Thanks for your appreciation. Request you to please share this with your friends and colleagues.
@@PKAnExcelExpert Hi PK, many thanks for doing this for the benefit of people wanting to learn more about Excel capabilities. However, there is one drawback to this Gantt Chart. It is assumed that all tasks/activity starts on the first day of the week. I have recreated what you taught us in your video, but I'm afraid it did not work for tasks starting the middle of the week (start date not the first day of the week). In there a formula that can be applied to take this into account, please?
Very helpful and even easier to follow!!
Thanks for your valuable feedback
PK, thanks for the video. What about adding percentage of completion? Can this be added?
Perfect,. Well explained video and easy to follow. Thanks
Thanks for your valuable feedback
Great tutorial!! Thank you!
What a marvelous work and substance You have delivered Mr. Kumar!
Thanks and appreciate it much for your commendable tutorial and you are helping millions of knowledge seekers
on PM and scheduling using the GANTT chart.
TY and God Bless
Cheers
SK
Thanks for your valuable feedback🙏
Very nice and no nonsense video. Doesn't waste a lot of time on intros and asking to like, subscribe etc. Appreciate the efforts.
Thanks for your valuable feedback
Thank you for the video with simplified explanation
Thanks a lot.
excellent- U made everything like a piece of cake.
Thanks for your valuable feedback
Great work, I really can't express my thanks to you
Thanks for your valuable feedback
Very nice, using this myself now. One question, if you have the date displayed as '01 02 03' rather than 'Oct -1', the data validation on the Highlight function only displays the same from the List dropdown, is there anyway to do this in this manner?. Thanks!
I love his accent. He sounds very smart.
Thanks for your valuable feedback
Nice Video clip! Forgive me for chiming in, I would love your initial thoughts. Have you tried - Weydaniel Organized Dominator (search on google)? It is a smashing one off product for getting 7000 plus project management and business templates minus the normal expense. Ive heard some pretty good things about it and my work buddy after a lifetime of fighting got cool results with it.
Lovely Video! Apologies for the intrusion, I would appreciate your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (do a google search)? It is a smashing exclusive product for getting 7000 plus project management and business templates minus the hard work. Ive heard some amazing things about it and my mate at last got cool results with it.
Kudos for the Video clip! Forgive me for butting in, I would love your opinion. Have you tried - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a great one off product for getting 7000 plus project management and business templates minus the hard work. Ive heard some unbelievable things about it and my work buddy after a lifetime of fighting got great results with it.
Cheers for the video content! Sorry for the intrusion, I am interested in your initial thoughts. Have you thought about - Weydaniel Organized Dominator (probably on Google)? It is a good one of a kind product for getting 7000 plus project management and business templates minus the headache. Ive heard some awesome things about it and my old buddy Taylor finally got excellent results with it.
good job bro...
Too good sirji
Thank you so much, it really helps.
Thanks for your valuable feedback
Gracias por el video y explicacion
Hi dear PK. Kindly share the practice regarding budgeted vs actual consumption in excel. thanks
Fantastico come sempre Kumar!!!!
Thanks
Thank you for the video.. I know that you are expert in the excel but please when you explain don’t use shortcuts always or you can explain the way to find it so it could be easier. Thank you again 👌
Thanks for your valuable feedback. I will take care of this for upcoming videos.
Thanks a million. I have been looking for the timeline selection from a desire instead of using Today in the formula
Thanks. You can watch the below video to highlight the desired date
ua-cam.com/video/gIPnC8b-HE8/v-deo.html
Tq....
That is a great video, Thank you very much
Thank you very much...superb
Thank you so much :)
Very helpful, Thanks for uploading
Thanks for your valuable feedback
Thank You Brother.
Thanks for your valuable feedback
Thanks Sir from Bangladesh
Thanks for your valuable feedback
Easy to understand bro. thank you for your help.
Always welcome
HI PK - Thanks for this - curious how do you exclude holidays and weekends from this formula, if we have a list of holidays and weekends to exclude - otherwise if we just delete that date it still assumes the duration.
Really thanks for your clear teaching
It's my pleasure
Would you be able to make this for Googles worksheet? I would love to have my team update this as their projects are completed. Perfect visual indicator.Thank you! This video was amazing!!!!
Very Useful video , Thank you very much
Thanks for your valuable feedback
Great! Thanks for your time!
Thanks for watching and sharing your valuable feedback
I like you and respect you so much
Thanks for your valuable feedback
Thank you ..I would have paid an arm and leg for this......very easy to follow and understand.
Thanks for your valuable feedback
Wow great job. I have made this project plan sheet thanks to you!
Thanks for your valuable feedback
This was amazing and very helpful. How to spilt the date if falls on saturday and sunday ? What kind of formula to add for Sunday ?
খুব সুন্দর এবং দরকারী ভিডিও
PK. Nice video, mate. I enjoy watching your tuts and it has rekindled my interest in coming up with some nice templates. Again, thank you for your great video's and help!
Glad you like them!
Thank you PK, very useful
Thanks for your valuable feedback
its available in excel template. but i appreciate for your work bro, thanks.
This was easy and wonderful .
Thanks for your valuable feedback
OOOOOOO Bro I get new and good things from ur lecture it is soooo nice one bro.Thnaks a LOOOOT
Thanks for your valuable feedback
It was very useful. Thanks
Thanks for your valuable feedback
Thanks for the Video! Apologies for chiming in, I would appreciate your initial thoughts. Have you heard about - Weydaniel Organized Dominator (should be on google have a look)? It is a smashing one of a kind product for getting 7000 plus project management and business templates minus the headache. Ive heard some awesome things about it and my m8 got astronomical results with it.
Great Video clip! Sorry for the intrusion, I would love your thoughts. Have you researched - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a smashing one of a kind product for getting 7000 plus project management and business templates minus the headache. Ive heard some amazing things about it and my work colleague at last got astronomical results with it.
Appreciate video content! Excuse me for the intrusion, I would appreciate your opinion. Have you ever tried - Weydaniel Organized Dominator (erm, check it on google should be there)? It is a good one off product for getting 7000 plus project management and business templates minus the hard work. Ive heard some super things about it and my friend Sam at last got astronomical success with it.
Great Video clip! Excuse me for the intrusion, I am interested in your thoughts. Have you tried - Weydaniel Organized Dominator (google it)? It is a good one off guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some amazing things about it and my mate got astronomical success with it.
thank you!
Thanks for watching
Thank you very much for this video. It has been extremely useful.
Glad it was helpful!
This is brilliant. Well done 👍🏻
Thanks for your valuable feedback
it was fun making this--thanks
Thanks for your valuable feedback
Thank you, This was helpful...explained in simple manner..good one :)
Thanks for your valuable feedback
Cheers for the Video! Apologies for butting in, I would love your opinion. Have you ever tried - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a great exclusive product for getting 7000 plus project management and business templates minus the headache. Ive heard some super things about it and my work colleague got astronomical success with it.
Uunn7
thanks for this!
Thanks for watching
Simply and good. Thanks.
Thanks for your valuable feedback
thank you so much for your useful video :D
Thanks for your valuable feedback
Thanks for this video.U r very good :)
Thanks for your valuable feedback
Thanks so much
Thanks for watching
Thank youuu.
That was outstanding! Thanks PK
Most welcome🙏
Thank you so much sir..its helpfull :)
Most welcome!
Thank you for your help. This video contains exactly what I was looking for. Please don't use shortcut keys.
Thanks for your valuable feedback
Brilliant tutorial. Thank you sir.
Thanks for your valuable feedback