This Excel-based Supply Chain Management course teaches how to build and manage practical business systems using Microsoft Excel. It is designed for beginners, freelancers, and operations professionals who want hands-on skills in inventory and ERP-style systems.
The course begins with Bill of Materials (BOM) creation, showing how product structures are built using Excel tools and VBA automation. You will learn how components and materials are organized for manufacturing and production planning.
Next, it introduces ERP system building in Excel, demonstrating how businesses can simulate full enterprise resource planning processes, including operations, inventory, and workflow management.
A key focus is inventory management using Excel dashboards, including Kanban-style visual systems that help track stock levels and improve decision-making in real time.
The course also covers advanced Excel tricks for inventory control without VBA, making it easier to manage stock efficiently using formulas and structured sheets.
Finally, you will learn how to build a complete inventory system including invoices and purchase orders, simulating real business operations.
By the end of this course, you will be able to use Excel as a powerful tool for supply chain management, inventory tracking, and basic ERP system design.
