Loading Events

« All Events

Advanced Excel for Supply Chain | Beirut

December 13 @ 9:00 am - 5:00 pm

Workshop Objectives

Nowadays, the Supply Chain Management environment requires plenty of artistic vision, brainstorming, and inventiveness along with the 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 in. 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 Outlinedownload_brochure

The 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

Applicant Requirements

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)

Target Audience

The 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

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 for the course from Saber Academy
  • Optional Certificate of Completion from Saber Academy and Pebble Hills University (USA) upon passing a hour exam

To receive the Detailed Brochure and book your place(s), please click on the button and submit the form!

Register here for more Details

Get the In-House Training Experience!

Customize this course for your team. Saber Academy programs can be tailored to your training needs to suit your business requirements and relevant industry challenges. This will surely give a greater impact and return on your investment for developing your teams’ skills and executing customer-winning strategies.

If you have a team to train, our experts can come to you! For more info or to arrange for a free training needs analysis, please call us!

Head Office: +961 (5) 430 574    |    Hotline: +961 (3) 977 280

Details

Date:
December 13
Time:
9:00 am - 5:00 pm
Event Category:

Venue

Citea Apart Hotel
Citea Apart Hotel, Alfred Naccache Avenue
Ashrafieh, Lebanon
+ Google Map