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

[@niksprojects]

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]

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

[@niksprojects]

Thanks for the feedback and glad you enjoyed watching

[@niksprojects]

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.

[@rajdranmr]

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

[@niksprojects]

Glad it helped

[@superjzh]

Nice and clean. Thanks

[@niksprojects]

Thanks

[@LOKO32100]

Thank you so much for your insights.

[@niksprojects]

You are welcome

[@msshirgaonkar]

Mentioned very well in a Nutshell. THANK YOU !

[@niksprojects]

Thanks

[@sazopro]

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

[@niksprojects]

Thanks so much, appreciate you subscribing to the channel

[@ricklonghi909]

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

[@niksprojects]

Glad it was helpful!

[@pranayvlogs5726]

Great explanation thank you.

[@niksprojects]

Thanks

[@olujuwonoladunjoye8706]

Thanks for the video. Very detailed

[@niksprojects]

Glad it was helpful!

[@mrrownel]

10 points! Simple and effective. Thank you!

[@niksprojects]

Thanks so much for the feedback!

[@adriankasa4339]

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]

Glad it helped

[@gustavomonte6672]

Thanks man, really helpful!

[@niksprojects]

Glad it helped!

[@rahulsinghal3880]

Thanks for well explained.👍

[@niksprojects]

You are welcome

[@laurenbowser5587]

Thank you!! Love this quick and concise tutorial!

[@niksprojects]

Thank you! Glad you like it

[@divyanshigupta3667]

Thank you I got more clarity on this topic

[@amol6242]

Thanks for information. Explained in very simple way.

[@niksprojects]

Thanks for watching

[@afualesly]

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

[@niksprojects]

Glad it helped

[@keerthinayak9281]

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

[@niksprojects]

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

[@DivaDerin]

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

[@niksprojects]

Glad it helped

[@pimptown007]

Thank You...Very Easy to follow

[@chuniorferreira]

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

[@niksprojects]

Glad it helped

[@herathprabodha]

Thank you for the simple and very clear explanation 👍

[@niksprojects]

You are welcome, thanks for watching

[@prabinchitrakar2968]

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

[@niksprojects]

Thank you, glad it helped

[@kuvaraigwauchifamba7307]

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

[@niksprojects]

thanks

[@askdhuwuw]

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

[@niksprojects]

Glad it helped!

[@ntombizamimkhwanazi7547]

Thank you for the simply, easy to follow explanation.

[@niksprojects]

Thanks so much

[@gabrielservices7433]

Thank you man, you helped me a lot.

[@niksprojects]

Glad it helped! Thanks for the feedback and watching.

[@gautamdeepkaur1619]

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

[@niksprojects]

Glad it was helpful!

[@kapilmsit]

Thank you!

[@niksprojects]

You are welcome

[@Raining76]

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

[@misaelmelchia]

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

[@niksprojects]

Thanks, glad it helped

[@maheshaher3658]

Thanks a lot for the very detailed video!

[@niksprojects]

You are welcome

[@vbond0007]

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

[@niksprojects]

Glad it was helpful!

[@shirshodatta2886]

Great video

[@niksprojects]

Thanks

[@baby13tina]

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

[@niksprojects]

Thanks please subscribe if you haven’t already

[@jackadamsdaniels6719]

Thank you for this

[@niksprojects]

You got it

[@ambarkumar4977]

Thank you for that great explanation 🙏🙏

[@niksprojects]

Glad it was helpful!

[@lifeisgood5681]

Very nice ! Thank u

[@niksprojects]

Welcome 😊

[@elvirovelasquez8097]

Thanks a lot

[@niksprojects]

Happy to help

[@Ganstagrillz10]

Well done. Thanks so much for posting.

[@niksprojects]

Glad you enjoyed and hopefully helped!

[@andrewwilkes963]

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

[@niksprojects]

That means a lot! thanks for the appreciation.

[@curiousgalt]

Thanks this hepled a lot

[@niksprojects]

You are welcome

[@AncestralGratitude85]

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

[@niksprojects]

Thanks! Glad you liked it

[@Move_My_Peeps]

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

[@niksprojects]

Awesome, thank you!

[@Sqagg]

Thanks heaps man. This explained it very well.

[@niksprojects]

Glad to hear and appreciate your feedback!

[@cottrellcoding3665]

Thank you, this is a great lesson.

[@niksprojects]

Thanks

[@amitavanath4393]

it was really great and easy to follow

[@niksprojects]

Thanks for your positive feedback, glad it helped

[@sreejith93]

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

[@niksprojects]

Thanks! Glad it helped

[@therealtoocoll]

Awesome thanks 🙏🏾

[@niksprojects]

No problem 👍

[@davidseedbaker]

Thank you, you’re awesome!

[@niksprojects]

Thanks so much, appreciate your encouragement.

[@SevenAnomone224]

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

[@niksprojects]

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

[@niteshsaini14]

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

[@tenebrae1191]

👏👏

[@mithunchakraborty9840]

Well done. Thank You.

[@niksprojects]

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

[@user-hf2hp8kz4v]

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

[@miguelito7989]

Easy to follow. Thanks!

[@divyagudapola2186]

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

[@m.derakhshan6464]

thanks, it was really helpful

[@niksprojects]

You are welcome

[@RajeshKumar-0101]

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

[@niksprojects]

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

[@mortgagediva]

Thank youuu

[@niksprojects]

You are welcome

[@MR-AK]

I’ve seen it done many ways, in your company, do you use story points or do it at the EPic level?

[@niksprojects]

Story point

[@mkarmakar3038]

Thnks. that helps

[@niksprojects]

Thanks for watching and for the feedback

[@pedroribeirodacruzpeixoto3678]

Thanks man!

[@niksprojects]

You got it

[@srinibassahu893]

very good niks , kindly upload more vedio

[@niksprojects]

Thanks! Glad you enjoyed the content and found useful

[@TobyMole]

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.

[@katerynaturchenko6937]

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

[@niksprojects]

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

[@malikmoazzam1907]

I like your very Polite way of talking style.

[@niksprojects]

😀 thank you

[@lukbabalis]

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]

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]

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]

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 KZbin video around those answering those questions.

[@Sriyanshim]

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

[@niksprojects]

Ideally daily

[@jatinitsok6756]

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]

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

[@bhaskarshukla637]

Why to show weekends ?

[@shrinathjadhav6120]

Good Job , Man :)

[@niksprojects]

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 😊

[@svmanka]

Thanks , it was a big help

[@niksprojects]

Thanks for the feedback, glad it helped

[@niksprojects]

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

[@svmanka]

@@niksprojects yes I already subscribed

[@niksprojects]

Awesome, appreciate your support

[@jasminsavani1583]

you skip that which chart you selected?

[@niksprojects]

I selected the line chart

[@jasminsavani1583]

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

[@jasminsavani1583]

thats my assignment for tomorrow

[@atoril1]

What if scope is added?

[@niksprojects]

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.

[@WandererPunekarTejas]

Nice.. Bro one reason for a your accent ?

[@niksprojects]

Thanks , you mean a confused accent ;-)

[@WandererPunekarTejas]

@@niksprojects heheh yeah its neither indian not american..so i was just checking :p

[@niksprojects]

Well it’s the internet, we have to speak a neutral accent as it is watched by all countries and not just US and India:-)

[@WandererPunekarTejas]

@@niksprojects thats true

[@VarunSharma-pn8jo]

why that acccent dude.. praaject .. LOL

[@niksprojects]

May be this will help you out kzbin.info/www/bejne/jGbYnJicbcRrhM0