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 - ua-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

[@prakashrao3607]

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

[@Sekoleyte]

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

[@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.

[@nabilsaadrahman7314]

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

[@chrism9037]

Awesome as always, thanks Chandoo!

[@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.

[@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.

[@StefunnyStrange]

THANK YOU!

[@Kiranmai30]

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

[@cshahed]

absolutely awsome

[@sayan42]

Great content

[@Mutyrf]

You're the best bro ❤❤

[@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

[@nishantpurohit100]

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

[@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

[@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

[@khanabdullah4121]

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

[@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?

[@yaseerMeha]

Thanks, let's do PowerPoint presentation tips

[@Parneetkaur20998]

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

[@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?

[@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

[@shajikp1414]

Is it work in Excel 2007?

[@TractorUlagam]

First of all love thalaivar poster on the door 😂

[@chandoo_]

😎

[@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.

[@ivaaan8995]

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

[@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