🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcelente
🔵FREE DOWNLOAD EXCEL SPREADSHEET: https://excelentejoao.com.br/wp-content/uploads/2025/02/Estoques-Lojas-JnHy-TFb3nw.xlsx
In this free Excel video lesson, we will learn how to create an Inventory Spreadsheet for Multiple Stores at the same time to control Different Consolidated Inventories in Excel. Inventory Spreadsheet with different inventories, inventory spreadsheet with multiple inventories.
In this Excel video lesson, we will learn how to use a complete inventory control spreadsheet with a purchase spreadsheet, sales spreadsheet, and inventory spreadsheet. This spreadsheet can help us perform important analyses and automate tasks, saving time in our daily lives. Inventory spreadsheet.
We will also learn how to use the SUMIF function in Excel or add with criteria, add by item, add by product in Excel.
The spreadsheet is made up of three parts, the first being the product item registration, the second part is where we will record and have the history of all the material entries in the stock or purchasing spreadsheet, the third part is the material exit from the stock or sales spreadsheet.
In the first part of the spreadsheet, registration, where we can check all the products that we have registered in our inventory. You can use several important pieces of information such as the location of the product, shelf, rack, etc. The item's SKU, EAN or product registration ID, the update date or registration date, the item name, the product brand, etc.
In addition, this first part of the spreadsheet serves as automation for the other parts, so you don't have to keep typing the same thing all the time. We will use drop-down lists here in Excel to help us automate these repetitive processes and tasks.
The second part is where we have all the inputs of the materials that arrive in our stock. We can record the date the material arrived in stock, the unit cost of the material, the total cost, we can include a note if necessary and, instead of typing the name of the product, we click on the cell and select the item we want to use in the spreadsheet from the list of options.
The third part of the spreadsheet, outputs or sales, is very similar to the previous tab, however, what will change is that here we will record the outputs and instead of using the cost we will use the sales value
#ExcelenteJoão #Excel #Dashboard