{"id":2105,"date":"2023-10-15T17:12:29","date_gmt":"2023-10-15T17:12:29","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/"},"modified":"2023-12-10T06:04:16","modified_gmt":"2023-12-10T06:04:16","slug":"fonksiyon-formulleri","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/","title":{"rendered":"Power query&#39;de i\u015flevler ve form\u00fcller nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1474203530\"><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>Power Query&#8217;de i\u015flevleri ve form\u00fclleri neredeyse bir e-tabloda kulland\u0131\u011f\u0131n\u0131z gibi kullanabilirsiniz. Power Query&#8217;nin uzun bir i\u015flev listesi vard\u0131r ve farkl\u0131 hesaplama i\u015flevlerini veya i\u015fle\u00e7lerini kullanarak form\u00fcller yazabilirsiniz.<\/p><p> Ve bu derste fonksiyonlar\u0131 ve form\u00fclleri ayr\u0131nt\u0131l\u0131 olarak anlayaca\u011f\u0131z.<\/p><h2 class=\"wp-block-heading\"> Power Query&#8217;de ilk form\u00fcl\u00fcn\u00fcz\u00fc yaz\u0131n<\/h2><p> Power Query&#8217;de, Excel&#8217;den farkl\u0131 olarak form\u00fcl girmek i\u00e7in yeni bir s\u00fctun eklemeniz gerekir. Ancak tek h\u00fccreye girebilirsiniz. Bir \u00f6rnekle anlayal\u0131m. A\u015fa\u011f\u0131da A ve B s\u00fctunlar\u0131nda baz\u0131 de\u011ferlerimiz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88811\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-dans-power-query.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusunda form\u00fcl\" width=\"185\" height=\"306\"><\/figure><\/div><p> \u015eimdi her iki s\u00fctunun toplam\u0131n\u0131 i\u00e7eren yeni bir s\u00fctun ekleyin. Bunu elde etmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/p><ol><li> \u00d6ncelikle verileri g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyicisine y\u00fckleyin (Veri sekmesi &gt; Di\u011fer kaynaklardan &gt; Aral\u0131ktan\/tablodan). <br><img decoding=\"async\" style=\"height: 442px; width: 509px;\" title=\"2-g\u00fc\u00e7 sorgusunda veri y\u00fckleme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-charger-les-donnees-dans-la-requete-de-puissance.png\" sizes=\"\" srcset=\"\" alt=\"load-data-into-power-query\"><\/li><li> Edit\u00f6rde, S\u00fctun Ekle sekmesine gitmeniz ve ileti\u015fim kutusunu a\u00e7mak i\u00e7in \u00d6zel S\u00fctun d\u00fc\u011fmesini t\u0131klaman\u0131z gerekir. <br><img decoding=\"async\" style=\"height: 429px; width: 540px;\" title=\"3 d\u00fc\u011fmeli s\u00fctunlu \u00f6zel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-bouton-de-colonne-personnalise.png\" sizes=\"\" srcset=\"\" alt=\"custom-column-button\"><\/li><li> Oradan ileti\u015fim kutusuna kullanmak istedi\u011finiz form\u00fcl\u00fc girmelisiniz. E\u015fittir i\u015fareti zaten orada oldu\u011fundan yazman\u0131za gerek yoktur. <br><img decoding=\"async\" style=\"height: 304px; width: 797px;\" title=\"4-ileti\u015fim kutusundaki-form\u00fcl\u00fc-girin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-la-formule-dans-la-boite-de-dialogue.png\" sizes=\"\" srcset=\"\" alt=\"enter-the-formula-in-dialog-box\"><\/li><li> Daha sonra form\u00fcl\u00fc yazman\u0131z gerekir:<ul><li> Form\u00fcle girmek i\u00e7in mevcut s\u00fctunlardaki Ocak&#8217;a t\u0131klay\u0131n.<\/li><\/ul><ul><li> Art\u0131 i\u015faretini (+) girin.<\/li><\/ul><ul><li> Form\u00fcle girmek i\u00e7in mevcut s\u00fctunlardaki \u015eubat&#8217;a t\u0131klay\u0131n.<\/li><\/ul><ul><li> Ayr\u0131ca s\u00fctun i\u00e7in bir ad girin. <\/li><\/ul><p><img decoding=\"async\" style=\"height: 404px; width: 665px;\" title=\"5-yeni-\u00f6zel-s\u00fctunla-girilecek-form\u00fcl\u00fc-yaz\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-ecrire-une-formule-a-saisir-avec-une-nouvelle-colonne-personnalisee.png\" sizes=\"\" srcset=\"\" alt=\"write-formula-to-enter-with-new-custom-column\"><\/p><\/li><li> Sonunda, form\u00fcl\u00fc yeni bir \u00f6zel s\u00fctunla girmek i\u00e7in Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Enter tu\u015funa bast\u0131\u011f\u0131n\u0131z anda, A ve B s\u00fctunlar\u0131n\u0131n (Ocak ve \u015eubat) toplam\u0131n\u0131n bulundu\u011fu yeni bir s\u00fctuna girer. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88816\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-nouvelle-colonne-avec-les-resultats-de-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"form\u00fcl-sonu\u00e7lar\u0131yla-yeni-s\u00fctun\" width=\"552\" height=\"306\"><\/figure><\/div><p> Sonunda, verileri Excel&#8217;deki yeni bir \u00e7al\u0131\u015fma sayfas\u0131na y\u00fcklemek i\u00e7in Giri\u015f sekmesindeki Kapat ve Y\u00fckle d\u00fc\u011fmesini t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88817\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-cliquez-sur-fermer-et-charger.png\" sizes=\"auto, \" srcset=\"\" alt=\"t\u0131kla-kapat ve y\u00fckle\" width=\"494\" height=\"156\"><\/figure><\/div><p> Ve \u00fczerine t\u0131klad\u0131\u011f\u0131n\u0131zda, g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyiciyi kapatacak ve yeni bir \u00e7al\u0131\u015fma sayfas\u0131 ekleyerek verileri y\u00fckleyecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88818\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-charge-les-donnees-en-inserant-une-nouvelle-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"yeni-\u00e7al\u0131\u015fma sayfas\u0131n\u0131-ekleyerek-verileri-y\u00fckle\" width=\"435\" height=\"401\"><\/figure><\/div><p> Ger\u00e7ek zamanl\u0131 geli\u015fmi\u015f sorgu olarak, kaynak verilere yeni de\u011ferler girdi\u011finizde ve geli\u015fmi\u015f sorgu d\u00fczenleyicisinden yeniden y\u00fckledi\u011finiz yeni tabloyu yeniledi\u011finizde bu tablodaki t\u00fcm yeni de\u011ferleri al\u0131rs\u0131n\u0131z. Yani yenileme s\u0131ras\u0131nda yeni de\u011ferlerin hesaplanmas\u0131 da yap\u0131lacakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> Form\u00fcl d\u00fczenleme<\/h2><p> Power Query&#8217;de bir form\u00fcl yazd\u0131ktan sonra onu d\u00fczenleyebilirsiniz.<\/p><ul><li> \u00d6ncelikle yeni tablodaki h\u00fccrelerden birini se\u00e7in ve \u015feritteki \u201cSorgu\u201d sekmesine gidin.<\/li><li> Daha sonra d\u00fczenle butonuna t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88819\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-modifier-une-formule-dans-power-query.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusunda-bir-form\u00fcl\u00fc de\u011fi\u015ftir\" width=\"473\" height=\"379\"><\/figure><\/div><p> D\u00fczenle d\u00fc\u011fmesine t\u0131klad\u0131\u011f\u0131n\u0131zda Power Query D\u00fczenleyicisi a\u00e7\u0131l\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88820\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-editeur-de-requete-de-puissance-ouvert.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusu d\u00fczenleyicisi a\u00e7\u0131ld\u0131\" width=\"600\" height=\"377\"><\/figure><\/div><p> Buradan pencerenin sa\u011f taraf\u0131nda \u201cUygulanan Ad\u0131mlar\u201d\u0131n bulundu\u011fu yere gitmeniz gerekiyor.<\/p><p> Daha sonra, ba\u015flang\u0131\u00e7ta form\u00fcl\u00fc girdi\u011finiz \u00f6zel s\u00fctunun ileti\u015fim kutusunu a\u00e7mak i\u00e7in &#8220;\u00d6zel Ekle&#8221;yi t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88821\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-cliquez-sur-la-coutume-ajoutee.png\" sizes=\"auto, \" srcset=\"\" alt=\"eklenen \u00f6zele t\u0131klay\u0131n\" width=\"242\" height=\"274\"><\/figure><\/div><p> Ve diyalog kutusundan yazd\u0131\u011f\u0131n\u0131z form\u00fcl\u00fc d\u00fczenleyebilir ve de\u011fi\u015ftirebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88822\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-modifier-ou-modifier-la-formule-existante.png\" sizes=\"auto, \" srcset=\"\" alt=\"mevcut form\u00fcl\u00fc de\u011fi\u015ftirin veya de\u011fi\u015ftirin\" width=\"626\" height=\"238\"><\/figure><\/div><p> Power Query&#8217;de form\u00fcllerin kullan\u0131lmas\u0131 <a href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel&#8217;deki form\u00fcllere<\/a> benzer; yaln\u0131zca kullanaca\u011f\u0131n\u0131z do\u011fru i\u015flevi veya operat\u00f6r\u00fc bilmeniz yeterlidir.<\/p><p> Bu e\u011fitimin bir sonraki b\u00f6l\u00fcm\u00fcnde, istenen sonucu elde etmek veya g\u00fc\u00e7 sorgusu ile belirli bir sonu\u00e7 elde etmek i\u00e7in bir fonksiyonun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Power Query&#8217;de i\u015flevleri kullanma<\/h2><p> Excel&#8217;de oldu\u011fu gibi Power Query&#8217;de de belirli hesaplamalar i\u00e7in kullanabilece\u011finiz uzun bir i\u015flevler listesi bulunur.<\/p><p> Bu e\u011fitimin ilerleyen k\u0131s\u0131mlar\u0131nda, bir i\u015flevin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenerek onu yeni bir \u00f6zel s\u00fctun kullanarak nas\u0131l ekleyece\u011fimizi \u00f6\u011frenece\u011fiz ve ihtiyac\u0131n\u0131z olan i\u015flevi bulmak i\u00e7in ba\u015fvurabilece\u011finiz Microsoft i\u015flevlerinin <a href=\"https:\/\/learn.microsoft.com\/en-us\/powerquery-m\/power-query-m-function-reference\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">listesini burada bulabilirsiniz<\/a> .<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte elimizde bir tarih listesi var ve \u015fimdi bu g\u00fcnlerin ait oldu\u011fu ay\u0131n son tarihini almam\u0131z gerekiyor. \u00d6rne\u011fin, bir tarih ay\u0131n (May\u0131s) ise, May\u0131s ay\u0131n\u0131n son tarihini almam\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88823\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-fonctions-dutilisation-dans-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusunda-i\u015flevleri kullan\u0131n\" width=\"152\" height=\"311\"><\/figure><\/div><p> Bunun i\u00e7in Date.EndOfMonth fonksiyonunu kullanabiliriz. Bu fonksiyonda tan\u0131mlayacak tek bir arg\u00fcman\u0131m\u0131z var: <strong>dateTime<\/strong> .<\/p><p> Verilerinizi Geli\u015fmi\u015f Sorgu D\u00fczenleyicisine y\u00fckledikten sonra, \u00f6zel s\u00fctun ileti\u015fim kutusunu a\u00e7mak i\u00e7in S\u00fctun Ekle sekmesine gitmeniz ve \u00d6zel S\u00fctun d\u00fc\u011fmesini t\u0131klaman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88824\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-ouvrir-une-boite-de-dialogue-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zel ileti\u015fim kutusunu a\u00e7\" width=\"406\" height=\"150\"><\/figure><\/div><p> \u0130leti\u015fim kutusunda Date.EndOfMonth i\u015flev ad\u0131n\u0131 girin. \u0130\u015flev ad\u0131n\u0131 yazmaya ba\u015flad\u0131\u011f\u0131n\u0131zda Intellisense an\u0131nda ilgili i\u015flevlerin bir listesini g\u00f6r\u00fcnt\u00fcleyecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88825\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-dans-la-boite-de-dialogue-entrez-le-nom-de-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"ileti\u015fim kutusunda-fonksiyonun-ad\u0131n\u0131-girin\" width=\"566\" height=\"311\"><\/figure><\/div><p> Fonksiyonun tam ad\u0131n\u0131 girebilir veya listede bulunan ismin \u00fczerine t\u0131klayabilirsiniz. Fonksiyon ismini girdikten sonra bir ba\u015flang\u0131\u00e7 parantezi girmeniz gerekiyor, bu size belirtmeniz gereken arg\u00fcmanlar\u0131n detaylar\u0131n\u0131 g\u00f6sterecek. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88826\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-entrez-une-parenthese-ouvrante-apres-le-nom-de-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"form\u00fcl ad\u0131ndan sonra ba\u015flayan parantezleri girin\" width=\"591\" height=\"233\"><\/figure><\/div><p> Daha \u00f6nce de belirtti\u011fim gibi date veya datetime de\u011feri olabilen dateTime arg\u00fcman\u0131n\u0131 belirtmemiz gerekiyor. Ve g\u00fc\u00e7 sorgusuna y\u00fcklenen verilerde bir tarih listemiz var.<\/p><p> Bu nedenle, i\u015flev arg\u00fcman\u0131na s\u00fctun ad\u0131n\u0131 girmeniz gerekir. Daha sonra i\u015flevi kapan\u0131\u015f parantezleriyle kapat\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88827\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-nom-de-colonne-dans-largument-de-la-fonction.png\" sizes=\"auto, \" srcset=\"\" alt=\"i\u015flev ba\u011f\u0131ms\u0131z de\u011fi\u015fkenindeki s\u00fctun ad\u0131\" width=\"712\" height=\"257\"><\/figure><\/div><p> Tamam&#8217;\u0131 t\u0131klatmadan \u00f6nce yeni s\u00fctun i\u00e7in bir ad ekleyin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88829\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-ajouter-le-nom-de-la-nouvelle-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"yeni-s\u00fctun-ad\u0131 ekle\" width=\"696\" height=\"219\"><\/figure><\/div><p> Sonunda s\u00fctunu eklemek i\u00e7in Tamam&#8217;\u0131 t\u0131klay\u0131n. Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131zda, ilgili s\u00fctunda bulunan tarihe g\u00f6re Ay\u0131n Son Tarihini i\u00e7eren yeni bir s\u00fctun eklenecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88830\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-nouvelles-colonnes-avec-la-derniere-date-du-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"ay\u0131n-son-tarihi ile yeni-s\u00fctun\" width=\"431\" height=\"316\"><\/figure><\/div><p> Bu s\u00fctunda ayr\u0131ca tarihle birlikte bir saat de vard\u0131r, dolay\u0131s\u0131yla yaln\u0131zca tarih i\u00e7in s\u00fctun bi\u00e7imini de\u011fi\u015ftirmeniz gerekir. \u201cVeri T\u00fcr\u00fc\u201d a\u00e7\u0131l\u0131r men\u00fcs\u00fcne t\u0131klay\u0131n ve bunun i\u00e7in \u201cTarih\u201di se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88831\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-a-partir-du-type-de-donnees-selectionner-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"kaynak-veri t\u00fcr\u00fc-se\u00e7me tarihi\" width=\"626\" height=\"364\"><\/figure><\/div><p> Bu, s\u00fctunun bi\u00e7imini Tarih olarak de\u011fi\u015ftirecektir. Ve ilk s\u00fctunda sahip oldu\u011funuz aya g\u00f6re ay\u0131n son tarihine sahip oldu\u011fumuzu g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-88832\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Format-21-colonnes-change-en-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctun-bi\u00e7imi-tarihte-de\u011fi\u015ftirildi\" width=\"390\" height=\"286\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Hesaplamalar i\u00e7in i\u015flevleri kullanma<\/h2><p> Yukar\u0131daki \u00f6rnekte, g\u00fc\u00e7 sorgusunda herhangi bir i\u015flevi kullanma ad\u0131mlar\u0131n\u0131 anlaman\u0131z\u0131 sa\u011flamak i\u00e7in basit bir i\u015flev kulland\u0131k.<\/p><p> \u0130htiyac\u0131n\u0131z olan hesaplama i\u00e7in hangi fonksiyonu kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frendikten sonra \u00f6zel bir s\u00fctun ekleyebilir, fonksiyonu ekleyebilir ve ard\u0131ndan gerekli arg\u00fcmanlar\u0131 belirtebilirsiniz.<\/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\/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 class=\"gb-grid-column gb-grid-column-4eaecde3\"><div class=\"gb-container gb-container-4eaecde3\"><\/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-2105","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&#039;de i\u015flevler ve form\u00fcller nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Power Query&#039;de i\u015flevleri ve form\u00fclleri neredeyse bir e-tabloda kulland\u0131\u011f\u0131n\u0131z gibi kullanabilirsiniz.\" \/>\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\/fonksiyon-formulleri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query&#039;de i\u015flevler ve form\u00fcller nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Power Query&#039;de i\u015flevleri ve form\u00fclleri neredeyse bir e-tabloda kulland\u0131\u011f\u0131n\u0131z gibi kullanabilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-dans-power-query.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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/\",\"name\":\"Power Query&#39;de i\u015flevler ve form\u00fcller nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-dans-power-query.png\",\"datePublished\":\"2023-10-15T17:12:29+00:00\",\"dateModified\":\"2023-12-10T06:04:16+00:00\",\"description\":\"Power Query&#39;de i\u015flevleri ve form\u00fclleri neredeyse bir e-tabloda kulland\u0131\u011f\u0131n\u0131z gibi kullanabilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-dans-power-query.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-dans-power-query.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power query&#39;de i\u015flevler ve form\u00fcller nas\u0131l kullan\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":"Power Query&#39;de i\u015flevler ve form\u00fcller nas\u0131l kullan\u0131l\u0131r?","description":"Power Query&#39;de i\u015flevleri ve form\u00fclleri neredeyse bir e-tabloda kulland\u0131\u011f\u0131n\u0131z gibi kullanabilirsiniz.","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\/fonksiyon-formulleri\/","og_locale":"tr_TR","og_type":"article","og_title":"Power Query&#39;de i\u015flevler ve form\u00fcller nas\u0131l kullan\u0131l\u0131r?","og_description":"Power Query&#39;de i\u015flevleri ve form\u00fclleri neredeyse bir e-tabloda kulland\u0131\u011f\u0131n\u0131z gibi kullanabilirsiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-dans-power-query.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/","url":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/","name":"Power Query&#39;de i\u015flevler ve form\u00fcller nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-dans-power-query.png","datePublished":"2023-10-15T17:12:29+00:00","dateModified":"2023-12-10T06:04:16+00:00","description":"Power Query&#39;de i\u015flevleri ve form\u00fclleri neredeyse bir e-tabloda kulland\u0131\u011f\u0131n\u0131z gibi kullanabilirsiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-dans-power-query.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-dans-power-query.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Power query&#39;de i\u015flevler ve form\u00fcller nas\u0131l kullan\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\/2105","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=2105"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2105\/revisions"}],"predecessor-version":[{"id":2707,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2105\/revisions\/2707"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}