Formations

Tutoriels Excel

Blog

A propos

Complete Excel tutorials for Supply Chain Management

Tutoriels Excel

The “must have” Excel files for immediate results

Gestion des stocks

Prévision de la demande

performance de la Supply Chain

Découvrez les outils !
Instructeurs des cours pour SCM

Trouvez les bons outils en fonction de vos besoins.

Choisissez l’un de nos modèles Excel parmi les catégories suivantes :

Optimisez votre inventaire

Toutes les compétences essentielles de gestion des stocks à portée de main

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

Analysez comme un pro

Construisez des indicateurs de performance de la Supply Chain perspicaces à partir de zéro

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 stock turn days

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

Prévoyez en un rien de temps

Apprenez les formules et l’automatisation pour maîtriser rapidement les prévisions de base.

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.

Prêt à améliorer vos compétences ?

Découvrez nos formations :

Voir toutes les formations

Vignette Formation Excel en ligne
Excel Expert™️

Découvrir la formation

Vignette Formation SCM Analytics en ligne
SCM Analytics™️

Découvrir la formation

Vignette Formation Gestion de Stock en ligne
Expert Gestion de Stock™️

Découvrir la formation

Vignette Formation Forecasting en ligne
Forecasting Expert™️

Découvrir la formation

Retour en haut

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.