All prices are in Canadian dollars.

Data Analytics & Technical Skills: Excel for Supply Chain Professionals

Date:   Jan 15, 2024 - Jan 16, 2024
Time:   6:30 PM



Excel for Supply Chain Professionals


January 15 & 16, 2024


6:30 - 10:00 PM SK Time


5 Credits


Virtual via Zoom


$425 + tax Members

$495 + tax Non-Members


Basic to advanced understanding of Microsoft Excel


Supply Chain Management (SCM) is rapidly evolving as more and more corporations view it as a major source of value creation. In the effort to meet targets of ever shorter turnover times, waste reduction, and performance optimization while managing relationships with suppliers, SCM organizations are modernizing their systems and updating skills requirements. This creates a demand for a new breed of data-savvy analysts, adept at quickly processing large, complex data sets, automating data mining and analysis, and effectively communicating results.

Are you ready to upgrade what you’ve learned as a supply chain management professional by complementing it with the awesome analytical power of Excel?  Whether you are a practicing SCM professional or want to enhance your capabilities, this course is for you.

Who should attend?

SCM Professionals who want to become data-savvy and supply their companies with advanced analytics to help optimize performance and maximize savings. 

What Value can I expect?  

Aside from SCM-related exercises, this workshop provides tools and templates you can use immediately upon your return to work:

  • RFP Builder
  • Segmentation and Tiering Tool
  • Bridge and Gauge Chart Builder
    & more!

By attending this workshop, participants will:

  • Create better and cleaner spreadsheets or improve on existing ones by maximizing the use of advanced Excel functions and data integrity best practices
  • Work faster with large data sets
  • Prepare data for advanced analysis and visualization in Power BI
  • Create and design PivotTables for use in reporting and analysis
  • ...and more 

Some of the topics covered:

  • Work better with named ranges
  • The transition to Excel Tables (and why you'll never go back)
  • Data Control, Data Entry, and how SharePoint Lists and Excel work hand-in-hand
  • Practical Data Mining Formulas (including new functions in Excel 365!)
  • Flash Fill and other useful Shortcuts
  • Excel PivotTables
  • Data Models and Excel Data Tables

What version of Excel are we going to use?

The standard version that most corporations use today is MS Excel 365, which we’ll use throughout this workshop. Don’t worry if you’re using Excel 2013 or 2016, the workshop facilitator will help you bridge the gap between versions, which aren’t that much different from each other.


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 in the academe, teaching and upskilling has always been his passion.


Registrants will receive a full refund for courses cancelled by Supply Chain Canada, Saskatchewan Institute.

Registrants who have received written acceptance into a course and provided written notice to Supply Chain Canada, Saskatchewan Institute of their withdrawal from the course 14 days prior to 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 You are required to inform the Saskatchewan Institute 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


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.


Have a promotional code? Enter it here.