{"id":8952,"date":"2021-01-28T07:46:33","date_gmt":"2021-01-28T12:46:33","guid":{"rendered":"https:\/\/www.certitrek.com\/nlpa\/?post_type=avada_portfolio&#038;p=8952"},"modified":"2021-04-12T11:16:30","modified_gmt":"2021-04-12T15:16:30","slug":"data-analytics-for-procurement-professionals","status":"publish","type":"avada_portfolio","link":"https:\/\/www.certitrek.com\/nlpa\/blog\/courses\/data-analytics-for-procurement-professionals\/","title":{"rendered":"Data Analytics for Procurement Professionals"},"content":{"rendered":"<p>Are you failing to take advantage of Microsoft Excel\u2019s 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. Our highly personal and interactive online course <em>Data Analytics for Purchasing Professionals<\/em>\u00a0will enable you to perform sophisticated spreadsheet tasks through exercises that are based entirely on the situations that you face in your procurement work. Upon completing this course, you will be able to:<\/p>\n<ul>\n<li>Assess the competitiveness of supplier pricing through developing should cost models<\/li>\n<li>Assess all elements of supplier capabilities by creating weighted average supplier scorecards<\/li>\n<li>Apply Excel\u2019s sophisticated decision support features for procurement analysis<\/li>\n<li>Visually compare bids, analyze spend, and track supplier performance by creating charts<\/li>\n<li>Use PivotTables, functions, and subtotals to summarize large amounts of purchasing data<\/li>\n<li>Develop target pricing models for negotiation strategy<\/li>\n<li>Import data from other systems into Excel for analysis<\/li>\n<li>Drill down into complex purchasing spreadsheets by using filtering, conditional formatting, VLOOKUP, and more<\/li>\n<li>Use macros to free up time for strategic purchasing work<\/li>\n<\/ul>\n<p><em>You must have access to Microsoft Excel to complete this course.<\/em><\/p>\n<hr \/>\n<p>This is a self-paced course with no instructor-led forum and you have 60 days from registration to complete all course elements.\u00a0It should take you approximately 8 hours to review the material and take any quizzes. All readings are provided in the course.<\/p>\n<p>This course has been pre-approved for 8 CEHs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you failing to take advantage of Microsoft Excel\u2019s powerful [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":107,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"portfolio_category":[77,79,71],"portfolio_skills":[],"portfolio_tags":[],"class_list":["post-8952","avada_portfolio","type-avada_portfolio","status-publish","format-standard","has-post-thumbnail","hentry","portfolio_category-level-1-cpos","portfolio_category-project-management","portfolio_category-supplier-selection-individual-courses"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.4 (Yoast SEO v19.13) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Analytics for Procurement Professionals - Next Level Purchasing Association (NLPA)<\/title>\n<meta name=\"robots\" content=\"noindex, nofollow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Analytics for Procurement Professionals\" \/>\n<meta property=\"og:description\" content=\"Are you failing to take advantage of Microsoft Excel\u2019s powerful [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals\" \/>\n<meta property=\"og:site_name\" content=\"Next Level Purchasing Association (NLPA)\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/NextLevelPurchasing\/\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-12T15:16:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.certitrek.com\/nlpa\/wp-content\/uploads\/sites\/5\/2020\/08\/membership.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@nextlevelpurch\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.certitrek.com\/nlpa\/blog\/courses\/data-analytics-for-procurement-professionals\/\",\"url\":\"https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals\",\"name\":\"Data Analytics for Procurement Professionals - Next Level Purchasing Association (NLPA)\",\"isPartOf\":{\"@id\":\"https:\/\/www.certitrek.com\/nlpa\/#website\"},\"datePublished\":\"2021-01-28T12:46:33+00:00\",\"dateModified\":\"2021-04-12T15:16:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.certitrek.com\/nlpa\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Portfolio\",\"item\":\"https:\/\/www.certitrek.com\/nlpa\/blog\/courses\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Analytics for Procurement Professionals\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.certitrek.com\/nlpa\/#website\",\"url\":\"https:\/\/www.certitrek.com\/nlpa\/\",\"name\":\"Next Level Purchasing Association (NLPA)\",\"description\":\"The Next Level Purchasing Association\",\"publisher\":{\"@id\":\"https:\/\/www.certitrek.com\/nlpa\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.certitrek.com\/nlpa\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.certitrek.com\/nlpa\/#organization\",\"name\":\"Next Level Purchasing Association (NLPA)\",\"url\":\"https:\/\/www.certitrek.com\/nlpa\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.certitrek.com\/nlpa\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.certitrek.com\/nlpa\/wp-content\/uploads\/sites\/5\/2020\/08\/NLPA-logo-small-1.png\",\"contentUrl\":\"https:\/\/www.certitrek.com\/nlpa\/wp-content\/uploads\/sites\/5\/2020\/08\/NLPA-logo-small-1.png\",\"width\":149,\"height\":50,\"caption\":\"Next Level Purchasing Association (NLPA)\"},\"image\":{\"@id\":\"https:\/\/www.certitrek.com\/nlpa\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/next-level-purchasing-association\/\",\"https:\/\/www.youtube.com\/channel\/UCrNZYjcLcaNA4xMKQHEGamw\",\"https:\/\/www.facebook.com\/NextLevelPurchasing\/\",\"https:\/\/twitter.com\/nextlevelpurch\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Analytics for Procurement Professionals - Next Level Purchasing Association (NLPA)","robots":{"index":"noindex","follow":"nofollow"},"og_locale":"en_US","og_type":"article","og_title":"Data Analytics for Procurement Professionals","og_description":"Are you failing to take advantage of Microsoft Excel\u2019s powerful [&hellip;]","og_url":"https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals","og_site_name":"Next Level Purchasing Association (NLPA)","article_publisher":"https:\/\/www.facebook.com\/NextLevelPurchasing\/","article_modified_time":"2021-04-12T15:16:30+00:00","og_image":[{"width":300,"height":200,"url":"https:\/\/www.certitrek.com\/nlpa\/wp-content\/uploads\/sites\/5\/2020\/08\/membership.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@nextlevelpurch","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.certitrek.com\/nlpa\/blog\/courses\/data-analytics-for-procurement-professionals\/","url":"https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals","name":"Data Analytics for Procurement Professionals - Next Level Purchasing Association (NLPA)","isPartOf":{"@id":"https:\/\/www.certitrek.com\/nlpa\/#website"},"datePublished":"2021-01-28T12:46:33+00:00","dateModified":"2021-04-12T15:16:30+00:00","breadcrumb":{"@id":"https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learning.nextlevelpurchasing.com\/products\/data-analytics-for-procurement-professionals#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.certitrek.com\/nlpa\/"},{"@type":"ListItem","position":2,"name":"Portfolio","item":"https:\/\/www.certitrek.com\/nlpa\/blog\/courses\/"},{"@type":"ListItem","position":3,"name":"Data Analytics for Procurement Professionals"}]},{"@type":"WebSite","@id":"https:\/\/www.certitrek.com\/nlpa\/#website","url":"https:\/\/www.certitrek.com\/nlpa\/","name":"Next Level Purchasing Association (NLPA)","description":"The Next Level Purchasing Association","publisher":{"@id":"https:\/\/www.certitrek.com\/nlpa\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.certitrek.com\/nlpa\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.certitrek.com\/nlpa\/#organization","name":"Next Level Purchasing Association (NLPA)","url":"https:\/\/www.certitrek.com\/nlpa\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.certitrek.com\/nlpa\/#\/schema\/logo\/image\/","url":"https:\/\/www.certitrek.com\/nlpa\/wp-content\/uploads\/sites\/5\/2020\/08\/NLPA-logo-small-1.png","contentUrl":"https:\/\/www.certitrek.com\/nlpa\/wp-content\/uploads\/sites\/5\/2020\/08\/NLPA-logo-small-1.png","width":149,"height":50,"caption":"Next Level Purchasing Association (NLPA)"},"image":{"@id":"https:\/\/www.certitrek.com\/nlpa\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/next-level-purchasing-association\/","https:\/\/www.youtube.com\/channel\/UCrNZYjcLcaNA4xMKQHEGamw","https:\/\/www.facebook.com\/NextLevelPurchasing\/","https:\/\/twitter.com\/nextlevelpurch"]}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/avada_portfolio\/8952"}],"collection":[{"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/avada_portfolio"}],"about":[{"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/types\/avada_portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/comments?post=8952"}],"version-history":[{"count":5,"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/avada_portfolio\/8952\/revisions"}],"predecessor-version":[{"id":9477,"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/avada_portfolio\/8952\/revisions\/9477"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/media\/107"}],"wp:attachment":[{"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/media?parent=8952"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/portfolio_category?post=8952"},{"taxonomy":"portfolio_skills","embeddable":true,"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/portfolio_skills?post=8952"},{"taxonomy":"portfolio_tags","embeddable":true,"href":"https:\/\/www.certitrek.com\/nlpa\/wp-json\/wp\/v2\/portfolio_tags?post=8952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}