How-to Calculate Project Critical Path using Excel

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

Рет қаралды 25,133

10 ай бұрын

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-excel-template/
~
⏱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-excel-template/
📺 More on Project Management using Excel
=====================================
Gantt chart with Excel
kzfaq.info/get/bejne/jZ1-ia6bzJuaio0.html
Project Dashboard with Excel
kzfaq.info/get/bejne/fL6erK6Gm96-lX0.html
Team calendar with Excel
kzfaq.info/get/bejne/bZaelqyWr6uogo0.html
To-do list with Excel
kzfaq.info/get/bejne/o6dpZrCCzLG2hJc.html
Ready to use Excel Project Management Templates
chandoo.org/pmt/pmt-index-1.html
~
#projectmanagement #criticalpath

Пікірлер: 37

@haria2387 10 ай бұрын

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

@chandoo_ 10 ай бұрын

Sure. Please watch the Project Management videos playlist here - kzfaq.info/sun/PLmejDGrsgFyCS0n1GEXRuzxjK9wAXFNGo

@purnimabagweeducation4960 10 ай бұрын

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 10 ай бұрын

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

@prakashrao3607 10 ай бұрын

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

@AkshataShingote 21 күн бұрын

So well explained!

@HamdanYouTuber 10 ай бұрын

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

@abhishekupadhyay6938 10 ай бұрын

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 10 ай бұрын

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

@chrism9037 10 ай бұрын

Awesome as always, thanks Chandoo!

@canirmalchoudhary8173 9 ай бұрын

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

@Kiranmai30 10 ай бұрын

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

@StefunnyStrange 2 ай бұрын

THANK YOU!

@blairhall8379 10 ай бұрын

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!

@cshahed 10 ай бұрын

absolutely awsome

@purnimabagweeducation4960 10 ай бұрын

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

@sayan42 10 ай бұрын

Great content

@Mutyrf 10 ай бұрын

You're the best bro ❤❤

@khanabdullah4121 4 ай бұрын

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

@julianasmith5833 9 ай бұрын

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

@nishantpurohit100 10 ай бұрын

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

@paulmartinlife 10 ай бұрын

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

@chandoo_ 10 ай бұрын

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

@paulmartinlife 10 ай бұрын

@@chandoo_ great, many thanks

@yaseerMeha 9 ай бұрын

Thanks, let's do PowerPoint presentation tips

@ICTNuggets 10 ай бұрын

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?

@Parneetkaur20998 9 ай бұрын

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 4 ай бұрын

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?

@TractorUlagam 10 ай бұрын

First of all love thalaivar poster on the door 😂

@chandoo_ 10 ай бұрын

😎

@goutamnayak5011 10 ай бұрын

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

@pawemajewski2430 10 ай бұрын

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.