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!☺
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?
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 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.
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?
🙌 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!
24:17 600 was added for actual electricity for the bills table. Thats why the percentages changed. Hope that helped 😊
Thanks for this man! I can finally track my own budget without paying a hefty price just to have access to it 😊😊
This was EXTREMELYYYY HELPFUL, and I love that I didn't have to pay like the other templates on etsy lol. thank you!!!!!
I made it while watching. It took me 3 hours and a break. But I love it.
EXCELlent tutorial!! ...and with music that I didn't have to quickly mute at that. 😆Thank you!
Good taste of music though..
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 ❤
Finally a tutorial on budget tracker. The thumbnail has a dropdown for the month. May I ask how to do it. :)
Thank you for this tutorial! Followed it and now have a great financial tracker for free!
You did a great job! I also love the music. Thank you!
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
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.
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!
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! Can you show us how to then create the dropdown menu to switch between months?
Yo King dropped hella banger guide and left the sheet unnamed 👑
Thank you soooo much for this tutorial. you really help me for my financial!
Thank you for your efforts !!!
I would love to see profit and loss per project event in every month. Thank you
New subscriber here, thank you for the tutorial!
love it
Hi I am trying to learn. I'm new here, what does currency means? and why is it useful in a budget planner?
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
Thank you. This is very useful for me. It takes hours for me to make it hahahha. But thanks to you 😂👍
Ka playlist nya apa ya heheh saya suka denger nya
Can you show a dropdown option where i can switch between months rather than creating this at the start of every month
Hi Mark, wonder if you have this template in Excel spreadsheet?
hello, I am really thankful for you tutorial on creating this content and I followed it!! Thank you very much!!!
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?
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 ,
Thank you so much for this! Is such a detailed tutorial, I'm going to try to do it
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 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
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
Would be nice if I knew why my § input just pops up as an error
Same as well with me
La música super relajante. Saludos desde Colombia
Thank you for this!
Please create a video for travel planer sheet.
It was excellent. Thank you so much. I made it and it looked great. Learned a lot from this video. 🥳🥳💯💯
Thank youuuu
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.
What do you put in the saving after total
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?
The song 🥺🥺😍😍
GREAT KEEP UP UPLOADING
Thank you I will
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
Thanks for sharing, very useful and easy to follow! New sub 👍
What formula are you using for 17.01
Cómo hago esto en Excel , no encuentro los mismos atajos
bende kenarlıklar kalınlaştırsam bile bu kadar kalın görünmüyorlar, nasıl sizinki gibi yapabilirim
@excelwithmark How did you come up with 68.8%
but how do you change it month to month and keep the same settings? thank you
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?
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.
muchas gracias. Asi es genial porque podemos hacerlo paso a paso. Super util y super practico el video muchas gracias saludos
Thank you so much sir
hello,, why display using mobile not same,, please help me.. chart at left to spend not display the number
Hi, what program do you use to record your screen?
A Voice over would be great to minimize the pausing
why the IF formula (duration 14.48) is error?😭
Amazing, thank you so very much, keep it up
Thanks, will do!
Watchet it made it LOVE IT
love this, thankyouu❤
glad you enjoyed thanks fopr watching
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 😊
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 ,
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
So cool I want to do this
If you need any help just ask
music?!?
I need the spreadsheet and the playlist😂
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.
muchas gracia pa
Thank you for your efforts !!!