Event Registration

All prices are in Canadian dollars.

Data Analytics & Technical Skills: Excel for Supply Chain Professionals

Date:		Jan 21, 2023 - Jan 28, 2023
Time:		10:00 AM
Location:		NT

OVERVIEW

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
and more

KEY OUTCOMES

Key Learning Outcome(s):

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

Main Topics:

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.

CPD

5 Credits

PRICE

$425 Members | $495 Non-members

DATE

PART 1 Saturday, January 21, 2023 and PART 2 Saturday, January 28, 2023

10:00 am - 1:30 pm CST

Pre-Requisites

Basic to advanced understanding of Microsoft Excel

DO YOU RESIDE IN SASKATCHEWAN?

DO YOU RESIDE IN MANITOBA?

DO YOU RESIDE IN THE NORTHERN TERRITORIES ?

DO YOU RESIDE IN NEW BRUNSWICK?

ABOUT THE INSTRUCTOR

Ian Gonzalez

Ian has 16 years in senior positions in Procurement, Engineering and Maintenance, and Corporate Planning departments within oil and gas, and aviation MRO. industries. He has a passion for SCM teaching and does so from the perspective of an experienced SCM professional, engineer, and computer programmer. MBA and BSc in Mechanical Engineering.

ADDITIONAL INFORMATION

Refund Policy

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

Registrants who have received written acceptance into a course and provided written notice to Supply Chain Canada, Manitoba 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 [email protected]. You are required to inform the Manitoba Institute of your intent as soon as possible. Clearly state your intention to withdraw and provide authorization for us to proceed.

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.

Profile Information

The email address you have entered is not currently on file. If you are a Supply Chain Canada member or believe you should have a record in our database, please enter the email address we have on file. If you continue to have difficulties please contact [email protected].

Required Field *




*

*

*

*

Address

*


*

*

*

*

Telephone

*

Dietary Restrictions

E-mail

*

*

Yes, I provide my consent to Supply Chain Canada to periodically send me emails about my Registration/Enrollment, Supply Chain Canada programs, events or other information which may be of interest to me. I am aware that I may opt out or unsubscribe at any time.