Back to Create a Simple Gantt Chart using Microsoft Excel
Coursera

Create a Simple Gantt Chart using Microsoft Excel

By the end of this project, you will be able to create a simple Gantt chart to manage your next project. You will utilize the free online version of Microsoft Excel to create a Gantt chart from scratch. This Gantt chart will give you a better idea of how bar charts and conditional formatting work. This guide will incorporate some Excel functions to teach you how to use conditional formatting to make your chart and data interactive. In addition, this Gantt chart will allow you to track multiple tasks that run parallel with each other, and will incorporate some unique features such as a weekly view bar to organize dates more efficiently.

Status: Data Entry
Status: Timelines
BeginnerGuided Project1 hour

Featured reviews

IZ

5.0Reviewed Oct 19, 2021

It was an excellent training, very easy to follow the tasks.

JH

5.0Reviewed Nov 22, 2025

es interesantes y es algo que no sabia a si que me fue muy util.

MV

4.0Reviewed Jun 22, 2022

Short content but very useful, I would suggest adding an explanation on how to not include weekends in the chart. Thanks.

CH

4.0Reviewed Aug 7, 2023

Using Excel as gantt chart is a faster and easy way to achieve without any third party tools. A bit minor to stactifation in the end of the course.

AG

5.0Reviewed Mar 10, 2023

Simple Topic but useful, Clear instruction and very easy to follow. Great teaching strategy.

SM

5.0Reviewed Aug 29, 2024

A superb course that simplifies Gantt chart creation in Excel, enabling you to visualize project timelines with clarity and efficiency!