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.Instructor
Lenny has over 15 years combined experience in financial planning and analysis (FP&A), financial reporting and modeling, and compliance auditing.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout 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.
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 |