Managing Inventory Using Excel.

Managing Inventory Using Excel.
Grade Levels
Product Rating
File Type

PDF (Acrobat) Document File

Be sure that you have an application to open this file type before downloading and/or purchasing.

750 KB|32 pages
Product Description
This is a sample inventory solution developed using some of the basic features and functions like Sum, Sumif, Merge, Vlookup, Data Validation, etc. of Microsoft excel. Main topics of this course includes:
- Defining Item Categories
- Defining Items
- Recording Item Receipt
- Recording Item Issuance
- Calculating Item Balances (Quantity and Value)
Total Pages
32 pages
Answer Key
Teaching Duration
90 minutes
Report this Resource
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up