How To Create A Complete Inventory Management System In Excel From Scratch + FREE DOWNLOAD
Excel For Freelancers
0:00 / 0:00
How To Create A Complete Inventory Management System In Excel From Scratch + FREE DOWNLOAD
1 863 390 просмотров · 3 года назад
Excel For Freelancers
1 млн подписчиков
1 863 390 просмотров · 3 года назад
This complete inventory management system is about to replace juggling multiple sheets, built from scratch in Excel.
Stock, movement, and levels tracked across scattered spreadsheets never quite line up with each other. Here, you'll build a full inventory management system in Excel to track stock, movement, and levels in one workbook. You'll see exactly how every movement updates the stock count.
👇 GET THE FREE FILES FOR THIS VIDEO:
https://www.excelforfreelancers.com/i...
🆕 UPDATED VERSION NOW AVAILABLE FOR ELITE MEMBERS:
⭐️Dashboard - Added Month & Year Selection
⭐️Email Order (Supplier/Customer)
⭐️Clear Filter Button (Customer, Supplier, Products)
⭐️Product Location Detail
⭐️Recent Order List
🔗 GET THESE UPDATES IN OUR ELITE MEMBERSHIP HERE 👉 https://www.excelforfreelancers.com/e...
🔥OWN 550+ TEMPLATES & WORKBOOKS IN ONE PACK👉 https://www.excelforfreelancers.com/u...
📌 GET AI INSIDE EXCEL WITHOUT COPILOT & SAVE WITH THIS ADD-IN 👉 https://www.excelforfreelancers.com/a...
📌 GET DEEPER DATA INSIGHTS WITH AI DATA ANALYST 👉 https://www.excelforfreelancers.com/a...
🚀 GET YOUR OPERATIONS UNDER CONTROL — 3 Spots Open This Quarter👉 https://www.excelforfreelancers.com/b...
🛠 NEED THIS BUILT FOR YOUR BUSINESS OR NEEDS? Get Expert Customization Help 👉https://www.excelforfreelancers.com/C...
🛒 Browse All Excel And AI Templates, Courses & Tools: https://www.excelforfreelancers.com/shop
⏱ TIMESTAMPS:
0:00 – Introduction
0:45 – Overview
6:00 – Worksheet Design
49:34 – Select Menu
1:13:31 – Selection Change Event
1:20:37 – Refresh List Customer
1:24:14 – Change Event Worksheet
1:25:57 – Save Item
1:27:37 – Save and Update Customer
1:31:29 – Add New Customer
1:35:13 – Delete Item
1:34:40 – Delete Customer
1:37:38 – Add New Order
1:40:52 – Change Event Worksheet
1:49:50 – Save and Update Order
1:48:17 – Load Order
2:02:04 – Delete Order
2:05:34 – Print Order
2:06:46 – Creating Graph
👥 JOIN OUR COMMUNITY: https://www.excelforfreelancers.com/E...
🔗 LinkedIn: / excelforfreelancers
😎 Facebook: / excelforfreelancers
About: I'm Randy Austin — Excel developer and business systems builder. I help business owners and entrepreneurs replace expensive software subscriptions with powerful, done-for-you Excel templates they can customize and own forever. New training every week.
#excel #exceltutorial #excelforfreelancers #inventorymanagementsystem #inventorytracking
Thanks so much for your continued support,
Randy Austin