{"id":1774,"date":"2023-11-05T17:50:26","date_gmt":"2023-11-05T17:50:26","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/aramav-2\/"},"modified":"2023-12-10T06:02:03","modified_gmt":"2023-12-10T06:02:03","slug":"aramav-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/aramav-2\/","title":{"rendered":"Excel&#39;de power query&#39;de d\u00fc\u015feyara nas\u0131l yap\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-83330499\"><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 class=\"has-text-align-left\">D\u00dc\u015eEYARA, <a href=\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\">Excel&#8217;deki en pop\u00fcler i\u015flevlerden<\/a> biridir ve bu konuda hi\u00e7 \u015f\u00fcphe yoktur. Bunu Excel yolculu\u011funuzun ba\u015flang\u0131c\u0131ndan beri biliyorsunuz. Ama bug\u00fcn senin i\u00e7in yeni bir \u015feyim var ve bunu hemen \u00f6\u011frenmelisin.<\/p><p> <strong>\u0130\u015fte anla\u015fma:<\/strong><\/p><p> \u0130ki s\u00fctunu e\u015fle\u015ftirip de\u011ferleri almak i\u00e7in POWER QUERY&#8217;yi kullanabilirsiniz (birle\u015ftirme se\u00e7ene\u011fini kullanarak). Evet do\u011fru duydunuz, Power Query&#8217;de D\u00dc\u015eEYARA yapabilirsiniz.<\/p><p> Bildi\u011finiz gibi: \u201cD\u00dc\u015eEYARA bir s\u00fctunun de\u011ferlerini e\u015fle\u015ftirir, ard\u0131ndan farkl\u0131 s\u00fctunun ayn\u0131 sat\u0131r\u0131n\u0131n veya ayn\u0131 s\u00fctunun de\u011ferlerini d\u00f6nd\u00fcr\u00fcr. \u00bb<\/p><h2 class=\"wp-block-heading\"> Verilerle ba\u015flayal\u0131m<\/h2><p> A\u015fa\u011f\u0131daki verilere bakt\u0131\u011f\u0131n\u0131zda ( <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/requete-de-puissance-vlookup-2.xlsx\" rel=\"nofollow\"><strong>\u0130ND\u0130RMEK \u0130\u00c7\u0130N TIKLAYINIZ<\/strong><\/a> ) \u00fcr\u00fcn\u00fcn fiyat ve kategorisinin yer ald\u0131\u011f\u0131 iki farkl\u0131 tablomuz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-power-query-vlookup-1.png\" sizes=\"\" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusu g\u00f6r\u00fcn\u00fcm \u00f6zelli\u011fini kullanmak i\u00e7in veri tablosu\"><\/figure><\/div><p> Bu iki tabloda ortak olan tek \u015fey \u00fcr\u00fcn kimlikleridir. Ve burada miktar tablosunda kategorilerin olmas\u0131n\u0131 istiyorum.<\/p><h2 class=\"wp-block-heading\"> Neden D\u00dc\u015eEYARA yerine Power Query?<\/h2><p> G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi her iki tabloda da ortak olarak \u00fcr\u00fcn kimliklerimiz var.<\/p><p> gol&#8230; gol&#8230; gol&#8230;<\/p><p> D\u00dc\u015eEYARA&#8217;y\u0131 kullanmak istiyorsan\u0131z, \u00dcr\u00fcn Kimli\u011fi s\u00fctununu TABLO 2&#8217;deki Kategori s\u00fctununun \u00f6n\u00fcne ta\u015f\u0131man\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/La-colonne-power-query-vlookup-doit-etre-decalee-1.png\" sizes=\"\" srcset=\"\" alt=\"G\u00fc\u00e7 sorgusu g\u00f6r\u00fcn\u00fcm s\u00fctunu kayd\u0131r\u0131lmal\u0131d\u0131r\"><\/figure><\/div><p> Aksi takdirde <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/\">INDEX MATCH&#8217;i<\/a> kullanabilirsiniz. Ancak burada bunu Power Query ile yapaca\u011f\u0131z.<\/p><h2 class=\"wp-block-heading\"> Power Query ile D\u00dc\u015eEYARA ger\u00e7ekle\u015ftirme ad\u0131mlar\u0131<\/h2><p> D\u00dc\u015eEYARA&#8217;y\u0131 de\u011fi\u015ftirmek i\u00e7in Power Query&#8217;yi kullanmak yaln\u0131zca kolay de\u011fil ayn\u0131 zamanda h\u0131zl\u0131d\u0131r ve en iyi yan\u0131, kurulumun tek seferlik olmas\u0131d\u0131r.<\/p><p> Daha \u00e7ok \u015f\u00f6yle oluyor:<\/p><ol><li> Her iki tablo i\u00e7in de sorgular (ba\u011flant\u0131lar) olu\u015fturun.<\/li><li> Her iki tablo i\u00e7in ortak olan s\u00fctunu se\u00e7in.<\/li><li> Bunlar\u0131 birle\u015ftirin ve istedi\u011finiz s\u00fctunu al\u0131n.<\/li><\/ol><p> Ancak ad\u0131m ad\u0131m ilerleyelim ve takip etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/requete-de-puissance-vlookup-2.xlsx\" rel=\"nofollow\">bu \u00f6rnek dosyay\u0131 buradan indirdi\u011finizden<\/a> emin olun.<\/p><ul><li> \u00d6ncelikle iki tabloyu (TABLO 1 ve TABLO 2) Control + T veya Insert \u279c Tablolar \u279c Tablo tu\u015flar\u0131n\u0131 kullanarak Excel tablolar\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcn. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/appliquer-la-table-aux-donnees-pour-utiliser-power-query-vlookup-1.png\" sizes=\"\" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusu g\u00f6r\u00fcn\u00fcm \u00f6zelli\u011fini kullanmak i\u00e7in tabloyu verilere uygulay\u0131n\"><\/figure><\/div><ul><li> Daha sonra, Power Query D\u00fczenleyicisi&#8217;ne veri y\u00fcklemeniz gerekir ve bunun i\u00e7in Veri sekmesi \u279c Veri Al ve D\u00f6n\u00fc\u015ft\u00fcr \u279c 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\/power-query-vlookup-obtenir-les-donnees-de-la-table-1.png\" sizes=\"\" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusu vlookup tablodan veri al\"><\/figure><\/div><ul><li> Bundan sonra sorguyu Ana Sayfa sekmesinden kapat\u0131n \u279c Kapat\u0131n ve y\u00fckleyin \u279c Yaln\u0131zca oturum a\u00e7\u0131n. (\u0130kinci tablo i\u00e7in 2. ve 3. ad\u0131mlar\u0131 tekrarlay\u0131n). <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/power-query-vlookup-cliquez-et-chargez-la-table-1.png\" sizes=\"\" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusu vlookup t\u0131klama ve y\u00fckleme tablosu\"><\/figure><\/div><ul><li> \u015eimdi buradan sorguya sa\u011f t\u0131klay\u0131n ve &#8220;Birle\u015ftir&#8221;e t\u0131klay\u0131n ya da benim gibi Office 365 kullan\u0131yorsan\u0131z Veri sekmesinde \u279c Veri Al \u279c Sorgular\u0131 Birle\u015ftir \u279c Birle\u015ftir&#8217;de var. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/power-query-vlookup-option-de-fusion-du-clic-droit-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> \u201cBirle\u015ftir\u201de t\u0131klad\u0131\u011f\u0131n\u0131zda size birle\u015ftirme penceresini g\u00f6sterir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/fenetre-doption-de-fusion-power-query-vlookup-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Bu pencereden \u00fcst k\u0131s\u0131mda \u201cMiktar Tablosu\u201dnu, alt k\u0131s\u0131mda ise \u201cKategori Tablosu\u201dnu se\u00e7iniz.<\/li><li> Bundan sonra, her iki tablo i\u00e7in de ortak olan s\u00fctunu se\u00e7in (burada \u00dcr\u00fcn Kimli\u011fi ortakt\u0131r). <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-vlookup-selectionner-la-fenetre-de-fusion-de-colonnes-de-tables-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Bu noktada Geli\u015fmi\u015f Sorgu D\u00fczenleyicisinde yeni bir tablonuz var.<\/li><li> Buradan, tablonun son s\u00fctunundaki filtre d\u00fc\u011fmesine t\u0131klay\u0131n ve yaln\u0131zca kategoriyi se\u00e7in (\u00fcr\u00fcn kimli\u011finin se\u00e7imini kald\u0131r\u0131n) ve Tamam&#8217;a 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\/power-query-vlookup-selectionnez-la-categorie-de-produit-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Burada kategori s\u00fctunu olan yeni bir tablonuz var. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/power-query-vlookup-nouvelle-colonne-de-categorie-de-table-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Sonunda tabloyu e-tabloya y\u00fcklemek i\u00e7in &#8220;Kapat ve Y\u00fckle&#8221;ye 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\/cliquez-sur-fermer-et-chargez-obtenir-la-feuille-de-calcul-de-la-table-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> <strong>BOOM<\/strong> ! art\u0131k kategori s\u00fctunu olan yeni bir tablonuz var.<\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Geli\u015fmi\u015f bir sorguda yapman\u0131z gereken tek \u015fey tablolar i\u00e7in ba\u011flant\u0131 olu\u015fturmak ve sorgular\u0131 birle\u015ftirmektir.<\/p><p> Ve en iyi yan\u0131, miktar listesine yeni veriler ekledi\u011finizde yeni tablonun an\u0131nda g\u00fcncellenmesidir. Umar\u0131m bu g\u00fc\u00e7 sorgusu ipucunu faydal\u0131 bulmu\u015fsunuzdur, ama \u015fimdi bana bir \u015fey s\u00f6yleyin.<\/p><p> Sana en iyi g\u00f6r\u00fcnen \u015fey ne? PowerQuery mi yoksa D\u00dc\u015eEYARA m\u0131?<\/p><p> L\u00fctfen g\u00f6r\u00fc\u015flerinizi yorum k\u0131sm\u0131nda benimle payla\u015f\u0131n.<\/p><p> Sizden haber almay\u0131 \u00e7ok isterim ve l\u00fctfen bu g\u00f6nderiyi arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim onlar da bunu takdir edecektir ve genel olarak g\u00fc\u00e7 sorgusunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek istiyorsan\u0131z, buna g\u00f6z atmay\u0131 unutmay\u0131n. <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\"><strong>Excel Power Query \u00f6\u011freticisi<\/strong><\/a> .<\/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\/dondurulmemis-veriler\/\">Power Query&#8217;yi kullanarak Excel&#8217;deki veri pivotunu kald\u0131rma<\/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-1774","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>Excel&#039;de Power Query&#039;de D\u00dc\u015eEYARA nas\u0131l ger\u00e7ekle\u015ftirilir<\/title>\n<meta name=\"description\" content=\"D\u00dc\u015eEYARA&#039;y\u0131 de\u011fi\u015ftirmek i\u00e7in Power Query&#039;yi kullanmak yaln\u0131zca basit de\u011fil ayn\u0131 zamanda h\u0131zl\u0131d\u0131r ve tek seferlik bir kurulumdur.\" \/>\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\/aramav-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Power Query&#039;de D\u00dc\u015eEYARA nas\u0131l ger\u00e7ekle\u015ftirilir\" \/>\n<meta property=\"og:description\" content=\"D\u00dc\u015eEYARA&#039;y\u0131 de\u011fi\u015ftirmek i\u00e7in Power Query&#039;yi kullanmak yaln\u0131zca basit de\u011fil ayn\u0131 zamanda h\u0131zl\u0131d\u0131r ve tek seferlik bir kurulumdur.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/aramav-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:02:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-power-query-vlookup-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=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aramav-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/aramav-2\/\",\"name\":\"Excel&#39;de Power Query&#39;de D\u00dc\u015eEYARA nas\u0131l ger\u00e7ekle\u015ftirilir\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aramav-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aramav-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-power-query-vlookup-1.png\",\"datePublished\":\"2023-11-05T17:50:26+00:00\",\"dateModified\":\"2023-12-10T06:02:03+00:00\",\"description\":\"D\u00dc\u015eEYARA&#39;y\u0131 de\u011fi\u015ftirmek i\u00e7in Power Query&#39;yi kullanmak yaln\u0131zca basit de\u011fil ayn\u0131 zamanda h\u0131zl\u0131d\u0131r ve tek seferlik bir kurulumdur.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aramav-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/aramav-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aramav-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-power-query-vlookup-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-power-query-vlookup-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aramav-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de power query&#39;de d\u00fc\u015feyara nas\u0131l yap\u0131l\u0131r?\"}]},{\"@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":"Excel&#39;de Power Query&#39;de D\u00dc\u015eEYARA nas\u0131l ger\u00e7ekle\u015ftirilir","description":"D\u00dc\u015eEYARA&#39;y\u0131 de\u011fi\u015ftirmek i\u00e7in Power Query&#39;yi kullanmak yaln\u0131zca basit de\u011fil ayn\u0131 zamanda h\u0131zl\u0131d\u0131r ve tek seferlik bir kurulumdur.","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\/aramav-2\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Power Query&#39;de D\u00dc\u015eEYARA nas\u0131l ger\u00e7ekle\u015ftirilir","og_description":"D\u00dc\u015eEYARA&#39;y\u0131 de\u011fi\u015ftirmek i\u00e7in Power Query&#39;yi kullanmak yaln\u0131zca basit de\u011fil ayn\u0131 zamanda h\u0131zl\u0131d\u0131r ve tek seferlik bir kurulumdur.","og_url":"https:\/\/exceladvisor.org\/tr\/aramav-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:02:03+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-power-query-vlookup-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/aramav-2\/","url":"https:\/\/exceladvisor.org\/tr\/aramav-2\/","name":"Excel&#39;de Power Query&#39;de D\u00dc\u015eEYARA nas\u0131l ger\u00e7ekle\u015ftirilir","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/aramav-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/aramav-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-power-query-vlookup-1.png","datePublished":"2023-11-05T17:50:26+00:00","dateModified":"2023-12-10T06:02:03+00:00","description":"D\u00dc\u015eEYARA&#39;y\u0131 de\u011fi\u015ftirmek i\u00e7in Power Query&#39;yi kullanmak yaln\u0131zca basit de\u011fil ayn\u0131 zamanda h\u0131zl\u0131d\u0131r ve tek seferlik bir kurulumdur.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/aramav-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/aramav-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/aramav-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-power-query-vlookup-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-power-query-vlookup-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/aramav-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de power query&#39;de d\u00fc\u015feyara nas\u0131l yap\u0131l\u0131r?"}]},{"@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\/1774","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=1774"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1774\/revisions"}],"predecessor-version":[{"id":2574,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1774\/revisions\/2574"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}