Are you as good at using Excel as world-class purchasing professionals are?<\/h1><\/div><\/div><\/div>PurchTips edition #2<\/p>\n<\/div>
Purchaser’s Excel Competency Checklist<\/h2><\/div><\/div><\/div>\n- I know how to use Excel to compare bids among suppliers<\/li>\n
- I know how to format a spreadsheet including use of colors, borders, font properties, cell alignment, etc.<\/li>\n
- I know how to develop Should Cost Models so that I can estimate the cost of a product or service before I receive bids from suppliers<\/li>\n
- I know how to use formulas in Excel to add, subtract, multiply, and divide, including those cases where several cells are involved in a complex calculation<\/li>\n
- I know how to develop weighted average supplier scorecards that allow me to place statistical emphasis on more important elements of suppliers’ performance<\/a> or proposals<\/li>\n
- I know how to use absolute and relative references to make calculations easier<\/li>\n
- I know how to use Excel’s decision support features to automatically answer a question<\/li>\n
- I know how to use functions such as those that can automatically tell me my lowest bid in a series of bids<\/li>\n
- I know how to create bar charts to visually compare bids among multiple suppliers<\/li>\n
- I know how to create line charts to monitor a supplier’s performance over time<\/li>\n
- I know how to create pie charts to categorize and analyze spending<\/li>\n
- I know how to use sorting and subtotaling to organize and analyze a large amount of spend data<\/li>\n
- I know how to create PivotTables to summarize purchasing patterns<\/li>\n
- I know how to use the Goal Seek command<\/li>\n
- I know how to create a Target Pricing Model that supports my negotiation strategy development<\/a><\/li>\n<\/ul>\n<\/div><\/div><\/div><\/div><\/div>
Do You Want a More Rewarding Procurement Career?<\/h5><\/div>![](\"https:\/\/www.certitrek.com\/nlpa\/wp-content\/uploads\/sites\/5\/2020\/12\/spsm_verify.jpg\" "\\"spsm_verify\\"")
<\/span><\/div>Are you tired of not getting enough opportunities, respect, and money out of your procurement career? Well, guess what? Nothing will change unless you take action towards becoming a world-class procurement professional.<\/p>\n
Earning your SPSM Certification is the action to take if you want to bring the most modern procurement practices into your organization and achieve your career potential. Download the SPSM Certification Guide today to learn how to get started on your journey to a more rewarding procurement career!<\/p>\n<\/div>
Download<\/span><\/a><\/div><\/div><\/div>Need Better Performance From Your Procurement Team?<\/h5><\/div>![](\"https:\/\/www.certitrek.com\/nlpa\/wp-content\/uploads\/sites\/5\/2020\/12\/services.jpg\" "\\"services\\"")
<\/span><\/div>Are you a procurement leader whose team isn\u2019t achieving the results you know are possible? Maybe it\u2019s not enough cost savings. Or frustrating performance from the supply base. Or dissatisfied internal customers.<\/p>\n
You need a performance improvement plan that\u2019s easy to implement and quick to produce results. The NLPA can help.<\/p>\n
Download our whitepaper \u201cThe Procurement Leader\u2019s Guide To A More Successful Team.\u201d You\u2019ll learn the 7 steps for transforming your staff into a results-producing, world-class procurement team.<\/p>\n<\/div>
PurchTips edition #2<\/p>\n<\/div>
Purchaser’s Excel Competency Checklist<\/h2><\/div><\/div><\/div>\n- I know how to use Excel to compare bids among suppliers<\/li>\n
- I know how to format a spreadsheet including use of colors, borders, font properties, cell alignment, etc.<\/li>\n
- I know how to develop Should Cost Models so that I can estimate the cost of a product or service before I receive bids from suppliers<\/li>\n
- I know how to use formulas in Excel to add, subtract, multiply, and divide, including those cases where several cells are involved in a complex calculation<\/li>\n
- I know how to develop weighted average supplier scorecards that allow me to place statistical emphasis on more important elements of suppliers’ performance<\/a> or proposals<\/li>\n
- I know how to use absolute and relative references to make calculations easier<\/li>\n
- I know how to use Excel’s decision support features to automatically answer a question<\/li>\n
- I know how to use functions such as those that can automatically tell me my lowest bid in a series of bids<\/li>\n
- I know how to create bar charts to visually compare bids among multiple suppliers<\/li>\n
- I know how to create line charts to monitor a supplier’s performance over time<\/li>\n
- I know how to create pie charts to categorize and analyze spending<\/li>\n
- I know how to use sorting and subtotaling to organize and analyze a large amount of spend data<\/li>\n
- I know how to create PivotTables to summarize purchasing patterns<\/li>\n
- I know how to use the Goal Seek command<\/li>\n
- I know how to create a Target Pricing Model that supports my negotiation strategy development<\/a><\/li>\n<\/ul>\n<\/div><\/div><\/div><\/div><\/div>
Do You Want a More Rewarding Procurement Career?<\/h5><\/div><\/span><\/div>Are you tired of not getting enough opportunities, respect, and money out of your procurement career? Well, guess what? Nothing will change unless you take action towards becoming a world-class procurement professional.<\/p>\n
Earning your SPSM Certification is the action to take if you want to bring the most modern procurement practices into your organization and achieve your career potential. Download the SPSM Certification Guide today to learn how to get started on your journey to a more rewarding procurement career!<\/p>\n<\/div>
Download<\/span><\/a><\/div><\/div><\/div>Need Better Performance From Your Procurement Team?<\/h5><\/div><\/span><\/div>Are you a procurement leader whose team isn\u2019t achieving the results you know are possible? Maybe it\u2019s not enough cost savings. Or frustrating performance from the supply base. Or dissatisfied internal customers.<\/p>\n
You need a performance improvement plan that\u2019s easy to implement and quick to produce results. The NLPA can help.<\/p>\n
Download our whitepaper \u201cThe Procurement Leader\u2019s Guide To A More Successful Team.\u201d You\u2019ll learn the 7 steps for transforming your staff into a results-producing, world-class procurement team.<\/p>\n<\/div>
- \n
- I know how to use Excel to compare bids among suppliers<\/li>\n
- I know how to format a spreadsheet including use of colors, borders, font properties, cell alignment, etc.<\/li>\n
- I know how to develop Should Cost Models so that I can estimate the cost of a product or service before I receive bids from suppliers<\/li>\n
- I know how to use formulas in Excel to add, subtract, multiply, and divide, including those cases where several cells are involved in a complex calculation<\/li>\n
- I know how to develop weighted average supplier scorecards that allow me to place statistical emphasis on more important elements of suppliers’ performance<\/a> or proposals<\/li>\n
- I know how to use absolute and relative references to make calculations easier<\/li>\n
- I know how to use Excel’s decision support features to automatically answer a question<\/li>\n
- I know how to use functions such as those that can automatically tell me my lowest bid in a series of bids<\/li>\n
- I know how to create bar charts to visually compare bids among multiple suppliers<\/li>\n
- I know how to create line charts to monitor a supplier’s performance over time<\/li>\n
- I know how to create pie charts to categorize and analyze spending<\/li>\n
- I know how to use sorting and subtotaling to organize and analyze a large amount of spend data<\/li>\n
- I know how to create PivotTables to summarize purchasing patterns<\/li>\n
- I know how to use the Goal Seek command<\/li>\n
- I know how to create a Target Pricing Model that supports my negotiation strategy development<\/a><\/li>\n<\/ul>\n<\/div><\/div><\/div><\/div><\/div>
Do You Want a More Rewarding Procurement Career?<\/h5><\/div>
<\/span><\/div>Are you tired of not getting enough opportunities, respect, and money out of your procurement career? Well, guess what? Nothing will change unless you take action towards becoming a world-class procurement professional.<\/p>\n
Earning your SPSM Certification is the action to take if you want to bring the most modern procurement practices into your organization and achieve your career potential. Download the SPSM Certification Guide today to learn how to get started on your journey to a more rewarding procurement career!<\/p>\n<\/div>
Download<\/span><\/a><\/div><\/div><\/div>Need Better Performance From Your Procurement Team?<\/h5><\/div>
<\/span><\/div>Are you a procurement leader whose team isn\u2019t achieving the results you know are possible? Maybe it\u2019s not enough cost savings. Or frustrating performance from the supply base. Or dissatisfied internal customers.<\/p>\n
You need a performance improvement plan that\u2019s easy to implement and quick to produce results. The NLPA can help.<\/p>\n
Download our whitepaper \u201cThe Procurement Leader\u2019s Guide To A More Successful Team.\u201d You\u2019ll learn the 7 steps for transforming your staff into a results-producing, world-class procurement team.<\/p>\n<\/div>
![](\"https:\/\/www.certitrek.com\/nlpa\/wp-content\/uploads\/sites\/5\/2020\/12\/services-contracting.jpg\" "\\"services-contracting\\"")
<\/span><\/div>