{"id":14607,"date":"2022-12-29T08:24:28","date_gmt":"2022-12-29T07:24:28","guid":{"rendered":"https:\/\/www.itta.net\/formations\/icdl-advanced-spreadsheet-am4\/"},"modified":"2023-10-10T08:50:40","modified_gmt":"2023-10-10T06:50:40","slug":"icdl-advanced-spreadsheet-am4","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-spreadsheet-am4\/","title":{"rendered":"ICDL ADVANCED &#8211; Spreadsheet &#8211; AM4"},"content":{"rendered":"<p>This training covers advanced spreadsheet skills, e.g. the analysis of data in tables, conditional formatting and custom number formats.<\/p>\n","protected":false},"featured_media":0,"parent":0,"menu_order":0,"template":"","editeurs":[1532,1533],"domaine":[1265,1266],"class_list":["post-14607","formations","type-formations","status-publish","hentry","editeurs-ecdl","editeurs-modules-avances-ecdl","domaine-office-automation","domaine-office-automation-certifications"],"acf":{"reference":"ECDL3-AM4","duree_nombre":2,"duree_unite":"jour","prix_virtuel":1200,"prix_presentiel":1300,"prix_blended":"","prix_elearning":"","views":2101,"niveau":["Avanc\u00e9"],"role":"","certifiant":["Certifiant"],"pdus":"","lieux":["Gen\u00e8ve","Lausanne"],"formats_dapprentissage":["presentiel","virtuel"],"examen_inclus":"Optionnel","garanti":[""],"financement":["Temptraining"],"description_temptraining":"","description_caf":"","description_title":"","objectifs":"<ul>\r\n \t<li>Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets<\/li>\r\n \t<li>Use functions such as those associated with logical, statistical, financial and mathematical operations<\/li>\r\n \t<li>Create charts and apply advanced chart formatting `Work with tables and lists to analyse, filter and sort data. Create and use scenarios<\/li>\r\n \t<li>Validate and audit spreadsheet data<\/li>\r\n \t<li>Enhance productivity by working with named cell ranges and macros<\/li>\r\n \t<li>Use linking, embedding and importing features to integrate data<\/li>\r\n \t<li>Compare and merge spreadsheets. Apply spreadsheet security features<\/li>\r\n<\/ul>","connaissances":"<ul>\r\n \t<li>Follow\u00a0or have the knowledge covered by\u00a0ICDL Base - Spreadsheet course<\/li>\r\n<\/ul>","profils_participants":"<ul>\r\n \t<li>Anyone who already have advanced knowledge of Excel spreadsheet and wish to obtain the ICDL certification<\/li>\r\n<\/ul>","examen":"<ul>\r\n \t<li>This course prepares to the exam ICDL ADVANCED - Spreadsheet. If you wish to take this exam, please contact our secretariat who will let you know the cost of the exam and will take care of all the necessary administrative procedures for you<\/li>\r\n<\/ul>","documentation":"<ul>\r\n \t<li>Digital courseware included<\/li>\r\n<\/ul>","lab__exercices":"<ul>\r\n \t<li>Practice exercises will be offered during and at the end of each module<\/li>\r\n<\/ul>","contenu_cours":"<strong>Chapter 1: Formatting<\/strong>\r\n<ul>\r\n \t<li>Module 1: Cells\r\n<ul>\r\n \t<li>Apply conditional formatting<\/li>\r\n \t<li>Create and apply custom number formats<\/li>\r\n \t<li>Split text to columns<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 2: Worksheets\r\n<ul>\r\n \t<li>Copy, move worksheets between spreadsheets<\/li>\r\n \t<li>Split a window. Move, remove split bars<\/li>\r\n \t<li>Hide, show rows, columns, worksheets<\/li>\r\n \t<li>Save a spreadsheet as a template, modify a template<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 2: Formulas and Functions<\/strong>\r\n<ul>\r\n \t<li>Module 1: Using Formulas and Functions\r\n<ul>\r\n \t<li>Use date and time functions: today, now, day, month, year<\/li>\r\n \t<li>Use logical functions: and, or, not<\/li>\r\n \t<li>Use mathematical functions: rounddown, roundup, sumif<\/li>\r\n \t<li>Use statistical functions: countif, countblank, rank<\/li>\r\n \t<li>Use text functions: left, right, mid, trim, concatenate<\/li>\r\n \t<li>Use financial functions: fv, pv, pmt<\/li>\r\n \t<li>Use lookup functions: vlookup, hlookup<\/li>\r\n \t<li>Use database functions: dsum, dmin, dmax, dcount, daverage<\/li>\r\n \t<li>Create a two-level nested function<\/li>\r\n \t<li>Use a 3-D reference within a sum, average, minimum, maximum function<\/li>\r\n \t<li>Use mixed references in formulas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 3: Charts<\/strong>\r\n<ul>\r\n \t<li>Module 1: Creating Charts\r\n<ul>\r\n \t<li>Create a combined chart like: column and line, column and area<\/li>\r\n \t<li>Create, change, delete a sparkline<\/li>\r\n \t<li>Add a secondary axis to a chart<\/li>\r\n \t<li>Change the chart type for a defined data series<\/li>\r\n \t<li>Add, delete a data series in a chart<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 2: Formatting Charts\r\n<ul>\r\n \t<li>Re-position chart title, legend, data labels<\/li>\r\n \t<li>Change scale of value axis: minimum, maximum number to display, major interval<\/li>\r\n \t<li>Change display units on value axis without changing data source: hundreds, thousands, millions<\/li>\r\n \t<li>Format columns, bars, pie slices, plot area, chart area to display an image<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 4: Analysis<\/strong>\r\n<ul>\r\n \t<li>Module 1: Using Tables\r\n<ul>\r\n \t<li>Create, modify a pivot table\/datapilot<\/li>\r\n \t<li>Modify the data source and refresh the pivot table\/datapilot<\/li>\r\n \t<li>Filter, sort data in a pivot table\/datapilot<\/li>\r\n \t<li>Automatically, manually group data in a pivot table\/datapilot and rename groups<\/li>\r\n \t<li>Use one-input, two-input data tables\/multiple operations tables<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 2: Sorting and Filtering\r\n<ul>\r\n \t<li>Sort data by multiple columns at the same time<\/li>\r\n \t<li>Create a customized list and perform a custom sort<\/li>\r\n \t<li>Automatically filter a list in place<\/li>\r\n \t<li>Apply advanced filter options to a list<\/li>\r\n \t<li>Use automatic, manual outline features: group, ungroup, sub-total<\/li>\r\n \t<li>Expand, collapse outline detail levels<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 3: Scenarios\r\n<ul>\r\n \t<li>Create named scenarios<\/li>\r\n \t<li>Show, edit, delete scenarios<\/li>\r\n \t<li>Create a scenario summary report<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 5: Validating and Auditing<\/strong>\r\n<ul>\r\n \t<li>Module 1: Validating\r\n<ul>\r\n \t<li>Set, edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time<\/li>\r\n \t<li>Enter input message and error alert<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 2: Auditing\r\n<ul>\r\n \t<li>Trace precedent, dependent cells. Identify cells with missing dependents<\/li>\r\n \t<li>Display all formulas in a worksheet, rather than the resulting values<\/li>\r\n \t<li>Insert, edit, delete, show, hide comments\/notes in a worksheet locally, online<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 6: Enhancing Productivity<\/strong>\r\n<ul>\r\n \t<li>Module 1: Naming Cells\r\n<ul>\r\n \t<li>Name cell ranges, delete names for cell ranges<\/li>\r\n \t<li>Use named cell ranges in a function<\/li>\r\n \t<li>Activate, deactivate the group mode<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 2: Paste Special\r\n<ul>\r\n \t<li>Use paste special options: add, subtract, multiply, divide<\/li>\r\n \t<li>Use paste special options: values\/numbers, transpose<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 3: Linking, Embedding and Importing\r\n<ul>\r\n \t<li>Insert, edit, remove a hyperlink<\/li>\r\n \t<li>Link data within a spreadsheet, between spreadsheets<\/li>\r\n \t<li>Update, break a link<\/li>\r\n \t<li>Import delimited data from a text file<\/li>\r\n<\/ul>\r\n<\/li>\r\n \t<li>Module 4: Automation\r\n<ul>\r\n \t<li>Record a simple macro like: change page setup, apply a custom number format, apply autoformats to a cell range, insert fields in worksheet header, footer<\/li>\r\n \t<li>Run a macro<\/li>\r\n \t<li>Assign a macro to a custom button<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<strong>Chapter 7: Collaborative Editing<\/strong>\r\n<ul>\r\n \t<li>Module 1: Reviewing and Security\r\n<ul>\r\n \t<li>Compare and merge spreadsheets<\/li>\r\n \t<li>Add, remove password protection for a spreadsheet: to open, to modify<\/li>\r\n \t<li>Protect, unprotect cells, worksheet with a password<\/li>\r\n \t<li>Hide, unhide formulas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","cours_recommandes":[14606,14608,14609],"infos_additionnelles":"","inclus_dans_ce_cours_virtuel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>Exam fee (Skills Card not included)<\/li>\r\n \t<li>Pre-training level evaluation<\/li>\r\n \t<li>Digital documentation<\/li>\r\n<\/ul>","inclus_dans_ce_cours_presentiel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>Exam fee (Skills Card not included)<\/li>\r\n \t<li>Pre-training level evaluation<\/li>\r\n \t<li>Digital documentation<\/li>\r\n<\/ul>","inclus_dans_ce_cours_blended":"","inclus_dans_ce_cours_elearning":"","inclus_dans_ce_cours_surmesure":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Training ICDL ADVANCED - Spreadsheet AM4 - ITTA<\/title>\n<meta name=\"description\" content=\"This course covers advanced spreadsheet skills, e.g. the analysis of data in tables, conditional formatting and custom number formats.\" \/>\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.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-spreadsheet-am4\/\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated 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.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-spreadsheet-am4\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-spreadsheet-am4\\\/\",\"name\":\"Training ICDL ADVANCED - Spreadsheet AM4 - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"datePublished\":\"2022-12-29T07:24:28+00:00\",\"dateModified\":\"2023-10-10T06:50:40+00:00\",\"description\":\"This course covers advanced spreadsheet skills, e.g. the analysis of data in tables, conditional formatting and custom number formats.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-spreadsheet-am4\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-spreadsheet-am4\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/icdl-advanced-spreadsheet-am4\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Office Automation\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Office Automation Certifications\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/office-automation-certifications\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"ICDL ADVANCED &#8211; Spreadsheet &#8211; AM4\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"name\":\"ITTA\",\"description\":\"Formations &amp; Certifications en Suisse Romande\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itta.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Organization\",\"EducationalOrganization\"],\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\",\"name\":\"ITTA\",\"alternateName\":\"IT TRAINING ACADEMY SA\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"width\":1500,\"height\":623,\"caption\":\"ITTA\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/ITTA\\\/100063747262936\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1001738\",\"https:\\\/\\\/www.instagram.com\\\/itta_suisse\\\/\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"+41 58 307 73 00\",\"contactType\":\"customer service\",\"availableLanguage\":[\"French\",\"English\"],\"areaServed\":[{\"@type\":\"Country\",\"name\":\"Switzerland\"},{\"@type\":\"Country\",\"name\":\"France\"}]},\"location\":[{\"@type\":\"Place\",\"name\":\"ITTA Geneve\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Route des Jeunes 35\",\"addressLocality\":\"Carouge\",\"postalCode\":\"1227\",\"addressRegion\":\"GE\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.18274,\"longitude\":6.12922}},{\"@type\":\"Place\",\"name\":\"ITTA Lausanne\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Rue des Cotes-de-Montbenon 16\",\"addressLocality\":\"Lausanne\",\"postalCode\":\"1003\",\"addressRegion\":\"VD\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.52111,\"longitude\":6.62734}}]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Training ICDL ADVANCED - Spreadsheet AM4 - ITTA","description":"This course covers advanced spreadsheet skills, e.g. the analysis of data in tables, conditional formatting and custom number formats.","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.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-spreadsheet-am4\/","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-spreadsheet-am4\/","url":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-spreadsheet-am4\/","name":"Training ICDL ADVANCED - Spreadsheet AM4 - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"datePublished":"2022-12-29T07:24:28+00:00","dateModified":"2023-10-10T06:50:40+00:00","description":"This course covers advanced spreadsheet skills, e.g. the analysis of data in tables, conditional formatting and custom number formats.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-spreadsheet-am4\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-spreadsheet-am4\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/icdl-advanced-spreadsheet-am4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itta.net\/en\/"},{"@type":"ListItem","position":2,"name":"Office Automation","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/"},{"@type":"ListItem","position":3,"name":"Office Automation Certifications","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/office-automation-certifications\/"},{"@type":"ListItem","position":4,"name":"ICDL ADVANCED &#8211; Spreadsheet &#8211; AM4"}]},{"@type":"WebSite","@id":"https:\/\/www.itta.net\/en\/#website","url":"https:\/\/www.itta.net\/en\/","name":"ITTA","description":"Formations &amp; Certifications en Suisse Romande","publisher":{"@id":"https:\/\/www.itta.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itta.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Organization","EducationalOrganization"],"@id":"https:\/\/www.itta.net\/en\/#organization","name":"ITTA","alternateName":"IT TRAINING ACADEMY SA","url":"https:\/\/www.itta.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","width":1500,"height":623,"caption":"ITTA"},"image":{"@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/ITTA\/100063747262936\/","https:\/\/www.linkedin.com\/company\/1001738","https:\/\/www.instagram.com\/itta_suisse\/"],"contactPoint":{"@type":"ContactPoint","telephone":"+41 58 307 73 00","contactType":"customer service","availableLanguage":["French","English"],"areaServed":[{"@type":"Country","name":"Switzerland"},{"@type":"Country","name":"France"}]},"location":[{"@type":"Place","name":"ITTA Geneve","address":{"@type":"PostalAddress","streetAddress":"Route des Jeunes 35","addressLocality":"Carouge","postalCode":"1227","addressRegion":"GE","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.18274,"longitude":6.12922}},{"@type":"Place","name":"ITTA Lausanne","address":{"@type":"PostalAddress","streetAddress":"Rue des Cotes-de-Montbenon 16","addressLocality":"Lausanne","postalCode":"1003","addressRegion":"VD","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.52111,"longitude":6.62734}}]}]}},"_links":{"self":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations"}],"about":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/types\/formations"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14609"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14608"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14606"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=14607"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=14607"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=14607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}