prepare a budget in excel
It's interesting:"This wedding takes place during a week when the web is all astir over ... 4-Feb-201There's nothing like a wedding around Valentine's Day."
Microsoft Excel stores data in easy-to-navigate cells and does mathematical calculations. These features make Microsoft Excel a suitable program for preparing budgets. The Microsoft Office website has several templates you can use, ranging from personal budgets to business budgets. These budget templates work with several versions of Microsoft Excel. All you have to do is download a budget that suits your needs, then open the file and key in the financial information you want to include in the budget.
Instructions
1
Launch your Internet browser.
2
Go to the Microsoft Office Budget Templates page (see Resources).
3
Click one template that suits your needs. Various types of budget templates are available, including personal budget, event budget, college budget, business trip budget, retirement budget, wedding budget and expense budget. Each template has a title and an Excel version under its title. Select a template designed for your Excel version or earlier. For example, a budget for Excel 2003 would also work with later versions like Excel 2007.
4
Click "Download." When you see the Microsoft Service Agreement page, read the agreement terms, and click "Accept."
5
Click the "Download" button and choose "Save." Choose a location on your computer to save the file and click "Save."
6
Navigate to the location on your hard drive where you saved the budget template file. The file would have a ".cab" extension.
7
Double-click the file to open the compressed file in a decompression program such as WinZip, ZipGenius, 7-Zip or WinRAR (see Resources). Extract the template from the compressed file using a decompression program.
8
Double-click the template file to open it in Microsoft Excel.
9
Enter your cash flow items into the appropriate fields in the template. The file will automatically calculate your incomes and expenditures so that you can see your savings or shortages relative to the budget.
10
Click "File" at the top of the Microsoft Excel program window and choose "Save." Choose a location to save the budget file, and click "Save." As you receive incomes and incur expenses, open the file and add the additional cash flow items to receive an updated budget standing.
Tags: Microsoft Excel, template file, cash flow, cash flow items, Choose location, choose Save, choose Save ChooseSource: www.ehow.com
