uses of microsoft excel for procurement officer

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. You must have access to Microsoft Excel to complete this course.

Use macros to free up time for strategic purchasing work.Drill down into complex purchasing spreadsheets by using filtering, conditional formatting, VLOOKUP and more.Import data from other systems into Excel for analysis.Develop target pricing models for negotiation strategy.Use PivotTables, functions, and subtotals to summarize large amounts of purchasing data.

Visually compare bids, analyze spend, and track supplier performance by creating charts.Apply Excel’s sophisticated decision support features for procurement analysis.Assess all elements of supplier capabilities by creating weighted average supplier scorecards.Assess the competitiveness of supplier pricing through developing should cost models.Upon completing this course, you will be able to: 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. 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.

Uses of microsoft excel for procurement officer