Please ensure Javascript is enabled for purposes of website accessibility

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

Requirements: 

  • 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.

30 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

1h 27m

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
top
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel

3954196

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

3954197

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

Success! You are now entered to win lifetime access to all courses. Winners are selected at the beginning of each month. 

P.S. Look out for our exclusive sales only shown to students on our email list!