Hello guys, Welcome to Africa's Largest Video Search Engine, and you are watching How to Make a Gantt Chart in Excel. and this video is uploaded by Vertex42 at 2019-11-26T04:00:18-08:00. We are just promoting this video only for entertainment and educational purpose only. I hop you like our Video Search Engine. [un8j6QqpYa0]
| Name | How to Make a Gantt Chart in Excel |
| Video Uploader | Video From Vertex42 |
| Upload Date | This Video Uploaded At 26-11-2019 12:00:18 |
| Video Discription | Learn how to Make a Gantt Chart in Excel, including features like a scrolling timeline and the ability to show the progress of each task. Watch as I create the Simple Gantt Chart template from scratch, or download the template: https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html 👍 Remember to Subscribe and Turn on Notifications (click on the bell) THIS VIDEO: 0:20 Step 1 - Start with a List of Tasks and Dates 0:44 Step 2 - Set up the Timeline Labels 2:20 Step 3 - Add Initial Formatting to Style the Gantt Chart 4:05 Step 4 - Add the Bars of the Gantt Chart via Conditional Formatting 5:10 Step 5 - Make the Timeline more Dynamic 6:28 Step 6 - Add a Scroll Bar Form Control 7:20 Step 7 - Highlight Today's Date using Conditional Formatting 7:51 Step 8 - Add Columns for 'Assigned To' and Progress (% Complete) 9:07 Step 9 - Show Progress in the Gantt Chart by Shading a Portion of the Bars 11:31 Step 10 - Define Print Settings OTHER VIDEOS IN THIS SERIES: Check out the next videos to see how to work with workdays and weekends, how to change the display to weekly or monthly, and how to add dynamic color-coding: https://www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html GANTT CHART TEMPLATE PRO: A Gantt Chart is an extremely useful tool for project management. You can create a very simple project plan like the one in this tutorial, but if you are a project manager and want more features such as changing the view between daily/weekly/monthly, entering the duration of a task in work days, or color-coding the bars of the chart, download Gantt Chart Template Pro: https://www.vertex42.com/ExcelTemplates/gantt-chart-template-pro.html GANTT CHART TEMPLATE My original free Gantt chart template for Excel (and Google Sheets) can be found here: https://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html ANOTHER GREAT TUTORIAL Check out the following channel for another detailed tutorial showing how to add advanced features to a Gantt Chart in Excel: https://www.youtube.com/watch?v=OizqFlMtZLQ&t=4903s FOLLOW VERTEX42 HERE: Instagram: https://www.instagram.com/vertex42/ Facebook: https://www.facebook.com/vertex42/ Pinterest: https://www.pinterest.com/vertex42/ Twitter: https://twitter.com/vertex42 MUSIC: A Good Mood, by Young Rich Pixies, licensed via ArtList NOTE: This video is for educational use and for use in making a Gantt chart for your own projects. Reproducing or copying this video in part or in whole for commercial gain (including advertising or making products for sale) is not permitted. [un8j6QqpYa0] |
| Category | Education |
| Tags | gantt chart | make a gantt chart | create a gantt chart | gantt chart in excel | excel gantt | excel gantt chart | excel tutorial | project schedule | project plan | project scheduling | project planning | project management | gantt | gantt chart tutorial | gantt chart excel | gant chart | project manager | excel gantt chart tutorial | gantt chart for project management | gantt chart excel template |
