Ultimate Excel Gantt Chart Tutorial ( OnTrack, Low-High-Medium Risk, Unassigned) (V003)

Описание: Channel :
   / @excelexperthat  

Download: https://drive.google.com/file/d/1w5PC...

This Excel tutorial will teach you how to Make a Gantt Chart in Excel, including features like the ability to show the progress of each task. Watch as I create the Simple Gantt Chart template from scratch for the Production department.

Features you will Learn:
1) Work priority Gantt Chart
2) Progress Gantt Chart
3) Weekend and Holidays Task End date calculation
4) Conditional Formating
5) Colour coding as per Work Status and Work Priority.

TimeLine for your Help:
1) 0:20 : Chart Introduction
2) 1:17 : Start Making Data Table
3) 2:15 : How to make Calendar for Gantt Chart
4) 4:22 : How to put a Week Day Initial (M, T, W…S) for as per Each Date
5) 5:22 : How to Make a % Progress Bar in Cell (0%,10%.....100%) as per % in cell
6) 6:35 : List the employee names in Table
7) 9:08 : How to calculate Task End date which Includes Weekend and Holidays
8) 14:21 : Start making Gantt Chart with Conditional Formatting
9) 14:47 : How to Highlight Today's Date in the Gantt Chart
10) 16:52 : How to Highlighting the Gantt Chart Bars as per Work Status
11) 20:27 : How to put Weekend and Holidays in Gantt Chart
12) 24:09 : How to put a different colour in Gantt Bars as per Task Work Progress
13) 28:18 : How to Faint away the completed Tasks, Deem the completed progress lines
14) 40:16 : How to calculate Task End Date including Weekend and Holidays and How to book the manpower
15) 34:28 : How to show Manpower booking in different Gantt Chart
16) 35:51: How to pull each employee latest work start date and lask work end date

Hello Friends,
We have explained Excel tricks and tactics in detail in each video.
Please do visit our channel and given links below.
See Our All Videos:   • Excel Charts Series (English)  
Our Short Video:    • Excel-Short Trick Series (English)  
Visit Our Channel:    / @excelexperthat  

Our Long Videos:
1) Using Slicers in Excel to Filter Data
   • Using Slicers in Excel to Filter Data (V007)  
2) Excel Gantt Chart with Pivot Table
   • Excel Gantt Chart with Pivot Table (V006)  
3) Progress Bar in Excel Cells & Conditional Formatting
   • Progress Bar in Excel Cells & Conditional ...  
4) Excel Workday function: Find end date & exclude weekends & holidays
   • Excel Workday function: Find end date & ex...  
5) Project Plan in Excel with Gantt Chart (Plan, Actual & Progress, Work Priority)
   • Ultimate Excel Gantt Chart Tutorial ( OnTr...  
6) Remove author from the file properties – Excel
   • Remove author from the file properties - E...  
7) Excel Pivot Tables EXPLAINED in 15 Minutes (Productivity, Slicer tips included!)
   • Excel Pivot Tables EXPLAINED in 15 Minutes...  
8) How to Use SUM, SUMIF, SUMSQ, SUMIFS, SUMXMY2, SUMX2PY2, SUMX2MY2, SUMPRODUCT Formula in Excel
   • How to Use SUM, SUMIF, SUMSQ, SUMIFS, SUMX...  

Our Short Video:
1) Your Tab in Excel...Very Simple
   • Your Own Tab in Excel...Very Simple (V018)  
2) How to Show Excel Formulas in Cells with FORMULATEXT Function
   • How to Show Excel Formulas in Cells with F...  
3) Unit Converter in Excel
   • Unit Converter in Excel (V021)  
4) How to find Duplicated in List – Excel
   • How to find Duplicated in List - Excel (V023)