How to Make an Inventory Tracker in Excel | Beginner Tutorial

Learn how to build a simple inventory tracker in Excel from scratch. This beginner-friendly Excel tutorial shows you how to track current stock, set reorder points, automatically flag low and out-of-stock items, and calculate inventory value. You'll build the complete tracker step by step, including customizable category dropdowns, automatic stock statuses, inventory value by category, summary metrics, conditional formatting, and a simple inventory chart. This inventory spreadsheet is designed for beginners and works well for small businesses, online shops, handmade businesses, product sellers, and anyone who wants a straightforward way to monitor stock in Excel. In this tutorial you'll learn how to: Create a simple Excel inventory tracker Add customizable category dropdowns Calculate inventory value automatically Create In Stock, Low Stock and Out of Stock statuses Set reorder points Highlight low and out-of-stock inventory automatically Calculate inventory value by category Count items that need restocking Create a simple inventory donut chart Use IF, OR, SUMIF and COUNTIF Use data validation and conditional formatting Inventory Tracker Template: https://excelyourmind.etsy.com/listin... If there is another Excel tracker you'd like me to build from scratch, leave your idea in the comments. Subscribe for more beginner-friendly Excel tracker tutorials. #Excel #InventoryTracker #ExcelTutorial 00:00 Simple Inventory Tracker in Excel 00:32 Create and Format the Inventory Table 02:05 Create the Category List 03:12 Add the Category Dropdown 03:33 Add Inventory Data and Calculate Inventory Value 04:37 Create Automatic Stock Status 06:52 Calculate Inventory Value by Category 08:43 Add Inventory Summary KPIs 10:38 Add Stock Status Conditional Formatting 11:34 Test the Tracker 12:17 Create the Inventory Donut Chart 13:29 Finished Inventory Tracker