I’m 66, still working, deeply in debt and need so much help with my budgeting. I lost all retirement when in the 90’s and have basically started over. I’m frustrated but determined to pull thru this. Your videos are really encouraging me and easy to follow. Thank you!
Not everyone has had the privilege to learn from a young age how to save up. It honestly starts with how your parent’s handled their money. My parents are clueless and I have to learn to fix it for them 🙃
I am a COMPLETE beginner with all things Excel, so I was skeptical when I saw the title, as so many ‘beginner’ tutorials are too advanced. However, this was so helpful! I managed to follow along and create a great budget sheet! Thank you ☺️
Honestly this was SUPER helpful for me. I never understood how to use excels math formulas and this helped SO much. I probably still won't stick to my budget, and I have to reevaluate some of my priorities, but I hope this will help me be more mindful of what I'm spending.
I understand budgeting, and I am fairly good at Excel, but I have never followed a budget for very long. I found this video to be so straightforward, easy to follow, and I even learned a few cool shortcuts in Excel! Thank you so much for demonstrating how to create a simple household budget that is good for 90% of us out there!
I did everything you said on Excel, and it’s nice to see what I can spend comfortably. The way I have my funds consolidated plus 15% of my pay direct deposited monthly into my Apple savings, I’ve finally got my finances in order. Thanks again.
i have so many apps trying to help me track and this is the easiest tracker so far. Thank you! People think everyone knows how to use excel but really it is not that easy.
Thank you for this. Unfortunately my parents were never good at budgeting and my siblings and I have been stuck just trying to figure it out. I still struggle but this is helpful
Thank you so much for your help!!!!!!! Followed your instructions step by step and I was able to make my very own REAL Budget Planner. I'm so excited to embark on this new journey regarding my finances. 🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳
Thanks for this! For decades I've been utterly clueless as to the black magic that makes excel work. Now that I need to use excel, this pulled back the curtain and showed me that the wizard isn't all that. You're a lifesaver, man.
This was great and very helpful!! All these years, and no one has ever made me see my budget this way and change the way I look at my money. Thank you !!
2020 was rough for my industry, and for the first time in my life money has become a concern. This video helps, I'm definitely watching my money more carefully going forward.
Glad to hear the video helps! 😃 2020 was difficult for many. Reflect, learn, reset and dominate going forward 💯 And if you haven’t yet watched the documentary called “The Secret,” now would be the perfect time 🎬
I like the way you explain things. I have used Excel for years but starting a budget after not using Excel for a while. You are showing things exactly the way I was hoping. You Tube keeps switching to another video so I'm glad I wrote down your name. You know...with a pen on actual paper. Your formulas are super simple, too. LIKE THIS a lot. Thank you
@@laniecakes - You can add them together in the same cell if you like. If one payment is $2K and the other is $1.5K, the formula could be: "=2000+1500."
@@MarkReese ha ha. As I fell asleep I was thinking oh duhh, of course, just add them. I super appreciate you responding. You explain things so clearly without adding a lot of unnecessary information. I now have a budget. I have to go back and add donations. (TMI, right?) Once I see how much I'm spending it makes me stop those impulse purchases. I guess that should go under "fun money".
THIS WAS EXTREMELY BENIFICIAL. THE ONLY PROBLEM WAS WHEN I TRIED TO MOVE THE YEARLY CELL TO THE RIGHT, I COULDN'T GET THE PROPER CURSOR TO COME. BUT THANKS FOR SHARING AND I WILL FORWARD THE INFORMATION.
Thank you! I am new to EXCEL and I was trying to follow other budgeting tutorials. While they were informative they were a little too in depth for an amateur EXCEL user. One guy had me writing like 200 character code. This is a great starting point that will also help me with my business as well.
Thank you so much for simplifying the process and calmly explaining each steps and it’s benefits. We appreciate you looking forward to more lessons!!!!
No, You are great!!! Thanks so much for sharing your knowledge of excel for practical things like household budget! I’m trying to increase my knowledge of excel and you have been so helpful and extremely clear/thorough !!! Thank you so much!!
@@jojo9536 - here’s what I’m doing now: I opened a separate account for my non-monthly spend. I figured out how much my non-monthly expenses are per year, divided that by 12, and then transfer that amount into the account each month. Then, when I have a non-monthly expense come up, I can transfer the money from my “set aside account” into my normal every day checking account to cover it 😃👍 Make sense?
You can watch again at a slower rate. Click the gear icon in the lower right corner of the video, select Playback Speed, and choose the option you like!
This is what I need. Ima save this video and watch it over again and learn from it. I really appreciate these kind of lessons. I hope you understand how many people you can help by posting this video.. I appreciate it!!
This video was a great help for me on how to get control of my debt in simple form. I was able to see what was actually going where and really focus on what i needed to do to get where i want to be. I was able to take what I learned from here and expand it into other areas of my budget calendar to crunch numbers and figure out how to pay my debt off faster. Thank you.
I am very new at this and as I searched for guidance on this subject, I found you...and you did not disappoint! I truly thank and appreciate you for your CLEAR and CONCISE way of explaining how to do this. I pray for your continued growth and success as you continue to educate the public on this very important subject...no no no...SKILL!❤
As someone who finds budgets kind of hard to stick with, I've started using the anti-budget (coined by Paula Pant from the Afford Anything Podcast) to get over this hump while still using this Excel workbook. Instead of setting an amount per category, you set a minimum amount to save each month and a max to save each month, instead of watching every dollar, you'd save the minimum straight away (if you can) and then whatever money is left after expenses can be placed in the savings to get closer to your max or you can roll it over to the next month.
Thank you for taking the time to share this with us. I am trying to take better control of spending habits and this looks like a good tutorial, I cannot wait to try this!
Thank you for this! I am not familiar with Excel at all and your step by step video helped me create a wicked spreadsheet. Looking forward to making 2023 the year we actually save some money.
Thank you for the great help! The explanations are easy and clear. Could you advise on how to incorporate two different currencies into the same table, by any chance? Thank you in advance.
Another great video! This is the style of budgeting I love (and follow, albeit not verbatim). If you get too much into categories, it eventually gets frustrating and you stop following. This is better. And multiple accounts certainly help. The most imp part of this video is the fun way you explain it: very genuine and relatable! Thanks!!!
Beat Video by far I’ve ever seen, you explain it at a pace that’s manageable and speak slow enough to follow. Thanks for the video, I’ve shared it with friends and family.
Being an excel enthusiast, I really enjoyed this tutorial. :) Thank you! Can you also please share a video about your YT channel growth strategy ? What worked for you.
Wow! Truly helped to work on my budget at the same I had your video played. Do you do step tutorials of excel in other areas such as formulas, cell formatting etc
This is an awesome video! I’ve been wanting to learn to create a budget spreadsheet for a while now but felt it was to difficult to learn so fast! Your video helped me make my own Real budget. I’m subscribed love your channel keep up the awesome work!
Keep referring back to this video, one thing, your facial expression in the intro is so true, that's how I feel. Showed your intro to my wife and she said wow that's exactly your expression, lol 🤣🤣🤣
Hey man! Thanks for all your videos! They’re all really helpful and great. I hope you get lots of followers and likes! You might look at some click bait titles and match their video names or something.. maybe do some real estate how-tos that might get you some more traffic. Maybe a little jingle at the beginning with a short graphic flying around.. we need to get you some traffic! Thanks for your efforts!
Im doing so bad. I make 1400 a month right now. It’s only the 13th of the month and I’ve spent 1,000$ . And the semester is going to begin in a few days. I have a feeling I’m going to spend at least 500$ more. Meaning at least -100 of what I have in my account. I’m grateful for the budget yet sad at my irresponsibility.
I'd focus on changing myself / my habits / mindset and how I view money (that is, the program I have running through my head). Change often comes from the inside out. A spender will spend. A saver will save. It's the "money identity" that needs some tweaking.
@@MarkReese Hi Mark, thank you for the advice! I definitely need to change my mindset around money. For me I have a limited perception of it, so I spend fast. I have a budget now so hopefully it slows my spending and build my savings. ❤️🩹 From now on I’m going to be a saver!
This video is awesome! I was not a fan of Excel but watching this makes it simple and less daunting. Really appreciate your time & effort on this video!
Great video! You make it clear and the step by step instuctions are great. I replayed it but have totally missed how you subtract on sum from another. Could you explain?
Glad it helped, Trudy! You can enter something like the following into a new cell: =B12-A4 That is... - Equal sign - Name of 1st cell - Minus sign - Name of 2nd cell
Thanks for this video I've tried to make budgets before and they never worked out or I didnt make one correctly. This will help me to save for my plans to go to cdl school.
Maybe I'm missing something? Your total expenses are from your projected budget but not your actual monthly budget. If in the gray area you put $400 for restaurant expenses but in January you actually spent $500, then your total expenses and money left over are different than what your formula would tell you. Am I wrong?
Great point! Yes, that's correct. The purpose of the 'Total Income' vs. 'Total Expenses' cells was to give a sense of the estimated gain or loss per month. To get the actual result, you could instead do the following... Have a row for 'Total Income' and another for 'Total Expenses' for each monthly column. Then a 3rd row for 'Profit / Loss' or 'Over / Under' if you like. Using my examples in the video, it could be... Row 20 = Total Income (for each month, this would be manually typed in) Row 21 = Total Expenses (for each month, this would be the summation of expenses in the rows higher up, so for January: =SUM(C4:C18) Row 22 = Over/Under (for each month, this would be the difference between Row 20 and Row 21. For January, it'd be: =C20-C21 Make sense?
I think this pandemic has taught people the importance of multiple streams of income, unfortunately having one job doesn't mean security. We do need think about saving money in an emergency fund. So l really appreciate your transparency and giving people more to think about during these unpredictable times.👍
Hello thank you so much as even into 2024 you are still helpling people. I read all the comments and did not see my question. You clearly says on the tips section. Savings #1 is for setting aside. Then as you demonstrate on the spreadsheet you lable Savings #2 as setting aside. I am lost. Have watch video several times. Please help.
The title says how to make a budget on Excel (i.e., a spreadsheet). If you were looking for a video about how to divide your income into a budget in general, then you'll need to look elsewhere.
@@MarkReese It wasn't a knock on your video. It was a compliment. The fact that I clicked on the video AND received extra information on how to use a spreadsheet was excellent. It's things like that which is why I am actually subscribed to your channel. The content is great. Keep up the fantastic work.
Would love to know your thoughts on using a manual budget tracker like excel vs apps (like mint) that link to your bank account and categorizes your spending and provides analytics for you!
This video was great! I am a little stuck because I live at home so I have no “non-monthly” expenses so I’m not sure how to do the total income, total expenses, left over, etc parts! I feel like it’s probably simple, but I’ve never been to bright in math 😅
I’m 66, still working, deeply in debt and need so much help with my budgeting. I lost all retirement when in the 90’s and have basically started over. I’m frustrated but determined to pull thru this. Your videos are really encouraging me and easy to follow. Thank you!
Glad to hear it helped you & even more so to hear that you're determined to win 🏅
People like you are heroes without capes. What a positive and practical dude.
Thanks Kevin!
It amazes me how many people don't keep a budget. It's key to achieving the happy medium (balance between saving/investing & spending) :)
Right on man! 😃💯
Not everyone has had the privilege to learn from a young age how to save up. It honestly starts with how your parent’s handled their money. My parents are clueless and I have to learn to fix it for them 🙃
I recently found out that my husband has been paying a monthly subscription to like 5 different things he hasn’t used since 2013. WE NEED THIS VIDEO
I am a COMPLETE beginner with all things Excel, so I was skeptical when I saw the title, as so many ‘beginner’ tutorials are too advanced. However, this was so helpful! I managed to follow along and create a great budget sheet! Thank you ☺️
So glad to hear it helped you, Steph!
Honestly this was SUPER helpful for me. I never understood how to use excels math formulas and this helped SO much. I probably still won't stick to my budget, and I have to reevaluate some of my priorities, but I hope this will help me be more mindful of what I'm spending.
Glad it helped, Stacie! 😃💯
You're a life saver, everyone else runs through the formulas and I get lost. Your the best
Thanks - glad it helped you! 🥇
I understand budgeting, and I am fairly good at Excel, but I have never followed a budget for very long. I found this video to be so straightforward, easy to follow, and I even learned a few cool shortcuts in Excel! Thank you so much for demonstrating how to create a simple household budget that is good for 90% of us out there!
Glad it was helpful, Eric!
I really love how simple but yet extremely educative this video is. Thank you for this
Glad you found it beneficial, Ojay!
Most things I see made for beginners is so intimidating. This brother made it so easy. AND he talks to you as your there and like a person. He rocks.
Glad to hear you found it helpful!
Thank you! I’m in university and this video really helped me to start my budget up properly and was really easy to visualise so thank you!!!
You're welcome!
I did everything you said on Excel, and it’s nice to see what I can spend comfortably. The way I have my funds consolidated plus 15% of my pay direct deposited monthly into my Apple savings, I’ve finally got my finances in order. Thanks again.
Awesome to hear that! Well done 🏆
i have so many apps trying to help me track and this is the easiest tracker so far. Thank you! People think everyone knows how to use excel but really it is not that easy.
Thank you for this. Unfortunately my parents were never good at budgeting and my siblings and I have been stuck just trying to figure it out. I still struggle but this is helpful
Great that you're educating yourself 😃💯 Keep it up!
Thank you so much for your help!!!!!!! Followed your instructions step by step and I was able to make my very own REAL Budget Planner. I'm so excited to embark on this new journey regarding my finances. 🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳🥳
Congrats & well done! Happy to hear the video was beneficial to you!
5 seconds in and that's all I need in order to know that this funny man deserves a like and a subscribe.
Thank you!
Nice job, I modeled mine after yours for the most part after watching
Glad it helped you create yours!
Thanks for this! For decades I've been utterly clueless as to the black magic that makes excel work. Now that I need to use excel, this pulled back the curtain and showed me that the wizard isn't all that. You're a lifesaver, man.
Haha you got it man 👊 From black magic to real-world tool in 1 day...nice!
This was great and very helpful!! All these years, and no one has ever made me see my budget this way and change the way I look at my money. Thank you !!
Glad to hear you found it helpful, Kym!
2020 was rough for my industry, and for the first time in my life money has become a concern. This video helps, I'm definitely watching my money more carefully going forward.
Glad to hear the video helps! 😃 2020 was difficult for many. Reflect, learn, reset and dominate going forward 💯 And if you haven’t yet watched the documentary called “The Secret,” now would be the perfect time 🎬
I loved the way you made excel so easy, I got my budget made while I watched. So cool.
Thank you so much.
Well done, Ray!
Yes, me too! I completed it while I watched, what a eye opener!
Once you added step 3 you earned a sub from me. Very important to not only focus on whats going out but gaining more coming in.
Thanks so much; glad you enjoyed the video (esp. Step 3) 😃👊
I like the way you explain things. I have used Excel for years but starting a budget after not using Excel for a while. You are showing things exactly the way I was hoping. You Tube keeps switching to another video so I'm glad I wrote down your name. You know...with a pen on actual paper. Your formulas are super simple, too. LIKE THIS a lot. Thank you
Glad it was helpful, Elaine!
@@MarkReese Can I ask a question? What if I have 2 monthly incomes?
@@laniecakes - You can add them together in the same cell if you like. If one payment is $2K and the other is $1.5K, the formula could be: "=2000+1500."
@@MarkReese ha ha. As I fell asleep I was thinking oh duhh, of course, just add them. I super appreciate you responding. You explain things so clearly without adding a lot of unnecessary information. I now have a budget. I have to go back and add donations. (TMI, right?) Once I see how much I'm spending it makes me stop those impulse purchases. I guess that should go under "fun money".
Thank you so much. Peace and blessings to you my man.
You're welcome!
THIS WAS EXTREMELY BENIFICIAL. THE ONLY PROBLEM WAS WHEN I TRIED TO MOVE THE YEARLY CELL TO THE RIGHT, I COULDN'T GET THE PROPER CURSOR TO COME. BUT THANKS FOR SHARING AND I WILL FORWARD THE INFORMATION.
Did you try zooming in more, like 200%, then trying to get the cursor?
Thank you! I am new to EXCEL and I was trying to follow other budgeting tutorials. While they were informative they were a little too in depth for an amateur EXCEL user. One guy had me writing like 200 character code. This is a great starting point that will also help me with my business as well.
So glad to hear this video helped you Patrick! All the best with the biz in 2021 & beyond 😃💯📈
You're indeed a good teacher
Thank you!
Thank you. I have been looking for this for years.
You're welcome!
Thank you so much for simplifying the process and calmly explaining each steps and it’s benefits. We appreciate you looking forward to more lessons!!!!
Glad it helped!
No, You are great!!! Thanks so much for sharing your knowledge of excel for practical things like household budget! I’m trying to increase my knowledge of excel and you have been so helpful and extremely clear/thorough !!! Thank you so much!!
You're welcome, Thea! Happy it helped you 😃
Awesome video. You made understanding how to do a budget in excel very easy to understand.
Glad it helped you!
YOU ARE AMAZING!!! THANK YOU! YOU MADE THIS EXPERIENCE THAT I HAVE BEEN AVOIDING (DUE TO DEBT), LESS WORRISOME
Glad to hear it helped you, Ebony!
I JUST SAW THIS IN 2021 THANKS MAN !!! BIG HELP! I HAVE A CLEAR MIND WHERE MY MONEY IS NOW THANKS TO YOU.
So great to hear it Jo Jo! 😃✌️💯 Go make 2021 your best financial year yet 📈
@@MarkReese how do i manage my non monthly once i do spend something.
@@jojo9536 - here’s what I’m doing now: I opened a separate account for my non-monthly spend. I figured out how much my non-monthly expenses are per year, divided that by 12, and then transfer that amount into the account each month. Then, when I have a non-monthly expense come up, I can transfer the money from my “set aside account” into my normal every day checking account to cover it 😃👍 Make sense?
Great video. You are a fast talker and I was on my toes trying to keep up lol. Thank you.
You can watch again at a slower rate. Click the gear icon in the lower right corner of the video, select Playback Speed, and choose the option you like!
@@MarkReese well I watched it several times and now I have it all done! I love it. Great plan.
This is what I need. Ima save this video and watch it over again and learn from it. I really appreciate these kind of lessons. I hope you understand how many people you can help by posting this video.. I appreciate it!!
Glad to hear you found it beneficial, Jhonn 😃💯
Thank you for this amazing tool. After years of not understanding I finally understand.
Glad it helped you!
I really liked the way you explained how to do a budget excel sheet. Going to implement it ASAP.
Glad to hear it was beneficial to you!
This video was a great help for me on how to get control of my debt in simple form. I was able to see what was actually going where and really focus on what i needed to do to get where i want to be. I was able to take what I learned from here and expand it into other areas of my budget calendar to crunch numbers and figure out how to pay my debt off faster. Thank you.
Fantastic to hear that, Drew! 👊
I am very new at this and as I searched for guidance on this subject, I found you...and you did not disappoint! I truly thank and appreciate you for your CLEAR and CONCISE way of explaining how to do this. I pray for your continued growth and success as you continue to educate the public on this very important subject...no no no...SKILL!❤
Thanks Ada! Glad to hear you found the video helpful 💯
As someone who finds budgets kind of hard to stick with, I've started using the anti-budget (coined by Paula Pant from the Afford Anything Podcast) to get over this hump while still using this Excel workbook. Instead of setting an amount per category, you set a minimum amount to save each month and a max to save each month, instead of watching every dollar, you'd save the minimum straight away (if you can) and then whatever money is left after expenses can be placed in the savings to get closer to your max or you can roll it over to the next month.
Great that you found an alternative that works for you!
Thank You Mark. You made this so easy to set up. I will try this and change my mindset to get out of debt. Subscribing now. 😀
Glad it helped you! Go win!
Thank you for taking the time to share this with us. I am trying to take better control of spending habits and this looks like a good tutorial, I cannot wait to try this!
You're welcome! Glad to hear it helped you. Now go implement and win the first step of the financial game! 😃👊
Thank you for the great information and guidance. YOU ARE GREAT.
Thanks Mike! 😃👊🥇
Thank you for this! I am not familiar with Excel at all and your step by step video helped me create a wicked spreadsheet. Looking forward to making 2023 the year we actually save some money.
Glad to hear it, Laura-Lee! Now go out there and win 📈💵
Love that you are also helping folks learn formulas as well!
For sure! Gotta love how Excel does the math for you 😁💯
Thank you for the great help! The explanations are easy and clear. Could you advise on how to incorporate two different currencies into the same table, by any chance? Thank you in advance.
Glad to help! Not able to discuss multiple currencies here in the comments. Consider searching for other videos / articles / tutorials for help.
This was very helpful to me. First time using Excel and this video showed me how to.
Glad to hear it helped you!
This was an awesome video. I never thought about getting two checking accounts, just multiple savings. Thank you for the information.
Glad it helped!
Another great video! This is the style of budgeting I love (and follow, albeit not verbatim). If you get too much into categories, it eventually gets frustrating and you stop following. This is better. And multiple accounts certainly help. The most imp part of this video is the fun way you explain it: very genuine and relatable! Thanks!!!
Glad to hear you found it beneficial!
Beat Video by far I’ve ever seen, you explain it at a pace that’s manageable and speak slow enough to follow. Thanks for the video, I’ve shared it with friends and family.
Glad it was helpful & thank you for passing it along, Sergio! 🌟
You just saved me THANK YOU SUPER EASY! I've always wanted to know how to do this and Big thanks to you I DO ! I am soo excited
Glad to hear it helped you!
Being an excel enthusiast, I really enjoyed this tutorial. :) Thank you! Can you also please share a video about your YT channel growth strategy ? What worked for you.
Thanks Rashid! I don't discuss YT growth strategies on this channel; it's dedicated to credit / financial topics ✌️
Fantastic spreadsheet. I've just made it and I think its brilliant. Thanks
Glad it helped you, Lola!
Wow! Truly helped to work on my budget at the same I had your video played. Do you do step tutorials of excel in other areas such as formulas, cell formatting etc
Glad it helped! I don't have other Excel videos at this time.
This video is so easy to watch and understand. Thank you very much for making this.
You're welcome!
This is an awesome video! I’ve been wanting to learn to create a budget spreadsheet for a while now but felt it was to difficult to learn so fast! Your video helped me make my own Real budget. I’m subscribed love your channel keep up the awesome work!
Glad to hear you had success making your own budget, Angelo! Thank you for subscribing, too! 🥇
THANK YOU.
Made it way simpler than my father ever did. (and he was well versed with Excel lol)
Glad it helped you!
OMG I Have an excel budgeting test
Aced it!! 😄
😁💯👍
just did it ! love it, the other templates had too much visual noise. I wanted something simple, minimal and practical :) thanks
Well done, Maria!
Keep referring back to this video, one thing, your facial expression in the intro is so true, that's how I feel. Showed your intro to my wife and she said wow that's exactly your expression, lol 🤣🤣🤣
😂👍
Hey man! Thanks for all your videos! They’re all really helpful and great. I hope you get lots of followers and likes!
You might look at some click bait titles and match their video names or something.. maybe do some real estate how-tos that might get you some more traffic. Maybe a little jingle at the beginning with a short graphic flying around.. we need to get you some traffic!
Thanks for your efforts!
Much appreciated, Nathan!
This was so helpful. I was clueless on both budgeting & excel so this makes it look so much easier ! Thanks!
You're welcome!
is that easy thanks man people always lose me with the formulas
Glad it helped, Kevin!
Im doing so bad. I make 1400 a month right now. It’s only the 13th of the month and I’ve spent 1,000$ . And the semester is going to begin in a few days. I have a feeling I’m going to spend at least 500$ more. Meaning at least -100 of what I have in my account.
I’m grateful for the budget yet sad at my irresponsibility.
I'd focus on changing myself / my habits / mindset and how I view money (that is, the program I have running through my head). Change often comes from the inside out. A spender will spend. A saver will save. It's the "money identity" that needs some tweaking.
@@MarkReese Hi Mark, thank you for the advice! I definitely need to change my mindset around money. For me I have a limited perception of it, so I spend fast. I have a budget now so hopefully it slows my spending and build my savings. ❤️🩹 From now on I’m going to be a saver!
Thank you for providing this information. It has really helped me know my numbers.
Glad to hear it helped you, Estell!
Thank you so much for this easy to follow video! I love how thoroughly you explained every topic. ❤❤❤❤
Glad it helped you!
Best tutorial I've found so far. Thanks for this!
You're welcome!
Your explanation made a lot of sense to me, and I enjoyed it. I greatly appreciate it!
Glad to hear it!
This video is awesome! I was not a fan of Excel but watching this makes it simple and less daunting. Really appreciate your time & effort on this video!
Glad it was helpful, Derek!
Great video! You make it clear and the step by step instuctions are great. I replayed it but have totally missed how you subtract on sum from another. Could you explain?
Glad it helped, Trudy! You can enter something like the following into a new cell:
=B12-A4
That is...
- Equal sign
- Name of 1st cell
- Minus sign
- Name of 2nd cell
This was great! Thank you!
You're welcome!
Thank you best budget video I have seen, easy to use and step by step guidance.
You're welcome, Sandra!
Create a budget you can stick to, then focus on increasing your income 💯
Super amazing video Mark, thank you
@@SuperStrongAqeelA33 - You got it Ralf! 😃👊
This video was much needed. I went along with video and created my REAL budget. Thank you!
Right on! Glad it helped, and well done on creating your own 💯👍
Thank you for this video!!
My question is paying yourself first. Shouldn’t you pay yourself first before all the bills?
Glad you found it helpful! Sure 👍
This was a very great teaching video. I learned so much, thank you!
Glad it was helpful!
Awesome! Finally was able to make an excel spreadsheet on my budget that worked for me and was easy to follow…thank you and YOU are great! :)
So glad to hear it, Carmen! WELL DONE 🌟
Thanks for this video I've tried to make budgets before and they never worked out or I didnt make one correctly. This will help me to save for my plans to go to cdl school.
Glad you found it helpful! Go make 2021 your best financial year yet 😃👊💥
This was great because I needed it in a rush Mark. It was easy and I will be watching for more.
Glad you benefited from the video, Joan! 😃
Thanks Mark I'm excited to use the new info. Change your identity into a saver. Good words
Make it happen, Jon! 😃👊
Thank you soooo Much mark. You helped me with something very important. 💚
You're welcome!
Maybe I'm missing something? Your total expenses are from your projected budget but not your actual monthly budget. If in the gray area you put $400 for restaurant expenses but in January you actually spent $500, then your total expenses and money left over are different than what your formula would tell you. Am I wrong?
Great point! Yes, that's correct. The purpose of the 'Total Income' vs. 'Total Expenses' cells was to give a sense of the estimated gain or loss per month.
To get the actual result, you could instead do the following...
Have a row for 'Total Income' and another for 'Total Expenses' for each monthly column. Then a 3rd row for 'Profit / Loss' or 'Over / Under' if you like.
Using my examples in the video, it could be...
Row 20 = Total Income (for each month, this would be manually typed in)
Row 21 = Total Expenses (for each month, this would be the summation of expenses in the rows higher up, so for January: =SUM(C4:C18)
Row 22 = Over/Under (for each month, this would be the difference between Row 20 and Row 21. For January, it'd be: =C20-C21
Make sense?
This is really helpful, thanks! Do you think you could post a template if you can?
You're welcome! I don't have plans to post a template at this time.
This is exactly what I needed to start my year! Thank you so much!
You got it Marjie! Go make 2021 your year 😃💯
Appreciate this video, your into was awesome and caught my attention. Keep up the great work.
Thank you! 😃💯
Wow !!! is really amazing how much time one can save when knowing how to do something. Thank you very much.
Glad it was helpful! 😃✌️
Thank you. That was helpful
You're welcome 👍
Very Helpful 😃 but pls fix your april column
💯👍
I think this pandemic has taught people the importance of multiple streams of income, unfortunately having one job doesn't mean security. We do need think about saving money in an emergency fund. So l really appreciate your transparency and giving people more to think about during these unpredictable times.👍
Fifi Finance - Yep you totally get it, Fifi! 🏆
Thank you for this easy step-by-step budget on Excel!👍
You bet!
Hello thank you so much as even into 2024 you are still helpling people. I read all the comments and did not see my question. You clearly says on the tips section. Savings #1 is for setting aside. Then as you demonstrate on the spreadsheet you lable Savings #2 as setting aside. I am lost. Have watch video several times. Please help.
Don't worry about it. That was just my way of doing things at the time. There isn't 1 ways to make a "perfect" budget. Do what works for you.
Great tutorial on how you create a budget, not much to add since I already have my own system but interesting to see others for sure. Full watch here!
Thanks man!
Finally getting a handle on actual monthly expenses.. YAH for a 3 pay month lol.
Glad to hear it, Anna!
Clicked on the video for the budgeting, and got an educational video on how to use a spreadsheet
The title says how to make a budget on Excel (i.e., a spreadsheet). If you were looking for a video about how to divide your income into a budget in general, then you'll need to look elsewhere.
@@MarkReese It wasn't a knock on your video. It was a compliment. The fact that I clicked on the video AND received extra information on how to use a spreadsheet was excellent. It's things like that which is why I am actually subscribed to your channel. The content is great. Keep up the fantastic work.
@@anthonywilliams9415 - Ah I misunderstood. Glad to hear you received solid value from the content!
awesome thank you so much I learned so so much ❤
You're welcome! Glad it helped.
Thank you!! This video helped me ALOT! love the way you explain things
You got it Reyna! Glad it was helpful to you 😃🙌
Mark, You are great! Thank you. Rating: *****
Thank you, Sandra! 🌟
Not bad, young man. Thanks
Glad it helped 👍
Would love to know your thoughts on using a manual budget tracker like excel vs apps (like mint) that link to your bank account and categorizes your spending and provides analytics for you!
The mobile apps that track finances are definitely a lot easier to use and I'll give my support in using them 👍
Thankyou so much!
You're welcome!
This video was great! I am a little stuck because I live at home so I have no “non-monthly” expenses so I’m not sure how to do the total income, total expenses, left over, etc parts! I feel like it’s probably simple, but I’ve never been to bright in math 😅
Glad it helped, Amelia! This video was simply a guide; feel free to customize to your situation.