Developing Professional Gantt Charts with Excel & MS Project

Name: Developing Professional Gantt Charts with Excel & MS Project
Rating: 4.2 (36 reviews)

Master the art of Gantt charts using Excel & MS Project, from the basics to advanced techniques & practical applications

Created byMubasher Rehman - (Master of Engineering - Project Management)

Last updated 7/2025

English

What you'll learn

Learning to Develop Customized Dynamic Gantt Charts in Excel
Maintaining required calendar needs like Daily, Weekly, Monthly or even Yearly!
Managing multiple projects with any number of tasks and subtasks
Learning a LOT of Excel formulae , their integration and application
Learning Basic to Advance Microsoft Project (MS Project)
Navigate through MS Project interface proficiently, including the ribbon, Gantt Chart, Task Sheet, and Resource Sheet views.
Learn to create, organize, and schedule tasks effectively using different task dependencies such as FS, SS, FF, and SF
Master resource allocation, leveling, and tracking to optimize resource utilization and avoid overallocation conflicts.
Identify and analyze critical paths in project schedules to determine the sequence of tasks that must be completed on time for the project to finish as planned.
Understand methods for tracking project progress, including updating tasks, recording actuals, and analyzing variances to ensure projects stay on schedule.
Customize MS Project features to suit specific project needs, and generate insightful reports, including Gantt charts, resource allocation reports, and summary

Course content

2 sections • 20 lectures • 3h 48m total length

Formatting Excel Sheet8:22
Format the Excel sheet to create a dynamic Gantt chart that updates automatically from start dates, durations, and progress, including serial numbers, task names, and responsible persons.
Understanding Different Date Format Settings2:51
Learn how to set and verify date formats in Excel by checking your computer's regional settings, then switch between United States and United Kingdom formats to ensure correct date handling.
Science with IF and AND statements5:17
Learn how to automate Gantt chart formatting in Excel using if and and statements, enabling dynamic color updates through logical tests and multiple conditions.
Application of IF and AND Statement6:06
Apply the and function within an if statement to automate date boundaries in Excel, lock absolute references with dollar signs, and use conditional formatting to visualize start and end dates.
Dynamic Conditional Formatting6:06
Learn conditional formatting in Excel to automate a Gantt chart's dates using an if-else logic with the and function, define boundaries with start dates, and lock formulas with absolute references.
Creating Automation with Dates6:11
Apply conditional formatting in Excel to build a dynamic Gantt chart, highlighting tasks by status (completed, in progress, delayed, not started) and aligning end dates and durations.
Expanding Formatting and Troubleshooting4:17
Learn expanding formatting and troubleshooting a Gantt chart in Excel and MS Project, using conditional formatting to color-code status, adjust durations, assign responsibilities, and automate progress.
Status Automation with Complete9:13
Automate status in Excel based on percentage complete, coloring as completed, in process, delayed, or not started. Use a multi-condition if formula with and today() to evaluate dates.
Understanding Cell Reference and Troubleshooting4:11
Develop professional Gantt charts by mastering cell references and troubleshooting in Excel formulas, using absolute references with dollar signs, correcting start dates, percentage completion, and current date logic.
Creating Summary6:03
Learn to create and manage summary tasks in a Gantt chart using Excel, including inserting summary rows and calculating durations from start and end dates with min and max formulas.
Showing Progress through Today Date and Prints5:57
Show how to display today’s date in a Gantt chart, highlight today, adjust the date scale, insert a logo, and set print options for landscape and A3.
Generating High Level View9:11
Create a high level view of a complex Gantt chart in Excel by grouping subtasks, collapsing details, and switching between project A–D and weekly views while applying color-coded progress bars.

Dashboard Overview, Setting Calendrer , Entering Tasks18:06
Explore the Microsoft Project crash course to navigate the dashboard, set the start date and calendar, and enter tasks with auto scheduling, producing Gantt chart views.
Creating Summary task , Right-Left Indentation18:14
Group tasks under a summary task with right indentation to auto-schedule start and end dates, and learn four predecessor types—finish-to-start, start-to-start, finish-to-finish, start-to-finish.
Predecessors detail & Timescale19:19
Explain the four predecessor types—FS, SS, FF, SF—in MS Project and how delays and working-time adjustments automate task scheduling; show time-scale changes and auto-linking for dependent tasks.
Resource types , Resource Sheet and Costing21:29
Learn to create and manage resources in MS Project, including work, material, and cost resources; set rates and calendars; and link resource data to the Gantt chart for accurate costing.
Recourse Assignment & Levelling24:53
Setting Baseline Vs Actual Table8:12
Learn how to set baselines in Microsoft Project and compare plan versus actual data using tracking views, including baseline start, finish, duration, cost, and percent completion.
Performing Actual against Baseline15:19
Explore how to compare baseline and actual plans in a Gantt chart, update tasks with start dates, durations, completion, and costs, and analyze variances including travel costs.
Professional Formatting, Overview of Multiple Views and Reporting29:36
Learn professional Gantt chart formatting in Excel and MS Project, covering baseline versus actual planning, cost and schedule variances, milestones, timeline and resource usage, and reporting with cost overview.
Review Test - MCQs Based

Requirements

Just Excel and MS Project softwares

Description

Join us on a journey to Master Gantt charts with our comprehensive course, carefully designed to teach you essential project management skills using Excel and Microsoft Project (MS Project). Broken into two parts, this course guides you through creating and managing Gantt charts step by step.

In the first part, you'll learn how to make Gantt charts in Excel. We'll start with the basics and move to more advanced techniques, helping you set up workbooks, add project data, and customize charts for clarity.

Moving to the second part, you'll discover how to use Microsoft Project (MS Project) to create professional Gantt charts. Learn to make the most of its features for tasks like scheduling, resource management, progress tracking, and cost analysis.

But this course isn't just about chart creation – it's about mastering the entire project management lifecycle. Learn how to effectively track project progress, manage resources, analyze plan vs. actual performance, and apply professional formatting techniques for clear communication. Through practical examples and real-world scenarios, you'll emerge ready to tackle any project with confidence and finesse.

Whether you're a seasoned project manager or just starting out, this course provides the tools, knowledge, and practical insights needed to excel in project management. Join us on this transformative journey and unleash the power of Gantt charts to elevate your project management skills to new heights.

Who this course is for:

Project Managers
Students
Project Engineers
Project Coordinators
Team Leaders
Program Managers
Business Analysts
Operations Managers

Developing Professional Gantt Charts with Excel & MS Project

What you'll learn

Explore related topics

Course content

Developing Gantt Chart in MS Excel12 lectures • 1hr 14min

Developing Gantt Chart in MS Project8 lectures • 2hr 35min

Requirements

Description

Who this course is for: