Excel Magic 9: Building a Project Tracking “Gantt” Chart

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:

- ROUNDDOWN() formula

- Conditional Formatting: both single-element and multi-element conditional formatting

- Dropdown list

Third, we will learn how to build a Gantt Chart from scratch in three parts:

- Building a basic Gantt Chart

- Building an advanced Gantt Chart, and

- Building a “pure” Gantt Chart

Last, we introduce 2 cool Excel apps that will facilitate the data entry of Gantt Chart. They are:

- Form in Excel 365, and

- Calendar Date Picker

Course Search Keywords

- Project tracking

- Gantt Chart

- Milestones

- Tasks

- Assignees

- Dependents

- Pattern style

- Border

- Data Validation

- Transparent chart

- Overlapped chart

- Form

- Calendar Date Picker

Learning Objectives

● Understand the components of a Gantt Chart

● Recognize the basics for setting up both single-element and multi-element conditional formatting

● Discover how to build an advanced Gantt Chart with Overlapped Conditional Formatting

● Explore how to build a “pure” Gantt Chart with Overlapped Bar Chart

● Discover 2 cool apps in Excel that can facilitate data entry into the Gantt Chart