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 Key Concepts: Project tracking, Gantt Chart, Milestones, Tasks, Assignees, Dependents, Pattern style, Border, Data Validation, Transparent chart, Overlapped chart, Form, Calendar Date Picker.