Using Excel for Procurement Professionals

Using Excel for Procurement Professionals

Categoriescomputer group

Review

Course Fee$ per-month

The function of today’s procurement professional involves collating and analyzing vendor data, developing and sharing performance dashboards and creating interactive business cases and sensitivity or scenario models – and this require the capability to effectively utilize the Microsoft Excel software. This intensive, hands-on course demonstrates the full capabilities of the MS-Excel program for the role of a procurement and supply chain professional.

During the intensive training, delegates will learn to:

Set up Excel databases and data warehouse to consolidate data on vendor spend and estimates.

Develop and share performance dashboards which will include the number of vendors, value, number of transactions, payment terms and savings

Conduct profit and cost variation, sensitivity and margin analysis to help highlight key benefits of using one vendor over another