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 Key Concepts: Project tracking, Gantt Chart, Milestones, Tasks, Assignees, Dependents, Pattern style, Border, Data Validation, Transparent chart, Overlapped chart, Form, Calendar Date Picker.

Learning Objectives
  • Explore and 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.
Last updated/reviewed: March 16, 2024
3 Reviews (20 ratings)

Reviews

5
Member's Profile
Very practical - real world applications. There was enough review if you were not familiar with one of the course foundations, however it was not a course on formulas or conditional formatting.
4
Anonymous Author
This is a good course to provide some tricks to improve your project management. I like that it provided examples that are simple to more detailed
5
Member's Profile
good training - usefull, the formulas were showed step by step.
Prerequisites
Course Complexity: Foundational

Basic Excel knowledge
Example: be able to open one Excel file and connect to external data files, etc.
It is recommended to take other Excel Magic series courses by Lenny Wu.
Excel Magic 1: Building Dynamic Formulas
Excel Magic 2: Building Your Report Generation "Bot"
Excel Magic 3: Automating Data Entry with Data Feeds
Excel Magic 4: Ultimate API Reporting in Excel
Excel Magic 5: Building Interactive Budgeting Model in Excel
Excel Magic 6: Excel's 7 Languages
Excel Magic 7: Creating Excel Charts like a PRO
Excel Magic 8: Transforming a Pro-forma into a Dashboard
Excel Magic 9: Building a Project Tracking “Gantt” Chart

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
  Course Overview CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
  Introduction to Excel Magic 9: Building a Project Tracking “Gantt” Chart0:38
  Why do We Use Gantt Chart to Track Projects1::20
  Instructor Introduction1:11
  Comparison with Other Similar Courses1:24
  What you will get from this course?0:37
Gantt Chart
  Gantt Chart: The History0:32
  How to Build a Gantt Chart in Excel4:05
  Build a Customized Gantt Chart 1:00
  Three Types of Gantt Chart to Cover in this Course1:36
Refresher
  Refresher 1: Math Formulas6:44
  Refresher 2: Conditional Formatting (Part 1)3:18
  Refresher 3: Conditional Formatting (Part 2)4:32
  Refresher 4: Dropdown List2:32
  Refresher 5: Calendar Formulas2:28
No. 1: Basic Gantt Chart
  Basic Gantt Chart - Part 15:06
  Basic Gantt Chart - Part 23:24
No. 2: Advanced Gantt Chart
  Advanced Gantt Chart - Part 12:11
  Advanced Gantt Chart - Part 26:33
  Advanced Gantt Chart - Part 38:30
  Advanced Gantt Chart - Part 44:37
  Advanced Gantt Chart - Part 51:48
No. 3: “Pure” Gantt Chart
  “Pure” Gantt Chart - Part 15:01
  “Pure” Gantt Chart - Part 26:09
  “Pure” Gantt Chart - Part 34:53
Bonus: Two Cool Functions for Data Entry in Gantt
  Office 365 “Form3:55
  Calendar Date Picker1:39
CONCLUSION
  Takeaways1:20
  Next Course & Q&A0:29
CONTINUOUS PLAY
  Excel Magic 9: Building a Project Tracking “Gantt” Chart1:27:32
SUPPORTING MATERIAL
  Slides: Excel Magic 9: Building a Project Tracking “Gantt” ChartPDF
  Excel Magic 9: Building a Project Tracking “Gantt” Chart Glossary/ IndexPDF
  Workbook: Excel Magic 9: Building a Project Tracking “Gantt” ChartXLSX
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam