This course is designed to help garments industry professionals master Excel to manage tasks in merchandising, quality control, human resources, and industrial engineering. Learn industry-specific applications of Excel that are directly applicable to real-world tasks.
- By the end of this course, participants will be able to:
- Understand and use fundamental and advanced Excel functions.
- Track, analyze, and report data related to sales, inventory, HR, and quality control.
- Use Excel for cost management, pricing, vendor management, and workflow optimization.
- Apply lean manufacturing principles and continuous improvement strategies using Excel.
- Automate repetitive tasks to enhance productivity.
Module 1: Introduction to Excel (Day 1)
Excel basics, interface, and simple formulas.
Module 2: Core Excel Functions (Day 2)
Advanced data handling, VLOOKUP, IF functions, pivot tables.
Module 3: Excel for Garments Commercial (Day 3)
Sales tracking, cost analysis, financial models.
Module 4: Excel for Merchandising (Day 4)
Product costing, pricing models, inventory tracking.
Module 5: Material Management & Sourcing (Day 5)
Supply chain performance, vendor management.
Module 6: Quality Control & Inspection (Day 6)
Defect tracking, SPC (Statistical Process Control), data analysis.
Module 7: Excel for Industrial Engineering & Lean (Day 7)
Workflow optimization, continuous improvement strategies.
Module 8: Excel for HR (Day 8)
Employee tracking, HR data analysis, and database management.
-
Lecture 1: Lorem Ipsn gravida nibh vel velit auctor aliquet.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus.
-
Lecture 1.1: Lorem Ipsn gravida nibh vel velit auctor aliquet.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus.
-
Lecture 1.2: Lorem Ipsn gravida nibh vel velit auctor aliquet.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus.
-
-
Lecture 2: Lorem Ipsn gravida nibh vel velit auctor aliquet.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus.
-
Lecture 2.1: Lorem Ipsn gravida nibh vel velit auctor aliquet.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus.
-
Lecture 2.2: Lorem Ipsn gravida nibh vel velit auctor aliquet.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus.
-
-
Lecture 3: Lorem Ipsn gravida nibh vel velit auctor aliquet.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus.
-
Lecture 4: Lorem Ipsn gravida nibh vel velit auctor aliquet.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus.
-
Lecture 5: Lorem Ipsn gravida nibh vel velit auctor aliquet.
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus.
IE Manager, AKH Group