como fazer Grátis Planilha de Estoque no Excel com Menu e cara de Site

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... 🔵DOWNLOAD FREE SPREADSHEET VERSION: https://excelentejoao.com.br/wp-conte... In this free Excel video lesson, we will learn how to create an inventory control spreadsheet in Excel with material entries and exits. The objective of the inventory control spreadsheet in Excel is to control all entries and exits of products, materials, and inventory items. We can register purchases and sales, that is, entries and exits, and the spreadsheet will automatically register and calculate the current balance for each registered product. We will have two lessons, a registration and inventory tab and a movement tab. The first tab, "Inventory Registration," will help us register all the products we have in our inventory, and automatically, through a sum formula, the table will calculate the total entries or total exits, and the final balance for each item. Conditional formatting is an Excel tool that allows us to automatically color lines of a cell value in different colors. The inventory will be automatically highlighted in green, yellow, or red depending on the quantity. The SUMIFS formula will help us account for the balance of each item. This Excel function sums with criteria, summing only what we need, for example, summing by month, summing by item, summing by type, summing by category, etc. In the "Movements" tab, we will record all entries and exits of each product in the inventory. We will use information such as date, type (entry or exit), product name, quantity, and observation. The options list is another tool we will use to automatically select the item and the type of movement. The options box is basically a small list that appears when you click on a cell, allowing you to select an option from the list. Many people also call it an options list, data validation list, options box, name box, options box, small list in Excel, etc. #ExcellentJoão #Excel #Dashboard