Thursday, October 25, 2012

How to Create a Balance Sheet in Excel


Find Template Through Excel
1. Open Excel and click 'New' from the 'File' tab at the top of the screen, then scroll through the 'Templates' list at the left of the screen to view templates that came pre-loaded with your program and available on the Office website.
2. Click 'I Accept' on the right hand side of the page to accept the terms and conditions, if necessary. Browse under the 'Budget,' 'Expense Reports' and 'forms' categories to locate different kinds of balance sheet templates.
3. Click 'Download' to download and open a desired template in Excel.
4. Fill out your balance sheet.
Find Template Online
5. Visit the Microsoft Office Templates site, and enter 'balance sheet' in the text box.
6. Choose 'Excel' from the product drop-down and then click 'Search.'
7. Browse templates until you find one that fits your requirements for a balance sheet, and click 'Download.'
8. Validate your version of Excel, if prompted to do so, then indicate where to save the template (your desktop, hard drive or a memory device), then click 'Save.'
9. Open Excel, click 'Open' under the Office button, navigate to where you saved the template, and click 'Open.' Fill out your balance sheet.

Blogger news