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

Learn how to build a project tracking "Gantt" Chart!

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!

Requirements

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

Description

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

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

Who this course is for:

Office workers, Professionals, and Managers