How to create an Inventory Management System [using Excel] in 2021

If you would like to create your own Inventory Management system using Excel spreadsheets then this short video tutorial will show you how.

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

The Inventory Management spreadsheet will record Inventory transactions and will monitor Inventory Levels, Inventory Valuations and Product Line profitability.

As usual I will show you how to obtain a copy of the completed template at the end of the video.

If you need any help with the commands or functions I have used, then please leave me a comment.

I hope you enjoy watching.

Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks

Free Inventory Management Spreadsheet Template - https://www.MrSpreadsheet.com/product...

You can also visit our websites at:

USA & Canada & World - https://www.MrSpreadSheet.com
UK & Europe - https://www.MrSpreadSheet.co.uk

Or our Social channels:

FaceBook -   / mrspreadsheets  
Instagram -   / mrspreadsheet  
Twitter -   / mr_spreadsheet  

#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting