Excel Magic (Part 9): Building a Project Tracking Gantt Chart (Video) (Course Id 2223)

The course on building a project tracking Gantt Chart 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 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