How to Use Excel for an Inventory Accounting System

1. Click the 'Microsoft Office' button, and then click 'New.'
2. Click 'Inventories' from the list in the left-hand column.
3. Double-click the inventory sheet you would like to use. For example, you could choose 'Book Inventory' or 'Parts Inventory.' The inventory will download and open automatically in Excel. There are dozens of templates you can choose from, including inventories for home and business. The actual number of templates you can access will depend upon your version of Excel and if you have downloaded any templates from the Internet.
4. Click on any items contained within brackets to customize the spreadsheet. For example, you might click [Company Name] to enter your company name.
5. Follow the instructions on the template to fill in the inventory list. Once you have populated the template with your items, Excel will use built-in template formulas to calculate the number of items in your inventory. For example, a home inventory template may have an auto-summation formula in the 'Total Items' box of your worksheet, which updates automatically with each entry you make into the spreadsheet.