Easy Excel Gantt Charts - Perfect for Project Management

Описание к видео Easy Excel Gantt Charts - Perfect for Project Management

In this video I’m going to show you how easy it is to build Gantt charts in Excel using Conditional Formatting. We’ll also look at how we can highlight tasks that are overdue and the current date.

Note: the formula in column F should be: =IF(ISBLANK(B5),"",WORKDAY.INTL(B5-1,C5,1))

Download the completed Excel file here: https://bit.ly/3xKbYYF

Conditional Formatting with Formulas Explained:    • Conditional Formatting Formulas - Mys...  

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn:   / myndatreacy  

0:00 Excel Gantt Chart uses
0:22 Setting up for Gantt Charts in Excel
0:59 Calculating the Completion Date using WORKDAY.INTL
1:59 Gantt Chart Conditonal Formatting Rules
4:44 Highlight Overdue Tasks
6:19 Highlight the C urrent Date
7:08 Troubleshooting Conditional Formats

Комментарии

Информация по комментариям в разработке