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: [ Ссылка ]
👍 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:
[ Ссылка ]
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:
[ Ссылка ]
GANTT CHART TEMPLATE
My original free Gantt chart template for Excel (and Google Sheets) can be found here:
[ Ссылка ]
ANOTHER GREAT TUTORIAL
Check out the following channel for another detailed tutorial showing how to add advanced features to a Gantt Chart in Excel:
[ Ссылка ]
FOLLOW VERTEX42 HERE:
Instagram: [ Ссылка ]
Facebook: [ Ссылка ]
Pinterest: [ Ссылка ]
Twitter: [ Ссылка ]
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.
How to Make a Gantt Chart in Excel
Теги
gantt chartmake a gantt chartcreate a gantt chartgantt chart in excelexcel ganttexcel gantt chartexcel tutorialproject scheduleproject planproject schedulingproject planningproject managementganttgantt chart tutorialgantt chart excelgant chartproject managerexcel gantt chart tutorialgantt chart for project managementgantt chart excel template