How to create Ultimate Excel Gantt Chart for Project Management (with Smart Dependency Engine)
► Download Ultimate Excel Gantt Chart Template:
► Discover all our Excel templates:
How to create Ultimate Excel Gantt Chart for Project Management (with Smart Dependency Engine)
This Excel tutorial teaches you how to create the ultimate Excel Gantt Chart Template with many advanced and incredibly powerful features making this a professional project planning and management tool.
This template introduces a novel and intuitive way of creating and managing fully dynamic project schedules in Excel with items depending on each other based on the four common dependency connection types: Finish-to-Start (FS), Start-to-Start (SS), Start-to-Finish (SF), or Finish-to-Finish (FF). Furthermore, the template includes a smart Project Role and Team Management system, a fully automated Colouring Engine with four different color modes, and many more amazing features.
This tutorial covers every single step of the template creation and is an amazing training for your set of advanced Excel skills.
Tutorial Outline
------------------------
0:00 Demo
8:52 Initial Design Setup
28:52 Basic Item Details
34:36 Project Role and Team Management
46:50 Manual Planning with Independent Start or End Dates
1:09:52 Dynamic Planning with Dependency Engine
1:48:33 Dynamic Project Timespan
1:56:48 Auto-Coloring Engine with 4 Automated Color Modes
2:33:40 Base vs Plan Comparison
2:46:27 Progress Tracking
3:02:59 Dynamic and Static Date Highlighting
3:09:45 Scroll Buttons
3:12:26 How to Manage and Filter Items
Resources
-----------------
Final Template Download:
Set of Unicode Icons: ⚠, ◆, ⚑, ↖, ↙
Color Palette: F0E936, 40D492, F9B710, FE1684, 9237BC, 4633F2, 3285F3, 1DD7F3
Social Media
---------------------
Follow us on Twitter ►
Other Channels
------------------------
As this tutorial covers a very advanced Gantt Chart approach, here I have a list of channels that were the first popular on YouTube to explain the basic concept of cell-based Excel Gantt Charts in case you are looking for an easy start into the topic:
Vertex42 (English) ►
The Excel Challenge (English) ►
PK: An Excel Expert (English) ►
El Tío Tech (Spanish) ►
Tatakaus (German) ►
NOTE: This video has been produced for educational purposes as I want to have my community benefit from freely accessible training material. You are free to use the knowledge provided for your own personal or business-related projects. However, the reproduction, copying, and general reuse of the video or republishing of the creative process demonstrated is not permitted. Furthermore, the unauthorized redistribution of the final template or any sort of derivate of the template (for commercial gain or without a proper license) is not permitted. A violation thereof is considered copyright infringement and is subject to legal actions.
#excel #gantt #chart
1 view
381
93
4 days ago 00:03:47 1
SCOOTER - HOW MUCH IS THE FISH (Metal cover)
6 days ago 00:20:57 1
Incredible Discovery In The Grand Canyon? - YouTube
6 days ago 00:29:11 1
Interview with Valentin Kozlov, Valmix Company | Potato Tour Across Russia (Part 2) 🥔🚜
1 week ago 00:57:54 1
Lost In Time : The Isolated House Where She Lost Her Mind | How I Find Abandoned Placess
1 week ago 01:01:39 1
TIME SLIP STORIES (SN 18 EP 38) TRUE UNEXPLAINABLE EXPERIENCES WITH MISSING TIME & TIME SLIPS
1 week ago 00:00:31 2
How To Train Your Dragon | Big Game Spot
1 week ago 00:05:05 59
How to Clown - Misha Usov - Professional Clown School
1 week ago 00:38:45 2
Try Not To Laugh Challenge#7 | Instant Regret Fails Compilation 2024 | Amazing People
1 week ago 00:29:31 1
Membership Perks
2 weeks ago 07:10:32 1
У края бездны-(2024) все серии 1-4. Освобождение Мариуполя.Причитайте ограничения в описании ниже!!
2 weeks ago 00:08:00 16
Dream Theater - Midnight Messiah (Official Video)
2 weeks ago 00:05:14 2
Clara Fernández: The Spanish Sensation Transforming Pole Vaulting
2 weeks ago 00:27:54 5
Секретные космические лазеры устраивают пожары на Земле?
2 weeks ago 01:18:02 2
The Spider’s Web: Britain’s Second Empire | The Secret World of Finance
2 weeks ago 00:03:57 46
Britney Spears - ...Baby One More Time (Official Video)
2 weeks ago 00:17:09 1
Blouse crochet pattern - how to crochet summer top
2 weeks ago 00:15:40 1
Как вязать росток кардигана Вязание укороченными рядами How to knit a cardigan back height
2 weeks ago 00:04:50 20
In The Army Now (Status Quo) • Drum Cover
2 weeks ago 00:38:56 2
Time Team Podcast | New excavations at Pompeii
2 weeks ago 00:56:53 3
DOGMAN, MIRRORED MEN AND HIGHWAY GHOSTS: TALES FROM THE ROAD (SN 18 EP 36) TRUE SPOOKY STORIES
2 weeks ago 00:15:46 2
🐹 КРОТЫ УХОДЯТ НАВСЕГДА! Как прогнать кротов с участка дымовой самодельной шашкой
2 weeks ago 01:12:12 1
Crochet Lacey Vest Tutorial | Chenda DIY
2 weeks ago 00:09:56 1
Mother Tucker: The Donald Trump & Jared Kushner Family Business Suckled From The Tit Of Saudi Arabia
2 weeks ago 00:18:46 1
I Crocheted a Houndstooth Vest | Pattern Walk-through