Premium Only Content

Fully Featured Excel Gantt Chart - actual, planned & percentage completed
Jun 23, 2017 Excel Charts
In this video, learn how to create a more complete Gantt chart that not only shows percentage completed for each task and conditionally formats the progress bars but also allows you to compare actual project plan to planned project plan.
Download the free Excel Gantt chart template and edit to your own needs: https://www.xelplus.com/quick-gantt-chart/
If you want to make a quicker Gantt chart to visualize your project before you start, check out this video: https://youtu.be/QZd3iXcueaI
Gantt chart is a great visualization tool for project planning. Use the template to define the start date for each task as well as the number of working days each task will take. We will use Excel's Work day function to calculate the end date. This way we can account for weekends and holidays. We do two version. One for budget and one for actual. This allows us to switch the view of our gantt chart between actual and budget.
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
LIVE
LFA TV
1 day agoLFA TV ALL DAY STREAM - MONDAY 8/11/25
884 watching -
RiftTV
4 hours agoBREAKING: Trump FEDERALIZES D.C. To RESTORE Law & Order | The Rift | Ryan Matta, Olivia Krolczyk + Braeden Sorbo
11.3K2 -
LIVE
megimu32
2 hours agoOTS: Breakfast Nostalgia + Blind Chocolate Cereal Showdown… LIVE! 🍫🥣
139 watching -
LIVE
LIVE WITH CHRIS'WORLD
9 hours agoLIVE WITH CHRIS’WORLD - It’s Called LAW & ORDER
145 watching -
11:07
AlaskanBallistics
1 day agoBreek-Lok Quick Detach Hub Mount and Flash Hider System Review
2.92K -
57:44
Donald Trump Jr.
6 hours agoExclusive Interview with Deputy Secretary of State Chris Landau | Triggered Ep266
92K40 -
58:40
BonginoReport
10 hours agoModern Dating Woes & How To Resist Temptation w/ Tilly Dillehay - Hayley Caronia (Ep.109)
31.9K14 -
53:55
The Quiet Part
9 hours agoThey Want You to Sign Over Your Life Insurance—So They Can Keep Lying to You
11K9 -
1:47:05
The Mike Schwartz Show
6 hours agoTHE MIKE SCHWARTZ SHOW Evening Edition 08-11-2025
13K4 -
DVR
Quite Frankly
6 hours ago"D.C. Crackdown, Weekend News, World-Changing Inventions" 8/11/25
12.8K4