PROFESSIONAL DEVELOPMENT
DATA ANALYTICS & TECHNICAL SKILLS:
PROFESSIONAL DEVELOPMENT
DATA ANALYTICS & TECHNICAL SKILLS:
EXCEL FOR SUPPLY CHAIN PROFESSIONALS
DATA ANALYTICS & TECHNICAL SKILLS:
EXCEL FOR SUPPLY CHAIN PROFESSIONALS
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 tech-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
MEET THE INSTRUCTOR
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.
REGISTER NOW AT
SUPPLY CHAIN CANADA
COURSE DETAILS
DATE: January 21 and 28, 2023
LOCATION: Online Via Zoom
TIME: 9:00 AM – 12:30 PM MT
CPD: 5 Credits
PRICE: $425 + GST | MEMBER RATE
$495 + GST | NON-MEMBER RATE
COURSE REGISTRATION
AB RESIDENTSSK RESIDENTSMB RESIDENTSNT RESIDENTSNB RESIDENTS
DATA ANALYTICS & TECHNICAL SKILLS:
EXCEL FOR SUPPLY CHAIN PROFESSIONALS
COURSE DETAILS
DATE: January 21 and 28, 2023
LOCATION: Online Via Zoom
TIME: 9:00 AM – 12:30 PM MT
CPD: 5 Credits
PRICE: $425 + GST | MEMBER RATE
$495 + GST | NON-MEMBER RATE
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 tech-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
MEET THE INSTRUCTOR
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.
