There are three simple steps you can take to create a warehouse software in Excel.
Using VLOOKUP and Sumifs
If you need more advanced training or a program, just follow us and write in the comments