{"id":1656,"date":"2023-11-13T11:16:22","date_gmt":"2023-11-13T11:16:22","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/"},"modified":"2023-12-10T05:59:58","modified_gmt":"2023-12-10T05:59:58","slug":"guc-talebi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/","title":{"rendered":"Excel Power Query \u00f6\u011freticisi\u200c (al ve d\u00f6n\u00fc\u015ft\u00fcr)"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-244802929\"><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>Verilerle \u00e7ok \u00e7al\u0131\u015fan ki\u015filerden biriyseniz, herhangi biri olabilirsiniz ( <a href=\"https:\/\/exceladvisor.org\/tr\/muhasebeciler-icin-excel\/\">muhasebeci<\/a> , \u0130K, veri analisti vb.), PowerQuery sizin g\u00fc\u00e7l\u00fc arac\u0131n\u0131z olabilir.<\/p><p> Konuyu k\u0131sa keseyim, Power Query, \u00f6\u011frenmeniz gereken <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\">geli\u015fmi\u015f Excel becerilerinden<\/a> biridir ve bu e\u011fitimde PowerQuery&#8217;yi ayr\u0131nt\u0131l\u0131 olarak ke\u015ffedecek ve onunla verileri nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrece\u011finizi \u00f6\u011freneceksiniz.<\/p><p> Ba\u015flayal\u0131m.<\/p><h2 class=\"wp-block-heading\"> Excel G\u00fc\u00e7 Sorgusu Nedir?<\/h2><p> Power Query, ETL i\u00e7in kullanabilece\u011finiz bir Excel eklentisidir. Bu, farkl\u0131 kaynaklardan <strong>veri ay\u0131klayabilece\u011finiz<\/strong> , <strong>d\u00f6n\u00fc\u015ft\u00fcrebilece\u011finiz<\/strong> <strong>ve ard\u0131ndan elektronik tabloya y\u00fckleyebilece\u011finiz<\/strong> anlam\u0131na gelir. POWER QUERY&#8217;nin bir veri temizleme makinesi oldu\u011funu s\u00f6yleyebilirsiniz \u00e7\u00fcnk\u00fc verileri d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in t\u00fcm se\u00e7eneklere sahiptir. Ger\u00e7ek zamanl\u0131d\u0131r ve att\u0131\u011f\u0131n\u0131z her ad\u0131m\u0131 kaydeder.<\/p><h2 class=\"wp-block-heading\"> Power Query&#8217;yi (Avantajlar) neden kullanmal\u0131s\u0131n\u0131z?<\/h2><p> Akl\u0131n\u0131zda bu soru varsa i\u015fte size cevab\u0131m:<\/p><ul><li> <strong>Farkl\u0131 veri kaynaklar\u0131<\/strong> : CSV , TXT, JSON vb. gibi farkl\u0131 veri kaynaklar\u0131ndan verileri g\u00fc\u00e7l\u00fc bir sorgu d\u00fczenleyiciye y\u00fckleyebilirsiniz.<\/li><li> Verileri kolayca d\u00f6n\u00fc\u015ft\u00fcr\u00fcn: Normalde veri d\u00f6n\u00fc\u015ft\u00fcrmeleri i\u00e7in form\u00fcller ve pivot tablolar kullan\u0131rs\u0131n\u0131z ancak POWER QUERY ile yaln\u0131zca birka\u00e7 t\u0131klamayla \u00e7ok \u015fey yapabilirsiniz.<\/li><li> Ger\u00e7ek zamanl\u0131: Bir sorguyu bir kez yazd\u0131\u011f\u0131n\u0131zda, verilerde her de\u011fi\u015fiklik oldu\u011funda onu yenileyebilirsiniz; bu, g\u00fcncelledi\u011finiz yeni verileri d\u00f6n\u00fc\u015ft\u00fcrecektir.<\/li><\/ul><p> Bir \u00f6rnek payla\u015fay\u0131m:<\/p><p> 100 \u015fehrin verilerini i\u00e7eren 100 Excel dosyan\u0131z oldu\u011funu ve \u015fimdi patronunuzun bu 100 dosyadaki t\u00fcm verileri i\u00e7eren bir rapor olu\u015fturman\u0131z\u0131 istedi\u011fini d\u00fc\u015f\u00fcn\u00fcn. Tamam, her dosyay\u0131 manuel olarak a\u00e7maya ve bu dosyalardan verileri kopyalay\u0131p yap\u0131\u015ft\u0131rmaya karar verirseniz ve bunun i\u00e7in en az bir saate ihtiyac\u0131n\u0131z var.<\/p><p> Ancak Power Query ile bunu birka\u00e7 dakika i\u00e7inde yapabilirsiniz. Heyecanl\u0131 m\u0131s\u0131n? \u0130Y\u0130.<\/p><p> Bu e\u011fitimin ilerleyen k\u0131s\u0131mlar\u0131nda Power Query&#8217;nin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 bir\u00e7ok \u00f6rnekle \u00f6\u011freneceksiniz, ancak \u00f6nce konseptini anlaman\u0131z gerekiyor.<\/p><h2 class=\"wp-block-heading\"> G\u00fc\u00e7 talebi kavram\u0131<\/h2><p> G\u00fc\u00e7 sorgusunu \u00f6\u011frenmek i\u00e7in 3 ad\u0131mda \u00e7al\u0131\u015fan konseptini anlaman\u0131z gerekir:<\/p><h3 class=\"wp-block-heading has-text-align-left\"> 1. Verileri al\u0131n<\/h3><p> G\u00fc\u00e7 sorgusu, web, CSV, metin dosyalar\u0131, tek bir klas\u00f6rden birden fazla \u00e7al\u0131\u015fma kitab\u0131 ve veri depolayabilece\u011fimiz di\u011fer bir\u00e7ok kaynak gibi farkl\u0131 kaynaklardan veri alman\u0131z\u0131 sa\u011flar.<\/p><h3 class=\"wp-block-heading\"> 2. Verileri d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/h3><p> G\u00fc\u00e7 sorgusuna veri ald\u0131ktan sonra, onu d\u00f6n\u00fc\u015ft\u00fcrmek ve temizlemek i\u00e7in kullanabilece\u011finiz \u00e7ok say\u0131da se\u00e7ene\u011finiz vard\u0131r. Ger\u00e7ekle\u015ftirdi\u011finiz t\u00fcm ad\u0131mlar i\u00e7in (birbiri ard\u0131na s\u0131rayla) sorgular olu\u015fturur.<\/p><h3 class=\"wp-block-heading\"> 3. Verileri y\u00fckleyin<\/h3><p> Geli\u015fmi\u015f Sorgu D\u00fczenleyicisi&#8217;nden d\u00f6n\u00fc\u015ft\u00fcr\u00fclen verileri \u00e7al\u0131\u015fma sayfas\u0131na y\u00fckleyebilir veya do\u011frudan PivotTable veya PivotChart olu\u015fturabilir veya yaln\u0131zca veri ba\u011flant\u0131s\u0131 olu\u015fturabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Power Query nerede (Nas\u0131l y\u00fcklenir)?<\/h2><p> A\u015fa\u011f\u0131da Microsoft Excel&#8217;in farkl\u0131 s\u00fcr\u00fcmlerine Power Query Access&#8217;in nas\u0131l y\u00fcklenece\u011fini g\u00f6rebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> Excel 2007<\/h3><p> Excel 2007 kullan\u0131yorsan\u0131z, <strong>PQ&#8217;nun bu s\u00fcr\u00fcmde mevcut olmamas\u0131ndan dolay\u0131<\/strong> \u00fczg\u00fcn\u00fcz, bu nedenle Excel&#8217;in <code>latest version<\/code> (Office 365 i\u00e7in Excel, Excel 2019, Excel 2016, Excel 2013, Excel 2010) y\u00fckseltmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47480\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png\" sizes=\"auto, \" srcset=\"\" alt=\"power-query-excel-2007\" width=\"502\" height=\"161\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Excel 2010 ve Excel 2013<\/h3><p> 2010 ve 2013 i\u00e7in <a href=\"https:\/\/www.microsoft.com\/en-in\/download\/details.aspx?id=39379\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" this link  (opens in a new tab)\"><strong>bu ba\u011flant\u0131dan<\/strong><\/a> indirebilece\u011finiz <strong>bir eklentiyi ayr\u0131ca y\u00fcklemeniz gerekir<\/strong> ve y\u00fckledikten sonra Excel \u015feridinde a\u015fa\u011f\u0131daki gibi yeni bir sekme g\u00f6receksiniz: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47487\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2013-2010.png\" sizes=\"auto, \" srcset=\"\" alt=\"power-query-excel-2013-2010\" width=\"594\" height=\"110\"><\/figure><\/div><ul><li> \u00d6ncelikle eklentiyi buradan (Microsoft resmi web sitesi) indirin.<\/li><li> Dosya indirildikten sonra a\u00e7\u0131n ve talimatlar\u0131 izleyin.<\/li><li> Bundan sonra Excel \u015feridinizde otomatik olarak \u201cPower Query\u201d sekmesini g\u00f6receksiniz.<\/li><\/ul><p> E\u011fer bir \u015fekilde bu \u201cG\u00dc\u00c7 SORGULAMA\u201d sekmesi g\u00f6r\u00fcnm\u00fcyorsa endi\u015felenmenize gerek yok. COM Eklentileri se\u00e7ene\u011fini kullanarak ekleyebilirsiniz.<\/p><ul><li> Dosya sekmesi \u279c Se\u00e7enekler \u279c Eklentiler&#8217;e gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47299\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-complements-com-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"tamamlay\u0131c\u0131lar-1\" width=\"277\" height=\"84\"><\/figure><\/div><ul><li> \u201cEklenti\u201d se\u00e7eneklerinde \u201cCOM Eklentileri\u201dni se\u00e7in ve DEVAM&#8217;a t\u0131klay\u0131n.<\/li><li> Bundan sonra \u201cExcel i\u00e7in Microsoft Power Query\u201d kutusunu i\u015faretleyin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47300\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-coche-microsoft-power-query-pour-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-1 i\u00e7in onay i\u015fareti-microsoft-power-query\" width=\"208\" height=\"112\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><h3 class=\"wp-block-heading\"> Excel 2016, 2019, Ofis 365<\/h3><p> Excel 2016, Excel 2019 kullan\u0131yorsan\u0131z veya bir OFFICE 365 aboneli\u011finiz varsa, <strong>bu zaten Veri sekmesinde &#8220;GET &amp; TRANSFORM&#8221; adl\u0131 bir grup olarak mevcuttur<\/strong> (bu ad\u0131 be\u011fendim, ya siz?). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47301\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-obtenir-et-transformer-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"al ve d\u00f6n\u00fc\u015ft\u00fcr-1\" width=\"576\" height=\"183\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Excel Mac&#8217;i<\/h3><p> Mac&#8217;te Excel kullan\u0131yorsan\u0131z, korkar\u0131m bunun i\u00e7in bir g\u00fc\u00e7 sorgusu eklentisi yok ve <strong>yaln\u0131zca mevcut bir sorguyu yenileyebilirsiniz<\/strong> , ancak yeni bir sorgu olu\u015fturamaz ve hatta bir sorguyu d\u00fczenleyemezsiniz ( <a href=\"https:\/\/blog-insider.office.com\/2019\/05\/30\/you-asked-for-it-a-journey-to-power-query-in-excel-for-mac-starts-now\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>LINK<\/strong><\/a> ). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47481\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-mac.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00fc\u00e7 sorgusu-excel-mac\" width=\"570\" height=\"114\"><\/figure><\/div><h2 class=\"wp-block-heading\"> G\u00fc\u00e7 Sorgu D\u00fczenleyicisi<\/h2><p> Power Query&#8217;nin, verileri alabilece\u011finiz, sorgu olu\u015fturmak i\u00e7in t\u00fcm ad\u0131mlar\u0131 ger\u00e7ekle\u015ftirebilece\u011finiz ve ard\u0131ndan bunlar\u0131 elektronik tabloya y\u00fckleyebilece\u011finiz kendi d\u00fczenleyicisi vard\u0131r. Power Query D\u00fczenleyicisi&#8217;ni a\u00e7mak i\u00e7in Veri sekmesine gitmeniz ve Al ve D\u00f6n\u00fc\u015ft\u00fcr \u279c Veri Al \u279c Power Query D\u00fczenleyicisini Ba\u015flat&#8217;a gitmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47302\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-lancer-lediteur-de-requete-puissant-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"ba\u015flat-g\u00fc\u00e7-sorgu-d\u00fczenleyici-1\" width=\"343\" height=\"467\"><\/figure><\/div><p> A\u015fa\u011f\u0131da, a\u00e7t\u0131\u011f\u0131n\u0131zda alaca\u011f\u0131n\u0131z d\u00fczenleyicinin ilk \u00f6nizlemesi bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47303\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-premier-regard-de-lediteur.png\" sizes=\"auto, \" srcset=\"\" alt=\"edit\u00f6r\u00fcn ilk bak\u0131\u015f\u0131\" width=\"601\" height=\"321\"><\/figure><\/div><p> \u015eimdi her b\u00f6l\u00fcm\u00fc ayr\u0131nt\u0131l\u0131 olarak inceleyelim:<\/p><h3 class=\"wp-block-heading\"> 1. \u015eerit<\/h3><p> Mevcut t\u00fcm sekmelere bakal\u0131m:<\/p><ul><li> <strong>Dosya:<\/strong> Dosya sekmesinden verileri y\u00fckleyebilir, d\u00fczenleyiciyi kald\u0131rabilir ve sorgu parametrelerini a\u00e7abilirsiniz.<\/li><li> <strong>Ana<\/strong> Sayfa : G\u0130R\u0130\u015e sekmesinde, s\u00fctunlar ve sat\u0131rlar gibi y\u00fcklenen verileri y\u00f6netme, silme ve ta\u015f\u0131ma se\u00e7enekleriniz vard\u0131r.<\/li><li> <strong>D\u00f6n\u00fc\u015ft\u00fcrme<\/strong> : Bu sekme, s\u00fctunlar\u0131 birle\u015ftirme, devri\u011fi de\u011fi\u015ftirme vb. gibi verileri d\u00f6n\u00fc\u015ft\u00fcrmek ve temizlemek i\u00e7in ihtiyac\u0131n\u0131z olan t\u00fcm se\u00e7enekleri i\u00e7erir.<\/li><li> <strong>S\u00fctun Ekle<\/strong> : Burada geli\u015fmi\u015f d\u00fczenleyicide sahip oldu\u011funuz verilere yeni s\u00fctunlar ekleme se\u00e7ene\u011finiz vard\u0131r.<\/li><li> <strong>G\u00f6r\u00fcn\u00fcm<\/strong> : Bu sekmeden Geli\u015fmi\u015f Sorgu D\u00fczenleyicisi g\u00f6r\u00fcn\u00fcm\u00fcnde ve y\u00fcklenen verilerde de\u011fi\u015fiklik yapabilirsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> 2. Uygulanan ad\u0131mlar<\/h3><p> D\u00fczenleyicinin sa\u011f taraf\u0131nda, sorgu ad\u0131n\u0131 ve s\u0131rayla uygulanan t\u00fcm ad\u0131mlar\u0131 i\u00e7eren bir sorgu ayarlar\u0131 b\u00f6lmesi bulunur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47304\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-volet-de-parametrage-des-requetes-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"uygulanan-ad\u0131mlar-se\u00e7enekler-listesi\" width=\"238\" height=\"290\"><\/figure><\/div><p> Bir ad\u0131ma sa\u011f t\u0131klad\u0131\u011f\u0131n\u0131zda, yeniden adland\u0131rma, silme, d\u00fczenleme, yukar\u0131 veya a\u015fa\u011f\u0131 ta\u015f\u0131ma vb. gibi yapabilece\u011finiz se\u00e7eneklerin bir listesi bulunur. ve bir ad\u0131ma t\u0131klad\u0131\u011f\u0131n\u0131zda edit\u00f6r sizi o ad\u0131mda yap\u0131lan d\u00f6n\u00fc\u015f\u00fcme g\u00f6t\u00fcrecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47305\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-etapes-appliquees-liste-doptions.png\" sizes=\"auto, \" srcset=\"\" alt=\"uygulanan-ad\u0131mlar-se\u00e7enekler-listesi\" width=\"247\" height=\"342\"><\/figure><\/div><p> A\u015fa\u011f\u0131ya bak\u0131n, toplamda be\u015f ad\u0131m\u0131 da uygulad\u0131n\u0131z ve 4. ad\u0131ma t\u0131klad\u0131\u011f\u0131mda beni s\u00fctun adlar\u0131n\u0131n de\u011fi\u015fmedi\u011fi d\u00f6rd\u00fcnc\u00fc ad\u0131mdaki d\u00f6n\u00fc\u015f\u00fcme g\u00f6t\u00fcr\u00fcyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47306\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-au-total-cinq-etapes-appliquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplam be\u015f ad\u0131m uyguland\u0131\" width=\"661\" height=\"226\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. Sorular<\/h3><p> Sol taraftaki sorgular b\u00f6lmesi, \u015fu anda \u00e7al\u0131\u015fma kitab\u0131nda bulunan t\u00fcm sorgular\u0131 listeler. Temel olarak t\u00fcm sorgular\u0131 y\u00f6netebilece\u011finiz bir yerdir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47307\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-le-volet-des-requetes.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorgular b\u00f6lmesi\" width=\"178\" height=\"288\"><\/figure><\/div><p> Bir sorgu ad\u0131na sa\u011f t\u0131klad\u0131\u011f\u0131n\u0131zda kullanabilece\u011finiz t\u00fcm se\u00e7enekleri (kopyalama, silme, \u00e7o\u011faltma vb.) g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47308\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-clic-droit-sur-un-nom-de-requete.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir sorgu ad\u0131na sa\u011f t\u0131klay\u0131n\" width=\"254\" height=\"349\"><\/figure><\/div><p> Ayr\u0131ca sorgular b\u00f6lmesindeki bo\u015f alana sa\u011f t\u0131klay\u0131p ard\u0131ndan veri kayna\u011f\u0131 se\u00e7ene\u011fini belirleyerek de yeni bir sorgu olu\u015fturabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47309\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-espace-vide-dans-le-volet-des-requetes.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorgu b\u00f6lmesinde bo\u015f alan\" width=\"361\" height=\"381\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 4. Form\u00fcl \u00e7ubu\u011fu<\/h3><p> Dedi\u011fim gibi edit\u00f6rde her ad\u0131m uygulad\u0131\u011f\u0131n\u0131zda o ad\u0131ma ait M kodu \u00fcretiyor ve bu kodu form\u00fcl \u00e7ubu\u011funda g\u00f6rebiliyorsunuz. Kodu d\u00fczenlemek i\u00e7in form\u00fcl \u00e7ubu\u011funa t\u0131klaman\u0131z yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47310\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-barre-de-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"form\u00fcl \u00e7ubu\u011fu\" width=\"423\" height=\"33\"><\/figure><\/div><p> M kodunu nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frendikten sonra, kodu yazarak ve \u00f6zel bir ad\u0131m girmek i\u00e7in &#8220;FX&#8221; d\u00fc\u011fmesine t\u0131klayarak da bir ad\u0131m olu\u015fturabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47311\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-bouton-FX.png\" sizes=\"auto, \" srcset=\"\" alt=\"fx d\u00fc\u011fmesi\" width=\"168\" height=\"94\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 5. Verilere Genel Bak\u0131\u015f<\/h3><p> Veri \u00f6nizleme alan\u0131 bir Excel elektronik tablosuna benzer ancak bir h\u00fccreyi veya verileri do\u011frudan d\u00fczenleyebilece\u011finiz normal bir elektronik tablodan biraz farkl\u0131d\u0131r. D\u00fczenleyiciye veri y\u00fckledi\u011finizde (bunu birazdan yapaca\u011f\u0131z), ba\u015fl\u0131klar\u0131yla birlikte t\u00fcm s\u00fctunlar\u0131 s\u00fctun adlar\u0131yla birlikte ve ard\u0131ndan verileri i\u00e7eren sat\u0131rlar\u0131 g\u00f6r\u00fcnt\u00fcler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47312\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-la-zone-de-previsualisation-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"-veri-\u00f6nizleme-alan\u0131\" width=\"189\" height=\"268\"><\/figure><\/div><p> Her s\u00fctunun \u00fcst k\u0131sm\u0131nda, s\u00fctunun verilerinin veri t\u00fcr\u00fcn\u00fc g\u00f6rebilirsiniz. D\u00fczenleyiciye veri y\u00fckledi\u011finizde Geli\u015fmi\u015f Sorgu, do\u011fru veri t\u00fcr\u00fcn\u00fc (neredeyse her zaman) her s\u00fctuna otomatik olarak uygular.<\/p><p> S\u00fctuna uygulanan veri t\u00fcr\u00fcn\u00fc de\u011fi\u015ftirmek i\u00e7in s\u00fctun ba\u015fl\u0131\u011f\u0131n\u0131n sol \u00fcst k\u0131sm\u0131ndaki d\u00fc\u011fmeyi t\u0131klayabilirsiniz. \u00c7izim yapabilece\u011finiz t\u00fcm veri t\u00fcrlerinin bir listesini i\u00e7erir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47314\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-bouton-en-haut-a-gauche-sur-len-tete-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctun ba\u015fl\u0131\u011f\u0131nda sol \u00fcstteki d\u00fc\u011fme\" width=\"369\" height=\"376\"><\/figure><\/div><p> S\u00fctun ba\u015fl\u0131\u011f\u0131n\u0131n sol taraf\u0131nda, s\u00fctun de\u011ferlerini filtrelemek i\u00e7in kullanabilece\u011finiz filtre d\u00fc\u011fmesi bulunur. <strong>Not:<\/strong> Bir s\u00fctunun de\u011ferlerini filtreledi\u011finizde, geli\u015fmi\u015f sorgu bunu tek bir ad\u0131m olarak de\u011ferlendirir ve Uygulanan Ad\u0131mlar&#8217;da listeler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47316\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-le-cote-gauche-de-len-tete-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctunun sol taraf\u0131ndaki ba\u015fl\u0131k\" width=\"390\" height=\"329\"><\/figure><\/div><p> S\u00fctun ba\u015fl\u0131\u011f\u0131na sa\u011f t\u0131klarsan\u0131z, verileri d\u00f6n\u00fc\u015ft\u00fcrmek ve se\u00e7eneklerden birini ve uygulanan s\u00fcre\u00e7te bir ad\u0131m olarak saklad\u0131\u011f\u0131 PQ&#8217;yu kullanmak i\u00e7in kullanabilece\u011finiz se\u00e7eneklerin listesini i\u00e7eren bir men\u00fc oldu\u011funu g\u00f6rebilirsiniz. Olumsuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47319\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-clic-droit-sur-len-tete-de-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctun ba\u015fl\u0131\u011f\u0131na sa\u011f t\u0131klay\u0131n\" width=\"368\" height=\"505\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Power Query i\u00e7in veri kaynaklar\u0131<\/h2><p> Power Query&#8217;nin en iyi yan\u0131, birden \u00e7ok kaynaktan veri al\u0131p bu verileri d\u00f6n\u00fc\u015ft\u00fcr\u00fcp elektronik tabloya y\u00fckleme olana\u011f\u0131na sahip olman\u0131zd\u0131r. GET &amp; TRANSFORM&#8217;da <strong>Veri Al&#8217;\u0131<\/strong> t\u0131klatt\u0131\u011f\u0131n\u0131zda, d\u00fczenleyiciye y\u00fckleyebilece\u011finiz veri kaynaklar\u0131n\u0131n tam listesini g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47320\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-la-possibilite-dobtenir-des-donnees-a-partir-de-plusieurs-sources.png\" sizes=\"auto, \" srcset=\"\" alt=\"birden fazla kaynaktan veri alma se\u00e7ene\u011fi\" width=\"272\" height=\"491\"><\/figure><\/div><p> \u015eimdi baz\u0131 veri kaynaklar\u0131na bakal\u0131m:<\/p><ul><li> <strong>Tablodan\/Aral\u0131ktan<\/strong> : Bu se\u00e7enekle, verileri do\u011frudan etkin \u00e7al\u0131\u015fma sayfas\u0131ndan Geli\u015fmi\u015f Sorgu D\u00fczenleyicisi&#8217;ne y\u00fckleyebilirsiniz.<\/li><li> <strong>\u00c7al\u0131\u015fma kitab\u0131ndan<\/strong> : Bilgisayar\u0131n\u0131zdaki ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131ndan. A\u00e7\u0131k bir ileti\u015fim kutusu kullanarak bu dosyay\u0131 bulman\u0131z yeterlidir; bu dosyadaki verileri otomatik olarak alacakt\u0131r.<\/li><li> <strong>Metin\/CSV&#8217;den<\/strong> : Metin dosyas\u0131ndan veya virg\u00fclle ayr\u0131lm\u0131\u015f dosyadan veri al\u0131n, ard\u0131ndan bunu elektronik tabloya y\u00fckleyebilirsiniz.<\/li><li> <strong>Klas\u00f6rden<\/strong> : Klas\u00f6rdeki t\u00fcm dosyalar\u0131 al\u0131r ve g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyicideki verileri destekler. (\u015euna bak\u0131n: Excel dosyalar\u0131n\u0131 tek bir klas\u00f6rden birle\u015ftirme).<\/li><li> <strong>Web&#8217;den<\/strong> : Bu se\u00e7enekle bir web adresinden veri al\u0131rs\u0131n\u0131z, web&#8217;de saklanan bir dosyan\u0131z oldu\u011funu veya verileri alman\u0131z gereken bir web sayfan\u0131z oldu\u011funu d\u00fc\u015f\u00fcn\u00fcn.<\/li><\/ul><h2 class=\"wp-block-heading\"> Power Query D\u00fczenleyicisi&#8217;ne veri y\u00fckleme<\/h2><p> \u015eimdi verileri g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyicisine nas\u0131l y\u00fckleyece\u011finizi \u00f6\u011frenelim. Burada \u00f6\u011frenci adlar\u0131n\u0131n ve puanlar\u0131n\u0131n bir listesi bulunmaktad\u0131r ( <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/donnees-des-etudiants.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"LINK (opens in a new tab)\"><strong>LINK<\/strong><\/a> ). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47321\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-apprendre-a-charger-des-donnees-dans-lediteur-de-requete-puissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"Verileri g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyiciye nas\u0131l y\u00fckleyece\u011finizi \u00f6\u011frenin\" width=\"329\" height=\"323\"><\/figure><\/div><p> Verileri do\u011frudan e-tablodan y\u00fckleyece\u011finiz i\u00e7in \u00f6nce dosyay\u0131 a\u00e7man\u0131z ve ard\u0131ndan a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 uygulaman\u0131z gerekir:<\/p><ul><li> \u00d6ncelikle verilere bir Excel tablosu uygulay\u0131n (siz yapmasan\u0131z bile Excel, verileri PQ d\u00fczenleyicisine y\u00fcklemeden \u00f6nce bunu sizin i\u00e7in yapacakt\u0131r).<\/li><li> \u015eimdi tablodan bir h\u00fccre se\u00e7in ve \u201cTablodan\/Aral\u0131ktan\u201d (Veri Al ve D\u00f6n\u00fc\u015ft\u00fcr sekmesi) t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47322\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-cliquez-sur-la-plage-de-la-table-de-depart.png\" sizes=\"auto, \" srcset=\"\" alt=\"masan\u0131n \u00fczerine t\u0131klama aral\u0131\u011f\u0131\" width=\"329\" height=\"172\"><\/figure><\/div><ul><li> D\u00fc\u011fmeye t\u0131klad\u0131\u011f\u0131n\u0131zda Excel, bir Excel tablosunun uygulanaca\u011f\u0131 veri aral\u0131\u011f\u0131n\u0131 onaylar. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47323\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-la-plage-de-donnees-pour-appliquer-un-tableau-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tablosunun-uygulanaca\u011f\u0131-veri aral\u0131\u011f\u0131\" width=\"284\" height=\"167\"><\/figure><\/div><ul><li> Bu noktada Power Query D\u00fczenleyicisi&#8217;nde verileriniz var ve a\u015fa\u011f\u0131daki gibi g\u00f6r\u00fcn\u00fcyor. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47324\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-les-donnees-dans-lediteur-de-requete-puissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00fc\u00e7l\u00fc-sorgu-d\u00fczenleyicideki veriler\" width=\"678\" height=\"365\"><\/figure><\/div><ul><li> Burada g\u00f6rebilirsin:<ul><li> Form\u00fcl \u00e7ubu\u011funda PQ, d\u00fczenleyiciye yeni y\u00fckledi\u011finiz tablo i\u00e7in M kodunu olu\u015fturdu.<\/li><li> D\u00fczenleyicinin sol taraf\u0131nda, sorgu listesinin bulundu\u011fu sorgular b\u00f6lmesi bulunur.<\/li><li> Sa\u011f tarafta, sorgu ayarlar\u0131nda t\u00fcm ad\u0131mlar\u0131n listelendi\u011fi &#8220;Uygulanan Ad\u0131mlar&#8221; adl\u0131 b\u00f6l\u00fcm bulunmaktad\u0131r. Not: Herhangi bir &#8220;Modified Type&#8221; i\u015flemi yapmad\u0131\u011f\u0131n\u0131z\u0131 d\u00fc\u015f\u00fcnmelisiniz ancak burada &#8220;Modified Type&#8221; diye bir ad\u0131m var. <strong>POWER QUERY&#8217;nin ZEK\u00c2SINI<\/strong> anlatay\u0131m, edit\u00f6re veri y\u00fckledi\u011finizde otomatik olarak kontrol eder ve t\u00fcm s\u00fctunlar i\u00e7in do\u011fru veri t\u00fcrlerini uygular. <\/li><\/ul><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47325\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/23-barres-de-formule-pq.png\" sizes=\"auto, \" srcset=\"\" alt=\"form\u00fcl \u00e7ubu\u011fu-pq\" width=\"802\" height=\"373\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Power Query \u00d6rnekleri (\u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131)<\/h2><p> Normalde Excel&#8217;deki i\u015flevsel form\u00fcllerle yapt\u0131\u011f\u0131n\u0131z baz\u0131 temel g\u00f6revleri nas\u0131l yapaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenebilirsiniz, ancak PowerQuery ile bunu yaln\u0131zca birka\u00e7 t\u0131klamayla yapabilirsiniz: <\/p><div id=\"ub-content-toggle-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle\" data-mobilecollapse=\"false\" data-desktopcollapse=\"true\"><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-0-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 1. De\u011ferleri de\u011fi\u015ftirin <\/h3><\/div><div id=\"ub-content-toggle-panel-0-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir de\u011ferler listeniz var ve bir veya daha fazla de\u011feri ba\u015fka bir \u015feyle de\u011fi\u015ftirmek istiyorsunuz. <strong>Power Query&#8217;nin<\/strong> yard\u0131m\u0131yla k\u0131sa s\u00fcrede bir sorgu olu\u015fturabilir ve bu de\u011ferleri de\u011fi\u015ftirebilirsiniz.<\/p><p> A\u015fa\u011f\u0131daki listede \u201cPuneet\u201d ad\u0131m\u0131 \u201cPunit\u201d ile de\u011fi\u015ftirmeniz gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47329\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/24-liste-de-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"De\u011ferler listesi\" width=\"133\" height=\"299\"><\/figure><\/div><ul><li> \u00d6ncelikle Geli\u015fmi\u015f Sorgu D\u00fczenleyicisi&#8217;ndeki listeyi d\u00fczenleyin.<\/li><li> Bundan sonra Power Query D\u00fczenleyicisi&#8217;nde &#8220;D\u00f6n\u00fc\u015ft\u00fcrme Sekmesi&#8221;ne gidin ve &#8220;De\u011ferleri De\u011fi\u015ftir&#8221;e t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47330\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/25-onglet-de-transformation.png\" sizes=\"auto, \" srcset=\"\" alt=\"d\u00f6n\u00fc\u015ft\u00fcrme sekmesi\" width=\"479\" height=\"135\"><\/figure><\/div><ul><li> \u015eimdi \u201cBulunacak de\u011fer\u201de \u201cPuneet\u201d yaz\u0131n ve \u201c\u015eununla de\u011fi\u015ftir\u201de \u201cPunit\u201d girin ve ard\u0131ndan Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47331\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/26-valeur-a-trouver.png\" sizes=\"auto, \" srcset=\"\" alt=\"bulunacak de\u011fer\" width=\"350\" height=\"183\"><\/figure><\/div><ul><li> Tamam&#8217;a t\u0131klad\u0131\u011f\u0131n\u0131zda t\u00fcm de\u011ferler yeni de\u011ferlerle de\u011fi\u015ftirilir ve \u015fimdi verileri 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 size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47332\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/27-fermer-et-charger.png\" sizes=\"auto, \" srcset=\"\" alt=\"kapat ve y\u00fckle\" width=\"213\" height=\"376\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 2. Verileri s\u0131ralay\u0131n <\/h3><\/div><div id=\"ub-content-toggle-panel-1-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Normal s\u0131ralamada oldu\u011fu gibi, PowerQuery&#8217;yi kullanarak verileri s\u0131ralayabilirsiniz; ben de yukar\u0131daki \u00f6rnekte kulland\u0131\u011f\u0131n\u0131z ad listesinin ayn\u0131s\u0131n\u0131 kullan\u0131yorum.<\/p><ul><li> \u0130lk olarak verileri g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyicisine y\u00fckleyin.<\/li><li> Giri\u015f sekmesinde iki s\u0131ralama d\u00fc\u011fmeniz vard\u0131r (Artan ve Azalan).<\/li><li> S\u0131ralamak i\u00e7in bu d\u00fc\u011fmelerden birine t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/28-deux-boutons-de-tri.png\" sizes=\"auto, \" srcset=\"\" alt=\"iki s\u0131ralama d\u00fc\u011fmesi\" width=\"487\" height=\"135\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 3. S\u00fctunlar\u0131 silin <\/h3><\/div><div id=\"ub-content-toggle-panel-2-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Diyelim ki bir yerlerde baz\u0131 verileriniz var ve bu verilerden baz\u0131 s\u00fctunlar\u0131 kald\u0131rman\u0131z gerekiyor. Mesele \u015fu ki, her yeni veri ekledi\u011finizde bu s\u00fctunlar\u0131 silmeniz gerekiyor, de\u011fil mi? Ancak g\u00fc\u00e7 sorgusu bunu halledebilir.<\/p><ul><li> <span style=\"font-size: inherit; background-color: initial;\">Silmek istedi\u011finiz s\u00fctunu veya birden \u00e7ok s\u00fctunu se\u00e7in.<\/span> <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47334\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/29-donnees-ouvertes-dans-lediteur-de-requete-puissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"g\u00fc\u00e7l\u00fc-sorgu-d\u00fczenleyicide-veri-a\u00e7\u0131k\" width=\"495\" height=\"248\"><\/figure><\/div><ul><li> \u015eimdi sa\u011f t\u0131klay\u0131n ve \u201cSil\u201di se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/30-supprimer.png\" sizes=\"auto, \" srcset=\"\" alt=\"geri \u00e7ekilmek\" width=\"281\" height=\"228\"><\/figure><\/div><p> <strong>H\u0131zl\u0131 \u0130pucu:<\/strong> Se\u00e7ili olmayan t\u00fcm s\u00fctunlar\u0131 silebilece\u011finiz \u201cDi\u011fer s\u00fctunlar\u0131 kald\u0131r\u201d se\u00e7ene\u011fi de vard\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-3-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 4. S\u00fctunlar\u0131 b\u00f6l <\/h3><\/div><div id=\"ub-content-toggle-panel-3-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> T\u0131pk\u0131 s\u00fctuna metin se\u00e7ene\u011fi gibi, g\u00fc\u00e7 sorgusunda da &#8220;S\u00fctunu B\u00f6l&#8221; se\u00e7ene\u011finiz vard\u0131r. Size nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlatay\u0131m.<\/p><ul><li> <span style=\"font-size: inherit; background-color: initial;\">S\u00fctunu se\u00e7in ve Ana Sayfa sekmesine gidin \u279c D\u00f6n\u00fc\u015ft\u00fcr \u279c S\u00fctunu b\u00f6l \u279c S\u0131n\u0131rlay\u0131c\u0131ya g\u00f6re.<\/span> <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47337\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/31-colonnes-divisees.png\" sizes=\"auto, \" srcset=\"\" alt=\"b\u00f6l\u00fcnm\u00fc\u015f s\u00fctun\" width=\"578\" height=\"140\"><\/figure><\/div><ul><li> A\u00e7\u0131l\u0131r listeden \u00f6zel olan\u0131 se\u00e7in ve i\u00e7ine \u201c\u2013\u201d girin.<\/li><li> Art\u0131k burada bir s\u00fctunu b\u00f6lmek i\u00e7in \u00fc\u00e7 farkl\u0131 se\u00e7ene\u011finiz var.<ul><li> En soldaki s\u0131n\u0131rlay\u0131c\u0131<\/li><li> En sa\u011fdaki s\u0131n\u0131rlay\u0131c\u0131<\/li><li> S\u0131n\u0131rlay\u0131c\u0131n\u0131n her olu\u015fumu <\/li><\/ul><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47338\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/32-trois-options-differentes-pour-diviser-une-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir s\u00fctunu b\u00f6lmek i\u00e7in \u00fc\u00e7 farkl\u0131 se\u00e7enek\" width=\"371\" height=\"252\"><\/figure><\/div><p> Bir h\u00fccrede yaln\u0131zca bir s\u0131n\u0131rlay\u0131c\u0131n\u0131z varsa \u00fc\u00e7\u00fc de ayn\u0131 \u015fekilde \u00e7al\u0131\u015facakt\u0131r ancak birden fazla s\u0131n\u0131rlay\u0131c\u0131n\u0131z varsa buna g\u00f6re se\u00e7im yapmal\u0131s\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47339\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/33-delimiteur-dans-une-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccre i\u00e7i s\u0131n\u0131rlama\" width=\"361\" height=\"290\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-4-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 5. Bir s\u00fctunu yeniden adland\u0131r\u0131n <\/h3><\/div><div id=\"ub-content-toggle-panel-4-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir s\u00fctunu sa\u011f t\u0131klay\u0131p ard\u0131ndan \u201cYeniden Adland\u0131r\u201d se\u00e7ene\u011fine t\u0131klayarak yeniden adland\u0131rabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47340\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/34-renommer-une-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir s\u00fctunu yeniden adland\u0131r\" width=\"272\" height=\"121\"><\/figure><\/div><p> <strong>K\u0131sa ipucu<\/strong> : Diyelim ki bir s\u00fctunu yeniden adland\u0131rmak i\u00e7in bir sorgunuz var ve ba\u015fka biri onu yanl\u0131\u015fl\u0131kla yeniden adland\u0131rd\u0131. Bu ad\u0131 tek bir t\u0131klamayla geri y\u00fckleyebilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-5-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 6. S\u00fctunu \u00e7o\u011falt\u0131n <\/h3><\/div><div id=\"ub-content-toggle-panel-5-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Power Query&#8217;de yinelenen bir s\u00fctun olu\u015fturmak i\u00e7in basit bir se\u00e7enek vard\u0131r. \u00c7o\u011falt\u0131lm\u0131\u015f s\u00fctun olu\u015fturmak istedi\u011finiz s\u00fctuna sa\u011f t\u0131klay\u0131n ve ard\u0131ndan &#8220;S\u00fctunu \u00c7o\u011falt&#8221; se\u00e7ene\u011fine t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47341\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/35-creer-une-colonne-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"yinelenen bir s\u00fctun olu\u015ftur\" width=\"280\" height=\"200\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-6-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 7. S\u00fctun veya sat\u0131r\u0131n yerini de\u011fi\u015ftir <\/h3><\/div><div id=\"ub-content-toggle-panel-6-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> G\u00fc\u00e7 sorgusunda aktar\u0131m \u00e7ocuk oyunca\u011f\u0131d\u0131r. Evet, sadece tek bir t\u0131klama.<\/p><ul><li> Verileri Geli\u015fmi\u015f Sorgu D\u00fczenleyicisine y\u00fckledikten sonra tek yapman\u0131z gereken s\u00fctunlar\u0131 veya sat\u0131rlar\u0131 se\u00e7mektir.<\/li><li> D\u00f6n\u00fc\u015ft\u00fcrme sekmesine gidin \u279c Tablo \u279c Transpoze. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47346\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/38-colonne-ou-ligne-de-transposition.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctun veya sat\u0131r\u0131n yerini de\u011fi\u015ftirme\" width=\"341\" height=\"143\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-7-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 8. Hatalar\u0131 de\u011fi\u015ftirin\/kald\u0131r\u0131n <\/h3><\/div><div id=\"ub-content-toggle-panel-7-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Normalde Excel&#8217;deki hatalar\u0131 de\u011fi\u015ftirmek veya kald\u0131rmak i\u00e7in Bul ve De\u011fi\u015ftir se\u00e7ene\u011fini veya VBA kodunu kullanabilirsiniz. Ancak PowerQuery&#8217;de bu \u00e7ok daha kolayd\u0131r. Hatalar\u0131n\u0131z\u0131n oldu\u011fu a\u015fa\u011f\u0131daki s\u00fctuna bak\u0131n; bunlar\u0131 kald\u0131rabilir ve de\u011fi\u015ftirebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47347\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/39-remplacement-ou-suppression-des-erreurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"hatalar\u0131 de\u011fi\u015ftir veya kald\u0131r\" width=\"201\" height=\"282\"><\/figure><\/div><p> S\u00fctuna sa\u011f t\u0131klad\u0131\u011f\u0131n\u0131zda her iki se\u00e7ene\u011fe de sahip olacaks\u0131n\u0131z.<\/p><ul><li> Hatalar\u0131 de\u011fi\u015ftir<\/li><li> Hatalar\u0131 kald\u0131r <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47348\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/40-remplacer-les-erreurs-supprimer-les-erreurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"hatalar\u0131 de\u011fi\u015ftir-hatalar\u0131 kald\u0131r\" width=\"242\" height=\"262\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-8-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 9. Veri t\u00fcr\u00fcn\u00fc de\u011fi\u015ftirin <\/h3><\/div><div id=\"ub-content-toggle-panel-8-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir s\u00fctunda verileriniz var ancak bunlar do\u011fru formatta de\u011fil. Yani her seferinde format\u0131n\u0131 de\u011fi\u015ftirmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47349\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/41-changer-le-type-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"veri t\u00fcr\u00fcn\u00fc de\u011fi\u015ftir\" width=\"212\" height=\"240\"><\/figure><\/div><ul><li> \u0130lk olarak verileri g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyicide d\u00fczenleyin.<\/li><li> Bundan sonra s\u00fctunu se\u00e7in ve D\u00f6n\u00fc\u015ft\u00fcr sekmesine gidin.<\/li><li> \u015eimdi Veri T\u00fcr\u00fc&#8217;nden t\u00fcr olarak \u201cTarih\u201di se\u00e7in. <\/li><\/ul><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-9-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 10. \u00d6rneklerden s\u00fctun ekleyin <\/h3><\/div><div id=\"ub-content-toggle-panel-9-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Geli\u015fmi\u015f sorguda, asl\u0131nda ge\u00e7erli s\u00fctunla ilgili bir \u00f6rnek olmayan \u00f6rnek bir s\u00fctun ekleme se\u00e7ene\u011fi vard\u0131r.<\/p><p> Sana bir \u00f6rnek vereyim:<\/p><p> Bir tarih s\u00fctunundan g\u00fcn adlar\u0131na ihtiyac\u0131n\u0131z oldu\u011funu d\u00fc\u015f\u00fcn\u00fcn. Form\u00fcl ya da ba\u015fka bir se\u00e7enek kullanmak yerine \u201c\u00d6rneklerden S\u00fctun Ekle\u201d se\u00e7ene\u011fini kullanabilirsiniz.<\/p><p> Bunu nas\u0131l yapaca\u011f\u0131n\u0131z a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/p><ul><li> <span style=\"font-size: inherit; background-color: initial;\">Bir s\u00fctuna sa\u011f t\u0131klay\u0131n ve \u201c\u00d6rneklerden S\u00fctun Ekle\u201dye t\u0131klay\u0131n.<\/span> <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47350\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/42-ajouter-une-colonne-a-partir-dexemples.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6rneklerden s\u00fctun ekle\" width=\"271\" height=\"196\"><\/figure><\/div><ul><li> Burada bo\u015f bir s\u00fctun alacaks\u0131n\u0131z. Ekleyebilece\u011finiz de\u011ferlerin bir listesini almak i\u00e7in s\u00fctundaki ilk h\u00fccreye t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47351\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/43-colonne-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"bo\u015f s\u00fctun\" width=\"253\" height=\"198\"><\/figure><\/div><ul><li> \u201cTarihten itibaren haftan\u0131n g\u00fcn\u00fcn\u00fcn ad\u0131\u201d se\u00e7ene\u011fini se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47352\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/44-nom-du-jour-de-la-semaine-a-partir-de-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"haftan\u0131n g\u00fcn\u00fc-tarihi-ad\u0131\" width=\"479\" height=\"286\"><\/figure><\/div><p> <strong>Boom!<\/strong> yeni s\u00fctununuz burada. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47353\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/45-nouvelle-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"yeni s\u00fctun\" width=\"385\" height=\"257\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-10-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 11. Kutular\u0131 de\u011fi\u015ftirin <\/h3><\/div><div id=\"ub-content-toggle-panel-10-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> PowerQuery&#8217;de metnin b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf durumunu de\u011fi\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki se\u00e7eneklere sahipsiniz.<\/p><ul><li> Minik<\/li><li> \u00dcst kutu<\/li><li> Her kelimeyi b\u00fcy\u00fck harfle yaz<\/li><\/ul><p> Bunu, bir s\u00fctuna sa\u011f t\u0131klay\u0131p yukar\u0131daki \u00fc\u00e7 se\u00e7enekten birini se\u00e7erek yapabilirsiniz. Veya D\u00f6n\u00fc\u015ft\u00fcr sekmesine gidin \u279c Metin S\u00fctunu \u279c Bi\u00e7im. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47354\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/46-cas-de-changement.png\" sizes=\"auto, \" srcset=\"\" alt=\"de\u011fi\u015fiklik durumu\" width=\"241\" height=\"255\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-11-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 12. K\u0131rp\u0131n ve temizleyin <\/h3><\/div><div id=\"ub-content-toggle-panel-11-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Verileri temizlemek veya <a href=\"https:\/\/exceladvisor.org\/tr\/fazladan-bosluklari-kaldir\/\">istenmeyen bo\u015fluklar\u0131 kald\u0131rmak<\/a> i\u00e7in PowerQuery&#8217;deki TRIM ve CLEAN se\u00e7eneklerini kullanabilirsiniz. Ad\u0131mlar basit:<\/p><ul><li> Bir s\u00fctuna sa\u011f t\u0131klay\u0131n veya birden fazla s\u00fctununuz varsa t\u00fcm s\u00fctunlar\u0131 se\u00e7in.<\/li><li> D\u00f6n\u00fc\u015ft\u00fcr sekmesine gidin \u279c Metin S\u00fctunu \u279c Bi\u00e7im.<ol><li> TRIM: H\u00fccrenin sonundaki ve ba\u015flang\u0131c\u0131ndaki beyaz bo\u015fluklar\u0131 kald\u0131rmak i\u00e7in.<\/li><li> TEM\u0130ZLE: yazd\u0131r\u0131lmayan karakterleri h\u00fccreden kald\u0131rmak i\u00e7in. <\/li><\/ol><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47355\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/47-tailler-et-nettoyer.png\" sizes=\"auto, \" srcset=\"\" alt=\"d\u00fczelt ve temizle\" width=\"268\" height=\"275\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-12-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 13. Bir \u00f6nek\/sonek ekleyin <\/h3><\/div><div id=\"ub-content-toggle-panel-12-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Yani bir de\u011ferler listeniz var ve bu listeden her h\u00fccreye bir \u00f6nek\/sonek eklemek istiyorsunuz. Excel&#8217;de birle\u015ftirme y\u00f6ntemini kullanabilirsiniz ancak PowerQuery&#8217;de her ikisi i\u00e7in de kullan\u0131m\u0131 basit bir se\u00e7enek vard\u0131r.<\/p><ul><li> \u00d6ncelikle \u00f6nek\/sonek eklemeniz gereken s\u00fctunu se\u00e7in.<\/li><li> Daha sonra D\u00f6n\u00fc\u015ft\u00fcr sekmesine gidin \u279c Metin S\u00fctunu \u279c Bi\u00e7im \u279c \u00d6nek Ekle\/Sonek Ekle. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47356\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/47-tailler-et-nettoyer-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"kes ve temizle-1\" width=\"252\" height=\"259\"><\/figure><\/div><ul><li> Se\u00e7eneklerden herhangi birine t\u0131klad\u0131\u011f\u0131n\u0131zda, metin girmek i\u00e7in bir ileti\u015fim kutusu a\u00e7\u0131l\u0131r. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47357\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/49-boite-de-dialogue-pour-saisir-du-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"metin girmek i\u00e7in ileti\u015fim kutusu\" width=\"309\" height=\"130\"><\/figure><\/div><ul><li> Ve metni girdikten sonra Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47358\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/50-entrer-le-texte-cliquer-sur-ok.png\" sizes=\"auto, \" srcset=\"\" alt=\"metin girin-t\u0131klay\u0131n-tamam\" width=\"182\" height=\"305\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-13-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 14. De\u011ferleri \u00e7\u0131kar\u0131n <\/h3><\/div><div id=\"ub-content-toggle-panel-13-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> E\u011fer bir form\u00fcl merakl\u0131s\u0131ysan\u0131z, bir h\u00fccreden metin veya say\u0131 \u00e7\u0131karman\u0131n farkl\u0131 i\u015flevleri birle\u015ftirmeyi gerektirdi\u011fi konusunda benimle ayn\u0131 fikirde oldu\u011funuzdan eminim. Ancak PowerQuery bu sorunlar\u0131n \u00e7o\u011funu \u00e7\u00f6zm\u00fc\u015ft\u00fcr. Bir h\u00fccreden de\u011fer \u00e7\u0131karman\u0131n yedi yolu vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47359\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/51-valeurs-dextraction.png\" sizes=\"auto, \" srcset=\"\" alt=\"de\u011ferleri \u00e7\u0131kar\" width=\"247\" height=\"246\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-14-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 15. Yaln\u0131zca tarih veya saat <\/h3><\/div><div id=\"ub-content-toggle-panel-14-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> \u00c7o\u011fu zaman tarih ve saatin her ikisi de tek bir h\u00fccrede bulunur, ancak bunlardan birine ihtiyac\u0131n\u0131z vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47360\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/52-uniquement-la-date-ou-lheure.png\" sizes=\"auto, \" srcset=\"\" alt=\"yaln\u0131zca tarih veya saat\" width=\"180\" height=\"298\"><\/figure><\/div><ul><li> Birle\u015fik tarih ve saatin bulundu\u011fu s\u00fctunu se\u00e7in.<\/li><li> E\u011fer istersen:<ul><li> <strong>Tarih<\/strong> : Sa\u011f t\u0131klay\u0131n \u279c D\u00f6n\u00fc\u015ft\u00fcr \u279c Yaln\u0131zca tarih.<\/li><li> <strong>Zaman<\/strong> : \u279c D\u00f6n\u00fc\u015ft\u00fcr \u279c Yaln\u0131zca Zaman&#8217;a sa\u011f t\u0131klay\u0131n. <\/li><\/ul><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47361\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/53-si-vous-voulez-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"e\u011fer-bulu\u015fmak-istiyorsan\" width=\"248\" height=\"173\"><\/figure><\/div><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47362\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/54-si-tu-veux-du-temps.png\" sizes=\"auto, \" srcset=\"\" alt=\"e\u011fer zaman istersen\" width=\"244\" height=\"168\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-15-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 16. Tarih ve saati birle\u015ftirin <\/h3><\/div><div id=\"ub-content-toggle-panel-15-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Art\u0131k tarih ve saati nas\u0131l ay\u0131raca\u011f\u0131n\u0131z\u0131 biliyorsunuz. Ancak daha sonra bunlar\u0131 nas\u0131l birle\u015ftirece\u011finizi bilmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47363\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/55-combiner-date-et-heure.png\" sizes=\"auto, \" srcset=\"\" alt=\"tarih ve saati birle\u015ftir\" width=\"408\" height=\"256\"><\/figure><\/div><ul><li> \u00d6ncelikle tarih s\u00fctununu se\u00e7in ve \u201cYaln\u0131zca tarih\u201d se\u00e7ene\u011fine t\u0131klay\u0131n.<\/li><li> Daha sonra her iki s\u00fctunu da (Tarih ve Saat) se\u00e7ip D\u00f6n\u00fc\u015ft\u00fcrme sekmesine gidin ve \u201cTarih ve Saat S\u00fctunu\u201d grubundan Tarih\u2019e gidin ve \u201cTarih ve Saati Birle\u015ftir\u201d se\u00e7ene\u011fine t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47364\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/56-combiner-date-et-heure.png\" sizes=\"auto, \" srcset=\"\" alt=\"tarih ve saati birle\u015ftir\" width=\"264\" height=\"352\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-16-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 17. Yuvarlat\u0131lm\u0131\u015f say\u0131lar <\/h3><\/div><div id=\"ub-content-toggle-panel-16-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Say\u0131lar\u0131 yuvarlamak i\u00e7in a\u015fa\u011f\u0131daki se\u00e7enekleri kullanabilirsiniz.<\/p><ul><li> A\u015fa\u011f\u0131 yuvarlama: Bir say\u0131y\u0131 a\u015fa\u011f\u0131ya yuvarlamak.<\/li><li> Round: Bir say\u0131y\u0131 yuvarlamak.<\/li><li> Yuvarlama: Ondal\u0131k basamaklar\u0131m\u0131 ne kadar yuvarlayabilece\u011finizi se\u00e7ebilirsiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47365\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/57-chiffres-arrondis.png\" sizes=\"auto, \" srcset=\"\" alt=\"yuvarlat\u0131lm\u0131\u015f say\u0131lar\" width=\"235\" height=\"175\"><\/figure><\/div><p> \u0130\u015fte ad\u0131mlar:<\/p><ul><li> <span style=\"font-size: inherit; background-color: initial;\">S\u00fctunu se\u00e7in ve \u279c D\u00f6n\u00fc\u015ft\u00fcr \u279c Yuvarlak \u00f6\u011fesine sa\u011f t\u0131klay\u0131n<\/span> .<ol><li> A\u015fa\u011f\u0131 yuvarlama: Bir say\u0131y\u0131 a\u015fa\u011f\u0131ya yuvarlamak.<\/li><li> Round: Bir say\u0131y\u0131 yuvarlamak.<\/li><li> Yuvarlama: Ondal\u0131k basamaklar\u0131m\u0131 ne kadar yuvarlayabilece\u011finizi se\u00e7ebilirsiniz.<\/li><\/ol><\/li><\/ul><p> <strong>Not:<\/strong> \u201c#3 Yuvarlak\u201d se\u00e7ene\u011fini se\u00e7ti\u011finizde yuvarlanacak ondal\u0131k basamak say\u0131s\u0131n\u0131 girmeniz gerekir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-17-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 18. Hesaplamalar <\/h3><\/div><div id=\"ub-content-toggle-panel-17-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Hesaplamalar yapmak i\u00e7in kullanabilece\u011finiz se\u00e7enekler vard\u0131r (bunlardan bir\u00e7o\u011fu). T\u00fcm bu se\u00e7enekleri D\u00f6n\u00fc\u015ft\u00fcr sekmesinde (Say\u0131sal S\u00fctun grubunda) bulabilirsiniz.<\/p><ul><li> Temel<\/li><li> \u0130statistik<\/li><li> Bilim adam\u0131<\/li><li> Trigonometri<\/li><li> Yuvarlak<\/li><li> Bilgi <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47366\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/58-calculs.png\" sizes=\"auto, \" srcset=\"\" alt=\"hesaplamalar\" width=\"274\" height=\"131\"><\/figure><\/div><p> Bu hesaplamalardan herhangi birini ger\u00e7ekle\u015ftirmek i\u00e7in s\u00fctunu ve ard\u0131ndan se\u00e7ene\u011fi se\u00e7melisiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-18-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 19. Grupland\u0131rma \u00f6l\u00e7\u00fct\u00fc <\/h3><\/div><div id=\"ub-content-toggle-panel-18-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Diyelim ki geni\u015f bir veri k\u00fcmeniz var ve bir \u00f6zet tablo olu\u015fturmak istiyorsunuz. \u0130\u015fte yapman\u0131z gerekenler: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47367\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/59-grouper-par.png\" sizes=\"auto, \" srcset=\"\" alt=\"gruba g\u00f6re\" width=\"390\" height=\"294\"><\/figure><\/div><ul><li> D\u00f6n\u00fc\u015ft\u00fcrme sekmesinde &#8216;Grupland\u0131rma \u00f6l\u00e7\u00fct\u00fc&#8217; d\u00fc\u011fmesine t\u0131klay\u0131n, bir ileti\u015fim kutusu g\u00f6receksiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47368\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/60-groupes-par-bouton.png\" sizes=\"auto, \" srcset=\"\" alt=\"d\u00fc\u011fmeye g\u00f6re grupla\" width=\"241\" height=\"142\"><\/figure><\/div><ul><li> \u015eimdi bu ileti\u015fim kutusundan gruplamak istedi\u011finiz s\u00fctunu se\u00e7in ve ard\u0131ndan bir ad ekleyin, i\u015flemi ve de\u011ferlerin bulundu\u011fu s\u00fctunu se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47369\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/61-boite-de-dialogue-selectionner-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"diyalog-se\u00e7im-s\u00fctun\" width=\"461\" height=\"180\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47370\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/62-a-la-fin-cliquez-sur-ok.png\" sizes=\"auto, \" srcset=\"\" alt=\"sonunda t\u0131klama-tamam\" width=\"268\" height=\"311\"><\/figure><\/div><p> <strong>Not:<\/strong> \u00c7ok d\u00fczeyli bir grup tablosu olu\u015fturmak i\u00e7in kullanabilece\u011finiz &#8220;Grupland\u0131rma \u00d6l\u00e7\u00fct\u00fc&#8221; se\u00e7ene\u011finde geli\u015fmi\u015f se\u00e7enekler de vard\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-19-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\"> 20. Negatif De\u011ferleri Kald\u0131r <\/h3><\/div><div id=\"ub-content-toggle-panel-19-9eb12594-f4e8-44c0-b64f-a2adf7ad35f8\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Blog yaz\u0131lar\u0131mdan birinde <a href=\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/\">olumsuz i\u015faretleri kald\u0131rmak<\/a> i\u00e7in yedi y\u00f6ntem listeledim ve g\u00fc\u00e7 sorgusu da bunlardan biri. Bir s\u00fctuna sa\u011f t\u0131klay\u0131n ve D\u00f6n\u00fc\u015ft\u00fcr se\u00e7ene\u011fine gidin, ard\u0131ndan \u201cMutlak De\u011fer\u201de t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47371\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/63-supprimer-les-valeurs-negatives.png\" sizes=\"auto, \" srcset=\"\" alt=\"negatif de\u011ferleri kald\u0131r\" width=\"447\" height=\"241\"><\/figure><\/div><p> Bu, de\u011ferlerden t\u00fcm olumsuz i\u015faretleri an\u0131nda kald\u0131r\u0131r. <\/p><\/div><\/div><\/div><div class=\"gb-container gb-container-ce6d6657\"><div class=\"gb-container gb-container-1fa1aae1\"><h3 class=\"gb-headline gb-headline-dbd5c92a gb-headline-text\"> Daha fazla \u00f6rnek<\/h3><ol><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 veri pivotunu kald\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-beyan\/\">Power Query&#8217;de IF ifadesi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zincir\/\">Power Query&#8217;yi kullanarak de\u011ferleri (metin ve say\u0131lar) birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-farki\/\">Power Query&#8217;yi kullanarak tarih fark\u0131n\u0131 hesaplama<\/a><\/li><\/ol><\/div><\/div><h2 class=\"wp-block-heading\"> E-tabloya veri nas\u0131l y\u00fcklenir<\/h2><p> Verilerinizi d\u00f6n\u00fc\u015ft\u00fcrd\u00fckten sonra elektronik tabloya y\u00fckleyebilir ve daha fazla analiz i\u00e7in kullanabilirsiniz. Ana sekmede &#8220;Kapat ve Y\u00fckle&#8221; ad\u0131nda bir d\u00fc\u011fme vard\u0131r, ona t\u0131klad\u0131\u011f\u0131n\u0131zda ek se\u00e7enekler sunan bir a\u00e7\u0131l\u0131r liste g\u00f6r\u00fcnt\u00fclenir:<\/p><ul><li> Kapat ve y\u00fckle<\/li><li> Kapat\u0131n ve y\u00fckleyin <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47372\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/64-fermer-et-charger-a.png\" sizes=\"auto, \" srcset=\"\" alt=\"yak\u0131n ve y\u00fckleme\" width=\"199\" height=\"224\"><\/figure><\/div><ul><li> D\u00fc\u011fmeye t\u0131klad\u0131\u011f\u0131n\u0131zda a\u015fa\u011f\u0131daki se\u00e7enekler g\u00f6r\u00fcnt\u00fclenecektir: <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47373\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/65-options-dimportation-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"veri i\u00e7e aktarma se\u00e7enekleri\" width=\"276\" height=\"277\"><\/figure><\/div><ul><li> Bu verileri e-tablonuzda nas\u0131l g\u00f6r\u00fcnt\u00fclemek istedi\u011finizi se\u00e7in.<ul><li> Tablo<\/li><li> Pivot Tablo Raporu:<\/li><li> Tablo pivotu<\/li><li> Yaln\u0131zca bir ba\u011flant\u0131 olu\u015ftur<\/li><li> Verileri nereye koymak istiyorsunuz?<ul><li> Mevcut \u00c7al\u0131\u015fma Sayfas\u0131<\/li><li> Yeni \u00e7al\u0131\u015fma sayfas\u0131.<\/li><\/ul><\/li><li> Bu verileri veri modeline ekleyin.<\/li><\/ul><\/li><li> Tablo se\u00e7ene\u011fini ve yeni \u00e7al\u0131\u015fma sayfas\u0131n\u0131 se\u00e7ip veri modelini i\u015faretlemeden b\u0131rak\u0131n ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47374\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/66-options-dimportation-de-donnees-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"veri-i\u00e7e aktarma se\u00e7enekleri-2\" width=\"298\" height=\"300\"><\/figure><\/div><ul><li> Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131z anda verilerle birlikte yeni bir \u00e7al\u0131\u015fma sayfas\u0131 eklenir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47375\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/67-nouvelle-feuille-de-calcul-avec-les-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"veri i\u00e7eren yeni-e-tablo\" width=\"333\" height=\"254\"><\/figure><\/div><p> \u00d6\u011frenilecek daha fazla \u00f6rnek<\/p><h2 class=\"wp-block-heading\"> Sorguyu otomatik olarak yenileme<\/h2><p> Burada verdi\u011fim \u00f6rnekler aras\u0131nda en \u00f6nemlisi bu. Bir sorgu olu\u015fturdu\u011funuzda onu otomatik olarak yenileyebilirsiniz (bir zamanlay\u0131c\u0131 ayarlayabilirsiniz).<\/p><p> Ve i\u015fte ad\u0131mlar:<\/p><ul><li> Veri sekmesinde \u201cSorgular ve Ba\u011flant\u0131lar\u201da t\u0131klay\u0131n; pencerenin sa\u011f taraf\u0131nda Sorgular ve Ba\u011flant\u0131 b\u00f6lmesini g\u00f6receksiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47377\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/68-requetes-et-connexions.png\" sizes=\"auto, \" srcset=\"\" alt=\"istekler ve ba\u011flant\u0131lar\" width=\"285\" height=\"211\"><\/figure><\/div><ul><li> \u015eimdi sorguya sa\u011f t\u0131klay\u0131n ve \u201cHer yenile\u201d se\u00e7ene\u011fini i\u015faretleyin ve dakikalar\u0131 girin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47378\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/69-clic-droit-sur-la-coche-de-la-requete.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorgu onay i\u015faretine sa\u011f t\u0131klay\u0131n\" width=\"471\" height=\"300\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Power Query&#8217;de form\u00fcl ve i\u015flev nas\u0131l kullan\u0131l\u0131r?<\/h2><p> T\u0131pk\u0131 bir Excel elektronik tablosundaki i\u015flevleri ve form\u00fclleri kullanabildi\u011finiz gibi, Geli\u015fmi\u015f Sorgu&#8217;nun da kullanabilece\u011finiz kendi i\u015flevler listesi vard\u0131r. <a href=\"https:\/\/exceladvisor.org\/tr\/fonksiyon-formulleri\/\">PowerQuery&#8217;deki i\u015flev ve form\u00fcllerin<\/a> temelleri, Excel&#8217;in elektronik tablo i\u015flevleriyle ayn\u0131d\u0131r.<\/p><p> PQ&#8217;da bir i\u015flev veya form\u00fcl eklemek i\u00e7in yeni bir \u00f6zel s\u00fctun eklemeniz gerekir.<\/p><p> Bir \u00f6rnek verelim: A\u015fa\u011f\u0131daki verilerde (PQ edit\u00f6r\u00fcnde zaten mevcut) ad\u0131n\u0131z ve soyad\u0131n\u0131z var ( <strong><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/score-des-eleves.xlsx\">DOWNLOAD LINK<\/a> )<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47379\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/70-donnees-deja-dans-lediteur-pq-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"zaten-pq-d\u00fczenleyici-1'de bulunan veriler\" width=\"454\" height=\"302\"><\/figure><\/div><p> \u0130ki ad\u0131 birle\u015ftirmeniz ve tam ad i\u00e7in bir s\u00fctun olu\u015fturman\u0131z gerekti\u011fini d\u00fc\u015f\u00fcn\u00fcn. Bu durumda iki s\u00fctunun adlar\u0131n\u0131 birle\u015ftirmek i\u00e7in basit bir form\u00fcl girebilirsiniz.<\/p><ul><li> \u00d6ncelikle S\u00fctun Ekle sekmesine gidin ve <strong>\u201c\u00d6zel S\u00fctun\u201da t\u0131klay\u0131n.<\/strong> <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47380\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/71-ajouter-un-onglet-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctun sekmesi ekle\" width=\"499\" height=\"180\"><\/figure><\/div><ul><li> \u015eimdi \u00f6zel s\u00fctun ileti\u015fim kutusuna yeni s\u00fctunun <strong>ad\u0131n\u0131 &#8220;Tam Ad&#8221; veya yeni s\u00fctuna ne isim vermek istiyorsan\u0131z girin<\/strong> . <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47381\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/72-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zel s\u00fctun\" width=\"526\" height=\"330\"><\/figure><\/div><ul><li style=\"list-style-type: none;\"><ul><li> \u00d6zel s\u00fctun form\u00fcl\u00fc, form\u00fcl\u00fc girmeniz gereken yerdir. <strong>\u00d6yleyse a\u015fa\u011f\u0131daki form\u00fcl\u00fc girin<\/strong> : <\/li><\/ul><\/li><\/ul><pre> [First Name]&amp;\" \"&amp;[Last Name] <\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47382\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/73-formule-de-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zel s\u00fctun form\u00fcl\u00fc\" width=\"529\" height=\"332\"><\/figure><\/div><ul><li> &#8220;\u00d6zel S\u00fctun Form\u00fcl\u00fc&#8221;ne bir form\u00fcl girdi\u011finizde PQ, girdi\u011finiz form\u00fcl\u00fc kontrol eder ve &#8220;S\u00f6zdizimi hatas\u0131 tespit edilmedi&#8221; mesaj\u0131n\u0131 g\u00f6r\u00fcnt\u00fcler ve e\u011fer bir hata varsa, hatan\u0131n t\u00fcr\u00fcne g\u00f6re bir mesaj hatas\u0131 g\u00f6r\u00fcnt\u00fcler.<\/li><li> Form\u00fcl\u00fc girdikten ve hi\u00e7bir hata i\u00e7ermedikten sonra Tamam&#8217;a basman\u0131z yeterlidir.<\/li><li> Art\u0131k verilerin sonunda iki s\u00fctundan (ad ve soyad\u0131) de\u011ferleri i\u00e7eren yeni bir s\u00fctununuz var. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47383\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/74-nouvelle-colonne-a-la-fin-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"veri-sonunda-yeni-s\u00fctun\" width=\"593\" height=\"208\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Power Query&#8217;de bir i\u015flev nas\u0131l kullan\u0131l\u0131r?<\/h3><p> Benzer \u015fekilde, \u00f6zel bir s\u00fctun eklerken bir i\u015flevi de kullanabilirsiniz ve Power Query&#8217;de kullanabilece\u011finiz \u00e7ok say\u0131da i\u015flev listesi vard\u0131r.<\/p><p> Kolay ve basit bir \u00f6rnekle bir fonksiyonun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 anlayal\u0131m. Ad ve soyad\u0131n\u0131 birle\u015ftiren yeni bir s\u00fctun ekledi\u011fimiz yukar\u0131daki \u00f6rne\u011fe devam ediyorum. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47384\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/75-utiliser-la-fonction-lors-de-lajout-dune-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zel-s\u00fctun-eklerken-i\u015flevi kullan\" width=\"434\" height=\"274\"><\/figure><\/div><p> Ancak \u015fimdi bu s\u00fctunda bulunan tam ad metnini b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmeniz gerekiyor. Kullanabilece\u011finiz fonksiyon <strong>\u201c <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerquery-m\/text-upper\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Text.Upper (opens in a new tab)\">Text.Upper<\/a> \u201d<\/strong> d\u0131r. Ad\u0131ndan da anla\u015f\u0131laca\u011f\u0131 gibi metni b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p><ul><li> \u00d6ncelikle S\u00fctun Ekle sekmesine gidin ve \u00f6zel s\u00fctuna t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47385\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/76-cliquez-sur-la-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zel s\u00fctuna t\u0131klay\u0131n\" width=\"391\" height=\"196\"><\/figure><\/div><ul><li style=\"list-style-type: none;\"><ul><li> \u015eimdi, \u00f6zel s\u00fctun ileti\u015fim kutusunda, \u00f6zel s\u00fctun form\u00fcl kutusuna s\u00fctun ad\u0131n\u0131 ve a\u015fa\u011f\u0131daki form\u00fcl\u00fc girin: <\/li><\/ul><\/li><\/ul><pre class=\"wp-block-preformatted\"> Text.Upper([Full Name]) <\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47386\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/77-boite-de-dialogue-de-colonne-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zel s\u00fctun ileti\u015fim kutusu\" width=\"553\" height=\"347\"><\/figure><\/div><ul><li> Tamam&#8217;\u0131 t\u0131klatt\u0131\u011f\u0131n\u0131zda, t\u00fcm adlar\u0131n b\u00fcy\u00fck harflerle yaz\u0131ld\u0131\u011f\u0131 yeni bir s\u00fctun olu\u015fturulur.<\/li><li> Bir sonraki ad\u0131m eski s\u00fctunu silmek ve yeni s\u00fctunu yeniden adland\u0131rmakt\u0131r. Bu y\u00fczden ilk s\u00fctuna sa\u011f t\u0131klay\u0131n ve sil&#8217;i se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47387\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/78-nouvelle-colonne-avec-tous-les-noms-en-majuscule.png\" sizes=\"auto, \" srcset=\"\" alt=\"t\u00fcm isimlerin b\u00fcy\u00fck harfle yaz\u0131ld\u0131\u011f\u0131 yeni s\u00fctun\" width=\"390\" height=\"133\"><\/figure><\/div><ul><li> Sonunda yeni s\u00fctunu \u201cTam Ad\u201d olarak yeniden adland\u0131r\u0131n.<\/li><\/ul><p> Power query&#8217;te yeni s\u00fctun eklerken kullanabilece\u011finiz toplam 700 fonksiyon mevcut ve i\u015fte <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerquery-m\/power-query-m-function-reference\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"complete list provided by Microsoft (opens in a new tab)\">Microsoft&#8217;un bu fonksiyonlar i\u00e7in sa\u011flad\u0131\u011f\u0131 tam liste<\/a> , g\u00f6z at\u0131n.<\/p><h2 class=\"wp-block-heading\"> PQ&#8217;da bir sorgu nas\u0131l de\u011fi\u015ftirilir?<\/h2><p> Zaten \u00e7al\u0131\u015fma kitab\u0131n\u0131zda bulunan sorguda de\u011fi\u015fiklik yapmak istiyorsan\u0131z, sorguyu d\u00fczenleyip daha sonra bu de\u011fi\u015fiklikleri yapabilirsiniz. Veri sekmesinde <strong>Sorgular ve Ba\u011flant\u0131lar ad\u0131nda bir d\u00fc\u011fme vard\u0131r.<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47388\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/79-bouton-nomme-requetes-et-connexions.png\" sizes=\"auto, \" srcset=\"\" alt=\"d\u00fc\u011fme adl\u0131 istekler ve ba\u011flant\u0131lar\" width=\"512\" height=\"162\"><\/figure><\/div><p> Bu d\u00fc\u011fmeye t\u0131klad\u0131\u011f\u0131n\u0131zda sa\u011f tarafta ge\u00e7erli \u00e7al\u0131\u015fma kitab\u0131ndaki t\u00fcm sorgular\u0131n listelendi\u011fi bir b\u00f6lme a\u00e7\u0131l\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47389\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/80-repertorie-toutes-les-requetes-effectuees.png\" sizes=\"auto, \" srcset=\"\" alt=\"ger\u00e7ekle\u015ftirilen t\u00fcm sorgular\u0131 listele\" width=\"324\" height=\"302\"><\/figure><\/div><p> Sorgu ad\u0131na sa\u011f t\u0131klay\u0131p d\u00fczenle&#8217;yi se\u00e7ebilirsiniz ve onu d\u00fczenlemek i\u00e7in g\u00fc\u00e7l\u00fc sorgu d\u00fczenleyicisine alabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47390\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/81-faites-un-clic-droit-sur-le-nom-de-la-requete-et-selectionnez-modifier.png\" sizes=\"auto, \" srcset=\"\" alt=\"sorgu ad\u0131na sa\u011f t\u0131klay\u0131n ve d\u00fczenlemeyi se\u00e7in\" width=\"368\" height=\"213\"><\/figure><\/div><p> Bir sorguyu d\u00fczenledi\u011finizde, daha \u00f6nce ger\u00e7ekle\u015ftirdi\u011finiz t\u00fcm ad\u0131mlar\u0131n, sizin de d\u00fczenleyebilece\u011finiz veya yeni ad\u0131mlar ger\u00e7ekle\u015ftirebilece\u011finiz &#8220;Uygulanan Ad\u0131mlar&#8221; i\u00e7erisinde listelendi\u011fini g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47391\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/82-etapes-appliquees-que-vous-pouvez-egalement-modifier.png\" sizes=\"auto, \" srcset=\"\" alt=\"ayr\u0131ca-d\u00fczenleyebilece\u011finiz-uygulanan-ad\u0131mlar\" width=\"259\" height=\"180\"><\/figure><\/div><p> D\u00fczenlemelerinizi tamamlad\u0131\u011f\u0131n\u0131zda &#8220;Kapat ve Y\u00fckle&#8221; d\u00fc\u011fmesini t\u0131klaman\u0131z yeterlidir.<\/p><h2 class=\"wp-block-heading\"> Ba\u011flant\u0131lar\u0131 d\u0131\u015fa ve i\u00e7e aktarma<\/h2><p> Bir sorgu i\u00e7in kulland\u0131\u011f\u0131n\u0131z bir ba\u011flant\u0131n\u0131z varsa ve \u015fimdi bu ba\u011flant\u0131y\u0131 ba\u015fka biriyle payla\u015fmak istiyorsan\u0131z bu ba\u011flant\u0131y\u0131 bir odc dosyas\u0131 olarak d\u0131\u015far\u0131 aktarabilirsiniz.<\/p><p> Sorgu tablosunda <strong>&#8220;Ba\u011flant\u0131y\u0131 D\u0131\u015fa Aktar&#8221; ad\u0131nda bir buton<\/strong> bulunmaktad\u0131r ve bu tu\u015fa t\u0131klad\u0131\u011f\u0131n\u0131zda o sorgunun ba\u011flant\u0131s\u0131n\u0131 sisteminize kaydetmenizi sa\u011flar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47392\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/83-connexion-dexportation.png\" sizes=\"auto, \" srcset=\"\" alt=\"ihracat ba\u011flant\u0131s\u0131\" width=\"216\" height=\"143\"><\/figure><\/div><p> Ba\u015fka biri taraf\u0131ndan payla\u015f\u0131lan bir ba\u011flant\u0131y\u0131 i\u00e7e aktarmak istiyorsan\u0131z, Veri sekmesine gidip Al ve D\u00f6n\u00fc\u015ft\u00fcr b\u00f6l\u00fcm\u00fcnde <strong>Mevcut Ba\u011flant\u0131lar&#8217;a t\u0131klaman\u0131z<\/strong> yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47393\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/84-importer-une-connexion-obtenir-une-transformation.png\" sizes=\"auto, \" srcset=\"\" alt=\"i\u00e7e aktarma ba\u011flant\u0131s\u0131-get-d\u00f6n\u00fc\u015ft\u00fcrme\" width=\"400\" height=\"133\"><\/figure><\/div><p> Ard\u0131ndan, sizinle payla\u015f\u0131lan ba\u011flant\u0131 dosyas\u0131n\u0131 bulabilece\u011finiz ve \u00e7al\u0131\u015fma kitab\u0131n\u0131za aktarabilece\u011finiz &#8220;Daha fazlas\u0131 i\u00e7in g\u00f6z at&#8221; d\u00fc\u011fmesine t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47394\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/85-bouton-parcourir-pour-plus.png\" sizes=\"auto, \" srcset=\"\" alt=\"daha fazla bilgi edinmek i\u00e7in g\u00f6z at d\u00fc\u011fmesi\" width=\"465\" height=\"238\"><\/figure><\/div><h2 class=\"wp-block-heading\"> PowerQuery dili (M kodu)<\/h2><p> Daha \u00f6nce de belirtti\u011fim gibi PowerQuery&#8217;de att\u0131\u011f\u0131n\u0131z her ad\u0131m i\u00e7in <strong>M Code<\/strong> ad\u0131 verilen bir kod (arka u\u00e7ta) \u00fcretir. Ana Sayfa sekmesinde kodu g\u00f6r\u00fcnt\u00fclemek i\u00e7in kullanabilece\u011finiz &#8221; <strong>Geli\u015fmi\u015f D\u00fczenleyici&#8221;<\/strong> ad\u0131nda bir d\u00fc\u011fme bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47395\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/86-editeur-avance.png\" sizes=\"auto, \" srcset=\"\" alt=\"geli\u015fmi\u015f d\u00fczenleyici\" width=\"265\" height=\"176\"><\/figure><\/div><p> Ve geli\u015fmi\u015f d\u00fczenleyiciye t\u0131klad\u0131\u011f\u0131n\u0131zda size kod d\u00fczenleyiciyi g\u00f6sterecek ve bu kod \u015funa benzer: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47396\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/87-lediteur-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"kod d\u00fczenleyici\" width=\"578\" height=\"390\"><\/figure><\/div><p> <strong>M, b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 bir dildir<\/strong> ve di\u011fer t\u00fcm diller gibi de\u011fi\u015fkenleri ve ifadeleri kullan\u0131r. Kodun temel yap\u0131s\u0131 a\u015fa\u011f\u0131daki gibi olup kodun LET ifadesi ile ba\u015flad\u0131\u011f\u0131 yerdir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47397\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/88-structure-de-base-du-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"temel kod yap\u0131s\u0131\" width=\"539\" height=\"364\"><\/figure><\/div><p> Bu kodda iki de\u011fi\u015fkenimiz ve bunlara ayarlanm\u0131\u015f de\u011ferler var. Sonunda de\u011feri elde etmek i\u00e7in IN ifadesi kullan\u0131ld\u0131. Art\u0131k Tamam&#8217;a t\u0131klad\u0131\u011f\u0131n\u0131zda sonu\u00e7ta \u201cDe\u011fi\u015fkenad\u0131\u201d de\u011fi\u015fkenine atanan de\u011feri d\u00f6nd\u00fcrecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47398\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/89-nom-de-variable.png\" sizes=\"auto, \" srcset=\"\" alt=\"De\u011fi\u015fken ismi\" width=\"444\" height=\"199\"><\/figure><\/div><p> <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerquery-m\/quick-tour-of-the-power-query-m-formula-language\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Power Query Language. (opens in a new tab)\">Power Query Dili hakk\u0131nda daha fazla bilgi edinmek i\u00e7in bu kayna\u011fa g\u00f6z at\u0131n.<\/a> <\/p><p class=\"has-text-color has-background has-very-dark-gray-color has-very-light-gray-background-color\" style=\"font-size: 26px;\"> <strong>Sonunda<\/strong> <\/p><div class=\"schema-faq wp-block-yoast-faq-block\"><div id=\"faq-question-1583515972468\" class=\"schema-faq-section\"> <strong class=\"schema-faq-question\">Excel PowerQuery nedir?<\/strong><p class=\"schema-faq-answer\"> Power Query, birden \u00e7ok kaynaktan veri elde etmek, bu verileri temizleyip d\u00f6n\u00fc\u015ft\u00fcrmek ve ard\u0131ndan analizde daha ileri d\u00fczeyde kullanmak i\u00e7in kullanabilece\u011finiz bir veri d\u00f6n\u00fc\u015ft\u00fcrme motorudur.<\/p><\/div><\/div><p> POWER QUERY&#8217;den ka\u00e7\u0131nmay\u0131 g\u00f6ze alamazs\u0131n\u0131z. E\u011fer b\u00f6yle d\u00fc\u015f\u00fcn\u00fcyorsan\u0131z, <a href=\"https:\/\/exceladvisor.org\/tr\/excelde-fonksiyon-nedir\/\">Excel i\u015flevleri<\/a> veya VBA kodlar\u0131 ile yapt\u0131\u011f\u0131m\u0131z pek \u00e7ok \u015fey onu kullanarak otomatik hale getirilebilir ve eminim ki bu e\u011fitim size onu daha fazla kullanman\u0131z i\u00e7in ilham verecektir.<\/p>","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-1656","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 \u2013 E\u011fitim + \u00d6rnekler (Al ve D\u00f6n\u00fc\u015ft\u00fcr)<\/title>\n<meta name=\"description\" content=\"Power Query ile birden fazla kaynaktan veri al\u0131p d\u00f6n\u00fc\u015ft\u00fcrebilirsiniz; bu k\u0131lavuz TAM bir e\u011fitimdir.\" \/>\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\/guc-talebi\/\" \/>\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 \u2013 E\u011fitim + \u00d6rnekler (Al ve D\u00f6n\u00fc\u015ft\u00fcr)\" \/>\n<meta property=\"og:description\" content=\"Power Query ile birden fazla kaynaktan veri al\u0131p d\u00f6n\u00fc\u015ft\u00fcrebilirsiniz; bu k\u0131lavuz TAM bir e\u011fitimdir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.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=\"33 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\",\"name\":\"Excel'de Power Query \u2013 E\u011fitim + \u00d6rnekler (Al ve D\u00f6n\u00fc\u015ft\u00fcr)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png\",\"datePublished\":\"2023-11-13T11:16:22+00:00\",\"dateModified\":\"2023-12-10T05:59:58+00:00\",\"description\":\"Power Query ile birden fazla kaynaktan veri al\u0131p d\u00f6n\u00fc\u015ft\u00fcrebilirsiniz; bu k\u0131lavuz TAM bir e\u011fitimdir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Power Query \u00f6\u011freticisi\u200c (al ve d\u00f6n\u00fc\u015ft\u00fcr)\"}]},{\"@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'de Power Query \u2013 E\u011fitim + \u00d6rnekler (Al ve D\u00f6n\u00fc\u015ft\u00fcr)","description":"Power Query ile birden fazla kaynaktan veri al\u0131p d\u00f6n\u00fc\u015ft\u00fcrebilirsiniz; bu k\u0131lavuz TAM bir e\u011fitimdir.","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\/guc-talebi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Power Query \u2013 E\u011fitim + \u00d6rnekler (Al ve D\u00f6n\u00fc\u015ft\u00fcr)","og_description":"Power Query ile birden fazla kaynaktan veri al\u0131p d\u00f6n\u00fc\u015ft\u00fcrebilirsiniz; bu k\u0131lavuz TAM bir e\u011fitimdir.","og_url":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:58+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"33 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/","url":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/","name":"Excel'de Power Query \u2013 E\u011fitim + \u00d6rnekler (Al ve D\u00f6n\u00fc\u015ft\u00fcr)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png","datePublished":"2023-11-13T11:16:22+00:00","dateModified":"2023-12-10T05:59:58+00:00","description":"Power Query ile birden fazla kaynaktan veri al\u0131p d\u00f6n\u00fc\u015ft\u00fcrebilirsiniz; bu k\u0131lavuz TAM bir e\u011fitimdir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/guc-talebi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/requete-de-puissance-excel-2007.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/guc-talebi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel Power Query \u00f6\u011freticisi\u200c (al ve d\u00f6n\u00fc\u015ft\u00fcr)"}]},{"@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\/1656","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=1656"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1656\/revisions"}],"predecessor-version":[{"id":2232,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1656\/revisions\/2232"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}