How-to Calculate Project Critical Path using Excel - Step by Step Tutorial

Do you know that we can automatically calculate the critical path of a project using Excel formulas? In this video, let me explain the theory and calculation logic for figuring out the CRITICAL PATH using Excel.
Bring your hardhats, it's going to be MINDBLOWINGLY AWESOME!!!
For a free Critical Path template & more explanation, visit 👇
chandoo.org/wp/critical-path-...
~
⏱In this video
============
0:00 - What is Critical Path and why it is relevant in Project Management?
1:00 - Demo of Critical Path calculator workbook
1:42 - What is Critical Path Analysis and how to do it? (with a demo)
5:46 - Slack / Float explained.
6:10 - Forward vs. Backward Pass explained.
7:09 - Critical Path Calculations in Excel
8:36 - Formulas for Earliest Start (ES) and Earliest Finish (EF)
11:00 - Formulas for Latest Start (LS) and Latest Finish (LF)
12:08 - Calculating Float (Slack) per activity and what it means?
13:38 - Using Excel for other Project Management Stuff
📁 Critical Path Calculator Workbook
===============================
For a free Critical Path template & more explanation, visit 👇
chandoo.org/wp/critical-path-...
📺 More on Project Management using Excel
=====================================
Gantt chart with Excel
• Advanced Gantt chart i...
Project Dashboard with Excel
• Make an awesome Projec...
Team calendar with Excel
• Kick start the year wi...
To-do list with Excel
• Make a beautiful and i...
Ready to use Excel Project Management Templates
chandoo.org/pmt/pmt-index-1.html
~
#projectmanagement #criticalpath

[@haria2387]

Please make more content on Project Management Chandoo. Loving your content.

[@chandoo_]

Sure. Please watch the Project Management videos playlist here - th-cam.com/play/PLmejDGrsgFyCS0n1GEXRuzxjK9wAXFNGo.html

[@purnimabagweeducation4960]

This is really helpful I request you to make videos on assembly planning and line balancing how to do it in excel with 200-300 jobs going through 20-30 operations

[@Sekoleyte]

It's a lesson from universities for civil engineers and you tell it with automation in excel. Congrats and thanks for your effort.

[@prakashrao3607]

Thank you for giving such a clear explanation of Critical Path Method and use of Excel for the same!

[@AkshataShingote]

So well explained!

[@HamdanYouTuber]

I'm still trying to understand Excel, and your channel is one of the channels for learning Excel.
Thank you for everything.

[@abhishekupadhyay6938]

Very good sir. Everytime someone thinks that they know many things in Excel, you come up with new gem. Thank you for sharing this knowledge.

[@nabilsaadrahman7314]

I just love the way of your presentation.. So comfortable with it..

[@StefunnyStrange]

THANK YOU!

[@blairhall8379]

Nice. It would be interesting to see if you could attempt to solve Guan's route problem (or the route inspection problem) where the goal is to identify the path that optimizes a route to traverse every path in a given map. I would be super interested in seeing how Excel might be able to help with that. Thanks!

[@canirmalchoudhary8173]

This is awesome formula combination. So much brain is involved here to decode it. Thanks to article.

[@chrism9037]

Awesome as always, thanks Chandoo!

[@Kiranmai30]

With this video i can memorize my ug studies, operations research classes.
Thank u

[@purnimabagweeducation4960]

This is really helpful I request you to make videos on assembly planning and line balancing how to do it in excel with 200-300 jobs going through 20-30 operations

[@cshahed]

absolutely awsome

[@Mutyrf]

You're the best bro ❤❤

[@julianasmith5833]

Hi. This is great! I’m just wondering if it could be done in Power Bi as well? Perhaps using some of the PATH functions? Thanks a lot

[@sayan42]

Great content

[@khanabdullah4121]

Thank you sir just explain how to draw a CPM diagram in excel

[@nishantpurohit100]

Hi Chandoo, make some videos on demand planning, forecasting, supply chain analytics.
Thanks

[@paulmartinlife]

That's very useful, Chandoo. Could you also share the conditional formatting formula?

[@chandoo_]

The formula goes like this:
=$L7=0
You can see the formula and more explanation here - chandoo.org/wp/critical-path-excel-template/

[@paulmartinlife]

@@chandoo_ great, many thanks

[@ICTNuggets]

Chandoo G, do you think that learning Excel, Power BI, and SQL to their full extent is sufficient to become a data scientist, or should we also consider learning other tools like Python, Matplotlib, Seaborn, and ggplot2? In short what is most important to become a more professional data scientist?

[@antonpersson5456]

Hi!
Great video!
However, I'm running into problems when I have more than two predecessors. I get the error message "#VALUE!".
What can I do fix this?

[@Key2success786]

Can you make a video on how to use excel for management information system , in short what a mis executive has to do in excel

[@goutamnayak5011]

Sir as a ms Excel export please clear my doubt, copilot 365 will available in ms Excel and other ai tools, so as beginner should I learn ms Excel deeply all functions and advance formulas
Or I can do all ms Excel works by using copilot and other ai tools???
What should I do

[@yaseerMeha]

Thanks, let's do PowerPoint presentation tips

[@pawemajewski2430]

hi. i have problem with my excel file. i am use macros and always try to make my program better and better. but for some reason start getting more memory by self and now it is impossible to work on it :/ my excel can extend even 1 Mb more when i use this file.any help please.

[@TractorUlagam]

First of all love thalaivar poster on the door 😂

[@chandoo_]

😎

[@ivaaan8995]

what was the formula for LS? I think you did not include it huhuhu

[@shajikp1414]

Is it work in Excel 2007?

[@shekharsinghtomar4489]

Hey Dear, any thought on hiring a video editor?

[@user-yb9ht9qz8h]

Sorry chandoo, I want you to help me something, can we talk please

[@proximacentaur1654]

Dad joke countdown