In-house Training | (Onsite or Virtual)
Delivered by Saber Middle East
Accredited by Pebble Hills University
Endorsed by Levant Supply Chain Network
Click Here to Request Detailed Brochure
Workshop Objectives
Nowadays, the Supply Chain Management environment requires plenty of artistic vision, brainstorming, and inventiveness along with usual technical competencies. However, if you are a professional in supply chain management, then you should know that Excel comes handy during everyday operations of Supply Chain and Logistics activities. The use of Excel tips & tricks forms a major part of this daily standard work.
A good portion of your job as a Supply Chain Professional goes into data gathering, analysis and creating meaning inferences for the business you work for. All these activities imply spending a considerable period of useful time on the Excel spreadsheet environment. For this reason, we have prepared this course specially for the Supply Chain Management Professional.
Workshop Outline
This course includes the following topics:
Module One: Refresher on Excel Tips and Tricks
- Formulas and Functions
- Naming Cells and Ranges
- Conditional Formatting
- Excel Charts
- IF Statement
- Lookup Tables
- Advanced Filters
- Pivot Tables
Module Two: Supply Chain Analysis using Excel
- Statistical Tools using Data Analysis
- Graphical representation of Data
- Forecasting using Statistical Regression
- Classification of Inventory
- Economic Order Quantity calculation
- Inventory Safety Stocks computation
- Decision Models using the Solver Add-In Optimizer
- Case Study Example in Supply Chain Management
Target Audience
This course is designed for:
- Supply Chain Analysts, Stock Controllers, Inventory Analysts and Demand Planners
- Logistics and Supply Chain Managers, Materials Managers, Brand and Product Managers
- Other company personnel who are involved in the supply chain activities
Applicant Eligibility
- Have good knowledge of computer and analytical skills
- Be very familiar with Microsoft Excel, preferably at an Intermediate level
- Bring a laptop with a valid Microsoft Excel installed license (2013 version or above)
Registration Details
Capacity: 12 participants only (Limited attendance to ensure maximum participation, interaction and benefits for all the participants)
Workshop Deliverables:
- Attendance in Live Virtual sessions
- Course materials in soft copy format (in English)
- Language of instruction in both: English & Arabic
- Certificate of Attendance from Saber Academy
- Optional Certificate of Completion from Saber Academy and Pebble Hills University (USA) upon passing a 1 hour exam