Please ensure Javascript is enabled for purposes of website accessibility
Excel Magic 9 - Building A Project Tracking Gantt Chart
0( 0 REVIEWS )
1h 27m

This course is designed for those interested to learn how to track projects using Gantt Charts in Excel, from building different Gantt Charts to using apps to facilitate data entry.

Read more.
Course Skill Level
Time Estimate
1h 27m



Lenny has over 15 years combined experience in financial planning and analysis (FP&A), financial reporting and modeling, and compliance auditing.

Only want this course? Buy this course for $199 $29 and keep lifetime access. Click here

About This Course

Who this course is for:

  • Office workers
  • Professionals
  • Managers
  • Project Managers

What you’ll learn: 

  • 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


  • Basic Excel, for 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

Our Promise to You

By the end of this course, you will have learned how to build a Gantt Chart to track projects.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about project tracking in Excel.

Course Curriculum

Section 1 - Introduction
Introduction 00:00:00
Downloadable Course Resources 00:00:00
Why Do We Use Gantt Chart To Track Projects? 00:00:00
Instructor 00:00:00
How This Course Is Compared With “Other Similar Courses”? 00:00:00
What You Will Get From This Course 00:00:00
Section 2 - Gantt Chart
Gantt Chart: The History 00:00:00
How To Build A Gantt Chart In Excel 00:00:00
Build A Customized Gantt Chart 00:00:00
Three Types Of Gantt Chart To Cover In This Course 00:00:00
Section 3 - Refresher
Refresher 1: Math Formulas 00:00:00
Refresher 2: Conditional Formatting (Part 1) 00:00:00
Refresher 3: Conditional Formatting (Part 2) 00:00:00
Refresher 4: Dropdown List 00:00:00
Refresher 5: Calendar Formulas 00:00:00
Section 4 - No. 1: Basic Gantt Chart
Basic Gantt Chart – Part 1 00:00:00
Basic Gantt Chart – Part 2 00:00:00
Section 5 - No. 2: Advanced Gantt Chart
Advanced Gantt Chart – Part 1 00:00:00
Advanced Gantt Chart – Part 2 00:00:00
Advanced Gantt Chart – Part 3 00:00:00
Advanced Gantt Chart – Part 4 00:00:00
Advanced Gantt Chart – Part 5 00:00:00
Section 6 - No. 3: “Pure” Gantt Chart
“Pure” Gantt Chart – Part 1 00:00:00
“Pure” Gantt Chart – Part 2 00:00:00
“Pure” Gantt Chart – Part 3 00:00:00
Section 7 - Bonus: Two Cool Functions For Data Entry In Gantt Chart
Office 365 “Form” 00:00:00
Calendar Date Picker 00:00:00
Section 8 - Conclusion
Takeaways 00:00:00
Next Course 00:00:00