HomeОбразованиеRelated VideosMore From: Subjectmoney

How to Make a Gantt Chart Microsoft Excel 2013 Tutorial #1 Automated Progress

92 ratings | 18560 views
http://www.excelfornoobs.com In this Microsoft Excel 2013 tutorial I show you how to create a Gantt Chart in Excel. For this Gantt chart I also use the Today function (=today()) and I use the If function (=if()) to show to progress and to automate and update the progress as time passes. This tutorial will also work for Excel 2007, excel 2010 and excel 2013 https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=t3FnjVY5YKY
Html code for embedding videos on your blog
Text Comments (6)
markduffy100 (1 year ago)
I have just found this. I am sure my enthusiasm will continue. I find the way your brain works delightful. i am looking forward to completing this and getting onto so of your other videos. I am enthralled that there are so many people like you contributing such great information on the web. Thank you very much
Chris DeLeon (2 years ago)
Thanks for the video
Kolbi B. (2 years ago)
The best way to describe functions is using them in a sentence. In this case, it's easiest to say "My function serves the purpose of stating 'If the amount of time between today and the total estimated days is greater than the total estimated days, then display the total estimated days; otherwise if the amount of time between today and the total estimated days is less than the total estimated days, display the difference between today and the start date.'" The sentence structure replicates Excel's function language structure, so this should help you explain the concept more clearly. Thanks for the video!
Vishal Kanchan (2 years ago)
nice one
lykitmattersanyway (4 years ago)
Is it possible with percentages. How do i include percentage complete and remaining?
Subjectmoney (5 years ago)
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!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.