Trainings
Excel Tutorials
Blog
About us

Complete Excel tutorials for Supply Chain Management

Excel Tutorials ⚒

The “must have” Excel files for immediate results

Inventory Management
Demand Forecasting
Supply Chain Performance
Check the tutorials !
Instructor of Excel Online Course for SCM
Find the right tools based on your needs.
Pick one of our Excel templates from the following categories:
Optimize your inventory
All Inventory Management core skills at your fingertip

Free Excel template with real examples

Check the tutorial!

Safety Stock: the 6 best formulas in Excel

  • Optimize your inventory with Safety Stock
  • Order Point calculation formula
  • Discover the 6 best safety stock formulas
  • How to choose the best formula
  • Calculations and common mistakes to avoid

Free Excel template with real examples

Check the tutorial!

ABC Analysis in Excel

  • Pareto principle & ABC classification
  • Business example with 500 products in Excel
  • Step-by-Step tutorial in Excel to automate your ABC analysis
  • Fondation to start optimizing your inventory management

Free Excel template with real examples

Check the tutorial!

ABC XYZ Analyse to optimize your Inventory Management

  • The ABC Analysis is insufficient to optimize your inventory
  • Classify your products based on the uncertainty & volatility of the demand
  • Optimize your safety stock with the ABC XYZ classification
  • Free ABC XYZ Excel with 3 methodologies

Free Excel template with real examples

Check the tutorial!

Optimize your EOQ with the Wilson Formula

  • Optimize your inventory management with Wilson Formula
  • Economic Order Quantity Formula (EOQ)
  • Minimum Order Quantity Formula (MOQ)
  • Nike Business Example in Excel
  • Free EOQ Excel including formulas to download
Analyse like a pro
Construct insightful Supply Chain KPIs from scratch

Free Excel template with real examples

Check the tutorial!

The 10 best KPIs for your Logistics & Supply Chain

  • 10 best KPIs / Metrics to manage Supply Chain performance
  • Included : Service Rate, Availability Rate, Stock Coverage…
  • Build Dashboard & Metrics to track your performance
  • 10 mistakes to avoid (expert syndrome)
inventory turnover ratio formula calculation days in inventory

Free Excel template with real examples

Check the tutorial!

Inventory Turnover KPI : Calculation in Excel

  • Presentation of the Inventory Turnover Ratio formula
  • Stock Turn in days
  • Stock Turn in cycle
  • Perfect first metric to start optimizing your inventory management

Free Excel template with real examples

Check the tutorial!

Logistics Lead Time – Free Excel to Track itT

  • Why is measuring lead time important?
  • Calculate the average logistics lead time
  • How to interpret the data
  • Implementing the Lead Time KPI

Free Excel template with real examples

Check the tutorial!

Inventory Accuracy KPI – Stocktake, Excel Calculation Tutorial

  • Why is Inventory Accuracy so important?
  • The Excel formulas of Stock Tracking
  • How to check your stock (inventory process)
  • Implementing the Inventory Accuracy KPI

Free Excel template with real examples

Check the tutorial!

Slow Moving And Obsolete Inventory

  • Understanding Slow Moving and Obsolete Inventory
  • How to deal with Obsolete Inventory
  • How to manage Slow-moving Inventory
  • Implementing the SLOB Inventory KPI

Free Excel template with real examples

Check the tutorial!

KPIs Service rate – OTIF – DIFOT – Availability

  • Step-by-Step tutorial to track your Service in Excel
  • Global service level (OTIF, DIFOT)
  • Service level / Fill rate (DIF)
  • Delivery on Quality (DOQ)
  • Delivery on Time (DOT)
  • Availability Rate Indicator
Forecast in no time
Learn the formulas and automation to master basic forecasting in no time.

Free Excel template with real examples

Check the tutorial!

 Forecasting with Excel in 3 clicks

  • Forecast automatically with Excel in less than 5 minutes
  • Forecasting models and trendlines
  • Seasonality & exponential smoothing (easy 😉 )
  • Forecast examples of Covid Cases in the World, India and USA
  • Forecast examples of Sales Cars in the USA

Free Excel template with real examples

Check the tutorial!

Forecast Accuracy formula: 4 Calculations in Excel

 

  • Reduce your stock-outs,
  • Increase your service rate
  • Reduce the cost of your Supply Chain. 
  • 5 steps how to master forecast accuracy formulas
  • Implement the right KPI in your business.
Ready to boost your skill ?
Discover our courses
See all courses
Excel training label
Excel Expert
View the course
Inventory management training label
SCM Analytics
View the course
SCM Analytics training label
Inventory Management
View the course
Forecasting training label
Forecasting Expert
View the course
Scroll to Top

FIND OUT HOW MUCH YOU ARE WORTH.

You will receive an email with an estimate of your salary along with some advice on how to boost it.

Your information is confidential and will never be given to third parties. You can unsubscribe in 1 click from any of my emails.