The course is presented in four parts.

First, the course introduces the popular project tracking system in project management – the Gantt Chart, and where we can quickly get a sample of Gantt Chart in Excel.

Next, the course will refresh some basic but crucial Excel skills that will help us build a Gantt Chart in Excel. They include: o ROUNDDOWN() formula o Conditional Formatting: both single-element and multi-element conditional formatting o Dropdown list

Third, we will learn how to build a Gantt Chart from scratch in three parts: o Building a basic Gantt Chart o Building an advanced Gantt Chart, and o Building a “pure” Gantt Chart

Last, we introduce 2 cool Excel apps that will facilitate the data entry of Gantt Chart. They are: o Form in Excel 365, and o Calendar Date Picker

Field of Study: Computer Software & Applications