How to Make a Gantt Chart in Excel
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)
OTHER VIDEOS IN THIS SERIES:
https://www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html
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
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
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.
Видео How to Make a Gantt Chart in Excel канала Vertex42
👍 Remember to Subscribe and Turn on Notifications (click on the bell)
OTHER VIDEOS IN THIS SERIES:
https://www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html
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
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
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.
Видео How to Make a Gantt Chart in Excel канала Vertex42
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Gantt Chart Excel Tutorial - How to make a Basic Gantt Chart in Microsoft Excel 2013Advanced Gantt chart in Excel with drill-down featureInteractive Excel Project Management Dashboard - FREE Download5 Excel Functions YOU NEED in 2021What is a Gantt ChartTECH-005 - Create a quick and simple Time Line (Gantt Chart) in ExcelCreate Gantt Chart easily in PowerPointCreating a Gantt Chart in Google SheetsCreate a Gantt Chart in Excel 2016/2019/365 for Task ManagementFully Featured Excel Gantt Chart - actual, planned & percentage completedHow to Make a Gantt Chart in Word | Microsoft Word TutorialsQuick Gantt Chart in Excel (Unusual technique)How to build Interactive Excel DashboardsSecrets to Building Excel Dashboards in Under 15 Minutes!Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)Power Gantt Chart (Project Planner) for Project ManagementMake Gantt Chart In Excel 2013 HindiHow to make Gantt Chart in ExcelExcel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas