{"id":1786,"date":"2021-11-02T18:27:42","date_gmt":"2021-11-02T16:27:42","guid":{"rendered":"https:\/\/yourdevelopment.site\/pepa\/?page_id=1786"},"modified":"2021-11-19T16:46:57","modified_gmt":"2021-11-19T14:46:57","slug":"excel-support","status":"publish","type":"page","link":"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/","title":{"rendered":"Excel Support"},"content":{"rendered":"<p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:83.2%;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_3 1_3 fusion-flex-column fusion-flex-align-self-stretch\" style=\"--awb-padding-top:40px;--awb-padding-right:40px;--awb-padding-bottom:40px;--awb-padding-left:40px;--awb-bg-color:#eaa52c;--awb-bg-color-hover:#eaa52c;--awb-bg-size:cover;--awb-width-large:33.333333333333%;--awb-margin-top-large:40px;--awb-spacing-right-large:0px;--awb-margin-bottom-large:40px;--awb-spacing-left-large:0px;--awb-width-medium:33.333333333333%;--awb-order-medium:0;--awb-spacing-right-medium:0px;--awb-spacing-left-medium:0px;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"--awb-text-color:#ffffff;--awb-font-size:20px;\"><h1 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:20;--minFontSize:20;line-height:1.16;\">About<\/h1><\/div><div class=\"fusion-separator\" style=\"align-self: flex-start;margin-right:auto;margin-top:10px;margin-bottom:20px;width:100%;max-width:25%;\"><div class=\"fusion-separator-border sep-single sep-solid\" style=\"--awb-height:20px;--awb-amount:20px;--awb-sep-color:#ffffff;border-color:#ffffff;border-top-width:2px;\"><\/div><\/div><div class=\"fusion-text fusion-text-1\" style=\"--awb-text-color:#ffffff;\"><p>These five Excel support webinars will help you master the excel building blocks. The beauty of MS Excel is that no matter how complex formulas and functions get, they are all made up of simple pieces. The excel support sessions below will demonstrate various functions of excel that you can use when undertaking steps 4 and 5 of the spending review methodology. Having good excel skills is crucial when undertaking a spending review, this series aims at providing you with the necessary skills required.<\/p>\n<\/div><div class=\"fusion-widget-area awb-widget-area-element fusion-widget-area-1 fusion-content-widget-area\" style=\"--awb-title-size:28px;--awb-title-color:#0f8643;--awb-padding:0px 0px 0px 0px;\"><div id=\"nav_menu-4\" class=\"widget widget_nav_menu\" style=\"border-style: solid;border-color:transparent;border-width:0px;\"><div class=\"menu-resources-menu-container\"><ul id=\"menu-resources-menu\" class=\"menu\"><li id=\"menu-item-1803\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1803\"><a href=\"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-tips\/\">Excel Tips<\/a><\/li>\n<li id=\"menu-item-1804\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1804\"><a href=\"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/\">Excel Support<\/a><\/li>\n<li id=\"menu-item-1805\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1805\"><a href=\"https:\/\/www.gtac.gov.za\/pepa\/resources\/introductory-videos\/\">Introductory Videos<\/a><\/li>\n<li id=\"menu-item-1806\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1806\"><a href=\"https:\/\/www.gtac.gov.za\/pepa\/resources\/infographics\/\">Infographics<\/a><\/li>\n<\/ul><\/div><\/div><div class=\"fusion-additional-widget-content\"><\/div><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_2_3 2_3 fusion-flex-column fusion-flex-align-self-stretch\" style=\"--awb-padding-top:40px;--awb-padding-right:40px;--awb-padding-bottom:40px;--awb-padding-left:40px;--awb-bg-size:cover;--awb-width-large:66.666666666667%;--awb-margin-top-large:0px;--awb-spacing-right-large:0px;--awb-margin-bottom-large:0px;--awb-spacing-left-large:0px;--awb-width-medium:66.666666666667%;--awb-order-medium:0;--awb-spacing-right-medium:0px;--awb-spacing-left-medium:0px;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-2 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"--awb-text-color:#af1f23;--awb-font-size:20px;\"><h1 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;font-size:1em;--fontSize:20;--minFontSize:20;line-height:1.16;\">EXCEL SUPPORT<\/h1><\/div><div class=\"fusion-separator\" style=\"align-self: flex-start;margin-right:auto;margin-top:10px;margin-bottom:20px;width:100%;max-width:25%;\"><div class=\"fusion-separator-border sep-single sep-solid\" style=\"--awb-height:20px;--awb-amount:20px;--awb-sep-color:#af1f23;border-color:#af1f23;border-top-width:2px;\"><\/div><\/div><div class=\"accordian fusion-accordian doctoggles\" style=\"--awb-border-size:1px;--awb-icon-size:25px;--awb-content-font-size:16px;--awb-icon-alignment:left;--awb-hover-color:#f9f9fb;--awb-border-color:#e2e2e2;--awb-background-color:#ffffff;--awb-divider-color:#e2e2e2;--awb-divider-hover-color:#e2e2e2;--awb-icon-color:#0f8643;--awb-title-color:#4c4f50;--awb-content-color:#4a4e57;--awb-icon-box-color:#4c4f50;--awb-toggle-hover-accent-color:#0f8643;--awb-title-font-family:&quot;Myriad Pro Regular&quot;;--awb-title-font-weight:400;--awb-title-font-style:normal;--awb-title-font-size:28px;--awb-content-font-family:&quot;Myriad Pro Regular&quot;;--awb-content-font-style:normal;--awb-content-font-weight:400;\"><div class=\"panel-group fusion-toggle-icon-unboxed\" id=\"accordion-1786-1\"><div class=\"fusion-panel panel-default panel-5d5fa88b2e16cc6dd fusion-toggle-has-divider\"><div class=\"panel-heading\"><h4 class=\"panel-title toggle\" id=\"toggle_5d5fa88b2e16cc6dd\"><a aria-expanded=\"false\" aria-controls=\"5d5fa88b2e16cc6dd\" role=\"button\" data-toggle=\"collapse\" data-parent=\"#accordion-1786-1\" data-target=\"#5d5fa88b2e16cc6dd\" href=\"#5d5fa88b2e16cc6dd\"><span class=\"fusion-toggle-icon-wrapper\" aria-hidden=\"true\"><i class=\"fa-fusion-box active-icon awb-icon-minus\" aria-hidden=\"true\"><\/i><i class=\"fa-fusion-box inactive-icon awb-icon-plus\" aria-hidden=\"true\"><\/i><\/span><span class=\"fusion-toggle-heading\">Session 1 - Finding and Cleaning Data<\/span><\/a><\/h4><\/div><div id=\"5d5fa88b2e16cc6dd\" class=\"panel-collapse collapse \" aria-labelledby=\"toggle_5d5fa88b2e16cc6dd\"><div class=\"panel-body toggle-content fusion-clearfix\">\n<p>During this session, you will be provided with some tips and tricks around the use of the IF and Vlookup for complex data cleaning functions.<\/p>\n<div class=\"video-shortcode\"><iframe title=\"PEPA - Knowledge Hub - Friday Excel Support Sessions - 2021 07 16\" width=\"1536\" height=\"864\" src=\"https:\/\/www.youtube.com\/embed\/GSyqilNk8b8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<\/div><\/div><\/div><div class=\"fusion-panel panel-default panel-05f549f913efc4abb fusion-toggle-has-divider\"><div class=\"panel-heading\"><h4 class=\"panel-title toggle\" id=\"toggle_05f549f913efc4abb\"><a aria-expanded=\"false\" aria-controls=\"05f549f913efc4abb\" role=\"button\" data-toggle=\"collapse\" data-parent=\"#accordion-1786-1\" data-target=\"#05f549f913efc4abb\" href=\"#05f549f913efc4abb\"><span class=\"fusion-toggle-icon-wrapper\" aria-hidden=\"true\"><i class=\"fa-fusion-box active-icon awb-icon-minus\" aria-hidden=\"true\"><\/i><i class=\"fa-fusion-box inactive-icon awb-icon-plus\" aria-hidden=\"true\"><\/i><\/span><span class=\"fusion-toggle-heading\">Session 2 - Cleaning and consolidating data<\/span><\/a><\/h4><\/div><div id=\"05f549f913efc4abb\" class=\"panel-collapse collapse \" aria-labelledby=\"toggle_05f549f913efc4abb\"><div class=\"panel-body toggle-content fusion-clearfix\">\n<p>During this session, you will be taken through Vlookup and TEXT functions. The functions will be used to FIND and CLEAN data. This means creating uniform names and text, removing unnecessary spaces and symbol, and neatening the text for consistency. A core part of spending reviews is comparing expenditure data with other data and while the structure of the data may generally be aligned, the exact names differ enough to be a problem for Excel. Therefore, its critical make sure the data is uniform. Vlookup will assist in making the datasets uniform.<\/p>\n<div class=\"video-shortcode\"><iframe title=\"PEPA - Knowledge Hub - Friday Excel Support Sessions - 2021 07 23\" width=\"1536\" height=\"864\" src=\"https:\/\/www.youtube.com\/embed\/2UfaO98GDYI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<\/div><\/div><\/div><div class=\"fusion-panel panel-default panel-35007d54d136115fa fusion-toggle-has-divider\"><div class=\"panel-heading\"><h4 class=\"panel-title toggle\" id=\"toggle_35007d54d136115fa\"><a aria-expanded=\"false\" aria-controls=\"35007d54d136115fa\" role=\"button\" data-toggle=\"collapse\" data-parent=\"#accordion-1786-1\" data-target=\"#35007d54d136115fa\" href=\"#35007d54d136115fa\"><span class=\"fusion-toggle-icon-wrapper\" aria-hidden=\"true\"><i class=\"fa-fusion-box active-icon awb-icon-minus\" aria-hidden=\"true\"><\/i><i class=\"fa-fusion-box inactive-icon awb-icon-plus\" aria-hidden=\"true\"><\/i><\/span><span class=\"fusion-toggle-heading\">Session 3 - Common Statistical Functions<\/span><\/a><\/h4><\/div><div id=\"35007d54d136115fa\" class=\"panel-collapse collapse \" aria-labelledby=\"toggle_35007d54d136115fa\"><div class=\"panel-body toggle-content fusion-clearfix\">\n<p>During this session, you will be taken through various statistical functions to be done within and outside the Pivot table. The functions are used to compare expenditure levels or performance across several locations or expenditure components. When using the functions, we can identify top spenders or top performers, order spenders according to level of spend or performance and assess particular implementation approach (e.g., insourcing vs. outsourcing has better outcomes)<\/p>\n<div class=\"video-shortcode\"><iframe title=\"PEPA - Knowledge Hub - Friday Excel Support Sessions - 2021 07 30\" width=\"1536\" height=\"864\" src=\"https:\/\/www.youtube.com\/embed\/pNk-BirVdEI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<\/div><\/div><\/div><div class=\"fusion-panel panel-default panel-7cd034addd0f4284b fusion-toggle-has-divider\"><div class=\"panel-heading\"><h4 class=\"panel-title toggle\" id=\"toggle_7cd034addd0f4284b\"><a aria-expanded=\"false\" aria-controls=\"7cd034addd0f4284b\" role=\"button\" data-toggle=\"collapse\" data-parent=\"#accordion-1786-1\" data-target=\"#7cd034addd0f4284b\" href=\"#7cd034addd0f4284b\"><span class=\"fusion-toggle-icon-wrapper\" aria-hidden=\"true\"><i class=\"fa-fusion-box active-icon awb-icon-minus\" aria-hidden=\"true\"><\/i><i class=\"fa-fusion-box inactive-icon awb-icon-plus\" aria-hidden=\"true\"><\/i><\/span><span class=\"fusion-toggle-heading\">Session 4 \u2013 Combining Performance and Expenditure Data<\/span><\/a><\/h4><\/div><div id=\"7cd034addd0f4284b\" class=\"panel-collapse collapse \" aria-labelledby=\"toggle_7cd034addd0f4284b\"><div class=\"panel-body toggle-content fusion-clearfix\">\n<p>During this session, you will be taken through the MATCH and INDEX functions. You will also learn how to structure and label your spreadsheets and use Excel functions to combine datasets.<\/p>\n<div class=\"video-shortcode\"><iframe title=\"Friday Excel Support Sessions - 2021 08 06\" width=\"1536\" height=\"864\" src=\"https:\/\/www.youtube.com\/embed\/-e4Txt4shDg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<\/div><\/div><\/div><div class=\"fusion-panel panel-default panel-e716eccc4ebdf191d fusion-toggle-has-divider\"><div class=\"panel-heading\"><h4 class=\"panel-title toggle\" id=\"toggle_e716eccc4ebdf191d\"><a aria-expanded=\"false\" aria-controls=\"e716eccc4ebdf191d\" role=\"button\" data-toggle=\"collapse\" data-parent=\"#accordion-1786-1\" data-target=\"#e716eccc4ebdf191d\" href=\"#e716eccc4ebdf191d\"><span class=\"fusion-toggle-icon-wrapper\" aria-hidden=\"true\"><i class=\"fa-fusion-box active-icon awb-icon-minus\" aria-hidden=\"true\"><\/i><i class=\"fa-fusion-box inactive-icon awb-icon-plus\" aria-hidden=\"true\"><\/i><\/span><span class=\"fusion-toggle-heading\">Session 5 - Data Visualization<\/span><\/a><\/h4><\/div><div id=\"e716eccc4ebdf191d\" class=\"panel-collapse collapse \" aria-labelledby=\"toggle_e716eccc4ebdf191d\"><div class=\"panel-body toggle-content fusion-clearfix\">\n<p>During this session, you will be taken though the principles for cleaning and presenting graphs. This is not about making graphs look good but rather making a clear point using data. It adds credibility to your analysis. The session will assist you in asking the relevant questions before presenting charts and tables in order to get a point to the readers.<\/p>\n<div class=\"video-shortcode\"><iframe title=\"GTAC Friday Excel Support Sessions - 2021 08 13\" width=\"1536\" height=\"864\" src=\"https:\/\/www.youtube.com\/embed\/nc_QeMuCe3o?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-2 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:83.2%;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-2\"><\/div><\/div><\/div><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2081,"featured_media":0,"parent":1783,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"100-width.php","meta":{"footnotes":""},"class_list":["post-1786","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Support - PEPA Knowledge Hub<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Support - PEPA Knowledge Hub\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/\" \/>\n<meta property=\"og:site_name\" content=\"PEPA Knowledge Hub\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-19T14:46:57+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/\",\"url\":\"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/\",\"name\":\"Excel Support - PEPA Knowledge Hub\",\"isPartOf\":{\"@id\":\"https:\/\/www.gtac.gov.za\/pepa\/#website\"},\"datePublished\":\"2021-11-02T16:27:42+00:00\",\"dateModified\":\"2021-11-19T14:46:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/#breadcrumb\"},\"inLanguage\":\"en-ZA\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gtac.gov.za\/pepa\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resources\",\"item\":\"https:\/\/www.gtac.gov.za\/pepa\/resources\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Support\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gtac.gov.za\/pepa\/#website\",\"url\":\"https:\/\/www.gtac.gov.za\/pepa\/\",\"name\":\"PEPA Knowledge Hub\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gtac.gov.za\/pepa\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-ZA\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Support - PEPA Knowledge Hub","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/","og_locale":"en_US","og_type":"article","og_title":"Excel Support - PEPA Knowledge Hub","og_url":"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/","og_site_name":"PEPA Knowledge Hub","article_modified_time":"2021-11-19T14:46:57+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/","url":"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/","name":"Excel Support - PEPA Knowledge Hub","isPartOf":{"@id":"https:\/\/www.gtac.gov.za\/pepa\/#website"},"datePublished":"2021-11-02T16:27:42+00:00","dateModified":"2021-11-19T14:46:57+00:00","breadcrumb":{"@id":"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/#breadcrumb"},"inLanguage":"en-ZA","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.gtac.gov.za\/pepa\/resources\/excel-support\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gtac.gov.za\/pepa\/"},{"@type":"ListItem","position":2,"name":"Resources","item":"https:\/\/www.gtac.gov.za\/pepa\/resources\/"},{"@type":"ListItem","position":3,"name":"Excel Support"}]},{"@type":"WebSite","@id":"https:\/\/www.gtac.gov.za\/pepa\/#website","url":"https:\/\/www.gtac.gov.za\/pepa\/","name":"PEPA Knowledge Hub","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gtac.gov.za\/pepa\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-ZA"}]}},"_links":{"self":[{"href":"https:\/\/www.gtac.gov.za\/pepa\/wp-json\/wp\/v2\/pages\/1786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gtac.gov.za\/pepa\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.gtac.gov.za\/pepa\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.gtac.gov.za\/pepa\/wp-json\/wp\/v2\/users\/2081"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gtac.gov.za\/pepa\/wp-json\/wp\/v2\/comments?post=1786"}],"version-history":[{"count":15,"href":"https:\/\/www.gtac.gov.za\/pepa\/wp-json\/wp\/v2\/pages\/1786\/revisions"}],"predecessor-version":[{"id":2692,"href":"https:\/\/www.gtac.gov.za\/pepa\/wp-json\/wp\/v2\/pages\/1786\/revisions\/2692"}],"up":[{"embeddable":true,"href":"https:\/\/www.gtac.gov.za\/pepa\/wp-json\/wp\/v2\/pages\/1783"}],"wp:attachment":[{"href":"https:\/\/www.gtac.gov.za\/pepa\/wp-json\/wp\/v2\/media?parent=1786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}