Inventory Solution in Microsoft Excel

Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010

More Videos

A user has 4 sheets in his workbook called:
1. Items List
2. Received List
3. Issued List
4. Stock on site
From the items list he would like to enter the serial number into the received list and issued list sheets and automatically get the item description and unit. This can be achieved easily using the Vlookup function and a named range from the items list..
The stock on site also displays the relevat item description and unit. The total stock from the recieved list minus the quantity from the issued list is automatically displayed using the sumif function.
Finally we use the conditional formatting feature of Microsoft Excel to highlight negative quantities in case we have issued more quantity than received.

Watch the training video below to learn how to solve an inventory problem in Microsoft Excel:

Note: If you get a message like this -
Your web browser may lack some functionality expected by Popcorn Maker to function properly. Please upgrade your browser or file a bug to find out why your browser isn't fully supported. Click here to remove this warning.
Just click on - Click here to remove this warning.





Download File


Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010