Create a Basic Burndown chart in Excel in 3 Minutes - Very simple

No video

Create a Basic Burndown chart in Excel in 3 Minutes - Very simple | NiksProjects

Рет қаралды 97,897

Күн бұрын

My Project Management Master Class: www.niksprojec...
Tutorial on how to create a basic burndown chart in 2 minutes.
If you are managing a project you will come across a request from the stakeholders to present the burndown chart of your project. In this video I will go over
1. What is Burndown Chart
2. What is the importance of Burndown Chart
3. How to create a Burndown Chart in
#burndownchart #agile #exceltutorial #excel

Пікірлер: 154

@niksprojects 4 жыл бұрын

Skip to 2:59 if you want to quickly jump in to creation of burndown chart in Excel. Also check out and pre-order my Project Management Master Class for a 75% discount for Pre-Orders at www.nikscourses.com

@cmonaco577 4 жыл бұрын

Not a lot of extraneous chatter. Concise and to the point. Bravo and thank you!

@niksprojects 4 жыл бұрын

Thanks for the feedback and glad you enjoyed watching

@rajdranmr Жыл бұрын

This is the best example of burndown chart I have seen on KZfaq. Thank you for this !!!!!!

@niksprojects Жыл бұрын

Glad it helped

@afualesly Жыл бұрын

This is the best example of burndown chart I have seen on KZfaq. Thank you for this visual representation!!!!!!

@niksprojects Жыл бұрын

Glad it helped

@superjzh 2 жыл бұрын

Nice and clean. Thanks

@niksprojects 2 жыл бұрын

Thanks

@sazopro Жыл бұрын

Thank you for being precise to explain the burndown chart! Instant subscription!

@niksprojects Жыл бұрын

Thanks so much, appreciate you subscribing to the channel

@kuvaraigwauchifamba7307 2 жыл бұрын

You are the G.O.A.T top man. Straight to the point. No BS all over the show. Thank you

@niksprojects 2 жыл бұрын

thanks

@keerthinayak9281 4 жыл бұрын

Hi Nikhil, The description about burndown chart is simple and neat!.

@niksprojects 4 жыл бұрын

Thanks Keerthi for watching and appreciate the feedback, glad you enjoyed the content

@adriankasa4339 3 ай бұрын

Thank you very much. I was struggling to do the burn down on an excel. Your video made it look very simple. Keep up your good work. You got one subscriber.

@niksprojects 3 ай бұрын

Glad it helped

@LOKO32100 2 жыл бұрын

Thank you so much for your insights.

@niksprojects 2 жыл бұрын

You are welcome

@niksprojects 4 жыл бұрын

With the popularity in Agile, the Burndown chart is something that leaders are looking for from the PM's for all kinds of project irrespective of the project is Agile or not. So when you are asked to Produce burndown for non-agile projects or non-sprint related items (ex: just for testing activity etc.) you can use excel to create burndown chart.

@gustavomonte6672 2 жыл бұрын

Thanks man, really helpful!

@niksprojects 2 жыл бұрын

Glad it helped!

@olujuwonoladunjoye8706 3 жыл бұрын

Thanks for the video. Very detailed

@niksprojects 3 жыл бұрын

Glad it was helpful!

@laurenbowser5587 4 жыл бұрын

Thank you!! Love this quick and concise tutorial!

@niksprojects 4 жыл бұрын

Thank you! Glad you like it

@chuniorferreira Жыл бұрын

you're awesome Nik! 🔥 Thank you for this video, was exactly what i nedded!

@niksprojects Жыл бұрын

Glad it helped

@pranayvlogs5726 2 жыл бұрын

Great explanation thank you.

@niksprojects 2 жыл бұрын

Thanks

@mrrownel 3 жыл бұрын

10 points! Simple and effective. Thank you!

@niksprojects 3 жыл бұрын

Thanks so much for the feedback!

@DivaDerin Жыл бұрын

Thank you so much Niks. This was simple to understand and helpful. Well done.

@niksprojects Жыл бұрын

Glad it helped

@msshirgaonkar Жыл бұрын

Mentioned very well in a Nutshell. THANK YOU !

@niksprojects Жыл бұрын

Thanks

@ricklonghi909 3 жыл бұрын

Exactly what I needed for upper management for my waterfall project. Thanks!

@niksprojects 2 жыл бұрын

Glad it was helpful!

@rahulsinghal3880 3 жыл бұрын

Thanks for well explained.👍

@niksprojects 3 жыл бұрын

You are welcome

@prabinchitrakar2968 3 жыл бұрын

Thank you for the simple, easy-to-follow explanation.

@niksprojects 3 жыл бұрын

Thank you, glad it helped

@amol6242 4 жыл бұрын

Thanks for information. Explained in very simple way.

@niksprojects 4 жыл бұрын

Thanks for watching

@divyanshigupta3667 8 ай бұрын

Thank you I got more clarity on this topic

@herathprabodha 4 жыл бұрын

Thank you for the simple and very clear explanation 👍

@niksprojects 4 жыл бұрын

You are welcome, thanks for watching

@pimptown007 Жыл бұрын

Thank You...Very Easy to follow

@askdhuwuw 3 жыл бұрын

So simple and easy, thank you so so much!!

@niksprojects 3 жыл бұрын

Glad it helped!

@ntombizamimkhwanazi7547 3 жыл бұрын

Thank you for the simply, easy to follow explanation.

@niksprojects 3 жыл бұрын

Thanks so much

@gautamdeepkaur1619 3 жыл бұрын

This was a helpful video, concise yet detailed. Thank you!

@niksprojects 3 жыл бұрын

Glad it was helpful!

@user-hf2hp8kz4v 5 ай бұрын

What an explanation! You made it look se seamless and, in fact fun! Thanks a lot!

@vbond0007 3 жыл бұрын

Concise and precise. Great video, appreciate your efforts. Thank you.

@niksprojects 2 жыл бұрын

Glad it was helpful!

@Raining76 11 ай бұрын

Precise .. well explained.. thank you for this video .. 👍

@maheshaher3658 3 жыл бұрын

Thanks a lot for the very detailed video!

@niksprojects 2 жыл бұрын

You are welcome

@misaelmelchia 3 жыл бұрын

Excelent man!!! its helps me a lot!!! easy and fast, Thanks!!!!

@niksprojects 3 жыл бұрын

Thanks, glad it helped

@gabrielservices7433 3 жыл бұрын

Thank you man, you helped me a lot.

@niksprojects 3 жыл бұрын

Glad it helped! Thanks for the feedback and watching.

@shirshodatta2886 2 жыл бұрын

Great video

@niksprojects 2 жыл бұрын

Thanks

@Move_My_Peeps 3 жыл бұрын

Very easy to follow. Thank you, Nik. Subscribed and liked!

@niksprojects 3 жыл бұрын

Awesome, thank you!

@ambarkumar4977 Жыл бұрын

Thank you for that great explanation 🙏🙏

@niksprojects Жыл бұрын

Glad it was helpful!

@tenebrae1191 Жыл бұрын

👏👏

@baby13tina 3 жыл бұрын

Thanks 👍i've followed your instructions to come out with my burndown chart..

@niksprojects 3 жыл бұрын

Thanks please subscribe if you haven’t already

@Ganstagrillz10 3 жыл бұрын

Well done. Thanks so much for posting.

@niksprojects 3 жыл бұрын

Glad you enjoyed and hopefully helped!

@AncestralGratitude85 2 жыл бұрын

Concise! And for that reason -- I'm subbed 👍

@niksprojects 2 жыл бұрын

Thanks! Glad you liked it

@kapilmsit 2 жыл бұрын

Thank you!

@niksprojects 2 жыл бұрын

You are welcome

@lifeisgood5681 3 жыл бұрын

Very nice ! Thank u

@niksprojects 3 жыл бұрын

Welcome 😊

@andrewwilkes963 3 жыл бұрын

Damn, I wish you were a professor at my college. You could really teach us some valuable skills. Thank you for this video.

@niksprojects 3 жыл бұрын

That means a lot! thanks for the appreciation.

@jackadamsdaniels6719 2 жыл бұрын

Thank you for this

@niksprojects 2 жыл бұрын

You got it

@sreejith93 2 жыл бұрын

This is really good. Thanks bro. Good practical knowledge.

@niksprojects 2 жыл бұрын

Thanks! Glad it helped

@elvirovelasquez8097 Жыл бұрын

Thanks a lot

@niksprojects Жыл бұрын

Happy to help

@curiousgalt 2 жыл бұрын

Thanks this hepled a lot

@niksprojects 2 жыл бұрын

You are welcome

@amitavanath4393 3 жыл бұрын

it was really great and easy to follow

@niksprojects 3 жыл бұрын

Thanks for your positive feedback, glad it helped

@Sqagg 3 жыл бұрын

Thanks heaps man. This explained it very well.

@niksprojects 3 жыл бұрын

Glad to hear and appreciate your feedback!

@SevenAnomone224 3 жыл бұрын

Great video thanks for the instruction. And for making project mgt look a bit cooler than usual! ;)

@niksprojects 3 жыл бұрын

Thanks. Ha ha we try to hide the stress behind the job ;-)

@therealtoocoll Жыл бұрын

Awesome thanks 🙏🏾

@niksprojects Жыл бұрын

No problem 👍

@cottrellcoding3665 3 жыл бұрын

Thank you, this is a great lesson.

@niksprojects 3 жыл бұрын

Thanks

@niteshsaini14 2 жыл бұрын

Thanks Niks, Can you also share a video for Burn up chart and how to draw it ?

@davidseedbaker 3 жыл бұрын

Thank you, you’re awesome!

@niksprojects 3 жыл бұрын

Thanks so much, appreciate your encouragement.

@miguelito7989 4 жыл бұрын

Easy to follow. Thanks!

@divyagudapola2186 3 жыл бұрын

Excellent explanation! Thanks for sharing On side note please let me know if you have any time to give a walk through or training on Scrum and PMP practices

@mithunchakraborty9840 4 жыл бұрын

Well done. Thank You.

@niksprojects 4 жыл бұрын

Thanks 😊, just creates a tutorial on how to create the same in PowerPoint

@srinibassahu893 4 жыл бұрын

very good niks , kindly upload more vedio

@niksprojects 4 жыл бұрын

Thanks! Glad you enjoyed the content and found useful

@mortgagediva Жыл бұрын

Thank youuu

@niksprojects Жыл бұрын

You are welcome

@RajeshKumar-0101 2 жыл бұрын

Very useful. One query what is the difference between Kanban board and burndown chart

@niksprojects 2 жыл бұрын

Kanban board is where you can see all task details and in which queue it is currently- To-do column vs In-Progress or Done column. Burndown chart show the progress quantitatively , meaning you will know out of let’s say 50 tasks how are we progressing on the completeness on track vs off track . I made a video about how to create a burn down chart in excel on this channel and I have explained it in that video as well

@mkarmakar3038 3 жыл бұрын

Thnks. that helps

@niksprojects 3 жыл бұрын

Thanks for watching and for the feedback

@m.derakhshan6464 4 жыл бұрын

thanks, it was really helpful

@niksprojects 4 жыл бұрын

You are welcome

@malikmoazzam1907 4 жыл бұрын

I like your very Polite way of talking style.

@niksprojects 4 жыл бұрын

😀 thank you

@TobyMole 2 жыл бұрын

Only works for line chart if your first column is dates. If you have, say week numbers., then excel picks arbitrary numbers for the x-axis and you need to edit the chart to beat it into submission to use the data it is supposed to.

@pedroribeirodacruzpeixoto3678 4 жыл бұрын

Thanks man!

@niksprojects 4 жыл бұрын

You got it

@lukbabalis 3 жыл бұрын

Hi! Great video, I have a question however. Let's say that the team plans to do more tasks in a following week. Does it make any sense? In your example, we have a downward trend which is not always the case.

@niksprojects 2 жыл бұрын

If the tasks are not done the the line will be flat and once the tasks are done then the actual line will come down.

@hajimd2983 3 жыл бұрын

It's was really nice way to create burndown chat in Excel and great way to explain.. thumps up.. - Can we connect on LinkedIn.. and do you provide Project Management Training as well?

@niksprojects 3 жыл бұрын

Thanks for the feedback and for watching! Glad it helped, I dont do project management training as I am full time working on my day job :-) I create these videos as a help to other fellow PM's. I started creating a course on MS Project training which I thought could sell as online course, but I wasn't sure how many would be interested so I put that on hold. If you can tell me what you are looking for, may be I can create some KZfaq video around those answering those questions.

@Sriyanshim 3 жыл бұрын

How often does burndown chart track the project’s/teams progress?

@niksprojects 3 жыл бұрын

Ideally daily

@katerynaturchenko6937 4 жыл бұрын

Thank you very much, Nikhil! One question: why do you add weekends at all? Can we just skip them?

@niksprojects 4 жыл бұрын

You are welcome. Yes there is no need to add weekend, we can skip them. For some projects the workdays include all 7 days hence I kept it there

@shrinathjadhav6120 3 жыл бұрын

Good Job , Man :)

@niksprojects 3 жыл бұрын

Thanks a lot. I love your bike.check out my other channel TLY Rider, I am sure you will like what you see there since I am also in to Motorcycle 😊

@jatinitsok6756 4 жыл бұрын

Hi Niks, as always a magnificent explanation. Please reply my question ( I have already asked but you didn't reply) - I am into Software Testing field with 10+ years (including 1 year in Test Leading). How can I switch my domain by doing CSM & PMP? Thank you so much in advance ! :)

@niksprojects 4 жыл бұрын

Sorry for the late response, I thought I replied earlier. Anyway I would say certification comes in handy when you are in the job market. It helps yo filter out others from the competition those who don't have the certification, sometimes PMP is a must for some jobs and by having certification you will have that criteria satisfied. Once you get your job interview the try to relate your testing lead experience as general overall project management. Example for testing you still have to plan to come up with test plan, you still have to manage testing resources so thats your resource management plan so on and so forth. You can switch to full PROJECT Management within your current organization and the. Show that experience when applying outside. Or be confident and apply outside and make the switch in the new organization. If you are still not comfortable may be start as project coordinator or PM assisting a program manager so you can learn from the program manager before taking full PM role

@svmanka 4 жыл бұрын

Thanks , it was a big help

@niksprojects 4 жыл бұрын

Thanks for the feedback, glad it helped

@niksprojects 4 жыл бұрын

Svmanka- please consider subscribing to this channel if you are interested in Project management career related topics

@svmanka 4 жыл бұрын

@@niksprojects yes I already subscribed

@niksprojects 4 жыл бұрын

Awesome, appreciate your support

@bhaskarshukla637 Жыл бұрын

Why to show weekends ?

@jasminsavani1583 2 жыл бұрын

you skip that which chart you selected?

@niksprojects 2 жыл бұрын

I selected the line chart

@jasminsavani1583 2 жыл бұрын

i select the treadline for unequal production rate and i draw tread line for linear, it does not pass through all points

@jasminsavani1583 2 жыл бұрын

thats my assignment for tomorrow

@atoril1 3 жыл бұрын

What if scope is added?

@niksprojects 2 жыл бұрын

you update the quantity from the date the scope is added, so the grey baseline will get adjusted accordingly. Eventually even with the new scope the tasks has to come down to zero at the end.