You are viewing the article How to Create an Inventory List in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 4,240 times.
This wikiHow teaches you how to manage a work inventory using an Excel spreadsheet on your Windows or Mac computer. You can use a pre-formatted inventory list template, or create your own sheet.
Steps
Use templates
- On a Mac, click File in the upper-left corner first, then click New from Template… in the drop-down menu.
- Each inventory template offers different features. If you don’t like the template you just selected, you can press Esc to return to the template page.
- Item Number – The inventory number (SKU or inventory unit) of the item.
- Item Name – The name that describes the item.
- Item Cost – The price per unit of the item.
- Number in Stock – Number of items in stock.
- Net Value – The net value of the item.
- Windows – Click File , click Save As , double click This PC , click a save location on the left side of the window, enter a name for the document (such as “Inventory List”) in the box text “File name” and then click Save .
- Mac – Click File , click Save As… , enter a name for the document (such as “Inventory List”) in the “Save As” field, choose a save location by clicking the “Where” box “, click the folder, and then click Save .
Create each part by yourself
- Skip this step if you’re on a Mac.
- A1 – Item Number or Inventory Number
- B1 – Item Name or Item Name
- C1 – Item Cost or Item Price
- D1 – Number of Items or Number of Items
- E1 – Net Value or Net Value
=C2*D2
in the cell and then press ↵ Enter . You will see the net value calculated and shown in the box.
- You can repeat this general formula with each cell in the “Net Value” column—just remember to replace C2 and D2 with the appropriate cell (for example, if you’re multiplying the values of cells C10 and D10 , you’ll need to use name these cells instead of C2 and D2 ).
- On Windows – Click File , click Save As , double-click This PC , click a save location on the left side of the window, enter a name for the document (such as “Inventory List”) in the “File” text box name” and then click Save .
- Mac – Click File , click Save As… , enter a name for the document (such as “Inventory List”) in the “Save As” field, choose a save location by clicking the “Where” box “, click the folder, and then click Save .
Advice
- You can add more worksheets to the worksheet set by clicking the + sign in the lower left of the page.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 4,240 times.
This wikiHow teaches you how to manage a work inventory using an Excel spreadsheet on a Windows or Mac computer. You can use a pre-formatted inventory list template, or create your own sheet.
Thank you for reading this post How to Create an Inventory List in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: