How to Make an Inventory Using Excel. Knowing what you have, what you need and what you've sold is critical information to a small business.

The Excel inventory system is one of the most popular ways to create an inventory system. Suppose you are running an eCommerce business, a small business, or a brick-and-mortar store.

Creating an inventory system for your plumbing and heating business will help you to better track and organize your current inventory and cost-effectively plan inventory.