just found the video, really great! but I have a problem, why can't I click the next cells (the L14) to put it in the formula like in 14:39 can someone explain to me what I did wrong?
ahh! i'm only at the data validation part of creating a dropdown for the bills - but i feel so accomplished 😀 no greater feeling than doing something yourself, thank you so much for this tutorial!☺
Hi, I'm flowing the tutorial and code for this but it in my income and expense and saving sections is just said 0 even though I have put numbers in the amount section in the entries sheet (7:24) would anyone be able to help me understand what I may be doing wrong
I was wondering that why we have to divide our left budget to left actual to see the percentage of left to spend? Can anybody give me some explanation about it because I am not good at maths, thank you
Excellent work! My husband and I both get paid bi-weekly but on alternate pay weeks, so we end up receiving a paycheck weekly between the two of us. How would you suggest I tweak this setup to show a weekly budget?
Can anyone write out the formula for the column that says "Actual" on the expense part. Mine keeps returning an error after deleting the difference formula.
@@excelwithmark hi, hoping I might get a response from this question. I get paid every week so I'm looking for an app or excel formula that will look at all my income and the dates I get paid, then look at all my bills per month and plot out where to pay them during the month (example.. I have $100, bill is $120, so then it automatically figures out how to spread that out). Do you offer an app or something that will do this for me?
I am really having hard time setting up the "Left to Spend" section, I cannot get the right percentage with the symbol §. How am I supposed to correctly create this? I am getting an error following that part. Anyone can help?
I would love to see a budget with sheets for each month (just copying the same monthly sheet multiple times) and an "annual summary" sheet that summarizes the totals for each month in the whole year.
🙌 SUBSCRIBE for more Excel Tutorials: bit.ly/3SYHKFQ
👨🏫 FREE Excel Courses: bit.ly/EssentialCourseEWM
🖥 Templates: bit.ly/TemplatesEWM
I sat here watching this, stuffing my face with chipotle, planning my financial future. Ultimate self care. 🎉
this sounds amazing
Now THIS is a tutorial 😭 thank you! I do recommend adding timestamps though!
This was EXTREMELYYYY HELPFUL, and I love that I didn't have to pay like the other templates on etsy lol. thank you!!!!!
Thanks for this man! I can finally track my own budget without paying a hefty price just to have access to it 😊😊
EXCELlent tutorial!! ...and with music that I didn't have to quickly mute at that. 😆Thank you!
I made it while watching. It took me 3 hours and a break. But I love it.
Thank you for this tutorial ❤ I also love your choice of palette here. Not too generic pastel theme yet vibrant and pleasant enough for the eyes ❤
Thank you for this tutorial! Followed it and now have a great financial tracker for free!
Love this budget set up! I'm going to make my own 😊
Thank you so much for this tutorial. You have saved me money. Now I am motivated to budget!
just found the video, really great!
but I have a problem, why can't I click the next cells (the L14) to put it in the formula like in 14:39 can someone explain to me what I did wrong?
I figured it out u must put ";" instead of ",". hope this helps
@@M4rty360 thanks it worked
same, :(
thanks for sharing, Mark.
i was helpful ❤
ahh! i'm only at the data validation part of creating a dropdown for the bills - but i feel so accomplished 😀 no greater feeling than doing something yourself, thank you so much for this tutorial!☺
You did a great job! I also love the music. Thank you!
Finally a tutorial on budget tracker. The thumbnail has a dropdown for the month. May I ask how to do it. :)
Yo King dropped hella banger guide and left the sheet unnamed 👑
muchas gracias. Asi es genial porque podemos hacerlo paso a paso. Super util y super practico el video muchas gracias saludos
i would like to say, i like your song playlist for this video😆
Thank you soooo much for this tutorial. you really help me for my financial!
Thank you for your efforts !!!
It was excellent. Thank you so much. I made it and it looked great. Learned a lot from this video. 🥳🥳💯💯
Hi, I'm flowing the tutorial and code for this but it in my income and expense and saving sections is just said 0 even though I have put numbers in the amount section in the entries sheet (7:24) would anyone be able to help me understand what I may be doing wrong
Good taste of music though..
Thank you so much for this! Is such a detailed tutorial, I'm going to try to do it
La música super relajante. Saludos desde Colombia
hello, I am really thankful for you tutorial on creating this content and I followed it!! Thank you very much!!!
Hi! Can you show us how to then create the dropdown menu to switch between months?
Thank you. This is very useful for me. It takes hours for me to make it hahahha. But thanks to you 😂👍
Going to have to watch this again because the first time I was just vibing to the music and pretending to be at a mini-concert.
what is the song called playing in the background of the video and who sings it?
Thank you for this video! Exactly what I'm looking for❤
Glad it helps
@@excelwithmark Would you bring able to explain why when I put my § input just pops up as an error
How about if you pay your bills using your credit card.? How would we able to calculate using your form? This will double up the cashflow
In 23:40, what command did you use to get the percentage below cash flow? Thank you!
Pause at 24:10, what command or symbol is after D19?
@@Unkn0wn54_ hi please help me. I'm having a hard time in 24:10. the percentage I dont get it
the symbol you use. for me it came out error
Does anyone knows how that 68.8% came to be.
C19/d19 that I understood. I tried to slow motion still I can't understand how 68.8% is coming
Hi I am trying to learn. I'm new here, what does currency means? and why is it useful in a budget planner?
What do you put in the saving after total
Im having an error when creating this formula 14:35
New subscriber here, thank you for the tutorial!
How would you set up a budget for a person who doesn't have any debt?
Thank you for this!
The song 🥺🥺😍😍
I would love to see profit and loss per project event in every month. Thank you
24:17 600 was added for actual electricity for the bills table. Thats why the percentages changed. Hope that helped 😊
Thanks for sharing, very useful and easy to follow! New sub 👍
love it
Can you show a dropdown option where i can switch between months rather than creating this at the start of every month
What formula are you using for 17.01
Watchet it made it LOVE IT
I was wondering that why we have to divide our left budget to left actual to see the percentage of left to spend? Can anybody give me some explanation about it because I am not good at maths, thank you
Thank youuuu
can anyone tell me what happened in 21:13, how to do it?
hi a chart was created using the data from the cashflow actual column. Hope this helps sorry it wasnt clearer
@@excelwithmark I was able to figured it out, but thank you so much for replying and for the this video. I learned a lot.
Between 24:16 and 24:17, all the little lines are gone in between the categories, the budget and the actual collum, does anyone know how to do that?
In the menu bar select View > Show > Gridlines and they should toggle off
Excellent work! My husband and I both get paid bi-weekly but on alternate pay weeks, so we end up receiving a paycheck weekly between the two of us. How would you suggest I tweak this setup to show a weekly budget?
Thank you so much sir
Can anyone write out the formula for the column that says "Actual" on the expense part. Mine keeps returning an error after deleting the difference formula.
Hi Mark, wonder if you have this template in Excel spreadsheet?
Amazing, thank you so very much, keep it up
Thanks, will do!
but how do you change it month to month and keep the same settings? thank you
I'm so sad I was nearly done but I can't see the formulas. Great tutorial tho.
Thank you! Something simple to put my actual down.
Glad it helps is you have any ideas to improve these templates let me know what you would like to include
@@excelwithmark hi, hoping I might get a response from this question.
I get paid every week so I'm looking for an app or excel formula that will look at all my income and the dates I get paid, then look at all my bills per month and plot out where to pay them during the month (example.. I have $100, bill is $120, so then it automatically figures out how to spread that out).
Do you offer an app or something that will do this for me?
love this, thankyouu❤
glad you enjoyed thanks fopr watching
Hello. I have a problem with the formula =IF(M14="", "", L14-M14). My Excel gives me an error and I don't know how to fix it.
Figure out it is because is a ; nota a ,
GREAT KEEP UP UPLOADING
Thank you I will
Do’you have google sheet courses ?
Ka playlist nya apa ya heheh saya suka denger nya
Cómo hago esto en Excel , no encuentro los mismos atajos
Would be nice if I knew why my § input just pops up as an error
Same as well with me
Please create a video for travel planer sheet.
I want to purchase one of your budget planners, I'm in the U.S. Is it simple to change the currency to U.S. dollars?
bende kenarlıklar kalınlaştırsam bile bu kadar kalın görünmüyorlar, nasıl sizinki gibi yapabilirim
I am really having hard time setting up the "Left to Spend" section, I cannot get the right percentage with the symbol §. How am I supposed to correctly create this? I am getting an error following that part. Anyone can help?
Everything workout well. Then I got confused how 68.8% is coming from.
hello,, why display using mobile not same,, please help me.. chart at left to spend not display the number
why the IF formula (duration 14.48) is error?😭
So cool I want to do this
If you need any help just ask
Hi, what program do you use to record your screen?
I would love to see a budget with sheets for each month (just copying the same monthly sheet multiple times) and an "annual summary" sheet that summarizes the totals for each month in the whole year.
Hi is this what you are looking for excelwithmark.com/products/budget-spreadsheet-for-personal-finance
❤ to see one using the mobile of Google Sheets
bagus banget ini rapi juga cantik,aku mau buat bisnis plan
Hello thank you for this video but I have a problem in Expenses when I write +IF(L15+" " , " " , ... can you help pls
=IF(M14="", "",L14-M14)
If it can help:
Put ; instead of ,
@excelwithmark How did you come up with 68.8%
Can somebody tell me how we are getting 68.80% and 31.20% suddenly from 56.54%(100%-(C19/D19) and 43.46%(C19/D19) UNDER THE CASHFLOW TABLE
Same I confuse to this how suddenly change😢
@@ariang5103 please help. did anyone has an answer to that?
Been watching this hours and hours still can't figure it out. 😅
600 was added for actual electricity for the bills table. Thats why the percentages changed. Hope that helped 😊
music?!?
I need the spreadsheet and the playlist😂
muchas gracia pa
A Voice over would be great to minimize the pausing
Thank you for your efforts !!!