What Office Program Would Be Best to Use to Create a Budget?

Microsoft Word is easy to use because it requires only typing skills. If a person’s budgeting goal was to simply list your income and expenses and fill in amounts next to each, Word might be the Office program of choice. However, if you need to update your budget as you pay expenses, Word will require you to do most of the work manually.

Like Word, Excel allows you to list your income and expenses. Unlike Word, Excel lets you create a variety of reports that automatically update as you enter your income and expenses each time. The program does this by allowing you to enter simple formulas into different fields to add, subtract, multiply and divide income and expense rows or columns. With Excel, you’ll reduce the chance of math errors as you track your average monthly spending, project year-end results and set savings goals based on your net income or excess cash available after you pay your bills.

Common reports for personal budgets made using Excel include “Total,” “Actual,” “Average Monthly,” and “Projected.” To create these reports, you’ll enter formulas into specific fields. For example, if line 3 of your budget is groceries, you can keep track of your average monthly spending on groceries as the year progresses, see your total spending year-to-date and project what your year-end-total will be based on your current spending. To determine your average spending, you divide your total spending by the months that have passed. To project your year-end spending, you multiply your average monthly spending by 12.

To create a report in Excel, you use standard formulas starting with the five characters, =sum( followed by the information contained in other fields. For example, your budget might list groceries across the page in row 3. Your 12 monthly columns might run from row C to row N. To determine your total spending, you would put =sum(C3:N3) in column O, row 3. This formula will add your grocery spending from January to December, showing your total in O3. To see your average monthly spending, you would divide your O3 total by the number of months that have passed, putting this information in column P, row 3. In April, your P3 field would read =sum(O3/4). This will divide your total grocery amount by the four months that have passed, giving you your average.

Excel formulas are easy to learn, you’ll only need a few of them and you’ll get the hang of using them quickly. If you can spend 10 minutes on the phone with a friend who uses Excel, you can skip the Office tutorial. Once you create your initial budget document, you no longer have to perform any math -- your Excel budget does it for you.