How to Create a Sprint Burndown Chart in Excel

Рет қаралды 103,178

Күн бұрын

⭐️⭐️⭐️ GET THIS TEMPLATE PLUS 52 MORE here: www.etsy.com/au/listing/11998...
👍 Ready made and ready to use.
How to Create a Sprint Burndown Chart in Excel
(More accurate) Timestamps:
00:20 What the chart will look like
00:46 Starting with a blank sheet
06:10 The formulas for the burndown matrix
08:45 Colouring the burndown matrix
09:45 Creating the Sprint Burndown Chart
10:15 Choosing our correct chart labels
Ideal for an Agile team and a great way to create the chart in Excel so you don't have to rely on other programs or systems.
#Agile #Burndown #Excel
Excel and Project Management playlist here: • How to Create Excel an...

Пікірлер: 65

@StephanieDeMeritt-tt2bt 2 ай бұрын

David M. is just the best. I feel like I can tackle anything listening to his encouraging voice. :)

@salsabilafirdaussauna 2 ай бұрын

belum pernah nemuin content creator yg mbikin time stamp huhuhu terharuuu thank youuu

@lpaone01 Ай бұрын

Yes, he is a great mentor.

@joshuacobbinah5610 Жыл бұрын

Your video's helped me pass my PMP, Thank you so much

@ninjitown23 2 жыл бұрын

Just to help David, at 8:20, use the formula of =D12-($D$12/COUNT($E$5:$N$5)). You can drag this across, and even beyond what you have, and if you add additional days in Row 5, or change the ideal trend in D12, the formula will adjust the time used automatically. cheers!

@davidmclachlanproject 2 жыл бұрын

Very nice, thank you! 🙂

@ninjitown23 2 жыл бұрын

@@davidmclachlanproject Welcome David, and thank you for the tutorial. The chart was very helpful for my project. :)

@ganeshgulhane8814 2 жыл бұрын

This is for first time I have heard & seen burn down, amazingly explained and learnt it.

@addiseshetu1532 2 жыл бұрын

Excellent presentation with perfect pace and content. Thank you!

@shiprakumar442 3 жыл бұрын

Amazingly detailed tutorial,helped me alot.

@rajasekharkolli3979 3 жыл бұрын

Brilliant David - Just Crisp and Clear :) Please keep doing more videos

@HungNguyen-si2xe 3 жыл бұрын

Amazing, unreal, thx so much David. Best wishes on everything you do.

@Mayaadyby. Жыл бұрын

Perfect in explanation & details combine with your positive energy!

@venkatgrandhi9866 3 жыл бұрын

Simple , neat and effective !! Thank You So much !!

@kommisettyveerendranath53 Жыл бұрын

Thank you David, for the detailed explanation.

@nidhi10sharma Жыл бұрын

Thank you, David! You made it look so easy and interesting.

@elemichoue 3 жыл бұрын

Thank you so much! That was so helpful to me! God bless you!

@ranpil04 2 жыл бұрын

You are a Savior !!! Thank you - very informative and very helpful !

@batasahoo6931 Жыл бұрын

You saved my day. Amazing explanation.

@manishbpm Жыл бұрын

The superb way you have explained, thank you!

@RichFinelli Жыл бұрын

Really nice job, exactly what I needed!

@narayananshiva1822 Жыл бұрын

Even I had enjoyed a lot your instructions are very informative I love it buddy keep up the good work My dear Friend

@ankur1606 2 жыл бұрын

thank you...very well explained. Helped me alot.

@adrynnovak3648 3 жыл бұрын

thank you for the lesson!

@ebereasogu8392 Жыл бұрын

Amazing. Thank you so much.

@danylokuzemskyi2394 3 жыл бұрын

David, thanks a lot 🙌

@santuchatterjee823 3 жыл бұрын

excellent tutorial

@AnimSparkStudios 3 жыл бұрын

Awesome work

@rahmadhidayat8771 3 жыл бұрын

thanks for the explanation

@vinodkumar-cs4xi Жыл бұрын

Just amazing 👏 sir

@thambuisaac 3 жыл бұрын

this is very helpful

@audreydetsaboun6098 2 жыл бұрын

Hi, thank you so much for this tutorial. For the ideal trend I used this formula : =D12-($D$12*10/100) at E12 and then dragged this to N12

@davidmclachlanproject 2 жыл бұрын

Nice one Audrey! 👍🙂

@hipockt4 Жыл бұрын

Very good

@faizelsm9555 11 ай бұрын

Could you explain the formula pls.. I didn't know how the equation works

@jaimishra8576 Жыл бұрын

Very helpful

@olaabdull6428 2 жыл бұрын

Thank you

@sivakumargami 2 жыл бұрын

nice job, thanks

@manasrautela3645 2 жыл бұрын

🙏 Thank you

@omerhatim4326 Жыл бұрын

Thanks

@rollandwinneruruna 2 жыл бұрын

thanks

@tenebrae1191 Жыл бұрын

👏👏

@arjunpalakkatan1519 Ай бұрын

Hi David, just Hank you for the video and I have a doubt about how to take the efforts estimation I did using Poker Estimation to Burn-down Chart? I am totally confused because most of the numbers you provided here is one right.

@mmmmkay4773 8 ай бұрын

Cool! But as long as you've reached the deadline at the agreed time, is this chart really even needed? Just wondering

@Own_stories11 2 ай бұрын

why did you divide ideal trend with 1,2,3 and so on. Would it be same for any chart having different number of estimated days?

@ceciljackson3068 2 жыл бұрын

David thanks for sharing, I purchased the 52 Templates and the Knowledge Worker's Toolbox, this is great stuff. Nice to have one accurate source for this information. This will help me with my PMP Preparation, exam scheduled on 04/20. Do offer one-on-one training in these areas ? Thanks again for sharing! Cecil

@davidmclachlanproject 2 жыл бұрын

Thank you! Good luck for your exam 🙂 (I'm sure you've already seen the 200 Agile questions, but that seems to help people pass) I don't do 1:1 currently but am working on new content all the time 🙂

@ceciljackson3068 2 жыл бұрын

Great, looking forward to reviewing future material. Yes, I've seen the 200 Agile Qs in 2021, I watched some of your videos on Agile Qs for the PMI-ACP Exam! Very helpful in breaking down the questions, your explanations helped reduce my learning curve. thanks again! Cecil

@ismailiam7195 2 жыл бұрын

Thanks for this interesting video, I have a question the numbers in the day1 column for example (1 corresponds to a working day?). When we have a number 2, does it mean that we need 2 men working during a day1?

@davidmclachlanproject 2 жыл бұрын

Hey Ismail, you are right! The days correspond to working days, and usually there are 10 working days (2 weeks) in a sprint. For the estimates, these are usually estimates on effort required. They can be different per team (whatever the team decides) and could be relative/broad sizings using the Fibonacci sequence (most common, i.e. 1, 2, 3, 5, 8, 13), or based on hours, or people, or anything else you choose.

@coolmeenmac761 8 ай бұрын

Apologies a silly question perhaps. At 5:56. Day 2 Aug 11. If one assumes 1 Day effort equates to 8 hours for 1 person ? Does this mean on that day 7 people are required to meet the tasks recorded? 1+2+1+1+1 ? ?

@ATLBOI1000 3 жыл бұрын

Hello David! I have a question regarding the Backlog ID and User Stories. What actually goes there? I’m trying to do a burn down for a new system transition and have 100 associates

@davidmclachlanproject 3 жыл бұрын

Oh that is an excellent question 🙂 let me know if I haven't understood correctly, but the ID can be anything you choose - a unique identifier like 001, 002 etc. The user stories are the small chunks of work, that together will make up a feature you want to release. In your case, it might be the individual tasks that make up the overall system transition. If 100 associates is too much for one matrix/chart, you could bundle some together, by team or area, for example.

@tareqmamun 2 жыл бұрын

I wish if you could add the template in the download section.

@Urmy998 2 жыл бұрын

Dear David thank you so much for your great explanation. Under feature 2, you put three days but you didnt actucally spread three days in this row, you spread only two. You typed the third day but it didnt go through. could you please tell me in other worsd what does it mean minus 2 or any number? Kind regards Guilda.

@davidmclachlanproject 2 жыл бұрын

Yes certainly 🙂 the minus numbers will add extra effort (above the estimate). You could also change the estimate and use normal numbers, though 🙂

@hipockt4 Жыл бұрын

You mentioned all the way down to 0 but could not see what was behind your head. Other than that very nice information.

@sabaaali2457 2 жыл бұрын

Great video, Can we add actual performance, please tell

@davidmclachlanproject 2 жыл бұрын

We could, either by adding the forward and backward pass details manually in each cell, or automatically with a formula. The challenge is that our schedule may not follow activities 1, 2, 3 etc - a path may go 1,4,5 for example. My video on critical path calculations is here kzfaq.info/get/bejne/hNuZZrynq7yaZKM.html

@sabaaali2457 2 жыл бұрын

@@davidmclachlanproject Thank you very much. It is great help

@MrNikhil1602 3 жыл бұрын

Hey, When I'm trying to do that keeping the same data, I am getting different data for remaining effort🙄

@solomonjuniorabebe8601 Жыл бұрын

but what if we wanted to update the graph day by day, not at once at the end? how can we do that?

@mrudangtrivedi4181 3 жыл бұрын

Did not get it for my sprints which have 14 days of one of the tasks.

@davidmclachlanproject 3 жыл бұрын

That's a great point to bring up Mrudang. When sprint planning, it's usually preferred to break cards down into smaller bits where possible. But if it's not possible, I reckon we could increase the sprint size in this sheet. Just add the columns you want, and make sure to divide the "Ideal trend" cells by the new number of days (i.e. 14 instead of 10), and multiplying them by 1 through 14 instead of 1 through 10 (i.e. /14*1 to /14*14)