Excellent! A little fast explanation, but I can pause all day long to get this program to be fully functional. Thanks!
@katicakes8824 күн бұрын
Love this!
@rob4433 Жыл бұрын
Your videos have been/are an amazing resource - thank you!
@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!
@kannank47565 ай бұрын
Informative
@jesselynchoo4930 Жыл бұрын
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!
@benjamin62222 жыл бұрын
Thank you David
@eleanorpikes2 жыл бұрын
What a lovely video, really useful. God bless.
@MA-kn2op6 күн бұрын
Hi David, Will it be possible to explain this formula in detail please and thanks! =SUM(E6:13*(MOD(ROW(E6:E13),2)=0))
@rsavitri Жыл бұрын
Somehow stuck for the array on the total budget/cummulative :(
@jesuspina8733 Жыл бұрын
Thank you
@amirsyazwan423610 ай бұрын
very good explaination sir..❤ may i know sir, how about if cumulative graph for forecast vs actual is same value?
@jesslovesanimalvideos31512 жыл бұрын
Can you make slower step by step version!?
@TheTruthSeeker756 Жыл бұрын
you can slow down the speed in the settings
@RobertWoodman2 ай бұрын
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?
@miftakhululum11806 ай бұрын
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.
@geeman43992 жыл бұрын
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.
@davidagiraldo2 жыл бұрын
How do I make the x-axis reflect the date, as in each day of the year with a mmddyyyy format?
@rebeccacrane35482 жыл бұрын
Right click on the blue or orange line in the graph, click "Select Data", then on the right hand side of the popup, click Edit under "Horizontal (Category) Axis Labels", then select the header row where you list your months.
@kennyanaedozie4126 Жыл бұрын
Great tutorial but only if you had slowed down considering not everyone is an excel wizard.
@glendagentry59595 ай бұрын
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.
@MrPherez Жыл бұрын
row 8 and 9 budget is 7 and when 6 is put why do we still see it turn to red ?
@AnkitGupta-nv8ug8 ай бұрын
It's not playing.. Kindly Check
@lauramartinez-pettit6009 Жыл бұрын
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?
@marcelk22979 ай бұрын
I have the same problem. Did you manage to solve it?
@user-uv8sl3ui8q11 ай бұрын
very fast! useless because I have to pause it everytime to understand which is very irritating
@pradyumnasatapathy3212 жыл бұрын
Awful. If you know excel, doesn't mean everyone know excel. So why dont you go slow and explain. Dont show off
@dyyy270 Жыл бұрын
Slow down dude. And take more time explaining
@user-pj1cz7vr9q6 ай бұрын
why does cell E5 have 45008 before you've spelt a date? from where is this value?