Gantt charts

- [Instructor] Among the various chart types in Excel, … you don't see the option a Gantt chart, … and yet you can create one. … These are widely used in project management scenarios, … and we're seeing one on the screen right here … on this worksheet called Gantt Chart. … Dirt work, for example, takes 20 days. … And if we were starting on January 6th in 2020, … you could say, well, this is finished on the 26th. … But let's say they don't work on Fridays and Saturdays, … we need to make an adjusted completion date, … using a function called WORKDAY. … This simply does not count Saturdays and Sundays, … it also has an option for not counting holidays … that we're not using. … So, actual completion is February 3rd. … So the length of the task, not working days, … but the length of the task, we subtract the two, … the adjusted length. … And that's going to be the number that we actually use … in the chart. … We see the 28th here, and we see it over to the right. … So I'll leave the chart here but actually create a new one. …