Microsoft Excel Inventory (Simple)

This video will show you the steps to creating a simple product inventory using Microsoft Excel. We begin by listing the products by name. Then we enumerate each product (how many we have made). Then We can add dates for each occasion that we sell product. We then use the Excel AutoSum feature to add up all the product we have sold. The video will also show us how to use the AutoFill function. Then finally we will learn how to subtract products sold from our original production run to give us a running total of remaining stock. Hope you find this helpful.