Being aware of different potential strategies is useful for those who hold funds run by a fund manager, as it may be better to pick managers with a range of strategies as part of a portfolio of funds, creating a more diversified portfolio.
I don’t know what I was expecting when searching up “how to make a budget on excel” but this is definitely YEARS better than what I anticipated, thank you so much🙌
Hey man, this is perfect!!! You should keep going with this UA-cam thing, you’ve got a gift for being able to teach Excel to the average person while still getting something useful done. Most channels assume proficiency or are simple beginner tutorials of the basic functions (with no end goal in mind)
My partner and I have been really struggling with finances lately for a multitude of reasons and it's been really negatively affecting our mental health. We've never been well off anyway, but we feel like we're not making progress with our finances. I've spent the last couple of days setting up my log and dashboard following your videos and they have been so useful and easy to follow! I've set my log to start in July... that gives me a little bit more time to get everything set up and get our budgets properly figured out. Thank you so much for these resources! ♥
Please, please make more videos. Your videos are so much more interesting than any others that I have found. I especially like the encouragement that you give. Thanks
Someone get this man that freak in the sheets mug. Thank you! I've been so scared of building my budget in excel and this is amazing. Subscribed as a loyal follower! Thanks!
Nice, Glad you mentioned about the pacing to make a listener aware that they can pause the video and use the information in the description area to find the formulas.
Thank you so much for this helpful tutorial. Expense-tracking apps leave much to be desired especially when it comes to customization but Excel, when you know how to use it, can be such a powerful and flexible tool!
Wow, this would otherwise be a course I'd gladly pay for. It is mind-blowing how much automation you can get out of formulas. Great video series bro. May God bless you abundantly.
This is absolutely awesome! Already created the automated budget for 2021. Now I am going to add this to it and create a Balance Sheet plus a Cashflow Statement to go along with it!! Thanks!!!
THANK YOU SO MUCH!! This and the Automated Budget (Excel version) are two of THE MOST HELPFUL UA-cam vids I've ever watched. All set up. Great info & easy to follow along without going too fast or unnecessary chatting. Fantastic!!
This works great, it took me a few hours and several mistakes, but I was able to build this spreadsheet and it works great. I have been wanting to make a budget, you showed me how and taught me so much along the way. Now I am going to watch the remainder of your tutorials you have uploaded. Thanks for taking the time. G
This is a good start for anyone that wants a simple dashboard. You can add an budget planner table/tab and have values linked to the correct portion, then can make it so you can select and sort each expense. It's easier to have a set number of rows, or you can do a header with two rows min (paychecks) then have a formula that dynamically alters the table. That can get complicated though.
Working on my 2021 Financial Tracking with this one. And making "Work Smarter and Not Harder" my mantra for the year. This channel is definitely one of my best discoveries in 2020. Thank you and keep your pretty cool and brilliant videos coming...
Hello~ thank you sooo much for this video!! Just wanted to point out, but the Step 1 Formula in the description is different from what's told in the video, here's the correct one: =SUMIFS(Log!$E:$E, Log!$A:$A, Dashboard!C$3, Log!$D:$D, Dashboard!$B5)
I still cant get Step 1 to work :/ I am using =SUMIFS(Log!$E:$E, Log!$A:$A, Dashboard!C$3, Log!$D:$D, Dashboard!$B5), and the one in the description but no values are input to cells C5 and C6
@@whyworksmarternotharder I have a question is they're anyway to keep the file from slowing down. since I add the new formula its been slow on updating and populating the information.
I was working to the older tutorial when I went through the comments to answer a question that I'd run into, and partially solved. then I saw this excellent new video, huzzah! The question I was going to answer, which had a reply from Work Smarter himself, involved tracking Credit Card accounts, and other accounts too, with this spreadsheet. Being an amateur/beginner/low level excel wizard, I was able to do so roughly. And figured I'd share my results. I also expanded it to work for bank accounts and investment accounts. I added five columns to the log, between Debit and Balance. These are, from left to right: Credit, Revenues, Checking Account, Credit Account, and Investment Account. Credit and Revenues function just like Income and Debit. You input numbers here. The account tabs hold the names of your various accounts. Again, very straightforward. The reason these are separated is important! On a use of credit, I want to be able to associate credit expenses with my credit limits automatically. But if I have Credit and Debit accounts sharing a tab, there will be an irreconcilable moment where I have to simultaneously add and subtract from two accounts in one tab. You can potentially combine Checking and Investments, but having done Credit first, I decided to avoid potential headache. In the Dashboard beneath monthly Debit, I add three new sections. Credit, Accounts, and investments. Credit is the simplest. In the Income/Debit monthly tab, you put your accounts in. In the Total tab, you SUMIF the relevant account, and you're done. Conditional format just like the others to represent credit utilization. A quirk of this system is that you have to input a Debit charge, and a negative Credit amount in your credit card payment, to avoid having to do two-entries per one Credit Card payment. Checking is next, beneath Credit, and it was slightly tricky. But you can get your bank accounts working with the same number of SUMIFs with the extra account column. I have this compare to the withdraws on the account, and I use a Conditional Formatting statement with the three-color flags to represent a desired baseline amount/savings in each account. After that is Investments, and that actually requires an additional SUMIF to do neatly, and automatically. An extra sumif hunts for a specific Description that signifies when you investment, versus the total income from the investments which will pick up your compound interest which you'll include with any other descriptor. I then take the difference of these two to calculate the profit margin. I wanted to reformat this to display as a percentage of overall passive gains, but current dollar amount will function for the time being. These account parameters mean that in the yearly tabulation, you will need to treat Income from Paycheck and income from Investments differently. I colorcode my investments yellow, and you can extend the formatting across each easily. But you can't copy the same code from Paycheck to Investments. This also gave me room for two new charts ! I did a multi-figure bar graph for Investments Breakdown beneath the pie chart, and I did an Earning Trends area-line graph beneath the Spending Trends. I seriously encourage anyone to give this a try! If I could dot his, especially while following along to this video, anyone can! An all the same ideas still apply. It totally works on the yearly, just as easily!
This comment definitely deserves more attention. I was having trouble figuring out how to separate credit and debit as well as how to include my investments, and I believe I've found my answer! I'll give this a go when I have the time, THANK YOU for this great idea!
One tip for which I don't have a solid "this is how Excel will definitely do it": You can use a table that's resizing as you go. This might save a LOT of diskspace. Sure, such a file might just be a few 100mb big, maybe 1gig one day but I was able to size it down to just a few kilobytes. Also, it saves immensly on processing power as Excel doesn't have to update the rows to infinity but has to update just one row at a time thus making the spreadsheet faster to work with. Sure, these are all minor things but I think it's much better this way. Also, hiding the month and year column clears up the table even further and these don't need to be visible all the time as they're automated.
That helps a lot. I was able to add a saving row as well. I have integrated the saving to the Month to date and Year to date dashboard. Thanks for this video. What I was looking for.
On the dashboard I added a "Data Validation List" to the Year. Now I can select the year from a drop down menu. Made it a little easier to switch back and forth between years
Thank you so much for the video! It helped me a lot. I have just one question: How do you take transfers from one credit card to another out of the 'expenses' or 'income' category while making sure, the balance adapts?
I love the budget & dashboard videos! Watched last night & already working on implementing! I’d love to add a sheet for debts to pay off, like the snowball method. We also have multiple home businesses to track & question ourselves with how to keep everything separate, in an easier way. Right now, we transfer by “robbing Peter to pay Paul” & then our transactions get really complicated to follow. Thanks for your help!
I'd like to add to this suggestion. Can this double as a check register? I would need to add a column for check # and one to check off transactions cleared from the bank. (checks and online scheduled payments)... Can I add columns to this without messing up the formulas?
I actually learned a lot about excel formulas from this video. With the SUMIFS feature I can a feature where I can track my finances in different accounts (Tracking Bank Account 1, Bank Account 2, Cash, etc)
thank you so very much for this amazing VLog on "personal budget dashboard/Budget spreadsheet/personal finance. Sure will use/apply it on a daily basis for my business. God Bless!
This video was great. I spent a year working with subscription budgeting tool only for random expenses not to pull over into the software throwing my totals off. Then it was a needle in a haystack to find which entry was missing. I decided to go back to Excel and then found this free video showing me how to do all the features most important to me--that I was paying a for in the other tool! Final question (I think) how to roll over the month on dashboard Month to date? Thank you for all your help. My budget is off to a great start for 2021!
Both your videos on budgeting are great and I am now a subscriber. I would love to see a video on how to create a forecast based on future income and expenses. This closes the circle by showing how current decisions impact future cashflow. I have not be able to find a good alternative to quicken, which I no longer use and my excel skills are not so advanced. Thanks again!
Great video! I have a question regarding the Month to date section of the "dashboard"- I have imputed the formulas correctly, over and over again and have used formulas others have commented to adjust the description steps. Either way, my "paycheck 2" always sums to zero. and i have been using this formula: " =SUMIFS(Log!$E:$E,Log!$A:$A,Dashboard!$C$3,Log!$C:$C,Dashboard!B6 " Does anyone know how I can fix this? I'm enjoying my personal finance journey and have really enjoyed working through these videos! What a great resource! However, I'm finding it a little bit frustrating! Thank You!
This is great! finally I've found what I was looking for. I have basic Excel knowledege and your video have made it so much easier and explanation is on point. I've completed the budget, savings and dashboard part. Thank you, you've help me a lot. Looking fowarde to learn more from you.
Excellent explanation and very useful. I have a question, though: how can I change the income/expense budget amounts from one month without altering the same in the following/previous months?
Thank you for your video, I am having a problem with the SUMIFS formula. I have been following along with your steps exactly but my SUMIFS total outputs as zero. any suggestions? Thanks in advance.
I love these videos!! I was wondering if you create a video showing how to create a life budgeting sheets. Creating budgets for habits, keeping track of calories, pages in book read, goals and such. I didn't realize how much could be done with excel and Google sheets it's inspiring as I like to keep track of everything I do. Especially being a day trader/ swing trader I would like to document my progress in all forms and see various from trades based on technical factors as well as mental factors. I believe this would give me the ability to take myself to higher level in life. I really appreciate these videos! Thank you so much! 😊
New sub here!! As many have said already thanks for doing these videos I was frustrated with the apps for budgeting and I was thinking of doing one on excel then found your videos and they have been very helpful and informative!! I now have a great working budget that is tailored to my needs!! So Thanks again and have a great 2021!!
Love the lay out, visual and function, this is kind of what I was looking for. I wanted to ask what would be the best way to be able to track different bank accounts with this spreadsheet?
This is so cool, you are so smart, this is just what I was looking for, it's going to take me a while to get the hang of this but I'm going to do this, yes it is fast but that's what they got rewind for, lol, now i'm going to see if I have google sheet or excel spreadsheet on my Ipad, thank you, oh new subbie !
How can i download your videos on youtube premium? Thank you so much for all of your hard work of putting these videos together. I am learning so much from you!!! You are amazing!!! 🥰
Sooooo... I have a keychain of the excel document icon that has “I-no-idea-what-I’m-doing.xtml” as the doc name... I am so glad I found you by looking for budget tables in the search on UA-cam! 🖤
Thanks for this video; the best out there. The only thing which is unclear to me - is why as criteria in the SUMIFS function for income, you were using 'description' whereas, for debits, you used "category". I've applied "category" for both, and it worked out, well at least I hope it did:)
I love your spreadsheet...but it has one key design flaw, a cardinal sin in Excel modeling. You hard code your numbers in the progression bar and the expense category names in the drop down list...when it should reference the cells where the information is drawn from. That way, when expenses change, or budgets change while creating and modifying your budget, you don't have to go into the original formula to change the budgeted number...or add or delete an expense category. I did it myself, and it makes editing my budget even more easier...
What a lovely lesson for me this evening I will spend a couple of my minutes trying the lesson out. Is there one that can help a Landlord manage rental property?
You are really good! I've learned so much since I watched the one before this. smh. Freaking months on UA-cam trying to get a better grasp on some of the basics on Excel. I'll go through this one until I get it and reach out if I have questions. I truly appreciate you. If possible can you work on doing a video on mail merge?
I like the Month to Date feature which matches what I like to track in my budget at a glance. It does not appear to be a feature on your extended template.
This is a life-saver!! its amazing, do you think you could make a video on a stock/investment table thrown into this dashboard? Because I would to create a data table tracking my stocks
Love how this can happen in excel as I have done a similar version of this but not as coded ad this one is... I am having a lot of trouble with the year to date boxes with the formulas used in the video plus in the description! I am thinking of just using my similar which has less coding in it but don't want to ruin the file. Any suggestions? My formulas I have now getting a $0 amount are =SUMIFS(Log!$E:$E, Log!$A:$A, Dashboard!G$4, Log!$C:$C, Dashboard!$B5) and =SUMIFS(Log!$F:$F,Log!$A:$A,Dashboard!G$3,Log!$D:$D,Dashboard!$B10)
I Love this excel sheet! Game changer. Yearly planning/ tracking is key! Can you show a similar sheet that allows you to track things like credit card pay off goals, savings goals? Also, one missing element.... what if your budget by category varies each month? Any options there?
if you add balance forecasting you'll basically have ms money, which everyone knows was by far the best. you can still download / run MS money sunset edition for free.
Hello, awesome tutorials! I watched your budgeting for google sheets video, but I prefer the way this one (for excel) is set up. Would it be possible to mostly follow this tutorial to replicate it in google sheets? Thank You!
*Leave a comment! It helps the UA-cam algorithm!!*
I need some help troubleshooting, how do I get ahold of you?
Being aware of different potential strategies is useful for those who hold funds run by a fund manager, as it may be better to pick managers with a range of strategies as part of a portfolio of funds, creating a more diversified portfolio.
Deciding on a suitable strategy can depend on various factors. kindly make referrals
@@xueyijun2144 i work with Tamara Diane Hagan . her strategies works very well for me. search her on the web.
@@walterlouis4828 i just found the website and i have drop a message.
I don’t know what I was expecting when searching up “how to make a budget on excel” but this is definitely YEARS better than what I anticipated, thank you so much🙌
I'd be totally lost without this video! I was able to complete everything successfully, and as a Excel noob I learned a lot! Thanks so much!
My excel budget was only ok. I had to manually change things every month. This budget is amazing sir! You have earned a like and follow!
Awesome! So glad it works for you!
Hey man, this is perfect!!! You should keep going with this UA-cam thing, you’ve got a gift for being able to teach Excel to the average person while still getting something useful done. Most channels assume proficiency or are simple beginner tutorials of the basic functions (with no end goal in mind)
Seriously, you actually followed everything, no way
My partner and I have been really struggling with finances lately for a multitude of reasons and it's been really negatively affecting our mental health. We've never been well off anyway, but we feel like we're not making progress with our finances. I've spent the last couple of days setting up my log and dashboard following your videos and they have been so useful and easy to follow! I've set my log to start in July... that gives me a little bit more time to get everything set up and get our budgets properly figured out. Thank you so much for these resources! ♥
Awesome! This one will help plan! ua-cam.com/video/WRWg8mpIWpY/v-deo.html
Please, please make more videos. Your videos are so much more interesting than any others that I have found. I especially like the encouragement that you give. Thanks
Someone get this man that freak in the sheets mug. Thank you! I've been so scared of building my budget in excel and this is amazing. Subscribed as a loyal follower! Thanks!
Most underated finance video on UA-cam. Thanks, man you've save me a lot of paper and headaches.
Nice, Glad you mentioned about the pacing to make a listener aware that they can pause the video and use the information in the description area to find the formulas.
Thank you so much for this helpful tutorial. Expense-tracking apps leave much to be desired especially when it comes to customization but Excel, when you know how to use it, can be such a powerful and flexible tool!
Wow, this would otherwise be a course I'd gladly pay for. It is mind-blowing how much automation you can get out of formulas. Great video series bro. May God bless you abundantly.
Love it
incredible how you explain every step with such detail that one can blindly type in the formulas without pausing! Thanks
Much appreciated
This is my first time commenting😋 but I have been using this for the last few months and it has been a great help💯
This is EXACTLY what I was looking for for my young Mom’s group ( teaching them finances)!
Thank you so much, this is great. Just in time to set it up for the new year. Thanks again!
Glad it worked out for you!
This is absolutely awesome! Already created the automated budget for 2021. Now I am going to add this to it and create a Balance Sheet plus a Cashflow Statement to go along with it!! Thanks!!!
Awesome! Glad it worked!!
THANK YOU SO MUCH!! This and the Automated Budget (Excel version) are two of THE MOST HELPFUL UA-cam vids I've ever watched. All set up. Great info & easy to follow along without going too fast or unnecessary chatting. Fantastic!!
Wow! Thanks for the kind words! Glad it worked!
This works great, it took me a few hours and several mistakes, but I was able to build this spreadsheet and it works great. I have been wanting to make a budget, you showed me how and taught me so much along the way. Now I am going to watch the remainder of your tutorials you have uploaded. Thanks for taking the time. G
This is a good start for anyone that wants a simple dashboard. You can add an budget planner table/tab and have values linked to the correct portion, then can make it so you can select and sort each expense. It's easier to have a set number of rows, or you can do a header with two rows min (paychecks) then have a formula that dynamically alters the table. That can get complicated though.
Thanks, I've learnt so much more watching and using these videos
Awesome that’s what I love to hear
Working on my 2021 Financial Tracking with this one. And making "Work Smarter and Not Harder" my mantra for the year. This channel is definitely one of my best discoveries in 2020. Thank you and keep your pretty cool and brilliant videos coming...
This is an awesome comment! Love getting these! Thank you for the kind words! Work smarter not harder has been my motto for a while now!
Hello~ thank you sooo much for this video!! Just wanted to point out, but the Step 1 Formula in the description is different from what's told in the video, here's the correct one: =SUMIFS(Log!$E:$E, Log!$A:$A, Dashboard!C$3, Log!$D:$D, Dashboard!$B5)
I still cant get Step 1 to work :/ I am using =SUMIFS(Log!$E:$E, Log!$A:$A, Dashboard!C$3, Log!$D:$D, Dashboard!$B5), and the one in the description but no values are input to cells C5 and C6
@@marvinmartin1357 =SUMIFS(Log!E:E, Log!A:A, Dashboard!$C$3, Log!C:C,Dashboard!B5)
Thank you so much! this makes its so much easier for me . I already fix my 2021! Now I can make it better. AWSOME!!!!!!!
Great! Glad it works!!
@@whyworksmarternotharder I have a question is they're anyway to keep the file from slowing down. since I add the new formula its been slow on updating and populating the information.
Wow!! Just like a summary of all the other youtuber's videos I've seen! Just perfect thank you very much, starting 2022 with a plan!
I was working to the older tutorial when I went through the comments to answer a question that I'd run into, and partially solved. then I saw this excellent new video, huzzah!
The question I was going to answer, which had a reply from Work Smarter himself, involved tracking Credit Card accounts, and other accounts too, with this spreadsheet. Being an amateur/beginner/low level excel wizard, I was able to do so roughly. And figured I'd share my results. I also expanded it to work for bank accounts and investment accounts.
I added five columns to the log, between Debit and Balance. These are, from left to right: Credit, Revenues, Checking Account, Credit Account, and Investment Account.
Credit and Revenues function just like Income and Debit. You input numbers here.
The account tabs hold the names of your various accounts. Again, very straightforward. The reason these are separated is important! On a use of credit, I want to be able to associate credit expenses with my credit limits automatically. But if I have Credit and Debit accounts sharing a tab, there will be an irreconcilable moment where I have to simultaneously add and subtract from two accounts in one tab. You can potentially combine Checking and Investments, but having done Credit first, I decided to avoid potential headache.
In the Dashboard beneath monthly Debit, I add three new sections. Credit, Accounts, and investments.
Credit is the simplest. In the Income/Debit monthly tab, you put your accounts in. In the Total tab, you SUMIF the relevant account, and you're done. Conditional format just like the others to represent credit utilization. A quirk of this system is that you have to input a Debit charge, and a negative Credit amount in your credit card payment, to avoid having to do two-entries per one Credit Card payment.
Checking is next, beneath Credit, and it was slightly tricky. But you can get your bank accounts working with the same number of SUMIFs with the extra account column. I have this compare to the withdraws on the account, and I use a Conditional Formatting statement with the three-color flags to represent a desired baseline amount/savings in each account.
After that is Investments, and that actually requires an additional SUMIF to do neatly, and automatically. An extra sumif hunts for a specific Description that signifies when you investment, versus the total income from the investments which will pick up your compound interest which you'll include with any other descriptor. I then take the difference of these two to calculate the profit margin. I wanted to reformat this to display as a percentage of overall passive gains, but current dollar amount will function for the time being.
These account parameters mean that in the yearly tabulation, you will need to treat Income from Paycheck and income from Investments differently. I colorcode my investments yellow, and you can extend the formatting across each easily. But you can't copy the same code from Paycheck to Investments.
This also gave me room for two new charts ! I did a multi-figure bar graph for Investments Breakdown beneath the pie chart, and I did an Earning Trends area-line graph beneath the Spending Trends.
I seriously encourage anyone to give this a try! If I could dot his, especially while following along to this video, anyone can! An all the same ideas still apply. It totally works on the yearly, just as easily!
This comment definitely deserves more attention. I was having trouble figuring out how to separate credit and debit as well as how to include my investments, and I believe I've found my answer! I'll give this a go when I have the time, THANK YOU for this great idea!
two years late but I just found your videos. I have a lot to learn!!!!
One tip for which I don't have a solid "this is how Excel will definitely do it":
You can use a table that's resizing as you go. This might save a LOT of diskspace. Sure, such a file might just be a few 100mb big, maybe 1gig one day but I was able to size it down to just a few kilobytes.
Also, it saves immensly on processing power as Excel doesn't have to update the rows to infinity but has to update just one row at a time thus making the spreadsheet faster to work with.
Sure, these are all minor things but I think it's much better this way. Also, hiding the month and year column clears up the table even further and these don't need to be visible all the time as they're automated.
AMAZING! I just did the first video about two weeks ago and this just took it to another level! Thank you.
Awesome! Glad it works!
Awesome! Glad it worked!
That helps a lot. I was able to add a saving row as well. I have integrated the saving to the Month to date and Year to date dashboard. Thanks for this video. What I was looking for.
On the dashboard I added a "Data Validation List" to the Year. Now I can select the year from a drop down menu. Made it a little easier to switch back and forth between years
Also on the "Year to Date" I added my Savings the same way you did Income. Now I can track my savings total as well
Thank you for your time and your willingness to share this kind of content & knowledge on UA-cam! This budget spreadsheet is very useful 👍
💯
SAVAGE!!! Thank you!!! I am still picking up skull fragments from that mind-blowing walk-thru. Just added another tool to my excel toolbox.
Thank you for this. I have been trying to figure out a much better method than what I had been using.
Thank you so much for this. I needed an Excel budget dashboard. Most of all, I needed practice. Thanks again!
Thank you! This video is PACKED, no fluffing around
Wow! Definitely going to take my time with this one. Thanks for the information as always
I already started using the spread sheet from part 1.
Awesome!! Glad it’s working for you!
Formule at part 1 doesnt seem to work keep getting an error so frustrating
Sir, Very nice template. One suggestion is to add savingsaccounts and creditcards and let the use of them be a part of the budgetplanner.
This video is very helpful, the dashboard definitely looks smart. hoping to see many more of this. Thanks dear & all the best.
Thank you so much for the video! It helped me a lot. I have just one question: How do you take transfers from one credit card to another out of the 'expenses' or 'income' category while making sure, the balance adapts?
I love the budget & dashboard videos! Watched last night & already working on implementing! I’d love to add a sheet for debts to pay off, like the snowball method. We also have multiple home businesses to track & question ourselves with how to keep everything separate, in an easier way. Right now, we transfer by “robbing Peter to pay Paul” & then our transactions get really complicated to follow. Thanks for your help!
Coming soon!!
I'd like to add to this suggestion. Can this double as a check register? I would need to add a column for check # and one to check off transactions cleared from the bank. (checks and online scheduled payments)... Can I add columns to this without messing up the formulas?
@@darlenehutchens9333 yes you can add those 2 columns without messing up the formulas. Google has a Checkbox you can insert
Hey, this is really awesome and I finally have my budget in line! Thank you for investing the time to save me among others!
This is the best video I've seen on budget templates, thank you so much for posting!
I hope everything's okay since you haven't posted any new videos in a few months. Love your videos! Super helpful!
Awesome! Im a noob on excel but I am learning from you a lot. Thank you! 🙏🏽
This was very helpful. I am setting mine up the same way but I am noticing the formula used in step 1 isn't the same as what's on the excel sheet.
I actually learned a lot about excel formulas from this video. With the SUMIFS feature I can a feature where I can track my finances in different accounts (Tracking Bank Account 1, Bank Account 2, Cash, etc)
Very nice mate.
After setting up a budget today, I'll have a go at this in a day or two :)
thank you so very much for this amazing VLog on "personal budget dashboard/Budget spreadsheet/personal finance. Sure will use/apply it on a daily basis for my business. God Bless!
Absolutely Loved learning how to do this! Thank you so much!
This video was great. I spent a year working with subscription budgeting tool only for random expenses not to pull over into the software throwing my totals off. Then it was a needle in a haystack to find which entry was missing. I decided to go back to Excel and then found this free video showing me how to do all the features most important to me--that I was paying a for in the other tool! Final question (I think) how to roll over the month on dashboard Month to date? Thank you for all your help. My budget is off to a great start for 2021!
Thank you for this. I'm really enjoying learning excel and building my budget tracker.
This is what I’ve been looking for! I got paid apps for budgeting and this one is also good to learn. Thank you sir
Both your videos on budgeting are great and I am now a subscriber. I would love to see a video on how to create a forecast based on future income and expenses. This closes the circle by showing how current decisions impact future cashflow. I have not be able to find a good alternative to quicken, which I no longer use and my excel skills are not so advanced. Thanks again!
I do cover this in my Google Sheets version! ua-cam.com/video/WRWg8mpIWpY/v-deo.html. I think you’ll like it.
Absolutely love this video! I was thinking about creating a budget and your video popes up in my home feed. :)
That is an awesome video. Thanks to your video, I have a very clear budget. Keep up the good work!!!
Great to hear!
Great video! I have a question regarding the Month to date section of the "dashboard"- I have imputed the formulas correctly, over and over again and have used formulas others have commented to adjust the description steps. Either way, my "paycheck 2" always sums to zero. and i have been using this formula: " =SUMIFS(Log!$E:$E,Log!$A:$A,Dashboard!$C$3,Log!$C:$C,Dashboard!B6 "
Does anyone know how I can fix this? I'm enjoying my personal finance journey and have really enjoyed working through these videos! What a great resource! However, I'm finding it a little bit frustrating!
Thank You!
This is great! finally I've found what I was looking for. I have basic Excel knowledege and your video have made it so much easier and explanation is on point. I've completed the budget, savings and dashboard part. Thank you, you've help me a lot. Looking fowarde to learn more from you.
Awesome! So glad it works for you!
I'll be bingewatching all of your videos and I'll be back with questions 😅
Excellent explanation and very useful. I have a question, though: how can I change the income/expense budget amounts from one month without altering the same in the following/previous months?
Thank you for your video, I am having a problem with the SUMIFS formula. I have been following along with your steps exactly but my SUMIFS total outputs as zero. any suggestions? Thanks in advance.
Your step formulas are off btw. Loving the video. Thank you!
I love these videos!! I was wondering if you create a video showing how to create a life budgeting sheets. Creating budgets for habits, keeping track of calories, pages in book read, goals and such. I didn't realize how much could be done with excel and Google sheets it's inspiring as I like to keep track of everything I do. Especially being a day trader/ swing trader I would like to document my progress in all forms and see various from trades based on technical factors as well as mental factors. I believe this would give me the ability to take myself to higher level in life. I really appreciate these videos! Thank you so much! 😊
Great Video! Helps a lot! Thank you!
New sub here!! As many have said already thanks for doing these videos I was frustrated with the apps for budgeting and I was thinking of doing one on excel then found your videos and they have been very helpful and informative!! I now have a great working budget that is tailored to my needs!! So Thanks again and have a great 2021!!
Wow! Thank you for the kind words! Glad it worked!
Love the lay out, visual and function, this is kind of what I was looking for. I wanted to ask what would be the best way to be able to track different bank accounts with this spreadsheet?
Amazing video just started doing it and it's hard cuz I don't know much about excel but I'll try my best
thanks for this, needed this to sort my budget out
This is so cool, you are so smart, this is just what I was looking for, it's going to take me a while to get the hang of this but I'm going to do this, yes it is fast but that's what they got rewind for, lol, now i'm going to see if I have google sheet or excel spreadsheet on my Ipad, thank you, oh new subbie !
Thank You, I have finally found a simple formula to get my miserable financial life together
How can i download your videos on youtube premium? Thank you so much for all of your hard work of putting these videos together. I am learning so much from you!!! You are amazing!!!
🥰
Sooooo... I have a keychain of the excel document icon that has “I-no-idea-what-I’m-doing.xtml” as the doc name...
I am so glad I found you by looking for budget tables in the search on UA-cam!
🖤
This is amazing!! Always wanted something to track my expenses!! Thanks 🙂
Great video! Can you create a video showing adding holding accounts (saving each month for an annual expense)
Coming soon!
Thanks for this video; the best out there. The only thing which is unclear to me - is why as criteria in the SUMIFS function for income, you were using 'description' whereas, for debits, you used "category". I've applied "category" for both, and it worked out, well at least I hope it did:)
That was a glitch in the video 🤦♂️
This is extremly helpful, thank you.
Great video, concise instructions. Easy to follow along 😃
Awesome. Glad it worked for you
I love your spreadsheet...but it has one key design flaw, a cardinal sin in Excel modeling. You hard code your numbers in the progression bar and the expense category names in the drop down list...when it should reference the cells where the information is drawn from. That way, when expenses change, or budgets change while creating and modifying your budget, you don't have to go into the original formula to change the budgeted number...or add or delete an expense category. I did it myself, and it makes editing my budget even more easier...
Thank you!! I am glad I came across this.
What a lovely lesson for me this evening I will spend a couple of my minutes trying the lesson out. Is there one that can help a Landlord manage rental property?
You are really good! I've learned so much since I watched the one before this. smh. Freaking months on UA-cam trying to get a better grasp on some of the basics on Excel. I'll go through this one until I get it and reach out if I have questions. I truly appreciate you.
If possible can you work on doing a video on mail merge?
Yes that’s on the docket! And I’m so glad to hear you are learning!! It’s why I do what I do!
@@whyworksmarternotharder Thank you so much.
I like the Month to Date feature which matches what I like to track in my budget at a glance. It does not appear to be a feature on your extended template.
Awesome vid! I have been looking for something like this for a long time.
Excellent tutorial!
This looks amazing! Would you have any videos to do the same on google sheets? Had a go with it but didn't go as I hoped. Thanks again!
commenting to help with the algorithm... great stuff!
This is a life-saver!! its amazing, do you think you could make a video on a stock/investment table thrown into this dashboard? Because I would to create a data table tracking my stocks
Great video, well explained and at a perfect pace.
sir can I get a blank copy of this budget to use ?
This video is really helpful. Thank you.
Love how this can happen in excel as I have done a similar version of this but not as coded ad this one is... I am having a lot of trouble with the year to date boxes with the formulas used in the video plus in the description! I am thinking of just using my similar which has less coding in it but don't want to ruin the file. Any suggestions?
My formulas I have now getting a $0 amount are
=SUMIFS(Log!$E:$E, Log!$A:$A, Dashboard!G$4, Log!$C:$C, Dashboard!$B5)
and
=SUMIFS(Log!$F:$F,Log!$A:$A,Dashboard!G$3,Log!$D:$D,Dashboard!$B10)
Thank you so much for this video! It’s amazing.
Wow! Thank you for the kind words and the comment! Glad it worked!
I Love this excel sheet! Game changer. Yearly planning/ tracking is key! Can you show a similar sheet that allows you to track things like credit card pay off goals, savings goals? Also, one missing element.... what if your budget by category varies each month? Any options there?
Does anyone else have an issue with how slowly the budgeting spreadsheet responds? Or is that just me? Lol
if you add balance forecasting you'll basically have ms money, which everyone knows was by far the best. you can still download / run MS money sunset edition for free.
Great video. Learned some new things!
Thanks for this great video! I'm starting early with learning to budget!
Awesome! Great way to start the year! Keep it up. It’ll be worth it!
Hello, awesome tutorials! I watched your budgeting for google sheets video, but I prefer the way this one (for excel) is set up. Would it be possible to mostly follow this tutorial to replicate it in google sheets? Thank You!
That took a long while to set up but I feel that was really helpful. Thank you
Yes but now it’s good forever basically! Glad it worked out!