How to Make a Simple Budget in Excel for Beginners
By Jason Bingham · September 18, 2026
Jason has spent 16 years helping everyday people get comfortable with technology.
Creating a Simple Budget in Excel
Budgeting might sound daunting, especially if you've never used a computer program like Excel before. But trust me, once you get the hang of it, you'll see how simple it can be. Excel is like a digital notebook where you can not only jot down your expenses and income but also see exactly how your money flows each month. So, let's dive into how to create a straightforward budget using Excel.
Starting Excel
First, you’ll need to open Excel. If you’re using a Windows computer, look for an icon on your taskbar that looks like a green box with a white letter “X” in it. It might also be in your Start Menu under the “All Apps” section. If you’re using a Mac, you’ll find it in your Applications folder or in the Dock at the bottom of your screen.
Once you’ve opened Excel, you’ll see a blank workbook. This is where you’ll create your budget. You’re looking at a grid made up of boxes called “cells.” Don’t worry if it feels like a lot at first; we’re going to take it step by step.
Setting Up Your Budget Worksheet
Start by labeling your main categories. Click on cell A1 (that's the first box on the left in the first row). Type “Income” here. Move down to cell A2 and type “Expenses.” You can hit the “Enter” key to move to the next cell below.
Now, let's fill in some specific details. In cell A3, you could type “Rent/Mortgage” under Expenses. In A4, type “Utilities,” and in A5, write “Groceries.” You can keep adding categories for all the things you pay for regularly, such as “Transportation” or “Entertainment.” You may need to adjust the height of the rows later on to fit all your text comfortably.
Under the Income section, you might start with something like “Salary” in cell B1. In cell B2, try adding “Other Income” if you have any side jobs or investments. You can add more rows here as needed.
Entering Your Figures
Now, here comes the practical part: entering your numbers. Moving to cell B3, you can type in your monthly income amount. For example, if you earn $3,000 a month, just type that in. Under Expenses, let’s say your rent is $1,200. You’d put that in cell B4. You can continue filling out these fields with your actual expenses to see where your money goes each month.
If you love being organized, try to color-code the income and expense categories. You can do this by highlighting the cells and then going to the “Home” tab at the top. Look for the paint bucket icon (it’s “Fill Color”) and choose a color that makes sense to you.
Calculating Totals
I know the idea of numbers can be a little confusing, but Excel makes this easy. Click on cell B6, which we’ll use to calculate your total expenses. Type this formula: `=SUM(B4:B5)`. This tells Excel to add up all the numbers in cells B4 and B5. Once you press “Enter,” you’ll see the total expenses pop up.
Next, click on cell B7 for your total income. Type `=SUM(B3:B4)` here, just like before. If you’ve followed along, you’ll now see how much money you’re bringing in and how much you’re spending.
Finding Out Balance
Now, let's see how much money you have left after taking care of your expenses. Click on cell B8 and type “Balance.” In cell C8, you’ll type this formula: `=B6-B7`. This takes your total income and subtracts your total expenses. You can now see at a glance how much money you have left at the end of the month.
I’ll be honest: sometimes, Excel can feel a little clunky when you’re just starting out. But that’s okay. Just remember to take your time and click around the different options to become familiar with where things are located.
Staying on Track
To keep your budget running smoothly, take some time each week or month to update it. Just open your Excel file and see if any of your income or expenses have changed. This will help you stay mindful of your spending and make any necessary adjustments.
If you want, you can even save your budget in a special folder on your computer. Just go to “File” in the upper left corner, click on “Save As,” and find a location that is easy for you to remember.
Once you’ve got the basics down, there are many other features you might explore in Excel, such as charts that can visualize your spending habits. For now, focus on these simple steps, and don’t hesitate to reach out for guidance if you need it.
Creating a budget might seem overwhelming, but every time you open Excel and start working on it, you’re taking control of your finances. You’re not just managing numbers; you’re also gaining insight into your spending habits and creating a clearer picture of your financial future. Dive in and have a go at it; you’ll be proud of the budget you create!