{"id":5761,"date":"2023-08-17T06:02:00","date_gmt":"2023-08-17T04:02:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=5761"},"modified":"2023-10-30T14:18:55","modified_gmt":"2023-10-30T13:18:55","slug":"create-excel-table","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/","title":{"rendered":"How to create an Excel table?"},"content":{"rendered":"\n<p class=\"has-text-align-center\"><strong><em>Create an Excel table from a data area.<\/em><\/strong><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-text-align-left\" id=\"h-step-by-step-guide-to-create-an-excel-table-to-manage-data-and-sort-format-and-filter-its-columns\"><em>Step by step guide to create an Excel table to manage data and sort, format and filter its columns.<\/em><\/h4>\n\n\n\n<p>In today&#8217;s data-driven world, organizing and presenting information effectively by learning how to create an Excel table is essential. Microsoft Excel, a powerful tool in the world of data analytics, offers the feature of Tables to make data presentation and manipulation much more intuitive. Creating an Excel table is not only about giving your data a neat appearance; it also provides dynamic ranges, easy filtering, and sorting.<\/p>\n\n\n\n<p>Ready to transform your plain data into a structured Excel table? Then easily filter it? First create the required rows and columns. Fill the table with data and turn it into a table with headers. In the form of a table, it is possible to sort and filter the data easily. An Excel table is very similar to a <a href=\"https:\/\/www.definitions.net\/definition\/data+table\" target=\"_blank\" rel=\"noreferrer noopener\">data table<\/a>, the type of object most commonly used by database professionals.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-create-a-new-excel-file\">1. Create a new Excel file<\/h2>\n\n\n\n<p>The first step of course if to cerate a new XLSX file. Then add the columns. In this example, it is monthly financial data. It could be actuals till the current date (March 2022) mixed with the budget forecasting for the next months.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-generate-the-list-of-months-and-years\">2. Generate the list of months and years<\/h2>\n\n\n\n<p>To generate the rest of the list of months in words, select the two cells January and February. Click on the small cross and hold then drag the mouse to December. The result is one year column and twelve month columns.<\/p>\n\n\n\n<p>Then add the years from 2014 to 2022 in the Year column.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"937\" height=\"345\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_table_raw_data.png\" alt=\"Prepare data to organize in the table with years and months columns\" class=\"wp-image-5762\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_table_raw_data.png 937w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_table_raw_data-300x110.png 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_table_raw_data-768x283.png 768w\" sizes=\"auto, (max-width: 937px) 100vw, 937px\" \/><figcaption class=\"wp-element-caption\">Prepare raw data using inputs and slide Excel option<\/figcaption><\/figure><\/div>\n\n\n<p><strong>This short tutorial is available in a four minutes video format here:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-embed-handler wp-block-embed-embed-handler wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to create an Excel table and sort its columns ?\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/DlQE4pYmE04?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-duplicate-the-excel-data-rows-to-fill-the-table\">3. Duplicate the excel data rows to fill the table<\/h2>\n\n\n\n<p>3 &#8211; To duplicate the rows, select the first row from January to the Total column. Then drag down as shown in this screenshot. This area of raw cells, the source of the table, is not filtered or formatted.<\/p>\n\n\n\n<p>The following steps shows how to format the Excel table to sort the data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-select-the-data-area-to-transform-to-an-excel-table\">4. Select the data area to transform to an Excel Table <\/h2>\n\n\n\n<p>To technically create the table follow this steps: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Select all contiguous cells by clicking on the top left cell<\/strong> and use the shortcut <strong>CTRL + A to select all the data<\/strong>. This Excel table or area is the table, without formatting.<\/li>\n\n\n\n<li>Under <strong>Home<\/strong>, choose the option <strong>Format as a table<\/strong>. Choose the colour and style of the table, here it is a Blue table.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"822\" height=\"458\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_table_format_table_data_no_filigran.png\" alt=\"Select a format to apply to the zone to create the Excel table\" class=\"wp-image-5768\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_table_format_table_data_no_filigran.png 822w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_table_format_table_data_no_filigran-300x167.png 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/excel_table_format_table_data_no_filigran-768x428.png 768w\" sizes=\"auto, (max-width: 822px) 100vw, 822px\" \/><figcaption class=\"wp-element-caption\"><strong>Select a format to apply to the Excel table zone selected<\/strong><\/figcaption><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Then, check the option <strong>My table has headers<\/strong>, to indicate to take into account the pre-existing headers. This action will not add any row to the table.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-add-the-totals-row\">5. Add the totals row<\/h2>\n\n\n\n<p>Now add the totals row to obtain the grand total with all the years:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Right-click on the Excel table<\/strong><\/li>\n\n\n\n<li>Then choose <strong>Table<\/strong><\/li>\n\n\n\n<li>And finally select <strong>Totals line<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p>The result is a formatted Excel table. It is possible to sort the cells, for example by year or to select only the year 2021 for example.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">6. Use an Excel formula to calculate the sums<\/h2>\n\n\n\n<p>8 &#8211; Adding the annual total with a formula. To have the Yearly line Total column on the right, use a simple Excel formula. The Excel formula in the cell uses the SUM function:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=SUM(Table1[@[January]:[December]])<\/pre>\n\n\n\n<p>To facilitate the creation of the formula, write the SUM function in one line and then select the first row of amounts from January to December. Then make the selection slide to the last line of the data. Note: for a more sober display, deactivate the grid on the Excel tab. To do this, in the top menu of Excel, under View, uncheck the Grid option. <\/p>\n\n\n\n<p>Finally, this short article explains how to create an Excel table to sort and filter data. To go further , here is <strong><a href=\"https:\/\/expert-only.com\/en\/excel\/how-to-remove-value-na-div0-excel-errors\/\">how to manage common errors from Excel formulas like VALUE, NA or DIV0<\/a><\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"RRNE2lsF7O\"><a href=\"https:\/\/expert-only.com\/en\/excel\/how-to-remove-value-na-div0-excel-errors\/\">How to remove #VALUE! #NA! #DIV0 Excel errors?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How to remove #VALUE! #NA! #DIV0 Excel errors?&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/excel\/how-to-remove-value-na-div0-excel-errors\/embed\/#?secret=mK5Snn8Tpp#?secret=RRNE2lsF7O\" data-secret=\"RRNE2lsF7O\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Create an Excel table from a data area. Step by step guide to create an Excel table to manage data and sort, format and filter its columns. In today&#8217;s data-driven world, organizing and presenting information effectively by learning how <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/\" title=\"How to create an Excel table?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5548,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[457],"tags":[417],"class_list":{"0":"post-5761","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-file"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to create an Excel table? Office Excel Tips<\/title>\n<meta name=\"description\" content=\"To create an Excel table and sort its columns, prepare the raw data, then format the area and its headers as a table and add the totals line.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to create an Excel table?\" \/>\n<meta property=\"og:description\" content=\"To create an Excel table and sort its columns, prepare the raw data, then format the area and its headers as a table and add the totals line.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-17T04:02:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T13:18:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How to create an Excel table?\",\"datePublished\":\"2023-08-17T04:02:00+00:00\",\"dateModified\":\"2023-10-30T13:18:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/\"},\"wordCount\":682,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg\",\"keywords\":[\"File\"],\"articleSection\":[\"Excel Tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/\",\"url\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/\",\"name\":\"How to create an Excel table? Office Excel Tips\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg\",\"datePublished\":\"2023-08-17T04:02:00+00:00\",\"dateModified\":\"2023-10-30T13:18:55+00:00\",\"description\":\"To create an Excel table and sort its columns, prepare the raw data, then format the area and its headers as a table and add the totals line.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create an Excel table?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to create an Excel table? Office Excel Tips","description":"To create an Excel table and sort its columns, prepare the raw data, then format the area and its headers as a table and add the totals line.","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:\/\/expert-only.com\/en\/excel\/create-excel-table\/","og_locale":"en_US","og_type":"article","og_title":"How to create an Excel table?","og_description":"To create an Excel table and sort its columns, prepare the raw data, then format the area and its headers as a table and add the totals line.","og_url":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-17T04:02:00+00:00","article_modified_time":"2023-10-30T13:18:55+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How to create an Excel table?","datePublished":"2023-08-17T04:02:00+00:00","dateModified":"2023-10-30T13:18:55+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/"},"wordCount":682,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg","keywords":["File"],"articleSection":["Excel Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/","url":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/","name":"How to create an Excel table? Office Excel Tips","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg","datePublished":"2023-08-17T04:02:00+00:00","dateModified":"2023-10-30T13:18:55+00:00","description":"To create an Excel table and sort its columns, prepare the raw data, then format the area and its headers as a table and add the totals line.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/excel\/create-excel-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2021\/01\/coffee-631768_1920.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/excel\/create-excel-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to create an Excel table?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=5761"}],"version-history":[{"count":5,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5761\/revisions"}],"predecessor-version":[{"id":27784,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/5761\/revisions\/27784"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5548"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=5761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=5761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=5761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}