Make an Inventory Management System in Excel.
🚀Get FREE Excel chart templates from Hubspot: https://clickhubspot.com/ix5q
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/pf8s4k26tn
In this tutorial we'll make an inventory management system in Excel with three different worksheets for the current inventory, the vendor sheet, and the order summary sheet. This is the simplest way to track inventory in your supply chain and make sure you order the right items. In the current inventory sheet, you can track your current inventory, see what products need to be re-ordered, and even know when they'll arrive. Then, if we navigate to the vendor sheet with the side bar, you'll find all of your vendor and product information, so you know exactly who to reach out to if you have a problem.
Finally, in the order summary sheet, this table will automatically populate based on the inventory you need to order. You'll know exactly what you need, how much it costs, and who to order from.
At the very end, I'l show you how to make a navigator bar on the side so you can move across the different tabs dynamically.
LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Overview
0:40 - Part 1: Vendor Info Sheet
1:28 - Part 2: Current Inventory
9:07 - Part 3: Order Summary
13:58 - Part 4: Navigation Bar