 Hi everyone in this tutorial I'm going to quickly go over how to set up a monthly budget in Excel that you could use either for a family You could extend it to make it for a business or anything larger as well But I want to show a tutorial because it can't really help you with it just the very basics of Excel and how to build something that's practical that you could use on a daily basis So I have here obviously just the basics of Excel everything from creating a new document Sorting auto so I'm not going to go into any of that. I'm just going to go over and go into Setting up a sheet that you could use to for your family That would be a family budget that you could help plan financially where you need to be so you can see here I'm as I click around I select different cells. I'm going to put in here family budget 2012 and again the numbers could vary but for now and I just hit Control B or command B if you're on a Mac To make it bold and you can increase the size here make it 16 whatever just make it a little bit different, you know higher Font size just so it'll have some hierarchy in the page Okay, so what I'm going to do is I have January through August set up here You could continue on with additional months, but I'm just gonna do the first, you know a couple months a year So you can kind of get a Vision for how you could plan a budget. I have all my different Costs that you would have throughout the year everything from rent to the car heat AC air conditioning and groceries utilities vacation You might have more as well, and they also have total just a column that says total at the bottom I then have January February across all the columns You can see jet January through August and then the I just put in sample data if your rent is more if it's 1250 a month that's fine And you can just type in 1250 and then go to the corner bottom right hand corner and drag across and I'll update them all Of 1250 so you can kind of see how this is a very quick Way to set up a sample budget to help you with your finances. What I want to do those I want to add up All the columns so what I'm gonna do is I'm gonna click on the cell here. It says total It's B 9 which is 9 is the row B is the column, so I'm gonna click in here, and I'm gonna type equals sum Open parentheses closed parentheses And then what you want to do is click back inside the parentheses and then click and drag all the different cells And I'll actually populate B 3 Colon B8 so that adds the different values there in those In those rows it adds them all together and then hit return or enter on your keyboard And you can see it adds up that amount What's cool is you don't have to do it now for the rest of them You just click like I did before I just want to copy that field what I'm doing is I'm copying this cell To all the different cells in this row, so I'm gonna click on the bottom right hand corner click and drag Across all of them, and you can see it adds up all the different amounts owed throughout that for each month In every column I'm gonna make these all bold So I'm gonna select them all and hit command B or control B if you're on a Mac, and I'm gonna add Grand total for the year Here just put wire Equal some similar to what I just did Open parentheses closed parentheses and then click back and click back between the parentheses and then select all of them here Just so in a sense. I'm saying okay now give me the sum of all of these Different cells from January to August so that's my in a sense budget from January to August One thing I did want to show you that might be beneficial is Formatting these cells so I'm gonna select all of these cells in here So just click and drag over all of them right click, and I'm gonna go to Where is it here? Format cells. I'm sorry format cells and what I want to do is instead of making this general This is just in a sense not format. I want to make it actual currency so it'll add in a sense It'll add the dollar sign It also add them decimal places if you have a certain you know If you know the utilities are $200 and 20 cents then you can do that by adding decimal places So I'm gonna click okay, and you can see it adds up and it makes it in a sense It has all the decimal places if you want to get rid of the dust these Additional decimal places what you can do is over here in your numbers section you can get rid of these After the decimal point it'll in a sense decrease the decimal so we'll make it you know a little bit more easy to read All right, hope that's helpful Enjoy and make sure you know try to stay on budget There's additional things that I'll be going over in the upcoming weeks to help you with setting up a quick family budget This definitely can help you to figure out. Hey, how much money do we need per month to survive? Enjoy