Bottom Line: This Excel tutorial teaches you how to create a professional Gantt Chart template in Excel for your project planning and management. It is designed using a fundamentally new approach that allows for a tremendous degree of automation, interactivity, and visualization of different project perspectives.
The final template contains a fully implemented Dependency Engine that let’s you connect your items to each other using one of four different dependency connection types (FS, SS, SF, FF) via dropdown selections. That means you are able to do forward and backward scheduling and even combine both approaches in the same schedule. Furthermore, this Gantt Chart enables you to switch between four fully automated Color Modes with one single click and gives you access to a smart Project Role and Team Management System. And that is just the tip of the iceberg.
Skill Level: Advanced
A Gantt Chart is arguably the most widely used project planning tool. And Excel allows you to quickly setup a simple Gantt Chart, but you can also build a really outstanding version with many advanced features that make this a professional project planning and management tool.
This video tutorial teaches every single step on how to create such an advanced and professional Gantt Chart in Microsoft Excel. Along the way you will learn a ton of high-level Excel skills such as how to
- systematically set up and design an extended professional Excel tool from scratch
- how to create understandable, reusable, and scalable formula constructs based on named calculations (which let you apply complex formula calculations by entering a single name)
- how to set up multi-level dropdown list constructs that with a dynamic list input
- how to set up an efficient set of conditional formatting rules building on top of each other
- how to smartly apply conditional formatting rules to improve the user experience when inserting data
- and much more…
The final Ultimate Excel Gantt Chart has the following main features:
- Smart Project Structure with Stages (S), Tasks (T), and Milestones (M)
- Dependency Engine with the 4 Dependency Connection Types Finish-to-Start (FS), Start-to-Start (SS), Start-to-Finish (SF), and Finish-to-Finish (FF)
- Auto-Coloring Engine with 4 Color Modes
- Plan vs. Base Comparison
- Intuitive Progress Tracking and Visualization
- Dynamic and Static Date Highlighting