All prices are in Canadian dollars.

Excel Master: Predictive & Prescriptive Analytics for SCM

Date:   May 05, 2025
Time:   6:00 PM - 9:30 PM
Location:  

Online National

EXCEL MASTER: Predictive and Prescriptive Analytics for SCM

DATE: 

Monday, May 5th 

and

Wednesday, May 7th, 2025

TIME: 

6:00 - 9:30 PM MT

CPD:

5 Credits

LOCATION:

Virtual via Zoom

PRICE:

Member: $445 +tax 

Non-Member: $545 +tax

Student Affiliates: $145 +tax
WORKSHOP OVERVIEW

Unlock the full analytical power of Excel in supply chain decision-making. 

As supply chains evolve, so must the tools and talent behind them. Excel remains a critical platform for data analysis, and mastering its advanced capabilities is now essential for professionals who want to lead with insight. 

This workshop dives deep into predictive and prescriptive analytics through Excel, tailored specifically for supply chain roles. From forecasting demand to simulating scenarios with Monte Carlo models, this two-evening, hands-on session empowers you with practical tools to support strategic decisions and elevate your technical skillset. 
WHY THIS WORKSHOP

Unlike generic Excel courses, this workshop is built for supply chain professionals—whether you're in procurement, inventory, logistics, or sourcing. You'll gain access to high-impact templates, learn from real-world SCM use cases, and walk away with dashboards and forecasting models you can immediately apply at work. 

WHO SHOULD ATTEND?

Supply Chain professionals ready to level up their technical skills and bring more value to their teams through data-driven decision-making. While it’s a great progression for those who attended our Excel Insights workshop, anyone with basic Excel knowledge and an interest in data-driven decision-making will benefit from the hands-on tools and techniques covered.
LEARNING OUTCOMES

By attending this workshop, participants will: 

  • Apply multiple forecasting methods to improve supply chain strategies 
  • Design professional dashboards and present data with clarity and impact 
  • Use What-If and Scenario Analysis tools to model complex decisions 
  • Implement Monte Carlo simulations for probabilistic planning 
  • Explore advanced Excel tools and gain a primer on MS Power BI 
WORKSHOP TOPICS

Day 1: Reporting in Excel 

  • Forecasting: Dealing with outliers, regression analysis 
  • Advanced Conditional Formatting & Charting 
  • Dashboard Design & Introduction to Power BI 

Day 2: Advanced Analysis in Excel 

  • What-If Analysis, Data Tables, Goal Seek 
  • Monte Carlo Simulation Method 
  • Statistical Theory & Scenario Modeling 

ABOUT THE INSTRUCTOR

Ian Gonzalez

IAN GONZALEZ

Ian Gonzalez is a professional from two worlds: data and supply chain management. For 9 years, he’s taught analytics and supply chain courses for the institution, making him the longest-running PD instructor at SCC. Drawing from his 19 years of experience in oil & gas, aviation, and consulting, Ian has inspired hundreds from all over Canada to embrace data and use it to move the supply chain profession forward. Whether it’s in corporate or the academe, teaching and upskilling have always been his passion.

REFUND POLICY

Registrants will receive a full refund for courses cancelled by Supply Chain Canada - West.

Registrants who have received written acceptance into a course and provided written notice to Supply Chain Canada - West of their withdrawal from the course 14 days before the first day of class will be provided with a full refund. After 14 days, refunds will not be granted.

If you would like to withdraw from a course, please send an e-mail to us at [email protected]. You are required to inform us of your intent as soon as possible. Clearly state your intention to withdraw and provide authorization for us to proceed.
SMT Diploma Program   l   SCMP Designation   l   PD & Webinars   l   Membership
FACEBOOK | LINKEDIN | WEBSITE


Registration/Enrollment

To begin, please enter your email address below.

Should you not be able to complete the form in one sitting, any information you have entered will be saved and your form will continue from where you left off when you return.

By entering your email you are giving your consent to be contacted electronically by Supply Chain Canada on matters regarding the event and your registration/enrollment.


Optional

Have a promotional code? Enter it here.



Privacy Policy · Terms and Conditions