How to create a Gantt chart in 3 minutes using Excel?
🚨 Test your Excel skills (with answers) and receive exclusive resources 🎯
➜ https://www.morpheus-formation.fr/blo...
🎁 Follow our free Excel training → https://www.morpheus-formation.fr/for...
🏆 Excel training eligible for CPF funding – Up to 100% financeable, all levels, 100% personalized → https://www.morpheus-formation.fr/for...
💡 ABOUT THIS VIDEO
📊 What is a Gantt chart?
A Gantt chart is a very practical tool for planning projects. It provides an overview of planned tasks. It indicates the estimated completion date for each task, and for the overall project.
In short, a Gantt chart is a graph that illustrates the start and end dates of a project.
How do you create a Gantt chart in Excel? Simply create a stacked bar chart from a 3-column table. You must first calculate the time elapsed since the project's start using a cumulative sum.
That's what I'll show you in this video!
🏢 WHO ARE WE?
Morpheus Formation is an organization 100% specialized in Excel and its latest features.
Your company and your profession have evolved over the last 15 years? Excel has too!
With a satisfaction rating of 9.8/10 in 2024, we have already supported over 500 learners and 50 companies, including Pernod Ricard, Cartier, and Orange.
Our Excel training courses are suitable for both businesses and individuals, with personalized support using your own files.
🎓 OUR EXCEL TRAINING COURSES
1️⃣ Personalized training, delivered live by an expert instructor, tailored to your needs.
2️⃣ Exclusive exercise materials and the ability to work on your files during the sessions.
3️⃣ Ultra-flexible scheduling (weekdays, holidays, weekends, etc.).
📌 Excel Training for All Levels → https://www.morpheus-formation.fr/for...
💡 CHAPTERS
00:00: Intro
00:59: Structuring the Table
01:37: Cumulative SUM
02:36: Inserting a Stacked Bar Chart
03:09: Formatting the Chart
04:06: Inverse X-Range
04:43: Outro
🎁 OTHER FREE RESOURCES
📂 20 Excel Exercises to Progress Quickly → https://www.morpheus-formation.fr/blo...
📥 Free PDF: 25 Essential Excel Functions → https://www.morpheus-formation.fr/blo...
⌨️ 20 Excel keyboard shortcuts to remember → https://www.morpheus-formation.fr/blo...
📬 FOLLOW US
🌐 Official website → https://www.morpheus-formation.fr/
💼 LinkedIn → / morpheus-formation