{"id":1789,"date":"2023-11-04T18:36:02","date_gmt":"2023-11-04T18:36:02","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/"},"modified":"2023-12-10T06:04:11","modified_gmt":"2023-12-10T06:04:11","slug":"dondurulmemis-veriler","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/","title":{"rendered":"Power query kullanarak excel&#39;de verilerin \u00f6zetini \u00e7\u0131karma"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2052568728\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>\u00c7apraz tablo format\u0131ndaki veriler, kolay anla\u015f\u0131l\u0131r oldu\u011fundan rapor olarak kullan\u0131labilir. Ancak sorun, onu daha fazla kullanman\u0131z gerekti\u011finde ortaya \u00e7\u0131kar.<\/p><p> Bu durumda onu tekrar kullan\u0131labilir hale getirmek i\u00e7in \u00e7aba harcaman\u0131z ve de\u011ferli zaman\u0131n\u0131z\u0131 harcaman\u0131z gerekir. A\u015fa\u011f\u0131daki \u00f6rnekte \u00e7apraz tablo verilerini g\u00f6rebilirsiniz. Tekrar kullan\u0131labilir hale getirmenin en iyi yolu, evet, t\u0131pk\u0131 bunun gibi, PIN&#8217;ini KALDIRMAKTIR. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Verilerin d\u00f6nd\u00fcr\u00fclmesini \u00f6nlemenin en iyi yolu POWER QUERY&#8217;yi kullanmakt\u0131r. Bu nedenle, bug\u00fcn bu makalede, POWER QUERY&#8217;nin \u00f6zetleme se\u00e7ene\u011fini kullanarak \u00e7apraz tablo verilerini tabloya d\u00f6n\u00fc\u015ft\u00fcrmeye y\u00f6nelik basit ad\u0131mlar\u0131 sizinle payla\u015fmak istiyorum.<\/p><h2 class=\"wp-block-heading\"> Power Query ile Excel&#8217;de Verilerin \u00d6zetini A\u00e7ma Ad\u0131mlar\u0131<\/h2><p> Bir veri tablosunun \u00f6zetini a\u00e7mak i\u00e7in <strong><a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\">Power Query&#8217;yi<\/a><\/strong> kullanmak tamamen keyiftir. Ne kadar kolay oldu\u011funa \u015fa\u015f\u0131racaks\u0131n\u0131z. Ancak Excel 2013 veya 2010 kullan\u0131yorsan\u0131z ve Excel 2016&#8217;da zaten &#8220;Al ve D\u00f6n\u00fc\u015ft\u00fcr&#8221; olarak mevcutsa, kullanmadan \u00f6nce Power Query eklentisini y\u00fcklemeniz gerekir. Devam etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/non-pivoter-les-donnees-brutes.xlsx\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">bu \u00f6rnek dosyay\u0131 indirdi\u011finizden<\/a> emin olun.<\/p><ul><li> \u00d6ncelikle \u00e7apraz tablo verilerinizi se\u00e7in ve &#8220;Veri&#8221; sekmesine gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-donnees-non-pivotees-avec-requete-de-puissance-selectionner-la-table-de-donnees-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Veri sekmesinde Al ve D\u00f6n\u00fc\u015ft\u00fcr \u2192 Tablodan se\u00e7ene\u011fine gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-donnees-non-pivotees-avec-une-requete-de-puissance-cliquez-sur-le-tableau-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> \u00dczerine t\u0131klad\u0131\u011f\u0131n\u0131zda, \u00e7apraz tablo verilerinizi bir Excel tablosuna d\u00f6n\u00fc\u015ft\u00fcr\u00fcr (e\u011fer hen\u00fcz yapmad\u0131ysa).<\/li><li> Ve verileri an\u0131nda g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyicisine y\u00fckleyecektir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-donnees-non-pivotees-avec-des-donnees-de-requete-de-puissance-dans-lediteur-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Buradan \u00f6zetlemek istedi\u011fimiz t\u00fcm s\u00fctunlar\u0131 se\u00e7memiz gerekiyor.<\/li><li> Bunu yapmak i\u00e7in Ocak s\u00fctununu se\u00e7in ve Shift tu\u015funu bas\u0131l\u0131 tutarak Aral\u0131k s\u00fctununu se\u00e7in.<\/li><li> Bundan sonra, \u00fczerine sa\u011f t\u0131klay\u0131n ve \u201cS\u00fctunlar\u0131 \u00d6zetle\u201d se\u00e7ene\u011fini se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-donnees-non-pivotees-avec-power-query-click-colonnes-non-pivotees-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Art\u0131k 12 s\u00fctun iki s\u00fctuna d\u00f6n\u00fc\u015ft\u00fcr\u00fclm\u00fcyor. Biri ayl\u0131k, di\u011feri miktar i\u00e7indir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-donnees-non-pivotees-avec-requete-de-puissance-effectuee-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Yapman\u0131z gereken son \u015fey s\u00fctunlar\u0131 yeniden adland\u0131rmakt\u0131r.<\/li><li> Bunu yapmak i\u00e7in s\u00fctuna sa\u011f t\u0131klay\u0131n ve yeniden adland\u0131r\u0131n (her ikisi i\u00e7in de). <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-donnees-non-pivotees-avec-power-query-renommer-la-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Sonunda <strong>\u201cKapat ve y\u00fckle\u201d ye<\/strong> t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-donnees-non-pivotees-avec-fermeture-de-requete-de-puissance-et-charge-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Art\u0131k \u00e7apraz verileriniz d\u00fcz verilere d\u00f6n\u00fc\u015ft\u00fcr\u00fcld\u00fc ve bunu daha fazla analiz ve sat\u0131\u015f raporlamas\u0131 i\u00e7in pivot tablolar ve di\u011fer her \u015feyi olu\u015fturmak i\u00e7in kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-donnees-non-pivotees-avec-power-query-nouvelles-donnees-dans-la-feuille-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Dedi\u011fim gibi PowerQuery&#8217;yi kullanmak e\u011flencelidir. Bu, pivotsuz \u00e7al\u0131\u015fman\u0131z\u0131 o kadar kolayla\u015ft\u0131r\u0131r ki zaman\u0131n\u0131z\u0131 ve \u00e7aban\u0131z\u0131 bo\u015fa harcaman\u0131za gerek kalmaz.<\/p><p> Aksi takdirde, manuel y\u00f6ntemleri tercih ederseniz, verilerinizi ka\u00e7 kez kesip yap\u0131\u015ft\u0131rman\u0131z gerekti\u011fini bilemezsiniz. VBA kullan\u0131yor olsan\u0131z bile kod yazmak i\u00e7in zamana ihtiyac\u0131n\u0131z vard\u0131r.<\/p><p> Ve PowerQuery, verilerinizin yap\u0131s\u0131n\u0131 anlayacak kadar ak\u0131ll\u0131d\u0131r.<\/p><p> Umar\u0131m bu y\u00f6ntemi faydal\u0131 bulmu\u015fsunuzdur.<\/p><p> <em>\u015eimdi bana bir \u015fey s\u00f6yle. Hi\u00e7 herhangi bir veri t\u00fcr\u00fcn\u00fcn y\u00f6n\u00fcn\u00fc de\u011fi\u015ftirmeyi denediniz mi? Hangi y\u00f6ntemi kulland\u0131n\u0131z? Peki y\u00f6nteminizi g\u00fc\u00e7 sorgusu ile kar\u015f\u0131la\u015ft\u0131r\u0131rken ne d\u00fc\u015f\u00fcn\u00fcyorsunuz? D\u00fc\u015f\u00fcncelerinizi yorum k\u0131sm\u0131nda benimle payla\u015f\u0131n, sizden haber almay\u0131 \u00e7ok isterim.<\/em><\/p><p> Ve bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n.<\/p><div class=\"gb-container gb-container-9e2850fe gb-container-mt\"> <a class=\"gb-button gb-button-71636faa gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\">Excel&#8217;de Power Query (E\u011fitim)<\/a><h2 class=\"gb-headline gb-headline-c566b2ed gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-b15ed1bf gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6e9de105\"><div class=\"gb-container gb-container-6e9de105\"><ul><li> Birden Fazla Excel DOSYASINI TEK B\u0130R DEFTERDE B\u0130RLE\u015eT\u0130R\u0130N<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aramav-2\/\">Excel&#8217;deki Power Query&#8217;de D\u00dc\u015eEYARA ger\u00e7ekle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zincir\/\">Power Query: de\u011ferleri (metin ve say\u0131lar) birle\u015ftirin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-farki\/\">G\u00fc\u00e7 Sorgusu: Tarih fark\u0131<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1789","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power Query kullanarak verilerin \u00f6zetini \u00e7\u0131karma<\/title>\n<meta name=\"description\" content=\"Power Query, Excel&#039;deki verileri \u00f6zetlemenin en iyi yoludur. D\u00f6n\u00fc\u015ft\u00fcrmek yaln\u0131zca birka\u00e7 t\u0131klama al\u0131r...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query kullanarak verilerin \u00f6zetini \u00e7\u0131karma\" \/>\n<meta property=\"og:description\" content=\"Power Query, Excel&#039;deki verileri \u00f6zetlemenin en iyi yoludur. D\u00f6n\u00fc\u015ft\u00fcrmek yaln\u0131zca birka\u00e7 t\u0131klama al\u0131r...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/\",\"name\":\"Power Query kullanarak verilerin \u00f6zetini \u00e7\u0131karma\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\",\"datePublished\":\"2023-11-04T18:36:02+00:00\",\"dateModified\":\"2023-12-10T06:04:11+00:00\",\"description\":\"Power Query, Excel&#39;deki verileri \u00f6zetlemenin en iyi yoludur. D\u00f6n\u00fc\u015ft\u00fcrmek yaln\u0131zca birka\u00e7 t\u0131klama al\u0131r...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power query kullanarak excel&#39;de verilerin \u00f6zetini \u00e7\u0131karma\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power Query kullanarak verilerin \u00f6zetini \u00e7\u0131karma","description":"Power Query, Excel&#39;deki verileri \u00f6zetlemenin en iyi yoludur. D\u00f6n\u00fc\u015ft\u00fcrmek yaln\u0131zca birka\u00e7 t\u0131klama al\u0131r...","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:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/","og_locale":"tr_TR","og_type":"article","og_title":"Power Query kullanarak verilerin \u00f6zetini \u00e7\u0131karma","og_description":"Power Query, Excel&#39;deki verileri \u00f6zetlemenin en iyi yoludur. D\u00f6n\u00fc\u015ft\u00fcrmek yaln\u0131zca birka\u00e7 t\u0131klama al\u0131r...","og_url":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:11+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/","url":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/","name":"Power Query kullanarak verilerin \u00f6zetini \u00e7\u0131karma","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png","datePublished":"2023-11-04T18:36:02+00:00","dateModified":"2023-12-10T06:04:11+00:00","description":"Power Query, Excel&#39;deki verileri \u00f6zetlemenin en iyi yoludur. D\u00f6n\u00fc\u015ft\u00fcrmek yaln\u0131zca birka\u00e7 t\u0131klama al\u0131r...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-non-pivotees-avec-power-query-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Power query kullanarak excel&#39;de verilerin \u00f6zetini \u00e7\u0131karma"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1789"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1789\/revisions"}],"predecessor-version":[{"id":2697,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1789\/revisions\/2697"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}