Microsoft Excel For Purchasing Professionals

Learn how to conduct procurement analysis using Excel

Are you failing to take advantage of Microsoft Excel’s powerful techniques for purchasing? 

Look, 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 “Microsoft Excel 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 purchasing work.


Businessman engaged in procurement analysis.

SPSM-BOK® Level: 1
Competency: Analysis & Spreadsheets
CEHs: 8

See Ratings & Reviews

Microsoft Excel For Purchasing Professionals

Learn how to conduct procurement analysis using Excel

Businessman engaged in procurement analysis.Are you failing to take advantage of Microsoft Excel’s powerful techniques for purchasing? 

Look, 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 “Microsoft Excel 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 purchasing work.

You will learn:

  • How to assess the competitiveness of supplier pricing through developing “Should Cost Models”
  • How to assess all elements of supplier capabilities by creating weighted average supplier scorecards
  • How to use Excel’s sophisticated decision support features for procurement analysis
  • How to visually compare bids, analyze spend, and track supplier performance by creating charts
  • How to use PivotTables, functions, and subtotals to summarize large amounts of purchasing data
  • How to develop “Target Pricing Models” for negotiation strategy
  • How to import data from other systems into Excel for analysis
  • How to drill down into complex purchasing spreadsheets by using filtering, conditional formatting, VLOOKUP and more
  • How to use macros to free up time for strategic purchasing work

 

How This Online Course Works

  • Start this on-demand course any time after you enroll; there’s no pre-scheduled start date!
  • This course has 8 lessons; it will take you between 30-60 minutes to complete each lesson.
  • Progress through the course at your own pace, accessing easy-to-understand reading material, exciting exercises, optional multimedia, quizzes, and even a fun mid-term game!
  • What if you have questions on the material? Ask a friendly, expert instructor any questions you may have!
  • Learn best practices and processes designed so that you can apply your new skills in the real world!

To learn more about how full-length online procurement courses from the Next Level Purchasing Association work, watch this short video.

What are others saying about this course?

"This was an excellent course and something I could take to my job immediately and put to work. The information like Pivot tables and VLOOKUP are things that are helping me daily with sourcing and quoting decisions."

Troy Emehiser, SPSM
Senior Buyer
Phoenix, Arizona

"I work with Excel all the time and, until this course, I did not realize how much of Excel I was not utilizing. I love taking courses that allow me to apply what I'm learning in the workplace on a daily basis."

Kathleen Warren, SPSM
Purchasing Manager
Auburn, Massachussetts

Option 1:

Learn to conduct Procurement Analysis

If you are:

  • New to using Excel
  • Looking for a step-by-step guide to utilizing Excel’s sophisticated analysis tools

Then “Microsoft Excel for Purchasing Professionals” would be a great course for you.

Bonuses for enrolling by deadline below:

  • FREE printer-friendly, PDF version of the course material
  • FREE Lifetime Purchasing Skills Retention Package

Number of Courses: 1

Length of Training: 6-8 hours

Duration of Access: 60 days

Start Date: Access begins as soon as you enroll

Cost: $229 US

Enroll Now

Option 2:

Earn Your SPSM® Certification

The course “Microsoft Excel for Purchasing Professionals” is one of the six online courses that count towards SPSM® Certification.

Thinking about pursuing your certification? Then, now is the time to enroll in the Senior Professional in Supply Management® Program, which gives you all you need to become certified, including “Microsoft for Purchasing Professionals.”

Bonuses for enrolling by deadline below:

Number of Courses: 6

Length of Training: 46-48 hours

Duration of Access: 1 year

Start Date: Access begins as soon as you enroll

Cost: $1,159 US

Enroll Now


 

Interested, but have a few questions?

For immediate assistance, call our office at +1 (412) 294-1990 and speak with a member of the NLPA Team, Monday through Friday from 8AM to 5PM Eastern US Time.

Click on the button below to submit your questions electronically and a member of the NLPA team will contact you within one business day.