How to Make a Budget Template in Excel - Budget versus Actual Cost!

👍 Ready made and ready to use.

How to make the best budget template in Excel, with the budget versus the actual cost, with a chart to track your budget and track your costs as they evolve over time.

Ideal for your next project!

There are some great Excel tricks in this video, from adding up every second row, to creating a cumulative total, to creating a chart with empty spaces if the values are blank.

#Excel #Budget #Template #ProjectManagement

[Lelapeace]

Wow
Thank you for zooming ur worksheet for us

Showing clear visual is very helpful

[rogerwillis]

Excellent! A little fast explanation, but I can pause all day long to get this program to be fully functional. Thanks!

[jesselynchoo]

You are such a wonderful instructor!! instruction is very clear and thorough in such a timely manner. Thank you so much for sharing this video. Extremely helpful. Thanks you so much!

[rob]

Your videos have been/are an amazing resource - thank you!

[rsavitri]

Somehow stuck for the array on the total budget/cummulative :(

[ztoobez]

Love your videos David. I just recently came across them, and now I'm thinking, if I only would have had access to these tools sooner. Anyway, great stuff. Thanks!

[MA-knop]

Hi David, Will it be possible to explain this formula in detail please and thanks! =SUM(E6:13*(MOD(ROW(E6:E13), 2)=0))

[eleanorpikes]

What a lovely video, really useful. God bless.

[RobertWoodman]

Hi, David. This spreadsheet will be an extremely useful template for me. However, I have a question. Starting at 5:49 in the video, cell E9 (actual spend of budget item #2, March 2023) is formatted red (showing spending over budget), but the budgeted amount is $7, and the spend is $6. So, I'm confused. Is there a formula problem or a conditional formatting problem?

[jesslovesanimalvideos]

Can you make slower step by step version!?

[miftakhululum]

Hi Dave, I am Miftah could youl please repeat part of the coloring if over budger red color and under or equal budget is color green. thank you.

[amirsyazwan]

very good explaination sir..❤
may i know sir, how about if cumulative graph for forecast vs actual is same value?

[kennyanaedozie]

Great tutorial but only if you had slowed down considering not everyone is an excel wizard.

[davidagiraldo]

How do I make the x-axis reflect the date, as in each day of the year with a mmddyyyy format?

[MrPherez]

row 8 and 9 budget is 7 and when 6 is put why do we still see it turn to red ?

[geeman]

Agreed need to set through so we can follow the excel use
Also is it possible to get the template of this as a download.

[glendagentry]

Can you slow down on the clicking things a little. I have to pause and rewind a bunch to figure out what you're actually doing because I'm not used to using spreadsheets. Thanks.

[lauramartinez-pettit]

When I copy the conditional format for the "Actual" data rows to new rows below, the rule doesn't automatically compare to the cell directly above. Instead, it compares to the original cell value the rule was created for. Anyone know how to correct this?

[uvsluiq]

very fast! useless because I have to pause it everytime to understand which is very irritating

[pradyumnasatapathy]

Awful. If you know excel, doesn't mean everyone know excel. So why dont you go slow and explain. Dont show off