About this course
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:
o ROUNDDOWN() formula
o Conditional Formatting: both single-element and multi-element conditional formatting
o Dropdown list
Third, we will learn how to build a Gantt Chart from scratch in three parts:
o Building a basic Gantt Chart
o Building an advanced Gantt Chart, and
o Building a “pure” Gantt Chart
Last, we introduce 2 cool Excel apps that will facilitate the data entry of Gantt Chart. They are:
o Form in Excel 365, and
o Calendar Date Picker
Field of Study: Computer Software & Applications
This course includes:
schedule2 hours on-demand video
signal_cellular_altBeginner level
task_altNo preparation required
calendar_todayPublished At Apr 23, 2022
workspace_premiumCertificate of completion
errorNo prerequisites
lock1 year access
calendar_todayUpdated At Jan 20, 2025
