Create A Personal Budget - Take Control Of Your Finances | Chris Benjamin | Skillshare

Create A Personal Budget - Take Control Of Your Finances

Chris Benjamin, Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Lessons (1h 28m)
    • 1. Course Introduction

      1:22
    • 2. Instructor Introduction

      1:23
    • 3. Excel Introduction Part 1

      6:03
    • 4. Excel Introduction Part 2

      7:02
    • 5. Excel Introduction Part 3

      5:20
    • 6. Overview and Dates

      7:07
    • 7. Income Sources and Formatting Beginning

      7:12
    • 8. Monthly Expense Categories

      5:06
    • 9. Monthly Expenses and Loans Continued

      7:28
    • 10. Sub Total Formatting and Income Totals

      4:19
    • 11. Sub and Grand Totals

      6:33
    • 12. Formatting and Clean Up

      6:45
    • 13. Data Entry

      4:43
    • 14. Adjusting The Numbers

      6:18
    • 15. Using The Data and Refining The Budget

      3:04
    • 16. Category Percentages and Wrap Up

      7:09
    • 17. Course Conclusion

      0:50
28 students are watching this class

About This Class

Have You Ever Had That Nagging Feeling You Should Be Doing More To Budget Your Money?

Do You Want To Gain Control Of Your Financial Situation?

Do You Want To Rework How You Allocate Your Income?

Do You Want To Learn How To Build An Effective Budget Easily In Excel? 

If You Answered "Yes" To Any Of The Above, Look No Further.  This Is The Course For You!

*** Updated June 2019 with new content! ***

Enroll today and join the 100,000+ successful students I have taught as a Top Rated instructor!

Three reasons to TAKE THIS COURSE right now:

  1. You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads

  2. You can ask me questions and see me respond to every single one of them thoroughly! 

  3. You will are being taught by a professional with a proven track record of success!

  4. Bonus Reason: Udemy has a 100% refund policy - no questions asked and no risk for you!

Recent Review:

Margret S. says "So glad I took this course. I've neglected ever budgeting my money, but knew I should.  After taking this course I felt completely empowered to create a budget and actually take control of my finances.  It's such a great feeling seeing my budget fully mapped out so I know where I'll be spending money and where I have excess.  Instructor does a terrific job making it easy.

Why You Should Take This Course: 

Personal finance is a topic that is a hurdle for most people.  Where does the money go? Why is your bank account always empty at the end of the month?  This course will teach you the skills needed to properly and effectively create a budget in Excel, stick to it, and see exactly where that money is going! You will be a personal budget pro after this course!

In this course we go step by step, starting with a blank Excel workbook.  We then build an full personal budget from scratch.  By the end of the course, you have a nicely formatted, useful, dynamic personal budget which you can continually update and see exactly where that money is going!

I also provide the budget created in the course as a download, in case you prefer to use the one I built than make your own. 

What We Do In The Course:  

  • Properly lay out an effective budget

  • Brainstorm and include all the income, expense and other outgoing cash line items

  • Format the budget so it is easy to read and use

  • Create simple yet effective formulas for calculating totals and showing you exactly where you are at any point financailly

  • Add in comparative values as well to help you make decisions about your balance of expenses

  • Ultimately, we give you the ability to make sound and wise spending and financial decisions

  • And Much More!!!

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  

***JOIN NOW AND LEARN HOW TO BUILD A PERSONAL BUDGET EASILY IN EXCEL WITH MY HELP! ***

About The Instructor

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, Microsoft Excel and personal finance and budgets.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA

Transcripts

1. Course Introduction: Hi, everyone. Thanks for signing up for the course. Create a personal budget in itself and manage your finances. My name is Chris Benjamin N B. A CFO. And most important, your instructor for this course. I'm really glad you signed up finances, personal finances. One area that just is a bit of a mystery for a lot of people and that I get it, You know, numbers isn't everybody's thing, Norris, you know, constantly tracking your spending. Well, we're here to help you out with this course. We're going to start with a blank Excel workbook, and from there we're gonna build on entire personal budget at the end of the course. I provide you the template that we build is well so you can use it yourself. Or I also encourage you have. If you have an interest to build your own as you're following along in the course, we're gonna have a full 12 month budget for you available. So what? By the end of the course, you'll be able to see Well, how much money do I have coming in every month? Where is my money going out? What bills do I have? What recurring expenses what nonrecurring expenses join me to work into my budget. By the end, you almost have your own mini profit and loss statement. Here's how much income you had. Here's how much expenses and here's what your net at the end of the day is and hopefully it's a positive number. So that said, the rest of the course is going to be completely in excel. We're gonna do screenshots and start with that blank workbook and build it out. So it came out really well. The course. I'm excited to teach you all about personal finance and budgeting, so let's get started on the course, everybody. 2. Instructor Introduction: everyone little introduction to myself and sort of my backgrounds. They have a better idea of who your instructor is again. My name is Chris Benjamin. I have an MBA from the university Washington. I work as a CFO and as well I'll be your instructor. So the last 20 years I've spent in accounting and finance, that's my background. The 1st 10 I spent in sort of corporate life, if you will. I work for corporations. I worked myself up the ladder to the CFO level. At some point, though, I really had a passion for working with entrepreneurs. So I left the corporate life. I went into consulting on my own, working with start up growth stage companies, implementing all the types of things the CFO would do for a company. And maybe they weren't at the place where they needed a full time CFL. What they certainly could use my help on a part time basis, and that's what I've been doing the last 10 years. I really enjoyed it. I've had a lot of success in it, and I've seen companies go from idea stage all the way to being publicly traded. We've done that twice now, So definitely it's been a fantastic ride. And the best part is I get to take all the knowledge and learning that I've done over the last 20 years and now share it with you guys here through these courses. So that said, over the course of my career, I've done a lot of work in Excel, all kinds of different financial planning, financial analysis ratios, forecasting, you name it. I've pretty much done in an Excel. So that said, Let's dive in the rest of the course we're gonna be looking at Excel and going through the content, so buckle in, Let's get started. 3. Excel Introduction Part 1: all right, everybody is. So before we get started on the rial content of the course, I want to go over in excel, just sort of some basic sort of functions and formatting that we're going to use just so that if you're not familiar with that deal, you'll be familiar with it a little bit more when we're actually in the course. So certainly, if you are already an expert in excel, you know, sort of general formatting. You know some of the basic formulas, like sums. You can certainly skip this video, but if you're not familiar with it, this is your time to learn a few tips and tricks. So I'm just gonna kind of randomly come up with different things. But we'll start with first. Let's start with a lot of formatting things, and then we'll get into some formulas as well. And there's really not too many all I've done so far as I opened up a work by ah Blank workbook and I've already saved, and I saved his personal budget templates. So this is the workbook that we will ultimately use in the course, but for now we're just going to kind of you know, do some work on the spreadsheet, and then we'll clear it out for when we actually start on our personal budget. So, first of all, if you're not familiar with Excel, there's, uh, columns across the top and rose down the down the side. So any and these air referred to his individual cells. So any given cell has a reference. So this cell we see is in column D and its roe for So this is cell D four and I always say the letter first. Likewise, this is B seven. So later, when we get to writing formulas, we will reference certain cells by that reference. So like B seven plus D four, for example. So that's just sort of introduction, and he just sell. You can certainly types if we click on any cell in the night. I just type some numbers here on my keypad. You'll see they show up here, and they also show up here, so you can certainly just click on the sound, start typing, or you can also click up here in the bar and type up here and they will populate. Ah, that is handy if you want to say, the edit, This cell that say you type this number wrong, You come up here and click. You can move around and make it a seven or eight or whatever it might be come so fairly easy to enter data in any cell. And we'll be doing a lot of basically are our personal budget at the end will be a lot of sort of rose with headings and then columns with headings and then a lot of numbers in between. And certainly that's, you know, the nature of a budget. So, uh, so definitely good to know how those work. So say we have some numbers. Let's just type 12 15 and 20 It doesn't matter. I say. We want to bold some numbers now sell. There's a lot of different ways to do things, and you don't have the fortune of seeing what I'm doing on the keyboard always, and there's a lot of keyboard shortcuts, but I always say what I'm doing if I don't make it obvious on the screen, so say we want to bold these items. So for whatever reason, or maybe this one is a total I know this isn't the total But for now, let's just say we wanted to work on these and do some formatting in general so you can highlight. So if you click on any given cell and hold down your ah, you're left, click and then drag your mouse, you can highlight. And then when you let go, you have all these cells highlighted, or you could just do one at a time. Just click on the South, so I like to highlight all at once if we're going to do ah range, so this would be considered a range of cells that several cells. Then we can do a few things. So say we want to bold this well, the's buns here. So on the home menu. And if you have a different version of Excel, this might be slightly different. But typically these functions are on one of the main. The first ah, tabs, if you will. You see there several tabs and excel to say we want a bold these we highlight them. Then we can click the B for bold. If we hover over it, we see it says bold, and you'll also see in brackets. It says Control plus B. That's the shortcut. So if I just press control be on my keyboard, it will also bowled it. So we can either click this and we can click it again on Bold it. Or I can press control be on my keyboard, which I'm doing now compress it again and on bold up. Same goes for a tallix, and there's a short cut, but it's control I or you can underline. So the individual numbers get underline, so not too hard, so that would be extended of sort of bolding. We probably won't use underlying too much nor italics, but we probably will be using some bolding and your personal budget. Uh, also, I tend to like to sort of shade sort of importance, important cells and the way we do that again and say we choose again say, this was a total I know it's not, but let's just say this was a total column up here. Right next to here you have two things, so this one hasn't eh with a red under it, and that changes the actual color of the font itself. So if we click it, it changes to read, we own, click and then actually can't change it back is the dread. If you click this little drop down box, it brings up all the color palette so we can change it back to black. And you see, as I hover over each of these, it's changing the color of that number. So let's just leave. It is black that I don't tend to change the colors of actual text themselves. But what I do tend to change is the color of the entire cell. So right next to it, this basically fills the entire cell, so I know it's blankets empty. We drop down our box so we can see what you fill it with. Lots of colors. If we filled with black, we can't see anything because the Texas Black attended the load of like use colors like a light blue. Maybe like this, for a totals column or some of the tan ones like this one, just to make numbers stand out a little bit more. So again, you just dropped down that box. Click that, and there we go. And if you want to change it back, you can come up here and choose this, which is white. Or you can choose No, Phil, which means absolutely like no color. It's essentially Ah, one No. Two. Just speaking of, if you ever made a change in one and it's something wrong, you did something incorrect and you want to go backwards. You have a couple options again, Control Z, which you might not remember. But also, this little arrow up here is the kind of undo undo your latest thing that you just did. So we just colored that sell. Well, we just done Did it Now say we want to redo it. We can redo it, but typically your undoing. Something that you just did. So for now I'm gonna cut this video off just cause already getting close to six minutes and then we'll pick this up in the next video and keep on going with some or Excel tips. 4. Excel Introduction Part 2: Okay, we're back. So eso we showed you have interest in data had a color of the cells using this box. How to bold it using this box. You can also underline and whatnot, but I tend not to use those. Um, let me think of other sort of formulas we're gonna use in the in the course. Um, if we ever need to. Well, this kind of occasionally we might have the need to sort of put a title on something. So say we had a bunch of rows of data and it was quarter once. Let's just say this was and I'm just quickly typing some numbers, actually, Don't matter. Okay? And say this was January, February, March, and we want to write quarter one over the top of this. But we want to be dead in the center. Some people will try to type it in the middle cell and make it century, but it doesn't always work out, you know? Say there was four columns with data. You wouldn't have a center cell. What you can do is highlight multiple cells again. We can click and drag and hold and highlight. There's this box called Emergence center. So what it does is it took those three cells and made one big sell now. So anything we type in here is automatically completely centered. And you see this green outline, So that means that is one big sell. If you want to undo this for any reason, just click merging center again, and it will default the text to the first sell off the box. We won't use that too much, but I do think it's worthwhile, sort of noting, if you will, um, concertedly highlight things. There's alignment here is I mean, we can go across and go through every single, uh, aspect, but I don't want to turn this into, ah, a course on how to use excel. Um, just want to point out the major things. Those centers definitely one. And you can kind of tell here by the by The graphic that centers that or you can move back to the left from formatting is important. So where will be doing a lot of dollar signs? Um, I tend to use the dollar sign when I, you know, doing things like a budget casual statement, etcetera. So few highlight numbers and click this dollar side. It automatically puts in the dollars with two decimals. If you don't want the decimals, there's this decimal mover. You can increase the decimal size or what we want is to decrease the decimal size. So just click at once, click it twice and it moves that decimal across and it will round up or down any numbers we won't get in tenia uh, these things feel we don't necessarily need sonny of this stuff. Ah, we won't necessarily be using and and what it is that we're doing in this course, So we kind of have ah, ad hoc little. I wouldn't even call it a budget. But we have a table with some numbers. Um, let's say we made a mistake and, you know, we forgot a month. We needed to insert something right here. We have a couple options. We could certainly just copy these and move them over one. Uh, I'll show you how to do that, and then I'll show you a different way to do it that I would probably actually choose because pretend this was a lot bigger. It went down several rows when it crossed. Several columns would be a bit more tougher to do with this method. But if you highlight again, I'm click and I hold and then I let go. You can if you hover over the edge of any box. You see, my cursor turns from that plus sign to ah, a four way arrow and then you click and hold again. You now hold here now holding that box and you can put it wherever you like. If I just drop it here and moves from here and if I want to move it up here, move back. Or as we said, we just want to move it over one. And now I've got this the other way to do this and I'm gonna use my undo feature. So there we go. Um, would be just inserted row here and again. Imagine you had several rows of data kind of highlighting and moving things isn't always as easy, especially but went across several pages. So, uh, one other way to do it is you can highlight any row. Sorry. Well, these would be rows or columns, so you can highlight a column, and then we can insert a new column on their several ways to do that. Ah, we have insert here, so insert cells. And since we have ah, entire and then I do it yet we have an entire column highlighted. So if we go insert cells, there we go. It just moved everything over one. Likewise, we could do that for Rose. Um, under if we had highlighted If you see it brings it up. But if we already have things highlighted, it will automatically default and probably say in search, he rose. So there you go. So that's a way to insert things. The nice thing about this and we haven't gotten formulas that if we had a formula stay over here that was adding these three, um, these three columns and we realized we needed to insert it an extra one if we did it the first method where we would just drag things over. The formulas tend to get a little bit messed up. But if we insert the way we did, the second way formula will update itself. And now we'll grab the entire thing, and we'll see that when we get more into building out the excel sheet itself. So what else can I show you? Um Okay, so now that we have some numbers, um, thinking of things like totals lines again. So I showed you how you might want to highlight. And again, this isn't a true total. Maybe let's put in some totals and then we can see what we would do with themselves. The most simplest of formulas on this is, you know, pretty much just adding, and subtracting is mainly what we're going to be doing in this course. So adding up these numbers, it's a simple as you can either hit the auto some button if you put it here and it will automatically grab these three sells and he hit, enter. And there you go. When we see that's correct. You could do that for all of them. In other ways, you can just hander I tend to handwrite this the formulas. I don't always go for the bottom, even though the buttons probably quicker. Um, the There's several ways to do this as well. You can go equals, and then you can highlight individual cells and say this cell. And then the plus sign and we see up here the formula were writing plus this sign, plus this sign or the self. Sorry. And there you go. That's your total. If you hit F two on any sale, it will bring it up so you can edit it if it's just a individual cell or if it's a formula as well. I mean, I still edit it, but it'll actually highlight what it is that you're adding or subtracting. Um, so now we have a nice formula here. Uh, here we did it with a some formula here. We did it by adding individual cells. They both accomplish the same thing. Say, we know we want the exact same formula here. We could rewrite the formula or we could just copy this formula. Ah, we go up here, get on this home tab over here on the left is kind of our copy and paste things. So this is copy right here. We can click that button, go here and hit paste. Apple is that and it copied and pasted that form of the calf. Kind of a weird number. Here, let's make this like 20 in this 50 for Let's just bring this down to 50 as well. Just so the numbers are kind of all in line So right now I have a little, you know, many table. We have three numbers and pretend this is like maybe January February, March. Let's even just write that. And again, we're gonna get way more into this once we actually start working on ah, the personal budget. But for now, I just want to demonstrate sort of how you go about these things. Actually, I see this video's already. It's seven minutes already, so let's cut this off. Will do. Ah, one final video on Excel. And by then we should be wrapped up. What kind of the basics that you need to know. 5. Excel Introduction Part 3: All right. So let's wrap up our little intro to itself. I'm sorry we left off. We had three columns. We're assuming Samra family march. We don't know what those data is. Maybe it's your Rencher. Uh huh. I know these numbers don't make sense your cable bill in your gas bill, but nonetheless, we have a total here, and that's the sum. But if you were just to see this, you wouldn't really be able to make sense of these numbers. So we need to kind of format. And obviously we would put headers over here as well. Or Rose titles, I should say, um, so we talked about, you know, using this and highlighting its We see how that's kind of useful, you know? Now we kind of see, Oh, this was important. Another thing I would I would do and that we will be doing the courses using kind of, uh, underlining and over lining. So we're not gonna be using this one because it does it just for the the numbers or letters in the cells. So if we click this since there's a dollar sign, it kind of does it the whole way across. But if it was just a number, it would only do the number. Plus, I don't like that. It sort of sits above the bottom of the cell. We want the actual cell to be the underlying number. So we're gonna undo that. The way we use it is the one right next to it. So by default, it has one with a single underline, and I'll show you what that looks like. So you see how that's different is right across the bottom of the cells, Um, for totals column. So I tend to like a different one. And if we get if we use this little drop down box will have more options. So that's a bottom boat border. The one that you typically would use, um is the top and double bottom. That's just kind of standard. I would say it's sort of in the accounting world, and that's what I come from. So it's what I tend to use in a personal budget. If we click it, let's take a look at what looks like that's definitely so now it looks much more like we see the single line that kind of means, like Okay, there's something here related to these three and then the double line kind of means, you know, final like this is the final total. If we had a sub total somewhere in a sheet that had more numbers under it, we would just use a single and a single line. So that's what we'll be using in the budget. Eso we know all about adding, subtracting works exact same way. Ah, we conform at I'll just still quick thing on dates. I mean, we just typed in January, February, March, but say we want to say January 2018 February 2018 I mean again, we could just type generate 2018. It automatically texted it's a day and it kind of formats it like this but say we don't like that formatting. Um and I tend not to. I tend to like a slightly different format. You can go here. It automatically detected it was a date. What you can do appears go custom. So this little boxes formatting again. Remember we formatted here. So this is also formatting. So we go down and we're dealing with a date. So they have short dating. Long date. Let's take a look at short date. So that is considered a short date. It's actually still working away. Oh, here we go. More number formats. That's what I was looking for. Okay, so now we have date. So we brought this box. This is a lot more options. So a lot of different options. So we're working with a date. And how do you want this date to show? Well, I tend to like, let's see, Maybe let's go with. I guess we're stuck. I thought there was one. That was the full date, Like March 2018. Apparently not. I'm mistaken on that. My apologies. Okay, well, we certainly will live well live from. So let's just go short date, more number formats. I guess I should have actually changed it when I had it there. I'm gonna tend to, like the three months I mean again. Tailor this to what you like. Ah, here. Those since. So here we have to do the same again. Weaken Type in like 02 No. 1 2018 for example. Sorry. I'm making a few typos here. I'm in here. 03 a one 1 18 Or you could write the 31st. It really has a matter. Since this won't show, we can copy our format. And one way to do that is with the paintbrush. This will show format painter. So the first step in format painting and I'll show you another example of this would be to click the cell that you like the format off. So we like this one, and then it can see this jog line. You highlight the cell that you want to make the same as that one. So I'm gonna highlight both of these and a copy of that format. Likewise, he could do with numbers. So let's just say I have some numbers and I want them to be dollar signs. Well, I could certainly, you know, do the thing and the dollar sign, but say we also want it, um, the total. You know, we typed in our total. Um, let's just do that. That that that So we have a new column, but we want to look like this. And what the dollar signs. We want the colors that we don't have to do all those steps. You could just highlight a range of cells, a copy of the foreman and will you go. There you go. So quick, little shortcut if you need to revisit that one, just sort of rewind to take another look. But essentially, all we did was, um, tell Excel. Hey, make these cells look exactly the same as these. And we did that through the format. Painter. All right, guys, I think that might be it. If there's anything else I think of Well, just introduce it. Ah, during the course, if you will. So you got kind of a little mini less than their own. Excel with that. Let's jump ahead and start. I'm gonna clear this out. So in the next video, we'll start building our personal budget. 6. Overview and Dates: Okay, everybody. Now that we know some basics and excel, let's go ahead and get started on this personal budget template. So, um, since we're starting with scratch again, we have a blank template. I encourage you. So when you open a new workbook, always given a name and save it right away, So any work that we do, um, you can save it along the way and you'll automatically have it. You can also turn on auto save I. I personally don't. I'm just for a reason. Flaw in my computer. Actually, Putnam nonetheless. So we have this blank workbook anything. Okay, well, where do we go from here? Some. It'll all come together. Obviously it first inmate look a bit haphazard just because you don't have a reference. Um, just to give you some idea at the end of the day, what we're gonna have is, um, kind of your income sources listed down here and then a sub total. Then we're gonna have all your expense items listed down here on a sub total and at the bottom with Well, let's say for now at the bottom you're gonna have a toast. Will be your income less your expenses. What I tend to do one little twist on that and we will put it on the bottom is I put it across the very top, so we'll have a revenue. There's not a revenue, but our income sources listed here, Um, again, Still, But there's very top line will be that calculation of total income, less total expenses. And the reason I do that is I want to be front and center. I want to see where I'm out at the end of each month. Given my budget as well, we're gonna have our months listed out. So, um, what will ultimately have is sort of that that income less expenses, number. Then we'll have the month. Then we'll have all our income sources and all of her expenses. They will have each of our months listen across and that typically go out about 12 months. Um, I don't always update. It's not like one month goes by. So I had another months to the end. I typically just do it for the entire year, and then somewhere, maybe mid year, you know, when there's only about six months left updated and revised it for the right for the upcoming year. Or maybe just add on six more months. But that will be personal preference. And that's about it, guys, that's honestly not too difficult. In the end, it's really just a matter of taking the plunge. Oh, well, message from you, Demi. That lecture is up. Sorry about that. Go ahead and close our inbox. There we go. Okay, so let's get started on this. So Ah, that's essentially what it's gonna look like. So now we need to start, you know, basically putting an information and the way I would suggest we tackle this is first we'll kind of start putting in the main headers and the main role list, like the items that we want. Then we'll eventually start and then do some formatting on it. And then we're gonna put in some data, and that's how we ultimately tested and make sure that it's working. And then that will kind of get us to the point where you could then take it on and you can add in and kind customize the model so again you can follow along and work with me building . Excel yourself or if you just want to follow along, see how one is done and maybe just use my template. I provide this at the end. The complete it ah, personal budget that we haven't. Sorry if I refer to it as a model or financial model on the way kind of use accounting terms sometimes come. So let's just start. So I mentioned initially that I like to put the total across the top. So let's leave this blank for now because it's gonna be a formula and we don't have anything to add or subtract at this point. But one thing we can certainly start with us the month now. I tend to not just start right on the far left because I know there's going to be things like we're gonna have all our expenses listed. Sometimes I like a little space like a break. Um, and one thing I'll just mention if we want sort of like an empty column, you can hover your mouse over the break. And then if you click and hold and drag, you can resize the column. I'm just kind of scrolling back and forth so we might actually put in, you know, like an empty cell here. It's just kind of creates a break, but for now, we don't know yet what we're gonna have. So let's just go a few cells out and will be moving things around. So let's just assume, um, this is going to be even though currently I'm recording this. It's the beginning of 2018 actual. It's actually March is no longer the beginning. Ah, but let's just start it started for New Year. Let's do for 2019. I know we're reaching far ahead, but just for the point of having kind of a January to December budget. So if you meant, remember in our excel, uh, kind of less than that before these videos, or if you didn't follow unease e way to put in a day. That's just kind of I used the first because in the case of our budget, we're not actually gonna be looking at the specific day of the month. Um, at least not the way that I format it like we're doing our columns by month. So it's gonna be January, February, March. So whether I put in a one a one 2019 or I put in you know, no one, no one are sorry. 1 31 2019 won't matter. Because at the end of the day, we're gonna format this and again, I'm kind zipping ahead. I'm assuming now you kind of remember some of those things, but this is our formatting box. Um, it puts in the short date, but we wanted a little bit different. I'm gonna go to more number formats date. And I kind of like this format here, the three letter month and then the year. So we did it on this cell. We could certainly redo that. Or if you also remember, if you watched Excel kind of tip tips, you could do a format painter. Click that and click here. So it didn't matter that this one was the first and this was the 31st. Because ultimately we're just representing what is the month in the year. Um, so let's go ahead and put in the rest of these months and the well in this video, and then we'll pick it up again in the next. So eso certainly this will actually be February, and I tend to use just the first just out of habit. I will give you one other short Katz's. Certainly we could type these all across, and it wouldn't take that long. But just for the sake of kind of giving you guys a little bit more power in Excel, there's a fill function. So you can. Actually, if you have a series of numbers like this is gonna be months since, could be growing by one month each time, right? So what you can do is you click the 1st 1 that's in the beginning of your Siri's and February works just because we're going forward from February, Um, and then we're going to go about 10 months outs. Let's see. 123456789 10. I believe that's 10. There's a ah function over here called Phil. Now Phil just fills numbers, but we want more of a Siri's. So here's the Siri's, and again, if you need to revisit this, if you're not familiar with these and it doesn't quite make sense, just go back, rewind this video a few minutes and watch it again. Ah, and posit, as you do things, so certainly highlight the Siri's click feel. We're gonna come over here. It's across the row. It's a date. So it's automatically detecting that this is a date that we're gonna be doing and it's gonna increment by one day. But we don't want that. We want to increment by month. We wanted to go a month at a time for each each column. We changed the month that value one. So one month each time, okay, and let's see what it does Perfect. February, March, April, May, June, etcetera. Ah, so there we go, guys. That was a quick way. And you can imagine. I mean, certainly for that, we probably could have typed them just as quick. But imagine you are putting five years worth of dates and much faster to use the fill formula. So let's end this video and we'll pick it up in the next one. 7. Income Sources and Formatting Beginning: Alright, guys. So we have our dates across. Um, nothing too much fancy yet, but, hey, we We learned a few lessons, haven't we? How to format things and how to fill the next thing I want to do to these dates. I want to center them. I just like the presentation to be nice and needs. So, um, again, we're gonna highlight everything. And again, that's obviously becoming important. So just a reminder. If you click out any cell, hold down your left click button assuming Iran PC and I believe on a Mac, if you just click and hold this works the same and drag across the drag your mouse across and you can see like I'm just moving my mouth and then release. Now, these are all highlighted. And anything we choose up here will impact all of these cells. So we want to center them. And remember again, this is our texts. Entering. This is our text box tech center. There we go. Easy is that I'm gonna hit the save button. You should be doing this. If you don't have auto save on, we'll definitely be doing that just every few minutes or when you think about it. One other thing. Just right now that I noticed that I like to do again. This is completely sort of my own preference. Some of these things you don't have to do it. Um, I like to rename my tab. So you to these down here is that tab and there's only one currently let's say you wanted an additional tab for whatever reason. In the future you can click the plus sign, and now there's your sheets that call them sheets. But it's up amused, referring them as tabs, and you can click back and forth so she won has our information. She, too, is blank, and he gets certainly add more, which we don't need. But if you did have a work, so this is considered a workbook. If you had a workbook with multiple sheets, you kind of want to name these what they are like. We don't know what's on sheet three. So if you double click on the name down here and highlights it, you can then type and we're just gonna call it personal budget. How about 2019? You know, maybe you want to retain this and then for 2020 would have your budget 2021 etcetera. And in the future, you can look back and just take a look at your budget. See how far you've come. All right, hit the save button again. So let's see what is next. So we have our month. Next. I kind of want to put in. I want to do is just a tiny bit of formatting just toe sort of figure out actually, before that. No, let's not do that. Let's think about our income sources first so we can start filling in some of these rows because we're going to take a methodical approach. So we have our kind of our column headings. Let's start putting in some information here, and even if it's not, if we need to add things later, that's OK, but just to kind of have some framework. So we're gonna have our income sources. So let's just type that over here and again. I'd like to leave some space because it's easier to delete space that is, to insert it. It's not too hard either way, but nonetheless, let's talk about her income sources, and again, I'm gonna leave a space down and across so income sources. Now, you might just have one. You work full time and that's your income source, and that's OK. And maybe we're gonna type that here. And that might be your job, but rather in your job. Let's just call this. Ah, you're employment. Um, you could certainly write out. Say you work for shell Company Shell oil right in shallow. However you want to frame it myself. I know my own personal budget. I have a couple of different revenue streams. I my consulting revenue. Um, sometimes I like to break things out. Maybe I like the revenue that comes by client. So I have my different clients listed out and again, I'm referring to it as revenue just cause I'm thinking more of a business. But certainly in a personal budget, maybe every employment and maybe hey, you sell some stuff on eBay on the side and maybe you also like to go yard sailing and you buy things and then you sell them off of eBay. You just sell it on locally in your city. Um, let's just call that yard sailing. Not sure how you would ah, sailing. I believe that's right. Anyways, So there we go. We have are three sort of sources of importer of income, so I don't love the formatting of this. There's a huge gap between income sources on this. Now we could certainly just putting sources on the top. Maybe bold it. Here's what I suggest that this is what I like to dio. Uh, I kind of showed you earlier. We can resize different columns and rows. Let's resize this road just to be a little bit narrow. And now what we have is income sources with a slight indent. And now we have these guys I like that far better, and hopefully you do too. So, actually, while we're here, just speaking of let's let's go ahead and give us a bold, you know, usar bolding skills. So there we go. So have income sources, and we have our three income sources now. Certainly, we're also gonna have her expenses. And when we think of budgeting, I think I think way, think a lot more about whatever our outgoing money. So, um, let's just put this as monthly better for you. Type that right? I'm actually gonna give up just a bit more space here and you'll see why. Shortly Monthly expenses. And then I'm gonna bull this already, cause I already know that's a heading. And then one other thing I'm gonna do I'm gonna assume that we do some savings. Now, if you do saving great. If you don't, you certainly don't have to include it. But I want to kind of show you having sort of multiple. Ah, you know, items here, if you will. So let's just put savings, so savings will still be money that's going out. You're setting it aside. Certainly. It's an asset. You own it. But this is really a budget. So we're really trying to calculate what are incoming money isn't our outgoing money. So certainly if you put money aside in savings, it's not money you have available. Just suspend etcetera. So I'm gonna we're gonna treat it is almost like an expense. We're not gonna label it, Spence. And hopefully that'll make sense. And you'll see why I think a bit more once we start putting it all together with formulas again. Um, so one thing I don't like here and we're gonna in this video right after we fix this. You see now that we've resized this column. There's an overlap. So this column now these these titles, air overhanging this. So what I like to do is on. We talked about this earlier is insert another column here? So there's two ways to tackle is I could just copy all these and move them over a few or even quicker. I'm just gonna insert a column here. So if I click on this, I can go to on my home tab. Um, there it is. Insert insert cells or insert column. Either one will work, and there we go. So now we have a nice column here so we can do a few things. What I also like to do is see, this is in this cell. This is in C five, but it kind of overlaps in the D five. Let's make this row as wide as it needs to be. To kind of handle all of that. There's two ways to do this. We can hold on the middle and drag and resize. Just remember, I'm scrolling back and forth, or if you double click on this, it will automatically expand to the widest text box so it automatically fixed itself. Perfect. Now, we also have this title which actually, um is in this little cell here. But it's so long it overlaps here. This one we might have to manually fix. So we might have to just expand this out just a bit further. And now we've got this big gap. But here's what I like to do. Like to make that one smaller. So hopefully you followed along for all that. Basically, I'm just doing a lot of clean up. You know? I want this. I want this little in Dent for our subtitles. But I also want this column to be wide enough to handle all the text. And then I want a nice little gap here between where we're gonna have titles and where we're gonna have data that said, Let's end this video, and then we'll pick it up in the next one 8. Monthly Expense Categories: Okay, so here we go. We got our months. We got our beginnings of our, uh, our row headings. We have our income sources. We will eventually put in some sub totals and etcetera. But we kind of do that Not last last, but after we get our items in. So for our monthly expenses, I'm envisioning that we have Ah, we have several. And what kind of limited to maybe 10. But you know, obviously as many as you have, it's how many you need to include. So I showed you the trick where you can click on a row, go to insert and insert a row. That certainly works, but even quicker way just to give you another shortcut if you want. If you highlight a row and then right click on it brings up a box so you can do lots of things. You can do some formatting, clear the contents. But one of the things is insert. You can insert additional road. You saw that Scoot down one another. Trick. If you highlights several rows and click right click are sorry. Yes, right. Click and hit insert. It'll insert as many roses. You have highlights. I've highlighted three. So it's gonna insert three more. The perfect a good way to enter, like a big block. So I think we need a few more. I said would do about 10. We have roughly 10 but I want a bit of space. Let's just do two more. And if we need that, another runs fine. So again, we're leaving ourselves a lot of space to work with, because we're gonna put in sub totals and we can clean it all up and believe things afterwards. So let's put in our expenses now. The way I like to do this is I like to think of this is reading downwards. So in the month of January, you know we have our employment income now for me. Personally, I don't I don't worry too much about the dates of the employment income. Um, what I do worry about is the specific dates of bills and when they're due. So I like to list these in order of when things they're typically do. So I'm gonna say we have a renter mortgage. Let's just say mortgage, But certainly if it's rent, it's right. And that's due on the first, then maybe we have a phone bill after that. May we have car insurance? We pay. And again, this is where, like, we're gonna throw in sort of 10 placeholders. Kind of apply to everybody, I would think. Or most people, but certainly tailor this to what your needs are. Maybe then you have a power bill. Well, maybe your credit card, uh, credit card bill is due about the 15th and we're actually gonna put it. I'm gonna add in another column where we put in the due dates. Ah. What else do we have? Let's see, We have a cable bill. Our You know, our television bill. Then we have other utilities, like power. We already power, but say we had natural gas and stuff. We have, ah, car payment. Let's do that. We have a car payment. And what else might we have? We have an Internet bill, and who knows? Maybe we, um we have a student loan. Let's say we have a student loan that we're paying. Okay, so there's 10 so Certainly, obviously you can put in whatever this is. And that's where you really need to tailor this to your own needs. So before we get too far down. Let's insert another column here, and we're gonna have just sort of resize it. Could I know it's not gonna be the biggest. Now, this one is gonna be the due dates we can certainly put. We could just call this d d like due date or we could put Do I put a question mark, Let's do that. Let's maybe bold. This is Well, I'm gonna hit control, be this time control be and then hit this to center in. So do and actually do is more related to monthly expenses. So we're going to use our way of dragging this down. Remember, if we hover over the edge of the box, click and drag do so now, the supplies more to these. So it's due on the first. So, since this is universal for all these months, we're just gonna put in a number. And actually, I will actually just type it, so I'm gonna say the first. This is due on the fifth, the eighth, that 12 the 15th the 16th maybe the 20th 23rd or fourth and 30th. Okay, so there we go. Now you have to think about your monthly expenses. So these air kind of all our bills, that's great. But the other things so personally, the things I liked also included, or just like spending money like I give myself a budget every month of how much I'm allowed to spend. That's for going out, maybe eating out now. Certainly a lot of people will budget the specifically they might put, you know, eating out gas. You know, pet supplies will be another one. I like to just lump that under just sort of general spending, mainly because there's not a specific due date. That's just something that happens over the course of a month. So I might put in spending. And if there is a big category, select gas for the car. If that's a bigger one, I'd like to break that out and track it individually. So gas, um, and that we don't need to put a due date because it's just over the course of the month. Um, you know, pet supplies if you have them, there's a 1,000,000 different things. If you have a hoppy, maybe you have membership dues that you're Jim. Another thing that would have probably a due date on it so you could put it in there. So there you go. There's our monthly expenses and certainly can see Put in whatever it is that you need. I'm gonna have that save button again. And actually, let's go ahead and end. This video just does a good cut off point, and then we'll pick it up and kind of finish off with some savings. 9. Monthly Expenses and Loans Continued : Alright, guys. So let's move on. So let's I'm assuming you have savings. If you don't, certainly you could just leave this line item out and I wouldn't necessarily say skip this video just cause we might do a few additional things. Besides, look at some savings south. Um, simple. Maybe you have a savings account. Let's just put them. Maybe it's your retirement account. Maybe were, um, retirement. Let's just leave it at retirement. You contribute to your retirement account and maybe have a general savings, our bank savings, whatever you wanna call it Now, um, again, probably not. Something might have a date, so maybe haven't on it. Let's say you do. You have an automatic withdrawal, and it's the 15th on the 15th just for ease, certainly whenever you needed to be. Um So why we have these and you're gonna see we're gonna be subtracting these former incumbent at the end of day. We want to see if we have a surplus or a negative amount of cash. So this is certainly cash that's being pulled out of your available amount of money that you have, so that even though it's money that you still have available to you. It's on the side. We're really looking at our monthly budget and what we can afford to do. Um, no. Try to think of, you know, you're trying to make a decision. Could you afford to get a second car? Well, this is how you would calculate that You need to calculate all of your outgoing money. Okay, so we're starting to look good here we have. Ah, a bit of a framework here. But, you know, what we don't have is a lot of formatting yet. So I like to do some formatting in general just to sort of start to break things up. So it becomes a little bit more clear, and then kind of the second last thing we'll do is put in formulas, and lastly, we'll put in some data and test it out. Okay, So first of all, we like to have our months kind of, you know, let's get this kind of a heading. So let's, um and I'm just gonna do it all the way across. We're gonna go all the way across, and then all the way down, so we kind of create a nice box. So I'm just gonna go across here one thing, and I'm just gonna come out. I don't tend to use. If you do this, you could certainly bold this entire row and it will go the entire way across. I don't tend to do that. Just because if you ever have to change the formatting, sometimes it gets tricky. But I might just go out to here. I'm gonna bold it for one, and then I want to put that kind of single line, single line around it. So let's drop down our borders box. And if you see, so there's a top and bottom thick border or just the top of bond border or sorry, Top bottom is normal thick. Let's see. I don't really want to get the thick. I just want a normal sort of top and bottom Didn't even see that they have that. Honestly. All right, so what we might have to do is double duty here. We're gonna go bottom border, and then we're also going to go top border. And there we go. You couldn't see it when the cells were highlighted. Uh, but that's essential idea. We just click the top which get the bottom and put it in for us. So now we have a nice break here. The other thing I like to do then is obviously sort of separate off to the left. So we're gonna do the same thing here. We're gonna put a border on the left side of this and actually going to one other thing. And this is just a personal preference thing. And I'm gonna come down a few cells as well, just cause ultimately we will have a total down here. So I'm gonna put in a left side of border. Now we see we have a nice break here. The other thing I really like to do. And you don't have to do this. And I don't think this just came out of habit. It's a habit I picked up at one point. I like to make this small kind of column here actually like to highlight her like that. Put in a color just to really break it off from the other side. So we fill this so we highlighted all those cells and we kind of have that Roe or Sorry, that column really narrow. Now I like the height, like just give it a color like a nice dark green just to really create a visual separation in the data. And I'm gonna make that column sort of extra small. There you go. That's a simple Is that personal preference completely on that one. So if you choose, if you want to do that or not Okay. So let's see, what can we do next? We have lots of options. That's the nice thing about these types of things. You can kind of do things out of order. So, um, let's start putting in some more, sir Lining if you will. So one thing I want to do, I want to narrow this column over here is because we have a big, empty space and there's really no need for it. There we go. That just looks a little bit neater. Okay, I'm gonna hit the save button. So one thing we want to do is we want to put it is kind of a sub total for our sources. So before we can put in the formless Yes, we know it's going to go right here. Say, we just know whats these three things that maybe you want to leave a blank, one for a placeholder. And just in case you have some future, um, source of income. And certainly you can insert a road. A future point, But I like to just leave, you know, one empty space. So what I'm gonna do, what I want to do right now is highlight thes and kind of do the same up top and bottom. Ah, borders. That's the bottom on the top. So what we're gonna do? Ultimately, you're gonna have some numbers in here, and they were gonna sub total. Now, let's do the same thing here. Well, we kind of left a space in between her expenses or gas and spending. We certainly don't have to do that again. I like to leave spaces sometimes just for filler, especially if it's not a big I wouldn't leave like, 10 empty rows, but one empty road just for ah filler. And then what's put in what we will put in is a sub total here. Now, one thing you know, this is we can no longer see the top, and I can't quite remember how far we came across. I'm just going to scroll up. We came across the column s. I'm gonna show you how to fix that in a second. But since we have this highlight it, I'm gonna do the same thing here. I'm gonna go bottom border and a top border. All right, so let's do this one last thing. And then, um and then we'll cut this video often that will finish off with some borders on the savings and then for some totals. So, as you see, as we scroll down, we lose what the months are. So say we're here. We have no idea what month this is like off top of our heads. Likewise, if we were scrolling across, say, we went way across that we had two years out as we scrolled across, we're gonna lose what those you know, we see a number here. We don't know what that was. So here's what we're gonna dio There's a way to freeze these rows so this road will always show on. These columns will always show now there's, um, the way to do this since we want to freeze both the top here and the left side. What we do is we go to kind of that transact air that Yeah, I guess the transaction point, if you will, where we want the freeze toe happen. So we want everything above this and everything to the left of this to always be on the screen on Lee. This middle section here ever moves. We do that. And then what we do is we go to let me think we go to view. So the view tab and then we go to freeze panes. And if we drop this down, we can see that we can either choose just the top row, the first left column or if we just choose freeze panes it where we have our cell will do everything above it and everything to the left. So let's click that and see how it looks. All right, so we don't see much other than kind of grade this out and you can't tell, but it also put a gray line down here on the colony. So what happens now If we scroll across now, watch that left side columns A, B, C, D and E don't move. They always stay visible. Likewise, if we go down that top row. So column arose one and two just always visible. So it's 12 and then a break 11 12. So essentially, it's just this middle section here that's moving or think of it is thes rose or frozen, and these roads, they're frozen. That's perfect. That's exactly what we want. So I'm going to save this right now. Let's end this video and then we'll continue on with putting in these and now that we can see our our headings up here even better. 10. Sub Total Formatting and Income Totals: Okay, let's continue on. So we have our our columns. Uh, sorry. I was gonna say a row kind of sub totals when put in numbers that let's do one final one here. Um, well, we could leave in a blank. Let's leaving a blank. Let's go with the same. And you know what? Since we have this row is exactly what we want the next, this other one to be Let's just copies. Let's do our format, painter. So we collect this row, go to our home tab. This little brushes are format painter, and then we're just gonna highlight this row. Bingo. It's all filled in. Saves us sometime. Once he learns that was kind of a little tips and tricks and excel. You can definitely kind of make those things happen really quickly. Him? It's a button really quick. All right, so right now we're at some point you're starting to envision, we're gonna have numbers in here with a sub total. We're gonna have our expenses of the sub total on our savings with a sub total. Now what I like to do again, I like to kind of format these, but let's format them after we put in some numbers, just we have a better sense of how they look. So what should we do next? Take a look at So ultimately what we might want is kind of our income. Less are to expenses are outgoing money, if you will. I want to put in kind of a grand total here. That will be the income less the two outgoing money. What's our grand sort of in floor outflow? And then we're also gonna put that number up here, but I like to show it just at the bottom. So down here, I want to put in a place holder. And again I give it a space where we do and I kind of show do in one XL videos from the single line within the double line, that kind of denotes like a grand total. So right now this looks like a bit of a mess. But once there's numbers in here, it will make a bit more sense. Okay, so I think we're getting close to putting in. Numbers aren't way. So let's take a look here, give us another safe. All right? Actually, before sorry. Before we put in numbers, let's put in some some formulas and then we'll ultimately test the formulas with some number. So let's just start off with a simple, simple one like and actually, none of these farmers they're gonna be It's all gonna be adding and subtracting. So our first formula is gonna be a sum of all these. Now when we want to add these and we actually want to add this blank one, just in case you ever put in a place holder, we don't wanna forget that we don't. This formula doesn't pick it up. So if you remember, if you know the some formula, this is the perfect place to use it. There's also an auto somebody in, and I'm not sure how it's gonna work because there's no data in the cells. Uh, let's give it a try. I'm just curious and actually know what hovering over it. Well done. Never mind. Let's give it a try. Ah, see it to know what to add. If we had had enough some numbers up here already, it would have guessed like, Oh, hey, you probably want to add these things. So I'm just gonna escape out of there. So the way you can do this again if you're familiar with Excel, and I tend to just like to write the formulas myself. So I hit the equal sign type the word some. I put a bracket, and then you can just go and highlight the cells that you're gonna add together. So again you click and then right click holding drag Go. Then if you close your bracket, it enter, and they got it. Zero, because there's nothing up here. If you hit up to on the cell, it will bring up the box and show you what you're adding. And you can also see F five F eight. Now if all that was a bit of a blurred a bit of a mystery definitely encourage you to go back, take a look at the Excel introduction videos at the beginning of the course, or just read up a little bit more about the some formula. Okay, so this are this formula is adding up these cells, so let's go ahead and let's just copy this across, and then we'll in this video that will put in formulas for the rest of the rest of the spreadsheet, or as far as we can get. So since we know that this form is gonna be the same here, we want to add these cells or sorry, these cells here, etcetera. We can copy this formula across its simple Is that so? One. So it's easy. As I'm just copy. We can highlight all these cells. Let's just go. This fire, which is kind of put in a few extra spaces on the right, Go over, right click and then paste. And there we go, and we can double check these. I was advocate double checking and we see just just spot check a few. Of course, they're all good. Okay, let's end this video. When we come back, we'll do the formulas down here for all of these and the ones at the top, and see where rat for that video. 11. Sub and Grand Totals: Alright, guys. So we put in our totals appear just as a reminder that we're going to some formatting. But let's do in a second, because all of these are going to be numbers dollar numbers. So we're gonna format this whole area in one sort of swoop rather than individually do it. So here also, let's do our total. So I'm gonna move this. I'm just scrolling around so that we can see this whole sections. This is gonna be a sub total of these numbers here and again. We'll put in data that can be a last step. So, um, again, we're gonna hit r equals type the words some put up, open our bracket. Highlight all of these things groups Just this column. And then at this point, I'll show you what happens if you hit enter without putting a closing bracket. It puts it in for you. It's smart enough to know that you need to do that. Now we need to copy this across. So I showed you where you can go here. New hit copy scroll across and hit paste Another way. A keyboard shortcut, if you will. So let's tell you what I'm doing If you press the control and then hold down control and press. See, You noticed the dash line came up. So it's copy. It's the same as if I click Copy. I can also then use my arrow keys and go Danny cell. And if I hold down shift. So if I go here, hold down, shift and now arrow across. It's highlighting all the cells and you can move up. You could move down, but we just want these cells and I want to copy this formula. Toe all these cells all I did withhold control, See, moved over here. Shift a road across. And now we're gonna hit paste or the same equivalent would be hitting control V Control V on. There you go. It's in there. We can spot check a few again If you go to a selling hit F two that brings up the edit button and you'll see it and you see the formula up here as well. Okay, so let's do this for this. This as well. So here, when they have to items like what we want include this empty line and we didn't include an empty line here, but that's OK, so we're gonna add these three. So again we're gonna hit equals some open bracket. I'm gonna scroll up. I'm going to use my keys Now. Do the same thing. Hold down, Shift Arrow down. Three Hit! Enter! There we go. Look at that. And a hit Control C I'm gonna hold down. Shift arrowing across. I'm gonna hit Control V And there you go. You see how quick that is? Once again, once you learned those shortcuts, things go so much quicker it becomes second nature. It's almost like if you knew a second language and you just spoke it really well, Extell is kind of my second language. I just do things quickly without even thinking. Sometimes I've had to think about in my right clicking or left clicking, cause I just do it naturally. So and you'll get to that point to Don't worry. Okay, so we have sub totals for each of these. So now what? We're ultimately gonna want down here. And I know this looks a little kind of weird, if you will right now, But once we format everything, get some data in, it will be a bit better. So let's go ahead and put in a total here. And the total remember, is going to be our total income. And let's actually write that here. Just so it's clear total income. And I'm gonna bold it. You might even want to do in caps, but ultimately, we're gonna make this kind of a shaded cell so I don't need to put into capsules. Well, here, I'm gonna write total expensive, and here, I'm gonna write total savings. Um, let's give it a bold side. This went there. I hit control, Be control, be and already bold it that one. I probably did it and not even thinking. I think when I was talking and hit save really quick. So this one's gonna be hurt. Let's say our, um our net, whatever we want to call it our net cash flow. It's our cash after expenses and savings, which would be kind along the type. I just want to call it sort of our cash at end of month. How about that cash At end of month, I'm gonna hit a be control. Be for that one. All right, so this is gonna be let's think about this, gonna be this number less this number less this number. Now, if we didn't have these sub totals, we could certainly to say it's all of these plus less all of these less. All of these, that's a little bit more cumbersome. And that's why we include sub totals. So one we can see to weaken, take a quick look and go o hare. Total expenses are X amount in our total savings or why it's nice to see those sub totals and as well here it is really handy for writing this formula. So the way we're going to do this is we're gonna stay equals and we're gonna is gonna go select themselves, is gonna be this cell. And then the next thing I'm gonna hit minus it is minus, and you can see up here you're gonna follow along when I'm typing. It's gonna be minus your total expenses, some clicking with cell minus F 24. And it's also going minus F 30. So we see it down here and you'll notice to. Each of these is colored and the color corresponds with the individual cells. So this was kind of purple that sells purple ones. Read this one's Highland ranch just to make it easier. Gonna hit enter and it zero. So right now, the numbers don't mean too much because we don't have any data in here. But trust me, it will all look great shortly. Let's go ahead and do the same thing here. I'm gonna hit control C. I'm highlighting right here on our cash it in the month for January. Hidden Control. See, I'm holding down shift arrowing across. I'm using the right arrow all the way to here. And now I let go a shift and I hit control and then v for paste. There we go, and we can spot check some of these. And I hit f two. And there you go. You see? It even comes up. So there we go, Tom. Let's just do one more. Yep, It's not less that less that perfect. All right, so let's cut this video off here. So right now we've got our formulas in. It's a simple Is that actually, let's do one more for me because I told you and I promised you we would put that number at the top. So there's two ways to do this One. We could just re create that same formula up here. We could say this number less that number less that number. Or since this number is basically gonna be this number, remember, I just put it on top for cosmetic reasons. You don't have to, but I like to be able to quickly see, like, how much of my head or behind at the end of each month. So what we can do is we could just reference the sell this cell up here, Cell one. And remember, this one stays at the top of Rashid as we scroll. It's not disappearing. Sell one is gonna be the is this number. I just want to make it a little bit more visible. I'm even gonna write that total up here. So cash at and of month gonna bold it and all. I'm gonna do this. I'm gonna equals. I'm gonna scroll down, and I'm gonna say this that this cell equals that cell. I just want the sack. Same number up here. Gonna hit control C. I'm gonna shift arrow across Control V and there we go. So at the end of the day, uh, once we have a bunch of data in here, which will start doing next. Then we will be able to steer our surplus and minuses up here. Is it safe and cut this video off and then we'll start putting in some data. 12. Formatting and Clean Up: all right, everybody is. So next, let's do some formatting. And then after the formatting, the last kind of step is really put some data on this and see how it shakes out. And I'll just give you some more instruction. How to kind of use this at the end. So far, we're just kind of built a Cool Excel spreadsheet that has really helped you out. Um, but that's okay. So Ah, once you have this built, you'll be able to use this for the rest of your life. And I'm not kidding. I've actually used the same budget in mind is laid out almost exactly like this. Um, and I've used it for probably a good 10 plus years. So definitely it's a format that's worked well for me, So let's do some formatting. So the only hitch I was going to say we conform at this whole area about we have this one line that's date. We want this to be dollar numbers and everything else to be dollar number Self. Let's just handle this one line and then we'll do everything else. Let's go up here. Let's just highlight these cells. I'm gonna come all the way across just cause I'm a bit of an idea over here Sometimes these things that you know, Excel is sort of could be a creative playground if you want to think about. So we're just gonna hit the dollars time. This is our formatting now, right now, Zero because my having numbers in here, But I know that it automatically puts in two decimal points. And I don't really want to see them for the budgeting purposes and kind of getting a sense of where we're at. We don't need to go down to the penny, so I'm gonna click this in den twice. Decrease the dent small, and we'll see that work for us once we actually put in numbers. Now what we're gonna do is highlighting again. I click. I hold the right groups like click hold down the right or the left click, and I just highlight I scroll around. So I was gonna scroll all the way down here, and I kind of go past and over just to make sure all my bases are covered. Let's even go down. This fire is here just because we did the green line that far. I mean, we might clean some of this up at the at the very Taylor, and it doesn't matter too much. So here we go. Let's hit the dollar sign again. Let's give it to click. So are two decimal points short and that's it. Honestly, that's it for the formatting of the numbers. The other thing I do like to do just to make these stand out, give this like a light shade so I might not tell you anymore. As I click and kind of scroll, you should have that figured out by now. So if I click and you start to see me sort scroll across and highlight onto its left clicking, holding and scrolling, So let's give that a shade. And so again, I don't I don't like big break killer. Some people, you know, use big, bright yellows. That's a little bit too much for me. I would say, Let's just, uh, you know, this is our income. Let's give it a nice green shade. And honestly, I like to just be, um, consistent in the coloring. I don't want to use a bunch of different colors, Um, so whether we is green or blue, I'm actually gonna go with Blue Honestly, myself. Let's just go with and this is complete personal preference. I'm gonna go with that. So now that kind of stands out a bit more and we're going to do the exact same thing here again. We could have actually copied to the format copy, but it's a simple it's highlight this, and now you'll see this box is, ironically blue. It's the it's the last color that you used. So it's gonna do that. And again, I could copy the format. But for me, I feel like it's just a quick to do this. And at the very end of the month, maybe let's give this one just a slightly different color. Maybe a darker blue. I don't want to go that dark, but they're just so it's slightly off okay and hit save, And I'm not gonna bother the color of the top one. It just seems a little bit excessive. Ah, the one thing that did do. We had this nice green bar before, and it kind of overrode that I kind of wanna Honestly, I like I like the green, So I'm gonna I'm just gonna go up here on a copy. One of these. I hit control C and come down here. I could control V. I'm gonna go down here Control V again. V is for paste. I know that doesn't make sense, but and there we go. So now we have that consistent green line back. Sometimes you have to. That's just the way Excel is. You know, you might override something and have to go back and do a bit of a touch up. So there we go. We got some nice formatting here. I like the way this is looking. Um, I don't see much else. The other thing, the only one other thing I do kind of want to add. This came to me as we're doing this. I kind of want to put a total over here for the year, just so we can see you know, what's our total employment income gonna be, Um, etcetera. So, um, all I'm basically gonna do since I'm this cell is God's gonna be kind of a replica in terms of format wise of the other. I was gonna copy this whole cell again. I hit Could hit control C a decide to come over and hit control. Do this. I'm gonna pay step now. It put in December. Let's just put, uh, total. Okay. Now, the other thing I do want to do I want to put in a line break. Um, just to separate it off from the side So again will come down as friends, That one. And we want a line on the left of the cell. So left border. And there we go. I'm gonna delete this right now, because I don't I don't think we're gonna have a need for that. Let's already start doing some cleanup, and I'm actually gonna put a right line on this as well. Now that I look at it just again, this is personal preference. This is just sort of designed, um, put a right border. And there we go. Now it looks like it's its own sort of boxed in column. All right, so now I feel like we're pretty framed up. I'm actually I'm gonna just delete these rows down here. We're not going to use thes, so we're doing a bit of sort of final polishing on the format. And what do you guys think? I mean, I like how it looks the next will be to start putting in some numbers. Um, see, we're at five minutes. One other thing we do need to do before we start putting the numbers for these totals to work, we need to add across. So we need a We need a some. So this will be, you know, this cell will be a some of the cells to the left, so I'm just gonna hard right this equal some open bracket, scroll over and just highlight these hit enter, and that's it. Hit f two and you see, it's that. And now we can just copy this formula all the way down, and we can even do it on the empty lines. It'll just show up zero. Now, we can skip this one. So this one, we have a choice. Really? If you think about it, we can add upwards or we can add across. It should give us and it would. It definitely should give us the same total either way. So since it already, and it looks like it looks like I put in a total for this line which won't have numbers, so I'm gonna delete that and this works this works to just total these cells. I'm gonna leave that. And then I'm gonna copy this. And this works the same down here, so we think about it. Get off to We just want a total all the way across. So let's just copy this. And now we don't need to do cell by cell. You know, we don't need to do this. We can just highlight them on. I think that's what I did above and control V, and we're going to the same down here. So we have these two lines, and then we're just gonna do the empty one, and there we go. So this is a total of that. This is a total there, and we still have our grand total. Perfect. Excuse me. All right, So in the next video, we'll start putting into numbers 13. Data Entry: Okay, you guys, So, honestly, I mean, the model is pretty much built when you think about now, it's just a matter of putting the numbers and how you're gonna interpret them. But as far as the building part and excel, you're all done. So, congratulations. I mean, again, I'm gonna provide this to you as a template. I'll include it. Probably with the course conclusion. The final video will be available for download, and ah, it I'll probably I'll leave in the sample numbers that we're gonna enter right now. Ah, but certainly then feel free toe. Delete those out. So let's see. So this might be a bit tedious if we put in numbers for all this. So what we're probably going to do here is I'm gonna put in some numbers for January. We're gonna copy him across for the whole year, and then we'll make some adjustments. Maybe we'll say, like, every third month, like some bills change. You know, maybe your phone bill, various etcetera. So let's just start with some base numbers, um, and were literally just gonna type them in here and you'll see formula start calculating. So let's say you make from your employment 4000 month. And again, this is gonna vary for every single person. You sell some stuff on eBay. Maybe you make roughly 2 50 And this would be in one number that we could vary. Maybe you know that the holiday season is busier. Um, yard sailing. You may. And I'm not sure that sailing it felt right. That one in some kind of bugs me. But nonetheless, that one might very too. But maybe you make $100 a month. Not much, but, you know, it's in a little extra something. So let's just copy these across for now. So again, I'm just gonna highlight thumb control. See Arrow Cross Control via And you saw there we did a whole block of numbers in one fell swoop again. We've been the past. We've been copying one number and pasting. If you copy down the block of cells and then go across, it'll keep that sort of consistent layout. What do we see here? So right off the bat, before we start putting in some expenses, we have totals. We made 43 50 each month again, we're gonna change these. We already have cashing in the month 43 50 because I don't have any expenses yet. And then for the year we see that we make 48,000. And that's one way to check. This is well, is to make sure that, you know, that kind of ties out with your salary. And you can also see what you make here. I'm gonna have one other recommendation on this side, but let's take care of that. Once all the numbers Aaron, just again, that's sort of an aside to start extra. I kind of want to bowl now that I see. You know, once we start seeing things, I kind of want a bold these totals. So I'm gonna highlight them and bold them even though they're colored. And then I kind of want to hold him up here. I know it might be getting a little bold crazy, but but let's give it a try for now. Just those air, the important sort of thing. Okay, Now let's put in some expenses again. Let's just put in January. Let's just copy, um, across on. Then in the next video, we could go in and start tinkering with numbers and seeing what happens, Um, And again, I'm not paying a respect to where on our income is all kind of them to a degree, because he wouldn't obviously have a $10,000 mortgage. What's only that income? Let's say our mortgages 1500 a month. Our phone bill is 200. Occur insurance is 1 50 Air Power bills 100. This is one thing that would certainly vary depending. And especially if you live somewhere where the climate changes drastically, it will go up and down your credit card bill. I mean, that will very based on how much you put on your credit card, let's say it's 200. On average your cable bills 1 50 Your car payment is 3 50 of a nice car. Your cable bill is 80. You pay 1 50 student loans. In general, you like to set aside 1000 a month for spending and gas. You end up spending about 100 a month. Okay, let's say every month you set aside 200 for, um, retirement on 100 for savings. Okay, so we did that really quickly. Um, again, I was kind of paying attention, so the numbers were kind of jive with our total income. Ah, but at the same time, you know, they seem like realistic numbers for a budget for someone who made about that salary. Okay, so before we get too into the numbers, let's just copy these across and then we'll go about tinkering with them in the next video . So I'm just gonna highlight again here this time. I'm just gonna hold down another tip if you will. So, in the past, we've just kind of been clicking and holding and dragging. You can also click on a cell, go to the final cell that you want in a range clear here, hold down, shift and click automatically covers the mall with Perfect. I'm gonna hit control C and I'm gonna scroll across. And Bingo. There we go. Copied all the way across. Same thing here, since it's only two numbers, I'm just gonna go arrow down, copy across and there we go. OK, so we have some numbers in now. Let's end. This video will come in. Let's tinker with these numbers that make them a little bit more realistic now, for month by month, we're gonna look at each month and then we'll kind of taken analysis of this 14. Adjusting The Numbers: Okay, everybody. So before we start tinkering with numbers one last thing, I just kind of remembered we bowled it. Sorry, Maar totals up here. So I want to go ahead and just bold these and another tricks that we've highlighted thes. You can certainly highlight other cells as well if they don't have to be all touching each other. So the way you do that, So we already ready? Highlighted thes. We certainly can't scroll down. I don't want all of these. If you hold down control and you click on the next sort of cells that you want, hold down control and then click and drag across it'll just select those individual cells and hold down control and click and drag across. I'm gonna hit bold and bingo. That it for all those that I had highlighted nothing in between are a perfect. So now let's think about this. Let's go row by row and we're not gonna spend too much time really putting a lot of thought into this. But this is where you would spend a lot of time when you're planning out your annual sort of budget. You really want to spend some time and think about this. So let's just make some adjustments just to show you how this can change. So from And basically the approach I would take is I kind of enter my data like this. I go through now. I, you know, refine each month. And then then I'm going to go look at the cash at the end of the month and see what changes I need to make some of these I can adjust. For example, I don't have to have as much spending where it could reduce my general savings. Okay, so for one, let's say we're expecting we always get a pay increase in July, and it's roughly 5% so Ah, that would So 10% would be $400 extra. So 5% is gonna be $200. So $4200. I'm gonna copy this across. Keep in mind. This would be your actual employment income that you bring home your net income or not. You know, this is actual money coming into the bank. Your bank account, eBay. Let's say again, we talked about maybe during the year, kind of averages 2 50 But hey, you start getting close to the holidays. Maybe it's 3 50 here and 500 here. You really put some effort into it in December as well goes to 700. Um, and maybe honestly, January is more like 1 50 because everybody spent all their money from Christmas and they're just not as active. And maybe it's slowly ramps up. So this is 200. Is this where you start messing with some numbers yard sailing? Maybe the summer months air bit better just because you know the weather's warmer, you're out. Maybe you have some more time to do it. It's lighter out longer, so get up earlier and get to those yard sales. So maybe in the winter months, maybe here you're so busy with your eBay, you don't do it as much. Um, let's just say you don't even do it all in December or November. And here you only make $50. Uh, January. It's back to say 100 so maybe put a bit more effort into it here. Um, just because there's a lot of people selling things I got for Christmas that they don't like. So, um, actually make it 200 and the 1 50 it tailors off. But starting May you start doing it a bit more. So it's 1 52 102 100 And then it kind of goes down 1 50 cetera Okay, Perfect. So now we've kind of adjusted. Our our income is quick. Is that you would definitely put a lot more thought into it. Ah, your mortgage. I'm gonna assume that's going to stay the same every month. Your phone bill? Probably the same. Your car insurance the same your power, Bill. I'm gonna say so. This will depend on where you live, where I live. It's really hot in the summer. So my powerball is a lot more expensive in the summer. It's almost not. It's relatively nothing in the winter months, just cause the A C is not cranking. I don't have to heat the house in the winter because it's still warm enough here, Um, so during the summer. So I'm gonna say 100 during the cold months. Actually, let's say this is 75 75. Maybe starts to creep up to 80 91 20 1 50 it's 200 in the summer months. It's horrible. That starts coming down 1 51 25 100 And then maybe 75. OK, credit card bills. So this is one that's really going to depend on. Maybe this is your minimum credit card payment. It's going to depend on How much do you use your credit card? So, um so one thing we haven't talked about this this is really dynamic budget. Like I set this out of the beginning of the years. Let's pretend this is December 2018 and I'm laying out my budget for the next year. Um, What I would do, though, is as the month start passing, I would refine this. I'm continually updating this file. You know, January happened and I got my raisin January. Well, you know, there's an extra bonus or something. I go ahead and I started just in this. I am constantly in my own personal budget, adjusting the numbers now I don't keep her visions. I don't set up master budget and key provisions. I just continually use it. It's sort of a live file, if you will. So I'm just some advice for you. Just you know how I go about it. Siblings, their credit cards. So maybe for budgeting purposes, we put in a place holder. But once, you know, you know, you've spent a lot in December, so maybe your credit card bill is a little bit more here. Maybe it's more like 300. Maybe it's even more. Maybe it's 405 100 but whatever. Um but then maybe in the summer months, you don't spend as much whatever the case might be. But it is 300 up here. Um, so yes. So this is a life. I low So as January comes and maybe your bills? Not as much. So you just start dropping these cable bill. I'm gonna assume that's the same every month. Your car payments by the same interests, your student loans? Probably the same. So a lot of these numbers are easy to put in and hit save real quick. So spending so these air, This is one number we can start to alter it. So, so far, win the green, appear out like we're positive every month. And that's great. Um, but say we had we were short $200. Well, that might be a month where we have to put in. You know, we only get 800 for spending that month. Let's see what else? The retirement savings. So here's also where you can kind of monkey with us a little bit if you will and kind of play. So you might say, Hey, you know what? I've got a surplus of 200 like all these surpluses. But here I have $200 surplus. Maybe say, you know what? I'm gonna put aside a little extra here. I'm just because that's the way the numbers shook out. Like these air numbers that aren't no, your retirement savings is probably standard. Might be an automatic withdrawal. Maybe you think, Hey, I should up that to $50. But up here, you even have more coming out. So maybe you say, Hey, you know what? Starting in July, when I get that raise, I'm gonna make this 300 going forward. I was gonna copy that across, and I'm just gonna leave this as 100. 100 is kind of my baseline What I put in. Okay, So what do we do with these numbers now? Well, actually, you know what? Let's cut this video off now that we've kind of put in some numbers, we've adjusted them. Let's end this video. Let's talk about how you use all this information now. 15. Using The Data and Refining The Budget: Okay, everybody, look at this. You know what we have. Ah, we have a personal budget. In about an hour and 1/2 we build on our up complete personal budget. How do you like that? Now, how do we use this? So we put in your real data. Now, pretend these air your numbers, You're certainly going to go in and adjust all these and enter your own expenses. Now, um, so one thing to keep in mind. So this is your employment. So maybe you get paid once at the end of the month, they get paid in middle of the month. End of the month. We didn't kind of put in dates for the second. You could You could break that out. Middle month and the month. Um, you kind of want to think about your bills. And again, this isn't so much a timing exercise some and your mortgage is doing the first. So it's up to you to kind of plan that out. You know, you probably need money from the previous month at the end of them. Maybe get paid on the last day of the month. Well, that's gonna go towards your mortgage. for the first of the next month, but nonetheless, um, So how do we use this? So the way I use it, and certainly this is up for whatever you feel you want to do. So right now we have some numbers, and I'm feeling pretty good about this. I don't have a $5 deficit this month, but aside from that were in the green. If we had had sort of a big negative here we were negatives across our first area. We would go to as reduced our spending. Secondly, we could look at our savings, you know? Do we need to cut back on savings? Thirdly, is there any way we can clean up some of our expenses? You know, maybe we use less for this was gas for your automobile, you know, is there a way to reduce this? Um, and we didn't even tinker with this. Maybe you do spend more in other months, but regardless you got the idea was changing some of these. Maybe we need to spend less on her credit card. I mean, spending on credit cards, essentially just spending as well. Um, maybe we need to cut something out. You know, we need to cut out our our cable bill. We don't need cable anymore. Maybe we can pay off our car so we can get rid of this this high car payment. So you start looking for ways to clean up your budget. That's essentially the main purpose of this is to kind of give you a highlight into where you're at at the end of each month. Okay, so besides that, um, so then since in this case, you know, we do have a surplus now, you need to start. Think about. So what I would do if I have a surplus. I wouldn't actually start planning on spending it right away. You know, again, we said we're in December 2018. Planning for the year. Hey, we have a surplus. Let's just leave it. You know, $200 isn't a grand surplus in the scheme of things, you know, if something happens, we have an unexpected expense. You know, certainly we could have put in a line item for contingencies or just miscellaneous spending . Um, and that might have been $200 a month and we would have been negative these few months and even here is Well, so, um, we didn't do that. But that's up to you to include sort of all the things you want to do it And I actually do encourage you to put in maybe a buffer line. So if you do end up with that negative start looking for ways to clean it up in this case, we have positive. I would just leave them. Was positive. I wouldn't start saying Okay, well, perfect. We can now spend 11 R 1000 and $90 that will bring us exactly zero. That's kind of wrong. Way to think about this. Having positive numbers is a good thing. 16. Category Percentages and Wrap Up: Okay, guys, there's one last thing I want include on this. And we couldn't We couldn't this earlier, but it kind of came to me a few videos ago. I never actually got around to doing it, and this is completely optional. I mean, I think I love the way this looks. Um, the thing I want to throw in is just Ah, it's very much if you're in the statistics and kind of looking at things, essentially, I want to see you know, what percentage. Really? I want to see what percentages of these expenses makes up of the total expense category. Now, I'm going to do the same thing for revenue or income, I should say, but it's not quite as you know, important. I would say I really want to see these expenses. And the reason why is that? If it comes down to yes, we need to cut out, You know, some money. Um, where the big categories. Now, here we have, you know, 10 items. Not too hard to see, but imagine have 20 items. Um, you know, you can start sorting them and think about them. What's important, what's not by really those percentages some sometimes means something. So let's just do it for expenses. So basically, we want to see this 18 grand. What is that? Percentage wise as a total of our total expenses. So we're gonna throw in some percentages. If anything, you learn percentages. So it's another formula, so it's gonna be equals this number divided by the grand total. They're gonna learn a few things here, actually. Okay, so now it's just this. But if we hit our percentage button, is this a nice percentage? And and nice round numbers are perfect for this. We don't need the decimal points, so we want to copy this down. But, um, so we have a few choices. We could either rewrite this formula for each line item. We could copy it down, but you'll see yourself. We copy this formula right now. I'm just gonna copy at one line down, divided by zero. So what does that mean? If we hit off too and look well, when we moved a formula down line, it now was looking at this cell. But it's also looking at the cell below this. It didn't realize that we always need that. The bottom number, the denominator to be, You know this number, but it's excel, and there's a way to fix that. So let's delete this and go back up here. So this cell, let's go up here to the box where we edit it. Another trick and not a lot of people. No, that's not necessary. Trick. It's an excel feature. But if you put in dollar signs in front of ah, cell reference so in front of the R, and in front of the number, it basically locks that end so that won't move. Says we copy this. Let's just do one. Here we go. So you see what it did? It did move this down, but it kept that that reference locked. Um, you can only you can up to just lock one or the other. You don't have to lock both. So if you're copping something across, you would want the, um, the reference to the column to move, but you wouldn't want necessarily the role reference to move things like that. But in this case, um, we want this. We could have actually left the are without the dollar sign, because it's always gonna be calling my cursor. Yeah, it's always gonna be called Amar, regardless, because we, um, aren't moving this way at all. We're just moving down. But nonetheless, I'm just gonna lock it in. We want the bottom to always be hoops like, mess that up. We want the bottom to always be this cell. So let's just make it that cell. And now let's go ahead and copy this all the way down. And if we do that, we see that that's 100% which it should be. And here we have the big ticket items, So mortgages 25%. Your phone bill is 5% down. We go spending 25%. So, you know, we think of 1000. That's not too much. But then when we see 25% we think, Wow, you know, 25 of our expert 25% of expenses is just spending. That's like going out. That's eating. That's groceries. Um, you know, pet supplies, you know, it's 25% really vow. Is there any way I could get away with you? No closer to 20%? No. Maybe it does need to be 800. So that's where I really like the use of, um, sort of a percentage formula. And I haven't done any fancy formatting on this. Um, you know what? Let's do it, because I'm gonna give you this model, so let's just do it really quick. Um, let's say, percentage of category, so I'm gonna just make that bigger. I'm also going to center these just for formatting purposes. And then, you know, we can also, um, you know what? Let's make this column the exact same format as this column, but we're gonna have to change these back to percentages. So for the sake of getting all the other formatting over, I just copied the format. But knowing that would have to then change those back to percentage. If you follow their and I like to center these, it's kind of breezing along here. All right, so we could do the same for here. Um, it's obvious that obviously that income is the big chunk. But let let's do it just for practice purposes equals that divided by this. So let's just make our formula. These are gonna be percentages, and then this We need to put our dollar signs on. If you remember the dollar sign dollar sign and let's do that Hopes and we need to do it here. So here's another trick. We know if we copy this formula down, it's gonna were gonna lose our formatting and our lines. There's a way to copy just the formula. So if we go here and hit control C, we go here and we want to paste it. But we don't. We want to paste in a special way. So do the drop down. This is normal pace. But this one says FX I mean, it's just paste the formula. Don't pace the format of the cell just before and you see that work perfect. Um, let's do the same here. And then we don't need one for the total, because it doesn't really make sense. Um, we could do you know, this is relative to this, but I I don't think it's important. So let's do this. And again, This this number is not gonna be too exciting if you will, just because, um, I'm just gonna copy this down. They're gonna make these all percentages really quick here to see you're not bored. Another option you have if you go up here, Um, copy. So I've right clicked. Yes, that right click there. If you go here and right click, you'll see Pay special. And we already see the FX. The formula. So it's up here, or it's over here. And there you go. Um, against a You know, we might take a look at this and go, Hey, you know, 71% of our statements goes to retirement. 30 are 29. General, maybe we want a shift. Maybe we should be going 3 50 50 We want a little bit more. Go into retirement, whatever the case might be. So there you go, guys. I actually really like this. I think that's a useful kind of information block. So you know what, guys? That's pretty much it for the for the model. I'm gonna upload this a download. Like I said, I really hope you found this course useful. Um, yeah. I'm trying to think of any other tips and tricks I can give you. Um, if I do, I'll certainly add on additional video to the to the course. But for now, I do have a wrap up video. Just sort of me talking to the camera, talking about it a bit more eso, but I'll just repeat myself here. You'll hear it in the next videos. Well, feel free to send me a message with any questions. Hopefully, this all made sense. If anything didn't go back rewatched that video. If you have any questions about formulas or formatting all those types of things, you don't send me a message directly through the course. Love to hear it. And, yeah, that's it. I hope you found this useful and practical, and now you can kind of take control of your finances. 17. Course Conclusion: Congratulations, everybody. You made it to the end. Hopefully really enjoyed the course through the course, we built a personal budget and excel. We started with that blank workbook, and now you have a complete model. If you build your own, I congratulate you. Or if you just follow along to get an idea of what needs to be tracked and how to go about tracking it, and you want to use the template that's provided, that's completely OK, too. I encourage you to do whatever works best for you, but at the end of the day, I hope you feel a little bit more empowered to manage your finances and manage your budget and sort of plan ahead. That was the goal of this course. If you had any questions during the course, definitely go ahead and leave them. Pose them to me through the course as well. If you can leave me your feedback on the course, I love it. So go ahead and leave your review of what you thought of the course. I always love hearing from my students, and I hope to be your instructor on the future course That said, That's it for me. Chris Benjamin