Advanced Excel for Supply Chain

October 25 | Beirut, Lebanon

Saber Middle East

Delivered by Saber Middle East

Accredited by Pebble Hills University

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

The workshop requires the attendees to:
  • 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 inclusive of coffee breaks and lunches
  • 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 hour exam

For more info, kindly contact Saber Academy:

HOTLINE +961 (3) 977 280  |  OFFICE +961 (5) 430 574

info@supplychain-training.com

Book your place(s) or Ask for more details. Get the full Brochure!

Register Here

Leave a Reply

Your email address will not be published. Required fields are marked *