How to Create an Excel Budget Spreadsheetby Filonia LeChat
Whether you're trying to track expenses per employee over time, calculate how much funds are available for an end-of-the-year corporate party or want a single place to keep track of the entire company budget and spending, Microsoft Excel can handle your calculations. Excel, part of the Microsoft Office Suite, is spreadsheet software completely customizable for your budget requirements. With a few clicks in Excel, you're able to create a budget spreadsheet and start tracking spending.
Open Excel, which automatically creates a new blank spreadsheet. Click into the first cell of the first row, A1. Type the company name or the name of the organization preparing the budget, such as "Janofsky Carving Company." The text may spill over into other cells.
Leave the next two rows, 2 and 3, blank. Click in the row and cell below it, A4. Type the categories you want to track, such as "Human Resources," "QA," "IT" and "Sales" or names of people. After typing each category, press the "Enter" key to drop into the cell below it. Add all of the names or categories.
Click into cell B3 and type the first objective to track, such as "January" if the budget will be a monthly/annual listing of funds spent each month. Press the "Tab" key to shift into the next cell, C3, and type the next objective, such as "February." Another option is to use names of clients or projects to track how many hours spent in those areas. Continue pressing "Tab" and entering new objectives until complete.
Highlight all of the objective cells in the row. Right-click and select "Format Cells." Click the "Font" tab, increase the "Size" to 14 and click "Bold" under "Font Style." Click the "Fill" tab and click a small colored box, such as a color that goes with the company's scheme, and click "OK." This makes the objectives stand out from where the actual numbers will be typed in.
Repeat the highlighting for all of the objectives in column A and perform the same changes on the "Format Cells" window so there are both vertical and horizontal shaded rows. Repeat the formatting on the row with the company name.
Click the "File" tab at the top of the screen. Click "Save As" and type a name for the budget spreadsheet, which forms the template. Each time information is ready to enter into the sheet, open it, type data into a cell and re-save it with a new name or version number, such as "BudgetJanuary."