Data Analytics for Procurement Professionals

5 (1 vote)

  • Register
    • Non-member - $229
    • Standard Member - $229
    • Premium Member - $229

Are you failing to take advantage of Microsoft Excel’s powerful techniques for purchasing? Even if you are an experienced Excel user, you may not be utilizing the tools that can help you conduct expert procurement analysis, make sound purchasing decisions, and deliver top-notch presentations. Our highly personal and interactive online course Data Analytics for Purchasing Professionals will enable you to perform sophisticated spreadsheet tasks through exercises that are based entirely on the situations that you face in your procurement work. Upon completing this course, you will be able to:

  • Assess the competitiveness of supplier pricing through developing should cost models
  • Assess all elements of supplier capabilities by creating weighted average supplier scorecards
  • Apply Excel’s sophisticated decision support features for procurement analysis
  • Visually compare bids, analyze spend, and track supplier performance by creating charts
  • Use PivotTables, functions, and subtotals to summarize large amounts of purchasing data
  • Develop target pricing models for negotiation strategy
  • Import data from other systems into Excel for analysis
  • Drill down into complex purchasing spreadsheets by using filtering, conditional formatting, VLOOKUP and more
  • Use macros to free up time for strategic purchasing work

You must have access to Microsoft Excel to complete this course.


This is a self-paced course with no instructor-led forum and you have 60 days from registration to complete all course elements. It should take you approximately 8 hours to review the material and take any quizzes. All readings are provided in the course.

This course has been pre-approved for 8 hours of CE credit.

Key:

Complete
Failed
Available
Locked
Course Content
Data Analytics for Procurement Professionals
Begin self-paced component package.
Begin self-paced component package.
PDF: Data Analytics for Procurement Professionals
Open to download resource.
Open to download resource.
Audio: Data Analytics for Procurement Professionals
Open to listen to or download MP3 audio.
Open to listen to or download MP3 audio.
Análisis de datos para profesionales de compras
Begin self-paced component package.
Begin self-paced component package.
PDF: Análisis de datos para profesionales de compras
Open to download resource.
Open to download resource.
采购专业人员的数据分析
Begin self-paced component package.
Begin self-paced component package.
PDF: 采购专业人员的数据分析
Open to download resource.
Open to download resource.
Analyse des données pour les professionnels de l'approvisionnement
Begin self-paced component package.
Begin self-paced component package.
PDF: Analyse des données pour les professionnels de l'approvisionnement
Open to download resource.
Open to download resource.
調達プロフェッショナル向けのデータ分析
Begin self-paced component package.
Begin self-paced component package.
PDF: 調達プロフェッショナル向けのデータ分析
Open to download resource.
Open to download resource.
Quiz
Quiz: Data Analytics for Procurement Professionals (Required)
40 Questions  |  Unlimited attempts  |  30/43 points to pass
40 Questions  |  Unlimited attempts  |  30/43 points to pass
CE Credits and Certificate
CE Credits and Certificate: Data Analytics for Procurement Professionals
8.00 CE credits  |  Certificate available
8.00 CE credits  |  Certificate available
Course Survey
Course Survey
7 Questions
7 Questions Kindly complete this 5-minute survey as accurately as possible.