How to create Ultimate Personal Budget in Excel

Putting excel on my resume as a skill at this point

Spent 2 days, My eyes are now burning but I completed it, thanks for this awesome video

I can't imagine the amount of time it must have taken to make this entire 6 hour video as soon as it was. Your explanations were so clear and you didn't skip any step. Some people will assume that some things are common knowledge in excel and will skip over it and that will ultimately lose some viewers. This was really an amazing dashboard and incredible video. I learnt so much, not just about excel's capabilities but also being detail-orientated so make sure everything is nice and standardised creates a beautiful end result. You're one of the people the world needs - people who share their knowledge generously. Thank you.

for those who have the problem with the formula for total 36:43 , here is the solution - =SUM(INDIRECT(ADDRESS(income_min_row;COLUMN())&":"&ADDRESS(income_max_row;COLUMN()))) the problem is that after min_row/max_row we need ";" not "'," also in the beggining we need "=sum" if you get value in the cell. Amazing tutorial man, thanks!

This is unbelievable. I was thinking of buying your template at first, but then I wanted to see how it works so I took the tutorial. Now that after +20 hours I'm finally done, I'm thinking of buying it just for gratitude. Thank you for this, I really appreciate the effort of putting this video together.

I followed this tutorial from A to Z. You, sir, are an absolute genius. The way you know your thing, the time you took to break down every single step, the tone of your voice... Everything was perfect. You could have just shown us your work and put a purchase link down in the description. You took +6hrs of your time to teach us noobs how to build something amazing. I am forever grateful. Thank you so much!

Just finished this absolutely incredible tutorial. I'm a university student with absolutely no Excel experience, and yet this guide was straightforward, easy to follow and unbelievably thorough. I'm amazed that this kind of tool has been made readily available on the internet for free. Thank you so much for the time and effort you have put into this <3

Dude ! You gave a 6 hour tutorial on how to build this epic budget tracker ! This is unbelievable. Thank you so much. Youtube Excel GOAT moves !!!

I also highly recommend adding a Reoccuring column in your Budget Tracking sheet in between Details and Balance with a dropdown for Yes or No, that way you can see what subscriptions you pay for or Loan payments every month or year and decide if you still want those subscriptions and what not.

Wow, this gotta be the greatest Excel sheet I’ve ever seen. Can’t imagine how much time and effort you had to put into this and then you just share it with us for free 😮

TIPS bellow it took me so many days (around 10 days on my free time) but I managed to follow and create my own! I cannot believe what I've managed to do (with your guidance OBVIOUSLY!). I confess some of the explanations were a bit too advanced to my excel level but I am very happy with the result nevertheless. Thank you for being so thorough. If anyone is following, I have a couple of tips: make sure of all your spellings on the formula bar. I had to go back a few times because the result seemed to be initially correct (when the answer was blank) but it would give me errors when I expected to have something returning. Usually it was a typo on the formula itself. Also, create your tracking list within the expenses, for example, in the order of your importance such as "groceries" in the first line, "rent/mortgage" on the second, "hydro" on the third, and so on... I just entered randomly and it makes a difference when populating the doughnut chart. Same for the other ones too (savings and income), top to bottom importance. If I remember anything else I will come back to update this comment. Thank you!

I want to primarily thank you for this amazing work I call, "a piece of art." I'm an analytics consultant, and there were many functions you explained here that I never knew were possible with excel. I will be using a lot of these moving forward in the production of a lot of my dashboards. Very well made. I went ahead and followed your explanation step by step to create this document for myself and it works perfectly on my mac.

GUYS FINALLY I SOLVED 30:31 Min Row and Max row function For Min row -> =Row(Index(Income,1,1)) Max Row =ROW(INDEX(Income,COUNTA(Income),1))

This is truly an ultimate personal budget tracker. Your generosity and patience to share such a detailed oriented 6 hours videos and valuable knowledge is highly appreciated!

Ok, this is seriously the BEST Excel video on personal budgets, period. 👆👍❤👆👍❤👆👍As a 35 year veteran Excel trainer and YouTube channel creator, I am absolutely floored by the incredible quality of virtually everything you've described here. I decided to create my own dashboard because the most popular money management applications have all gone into the cloud and I didn't want my information put at risk. Your gorgeous presentation with exquisitely thorough formulas and functions and elegant design elements makes this comprehensive tutorial a pleasure to watch but more importantly, a pleasure to actually use. Practical, yet so well designed that it really does provide an easy system that any one can use. I'm in awe of your skills. Coming from someone who teaches Excel up to the programming level. I learned so much even though I've used Excel since the very first version. Even your voice is perfectly modulated to make it easy to follow and understand though I did have to speed it up a bit - that's just because most of the techniques I already knew. 😊👏😊👏😊👏 EDIT: After walking through the whole video, I absolutely bought the template as a way to thank you for your work. 100% worth every penny!

Check mark symbol ✓ Arrow mark symbol ➜ Copy and paste if needed.

Finally completed using Excel 2019 version. Took a few days, typo errors, and some formulas had to be corrected for this version. Totally worth doing yourself, to fully understand the how powerful this spreadsheet is and excel itself! Like to send shout outs to everyone in the comments that posted formulas or keyboard commands for excel versions 2019! Time to Execute this powerhouse Template......

Jesus Christ, all of that in a six hour video! You're a trooper! I can't imagine how long it took you, to plan such a huge project.

I thought I was pretty good at Excel before this. I'm learning so much from this tutorial and I'm not even half way through! Thank you so much for putting this out!

I have finally completed this beautiful masterpiece. Point to note is excel 2019 on PC generates an error if used as =SUM(FUNC.A * FUNC.B) But will work if only written as =SUMPRODUCT(FUNC.A * FUNC.B). All other formulas work splendidly. Thanks OP