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

Learn how to build a project tracking “Gantt” Chart!

The course is presented in four parts.

What you’ll learn

  • – to build a “Gantt” Chart.
  • – to make yourself the go-to-person in their office, or.
  • – to be well positioned for your next promotion!.

Course Content

  • Introduction –> 5 lectures • 5min.
  • Gantt Chart –> 4 lectures • 7min.
  • Refresher –> 5 lectures • 20min.
  • No. 1: Basic Gantt Chart –> 2 lectures • 9min.
  • No. 2: Advanced Gantt Chart –> 5 lectures • 24min.
  • No. 3: “Pure” Gantt Chart –> 3 lectures • 16min.
  • Bonus: Two Cool Functions for Data Entry in Gantt Chart –> 2 lectures • 6min.
  • Conclusion –> 2 lectures • 2min.

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

Requirements

  • Basic Excel.
  • Example: be able to open one Excel file, etc..

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