 Welcome everybody to part 2 of our tutorial showing how to create an input and output table to track your key business activities using Excel 2016. If you missed part 1, we suggest you watch it first so you can fully understand and appreciate part 2. Now it's time for you to create some magic by using the SUMIF formula we taught in our Burn to Learn video number 15. When you do that, your input and output transactions appear in the main products inventory in real time automatically. Here's how you do it. Go to cell C4 of the main products inventory and type equal sign SUMIF with an open parenthesis. Now type the word inputs followed by an open bracket. This tells Excel where to find the input information. Now type the word code followed by a closed bracket and a comma. This tells Excel where to find the code information. Now select the cell A4 and Excel will write it as open bracket at sign code closed bracket followed by a comma. Now type the word inputs followed by an open bracket. Then type the word quantity followed by a closed bracket which tells Excel where to find the amounts to sum up. Now type a closed parenthesis, press enter and see the magic. Excel automatically makes the sum of all of the inputs with the same code. Was that helpful or what? Let us know at the end of this video. Now repeat the same process with the outputs column. Now scroll over to the balance column where you're going to use the basic Excel math calculation of subtraction. You will do this to determine the actual inventory balance. When you finish watching this video, you can check out burn to learn video number three to refresh yourself on how to do many basic Excel math calculations. So now here's the process to do subtraction. Now press enter and your answer is the stock balance in real time. Now when you record future stock movements, the inventory will be calculated automatically on the product table. Now you have the whole tutorial on how to create and fill in input and output tables using Excel 2016. You can now use this powerful tool to make your own magic when determining the status of key business activities like tracking warehouse inventories in real time. If you liked this video, please remember to comment, share it and hit the like button. And do subscribe to our channel for future videos. Also remember if you can access a computer you can burn to learn. Thanks for watching.