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. You don't want to get so small that you have no ...