The inventory of goods is a boring but necessary activity that must be carried out, at least once a year, by all those who deal with sales. I have written before how to make an inventory of fixed assets. The inventory of goods is done in a similar way, but this time I will show how this is achieved by applying the technique of data consolidation. Excel has had this option for at least 10 years, so I believe it will be useful for each user.
Consolidation is the term that denotes the unification of several parts into a single entity. In practice, we use consolidation when we want to receive a summary report; for example, when we want to summarize the sale by months, quarters, years … The simplest way to do this is by summarizing the data entered in several worksheets in the last sheet using the formula. But what if the data in the worksheets is not uniform? Excel also has a solution for this scenario …