Create a Simple Gantt Chart using Microsoft Excel
About this course
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.
55/100
CourseAsk score
- What the provider tells you
- 31/45
- Who stands behind it
- 8/35
- How complete the listing is
- 16/20
Scores how much the provider publishes and who stands behind it — not how well it is taught.
What you'll learn
- Create a basic Gantt chart in Excel
- Use bar charts to represent task timelines
- Apply conditional formatting to highlight schedule elements
- Utilize Excel functions to make the chart interactive
- Track multiple parallel tasks with a weekly view
Course objectives
- Construct a Gantt chart without relying on add‑ins or templates
- Demonstrate how conditional formatting can automate visual cues
- Show how to manage and visualize overlapping tasks
Price shown by Coursera — confirm on their site.
Enroll on CourseraYou'll be redirected to Coursera to complete enrollment.
- Listed & compared by CourseAsk
- English · 0
Udemy
Coursera
Compared on these lists
Where this course ranks against the alternatives.