Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 27 Minute(s)
Language
English
Taught by
Lenny Wu, MBA, CPA, CGA
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn how to build a project tracking "Gantt" Chart!
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 Search Keywords
- Project tracking
- Gantt Chart
- Milestones
- Tasks
- Assignees
- Dependents
- Pattern style
- Border
- Data Validation
- Transparent chart
- Overlapped chart
- Form
- 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
Course Content
- 8 section(s)
- 28 lecture(s)
- Section 1 Introduction
- Section 2 Gantt Chart
- Section 3 Refresher
- Section 4 No. 1: Basic Gantt Chart
- Section 5 No. 2: Advanced Gantt Chart
- Section 6 No. 3: “Pure” Gantt Chart
- Section 7 Bonus: Two Cool Functions for Data Entry in Gantt Chart
- Section 8 Conclusion
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!
Skills covered in this course
Reviews
-
SSimon
Excellent
-
ssandeep h.s
good
-
JJuan Pablo Bustamante Luna
The exercises are good. I have the feeling that it was necessary to emphasize more examples. In general the course covers what was expected, however it could have been better.
-
EEdward Larkin
Yes this was very good. Why, many times I realize that the instructor will have a foreign dialect. This can make my learning sometimes slightly more difficult (not in this case). I do not mean to be condescending in any way or trying to stereotype instructors please understand. The pace our instructor uses here and his level of depth as to his actions are excellent. Thank You
