California Consumer Privacy Act (CCPA) Policy. You'll use this same exact formula for the "Income" and "Balance" fields as well, except that you'll use "D" and "E" respectively instead of "C". Choose the template you want to use to see more details and click "Create" to open the template. You can then copy both total formulas across the rows for the remaining months. Creating a budget using templates Let's create a budget automatically using templates. In fact, she says that she cant wait to go back tomorrow. This example shows you how to create a budget in Excel. If you prefer a weekly budget, you can enter the week numbers or for a daily budget, enter the days of the week. Heres how an expenses list with actual and estimated expenses would look like. 1. Does Excel have a monthly budget template? As I reported a few months ago, I lost one fairly lucrative job andinstantly wenton the hunt for something to replace it. See screenshot: 2. Its a personal monthly budget template with spots for all income you receive, and the expenses are grouped by category. Most templates come with built-in formulas, so any changes that you make to one part of your template will update everywhere else. Well, apparently I replaced, Read More How to Make a Budget in Excel: Our Simple Step-by-Step GuideContinue. 2. Then, label one row Total Spending and another Final Balance. This is an easy way to help you track your spending so you can compare your planned totals to your actual totals. If you want to insert these amounts for previous time periods, thatll be helpful for an overall picture of the year. Read More Why My Emergency Fund is the BombdiggityContinue, Good morning, peeps! Step 1: Basic Functions of Excel Video Basic Functions of Excel with Autofill Share Watch on Add Tip Ask Question Comment Download Step 2: Create Title I. Follow these steps. Step 5: Input your budget numbers. By submitting your email, you agree to the Terms of Use and Privacy Policy. Your email address will not be published. 2. 6. In the Table/Range field, click the icon at the end and and select your whole data table from your Raw Data sheet. Need to customize your budget even more? To do this, select the first two rows in columns A-G and select Merge and Center from the workbooks Home menu. Once you have a blank workbook, block off a chunk of columns to use as a heading for the month. It will show you how to effectively create a company budget using the Excel spreadsheet. Let's get started with this step-by-step tutorial to creating a budget in Excel. Plug that into the revenue section of the Excel spreadsheet. For this, look at cell C54: 2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9c\/Make-a-Personal-Budget-on-Excel-Step-1-Version-3.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/9c\/Make-a-Personal-Budget-on-Excel-Step-1-Version-3.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot) License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/63\/Make-a-Personal-Budget-on-Excel-Step-2-Version-3.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/63\/Make-a-Personal-Budget-on-Excel-Step-2-Version-3.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b8\/Make-a-Personal-Budget-on-Excel-Step-3-Version-3.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/b8\/Make-a-Personal-Budget-on-Excel-Step-3-Version-3.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Make-a-Personal-Budget-on-Excel-Step-4-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-4-Version-4.jpg","bigUrl":"\/images\/thumb\/8\/82\/Make-a-Personal-Budget-on-Excel-Step-4-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/53\/Make-a-Personal-Budget-on-Excel-Step-5-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-5-Version-4.jpg","bigUrl":"\/images\/thumb\/5\/53\/Make-a-Personal-Budget-on-Excel-Step-5-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Make-a-Personal-Budget-on-Excel-Step-6-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-6-Version-4.jpg","bigUrl":"\/images\/thumb\/8\/82\/Make-a-Personal-Budget-on-Excel-Step-6-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0f\/Make-a-Personal-Budget-on-Excel-Step-7-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-7-Version-4.jpg","bigUrl":"\/images\/thumb\/0\/0f\/Make-a-Personal-Budget-on-Excel-Step-7-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-7-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a6\/Make-a-Personal-Budget-on-Excel-Step-8-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-8-Version-4.jpg","bigUrl":"\/images\/thumb\/a\/a6\/Make-a-Personal-Budget-on-Excel-Step-8-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-8-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/86\/Make-a-Personal-Budget-on-Excel-Step-9-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-9-Version-4.jpg","bigUrl":"\/images\/thumb\/8\/86\/Make-a-Personal-Budget-on-Excel-Step-9-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-9-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b0\/Make-a-Personal-Budget-on-Excel-Step-10-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-10-Version-4.jpg","bigUrl":"\/images\/thumb\/b\/b0\/Make-a-Personal-Budget-on-Excel-Step-10-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-10-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d7\/Make-a-Personal-Budget-on-Excel-Step-11-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-11-Version-4.jpg","bigUrl":"\/images\/thumb\/d\/d7\/Make-a-Personal-Budget-on-Excel-Step-11-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-11-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b0\/Make-a-Personal-Budget-on-Excel-Step-12-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-12-Version-4.jpg","bigUrl":"\/images\/thumb\/b\/b0\/Make-a-Personal-Budget-on-Excel-Step-12-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-12-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d5\/Make-a-Personal-Budget-on-Excel-Step-13-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-13-Version-4.jpg","bigUrl":"\/images\/thumb\/d\/d5\/Make-a-Personal-Budget-on-Excel-Step-13-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-13-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2b\/Make-a-Personal-Budget-on-Excel-Step-14-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-14-Version-4.jpg","bigUrl":"\/images\/thumb\/2\/2b\/Make-a-Personal-Budget-on-Excel-Step-14-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-14-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6a\/Make-a-Personal-Budget-on-Excel-Step-15-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-15-Version-4.jpg","bigUrl":"\/images\/thumb\/6\/6a\/Make-a-Personal-Budget-on-Excel-Step-15-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-15-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9e\/Make-a-Personal-Budget-on-Excel-Step-16-Version-4.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-16-Version-4.jpg","bigUrl":"\/images\/thumb\/9\/9e\/Make-a-Personal-Budget-on-Excel-Step-16-Version-4.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-16-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"