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
• Develop projection and cost-benefit analysis spreadsheets to assist with management decision making and managing external factor risk
• Set up spreadsheets to reliably analyze vendor information to assist in selection decision making
• Utilize Macros and advanced functions to save time when manipulating data and automating the production of management reports and charts