The Inventory Management spreadsheet will record Inventory transactions and will monitor Inventory Levels, Inventory Valuations and Product Line profitability.
This FREE Inventory Management Spreadsheet is based on our YouTube presentation
where we design a simple Inventory Management Spreadsheet using Excel.
The Inventory Management spreadsheet will use many of Excels functions and commands, including:
Use of Drop Down boxes to select data
Use of the SUMIF command
IF Statements to isolate and select data
The VLOOKUP command
We also introduce the CONCATENATE and MID commands