{"id":1484,"date":"2023-11-22T10:39:02","date_gmt":"2023-11-22T10:39:02","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/"},"modified":"2023-12-10T05:59:26","modified_gmt":"2023-12-10T05:59:26","slug":"excel-becerileri","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/","title":{"rendered":"En i\u0307yi 25 excel becerisi (temelden i\u0307leri d\u00fczey&#39;e)"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2339739971\"><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> <div class=\"wp-block-group is-layout-flow\"><div class=\"wp-block-group__inner-container\"><div class=\"adthrive-video-player in-post\" data-video-id=\"V46zVV96\" data-player-type=\"default\"> G\u00fcn\u00fcm\u00fczde <a href=\"https:\/\/exceladvisor.org\/tr\/muhasebeciler-icin-excel\/\">muhasebeciden<\/a> veri analistine, \u0130K&#8217;dan \u00fcr\u00fcn y\u00f6neticisine kadar hangi profil \u00fczerinde \u00e7al\u0131\u015f\u0131yor olursan\u0131z olun, Excel&#8217;de uzman olman\u0131n <a href=\"https:\/\/exceladvisor.org\/tr\/microsoft-excelin-avantajlari\/\">\u00e7ok b\u00fcy\u00fck faydalar\u0131<\/a> var.<\/div><\/div><\/div><p> Excel becerilerinden bahsetti\u011fimizde bunlar\u0131 3 seviyeye daha ayr\u0131nt\u0131l\u0131 olarak s\u0131n\u0131fland\u0131rabiliriz:<\/p><ul><li> Temel Excel becerileri<\/li><li> Orta d\u00fczeyde Excel becerileri<\/li><li> \u0130leri Excel becerileri<\/li><\/ul><p> Bu derste bu \u00fc\u00e7 seviyeyi tek tek ayr\u0131nt\u0131l\u0131 olarak ele alaca\u011f\u0131z, o y\u00fczden ba\u015flayal\u0131m.<\/p><h2 id=\"0-basic-excel-skills\" class=\"wp-block-heading\"> Temel Excel becerileri<\/h2><p> A\u015fa\u011f\u0131da <a href=\"https:\/\/exceladvisor.org\/tr\/excelin-temelleri\/\">Excel&#8217;e yeni ba\u015flayan<\/a> herkesin \u00f6\u011frenmesi gereken ilk on temel Excel becerisi bulunmaktad\u0131r.<\/p><h3 id=\"1-1-saving-and-opening-a-workbook\" class=\"wp-block-heading\"> 1. Bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydedin ve a\u00e7\u0131n<\/h3><p> Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131 <a href=\"https:\/\/exceladvisor.org\/tr\/farkli-kaydet\/\">kaydetmek<\/a> ve a\u00e7mak, t\u0131pk\u0131 di\u011fer uygulamalarda yapt\u0131\u011f\u0131n\u0131z gibidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47528\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-et-ouvrir-un-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydet ve a\u00e7\" width=\"401\" height=\"129\"><\/figure><\/div><p> Dosya sekmesine t\u0131klad\u0131\u011f\u0131n\u0131zda size dosyay\u0131 kaydetme se\u00e7ene\u011fi g\u00f6sterilir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47529\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cliquez-sur-longlet-fichier-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"dosya sekmesine t\u0131klay\u0131n\" width=\"133\" height=\"315\"><\/figure><\/div><p> Kaydet d\u00fc\u011fmesine t\u0131klad\u0131\u011f\u0131n\u0131zda, konumu belirleyebilece\u011finiz ve ayr\u0131ca kullan\u0131lacak dosya format\u0131n\u0131 se\u00e7ebilece\u011finiz <strong><a href=\"https:\/\/exceladvisor.org\/tr\/farkli-kaydet\/\">Farkl\u0131 Kaydet<\/a> ileti\u015fim kutusu a\u00e7\u0131l\u0131r<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-13454\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/boite-de-dialogue-enregistrer-souss.png\" alt=\"ileti\u015fim kutusu olarak kaydet\" width=\"457\" height=\"311\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/boite-de-dialogue-enregistrer-souss.png 969w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/boite-de-dialogue-enregistrer-souss-300x204.png 300w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/boite-de-dialogue-enregistrer-souss-768x523.png 768w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\"><\/figure><\/div><p> Temel olarak Excel&#8217;de \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydetmek i\u00e7in kullanabilece\u011finiz <a href=\"https:\/\/support.office.com\/en-us\/article\/file-formats-that-are-supported-in-excel-0943ff2c-6014-4e8d-aaea-b83d51d46247\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"different file extensions (opens in a new tab)\">farkl\u0131 dosya uzant\u0131lar\u0131<\/a> vard\u0131r. \u0130lk kez bir dosya kaydediyorsan\u0131z ve sistemde kay\u0131tl\u0131 bir dosyan\u0131z varsa, yukar\u0131daki ad\u0131mlar\u0131 kullanabilirsiniz. De\u011fi\u015fiklikleri kaydetmek i\u00e7in <strong>Ctrl + S<\/strong> tu\u015flar\u0131na basman\u0131z yeterlidir.<\/p><p> Benzer \u015fekilde sisteminizde kay\u0131tl\u0131 bir dosyay\u0131 a\u00e7mak istiyorsan\u0131z DOSYA sekmesine giderek A\u00e7 se\u00e7ene\u011fine t\u0131klayabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47531\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-onglet-fichier-et-cliquez-sur-louvrir.png\" sizes=\"auto, \" srcset=\"\" alt=\"dosya-sekme-ve-a\u00e7-t\u0131kla\" width=\"151\" height=\"221\"><\/figure><\/div><p> Dosyay\u0131 bulup a\u00e7abilece\u011finiz a\u00e7\u0131k ileti\u015fim kutusunu g\u00f6sterir.<\/p><h3 id=\"2-2-managing-worksheets\" class=\"wp-block-heading\"> 2. Elektronik Tablo Y\u00f6netimi<\/h3><p> Her \u00e7al\u0131\u015fma kitab\u0131, verilerinizi ekleyebilece\u011finiz ve analiz edebilece\u011finiz \u00e7al\u0131\u015fma sayfalar\u0131ndan olu\u015fur. Bir Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda pencerenin <a href=\"https:\/\/exceladvisor.org\/tr\/sekmeyi-degistir\/\">alt k\u0131sm\u0131nda sekmelerin<\/a> oldu\u011funu g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47532\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-onglets-en-bas-de-la-fenetre.png\" sizes=\"auto, \" srcset=\"\" alt=\"pencerenin alt\u0131ndaki sekmeler\" width=\"355\" height=\"143\"><\/figure><\/div><p class=\"other\"> <a href=\"https:\/\/exceladvisor.org\/tr\/eklemek\/\" data-wpil=\"url\">Yeni bir \u00e7al\u0131\u015fma sayfas\u0131 eklemek<\/a> i\u00e7in art\u0131 d\u00fc\u011fmesini t\u0131klaman\u0131z yeterlidir veya <kbd>Shift<\/kbd> + <kbd>F11<\/kbd> k\u0131sayol tu\u015funu da kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47533\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-inserer-une-nouvelle-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"yeni-\u00e7al\u0131\u015fma sayfas\u0131 ekle\" width=\"363\" height=\"146\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/eklemek\/\" data-wpil=\"url\">Bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 silmek istiyorsan\u0131z,<\/a> \u00e7al\u0131\u015fma sayfas\u0131 sekmesine sa\u011f t\u0131klay\u0131n ve ard\u0131ndan silme se\u00e7ene\u011fini se\u00e7in veya Alt \u279c H \u279c D \u279c S k\u0131sayol tu\u015funu da kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47534\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-supprimer-une-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"e-tabloyu sil\" width=\"150\" height=\"296\"><\/figure><\/div><p> Ancak emin olman\u0131z gereken bir \u015fey var ki <strong>, bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 sildikten sonra onu kurtaramazs\u0131n\u0131z<\/strong> .<\/p><h3 id=\"3-3-formatting-cells\" class=\"wp-block-heading\"> 3. H\u00fccreleri Bi\u00e7imlendirmek<\/h3><p> Excel&#8217;de, giri\u015f sekmesinde bi\u00e7imlendirme i\u00e7in bir\u00e7ok se\u00e7ene\u011finiz vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47535\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-cellules-de-formatage.png\" sizes=\"auto, \" srcset=\"\" alt=\"format h\u00fccreleri\" width=\"582\" height=\"94\"><\/figure><\/div><ol><li> <strong>Yaz\u0131 tipi grubu size<\/strong> yaz\u0131 tipini kal\u0131n, italik ve alt\u0131 \u00e7izili yaparak bi\u00e7imlendirme se\u00e7ene\u011fi sunar. Yaz\u0131 tipi boyutunu, yaz\u0131 tipi rengini ve <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-rengi\/\">h\u00fccre rengini<\/a> de\u011fi\u015ftirebilirsiniz.<\/li><li> <strong>Hizalama grubundan<\/strong> <a href=\"https:\/\/exceladvisor.org\/tr\/merkezi-hizalama\/\">metin hizalamas\u0131n\u0131<\/a> ayarlayabilir, <a href=\"https:\/\/exceladvisor.org\/tr\/para-cekme\/\">girinti<\/a> ekleyebilir, <a href=\"https:\/\/exceladvisor.org\/tr\/ayrisan-hucreleri-birlestirme\/\">h\u00fccreleri birle\u015ftirebilir-gruplar\u0131n\u0131<\/a> \u00e7\u00f6zebilir ve <a href=\"https:\/\/exceladvisor.org\/tr\/metni-sar\/\">metni kayd\u0131rabilirsiniz<\/a> .<\/li><li> <strong>Say\u0131 grubundan<\/strong> ise <a href=\"https:\/\/exceladvisor.org\/tr\/muhasebe-numarasi-formati\/\">muhasebe bi\u00e7imi<\/a> , metin bi\u00e7imi, virg\u00fcll\u00fc veya <a href=\"https:\/\/exceladvisor.org\/tr\/virgul-stilini-uygula\/\">virg\u00fcls\u00fcz<\/a> say\u0131 bi\u00e7imi vb. uygulayabilirsiniz.<\/li><\/ol><p> Yukar\u0131daki se\u00e7eneklerin d\u0131\u015f\u0131nda bir h\u00fccreye sa\u011f t\u0131klay\u0131p <a href=\"https:\/\/exceladvisor.org\/tr\/acik-formatli-hucre-secenekleri\/\">Bi\u00e7im se\u00e7ene\u011fini<\/a> se\u00e7erek de H\u00fccre Bi\u00e7imlendir se\u00e7eneklerini a\u00e7abilir veya <strong>Control + 1<\/strong> k\u0131sayol tu\u015funu da kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47536\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-options-de-format-de-cellule-par-clic-droit-sur-une-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccreyi-bi\u00e7imlendirme-se\u00e7enekleri-h\u00fccreye-sa\u011f-t\u0131klayarak\" width=\"500\" height=\"494\"><\/figure><\/div><h3 id=\"4-4-printing\" class=\"wp-block-heading\"> 4. Yazd\u0131rma<\/h3><p> Dosya sekmesine gitti\u011finizde, verileri bir elektronik tablodan yazd\u0131rmak i\u00e7in kullanabilece\u011finiz t\u00fcm yazd\u0131rma se\u00e7eneklerini i\u00e7eren bir yazd\u0131rma d\u00fc\u011fmesi bulabilirsiniz.<\/p><p> Yazd\u0131r se\u00e7ene\u011fini a\u00e7mak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/baski-onizleme-1\/\">Control + P<\/a> k\u0131sayol tu\u015funu da kullanabilirsiniz ve bu se\u00e7ene\u011fi a\u00e7t\u0131\u011f\u0131n\u0131zda, burada a\u015fa\u011f\u0131daki se\u00e7enekleri g\u00f6rebilirsiniz: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47537\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-bouton-dimpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"yazd\u0131r d\u00fc\u011fmesi\" width=\"258\" height=\"350\"><\/figure><\/div><ol><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yazdirma-alanini-ayarla\/\">Alan\u0131 yazd\u0131r<\/a><\/li><li> Yazd\u0131r\u0131lacak sayfa aral\u0131\u011f\u0131<\/li><li> \u00c7arp\u0131\u015fma<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfa-yonunu-degistir\/\">Y\u00f6nlendirme sayfas\u0131<\/a><\/li><li> Sayfa t\u00fcr\u00fc<\/li><li> Marjlar<\/li><li> \u00d6l\u00e7eklendirme<\/li><\/ol><h3 id=\"5-5-excel-functions-basic\" class=\"wp-block-heading\"> 5. Excel \u0130\u015flevleri (Temel)<\/h3><p> Excel&#8217;in en b\u00fcy\u00fck g\u00fcc\u00fc, bir\u00e7ok hesaplamay\u0131 ger\u00e7ekle\u015ftirmek i\u00e7in kullanabilece\u011finiz i\u015flevlerinde yatmaktad\u0131r. A\u015fa\u011f\u0131da en iyi on <strong>temel Excel i\u015flevinin<\/strong> listesi bulunmaktad\u0131r:<\/p><ol><li> SUM: Bu fonksiyonla birden fazla h\u00fccrenin de\u011ferlerini toplayabilece\u011finiz gibi do\u011frudan fonksiyona da de\u011fer girebilirsiniz.<\/li><li> COUNT: <em>Bu fonksiyon bir h\u00fccredeki say\u0131sal de\u011ferlerin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. De\u011ferlerinizin oldu\u011fu h\u00fccrelere ba\u015fvurabilir veya de\u011ferleri oraya ekleyebilirsiniz.<\/em><\/li><li> ORTALAMA: <em>Say\u0131sal de\u011ferlerin ortalamas\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. De\u011ferlere sahip oldu\u011funuz h\u00fccrelere ba\u015fvurabilir veya bunlar\u0131 yaln\u0131zca i\u015fleve ekleyebilirsiniz.<\/em><\/li><li> TIME: Excel&#8217;in saat format\u0131na g\u00f6re ge\u00e7erli bir zaman seri numaras\u0131 d\u00f6nd\u00fcr\u00fcr. Saat, dakika ve saniyeyi belirtmeniz gerekir.<\/li><li> TAR\u0130H: Belirtilen g\u00fcn, ay ve y\u0131l\u0131 kullanarak Excel&#8217;in saat format\u0131na g\u00f6re ge\u00e7erli bir tarih (tarih seri numaras\u0131) d\u00f6nd\u00fcr\u00fcr.<\/li><li> SOL: <em>Soldan (ba\u015flang\u0131\u00e7tan) ba\u015flayarak bir h\u00fccreden\/dizeden belirli karakterleri \u00e7\u0131kar\u0131r. \u00c7\u0131kar\u0131lacak metni ve karakter say\u0131s\u0131n\u0131 belirtmeniz gerekir.<\/em><\/li><li> SA\u011e: <em>Sa\u011fdan (sonuncu) ba\u015flayarak bir dizeden belirli karakterleri \u00e7\u0131kar\u0131r. \u00c7\u0131kar\u0131lacak metni ve karakter say\u0131s\u0131n\u0131 belirtmeniz gerekir.<\/em><\/li><li> D\u00dc\u015eEYARA: <em>Bir s\u00fctunda bir de\u011fer arar ve ayn\u0131 sat\u0131r numaras\u0131n\u0131 kullanarak bu de\u011feri veya kar\u015f\u0131l\u0131k gelen s\u00fctunlardan bir de\u011feri d\u00f6nd\u00fcrebilir.<\/em><\/li><li> E\u011eER: <em>E\u011eER (bir ko\u015fulu test eder) i\u015flevi, belirli bir ko\u015ful DO\u011eRU ise bir de\u011fer d\u00f6nd\u00fcr\u00fcr ve bu ko\u015ful YANLI\u015e ise ba\u015fka bir de\u011fer d\u00f6nd\u00fcr\u00fcr.<\/em><\/li><li> \u015e\u0130MD\u0130: Ekledi\u011finiz h\u00fccredeki ge\u00e7erli tarih ve saati (sistem ayarlar\u0131n\u0131z\u0131 kullanarak) d\u00f6nd\u00fcr\u00fcr.<\/li><\/ol><p> Daha fazlas\u0131n\u0131 \u00f6\u011frenmek i\u00e7in i\u015fte <a href=\"https:\/\/exceladvisor.org\/tr\/excel-fonksiyonlari\/\" rel=\"nofollow\">en iyi 100 Excel i\u015flevi<\/a> .<\/p><ol><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-dize-islevleri\/\">Dize i\u015flevleri (metin)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-tarih-fonksiyonlari\/\">Tarih i\u015flevleri<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-zaman-fonksiyonlari\/\">Zaman fonksiyonlar\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/a\/\">Mant\u0131ksal i\u015flevler<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/a\/\">Matematiksel fonksiyonlar<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/a\/\">\u0130statistiksel i\u015flevler<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/\">Arama i\u015flevleri<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-bilgi-fonksiyonlari\/\">Bilgi fonksiyonlar\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/finansal-fonksiyonlari-excel\/\">Mali i\u015flevler<\/a><\/li><\/ol><h3 id=\"6-6-charts\" class=\"wp-block-heading\"> 6. Grafikler<\/h3><p> Verilerle \u00e7al\u0131\u015fmaya ba\u015flad\u0131\u011f\u0131n\u0131zda muhtemelen onu birine sunman\u0131z gerekir ve grafik bunu yapman\u0131n en iyi yollar\u0131ndan biridir.<\/p><p> Excel&#8217;de olu\u015fturabilece\u011finiz <a href=\"https:\/\/exceladvisor.org\/tr\/excel-cizelgeleri\/\">grafiklerin tam bir listesi<\/a> vard\u0131r. Ekle sekmesine ve Grafikler grubuna gitti\u011finizde mevcut t\u00fcm grafikleri bulabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47538\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-onglet-dinsertion-et-dans-le-groupe-de-graphiques.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7izelgeler-grubuna-sekme-ve-ekleme\" width=\"556\" height=\"120\"><\/figure><\/div><p> Ancak Excel&#8217;de bir grafik olu\u015fturmak i\u00e7in, do\u011fru formatta verilere sahip olman\u0131z ve ard\u0131ndan do\u011fru grafik t\u00fcr\u00fcn\u00fc se\u00e7meniz gerekir (grafik t\u00fcrleri ile ilgili <a href=\"https:\/\/blog.hubspot.com\/marketing\/types-of-graphs-for-data-visualization\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"this guide (opens in a new tab)\">bu k\u0131lavuza<\/a> mutlaka g\u00f6z at\u0131n). \u00d6rne\u011fin, a\u015fa\u011f\u0131da <a href=\"https:\/\/exceladvisor.org\/tr\/satis-raporu\/\">Sat\u0131\u015f Miktar\u0131<\/a> i\u00e7in 12 ayl\u0131k verileriniz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47539\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-donnees-au-bon-format.png\" sizes=\"auto, \" srcset=\"\" alt=\"verileri do\u011fru formatta\" width=\"216\" height=\"265\"><\/figure><\/div><p> Bu ayl\u0131k verileri sunmak i\u00e7in bir histogram olu\u015fturabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47540\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/graphique-a-13-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctun grafi\u011fi\" width=\"418\" height=\"254\"><\/figure><\/div><p> Ancak 12 ayl\u0131k trendi g\u00f6stermek istiyorsan\u0131z \u00e7izgi grafi\u011fi de kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47541\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/graphique-14-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7evrimi\u00e7i grafik\" width=\"474\" height=\"287\"><\/figure><\/div><p> Ancak a\u015fa\u011f\u0131da \u00fcr\u00fcn verileriniz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47542\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-produits-sages-sont-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00fcr\u00fcn a\u00e7\u0131s\u0131ndan veridir\" width=\"264\" height=\"163\"><\/figure><\/div><p> Bu durumda m\u00fckemmel grafik, bu \u00fcr\u00fcnlerin niceliksel pay\u0131n\u0131 g\u00f6sterebilece\u011finiz bir pasta grafik olacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47543\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-camembert.png\" sizes=\"auto, \" srcset=\"\" alt=\"dairesel diyagram\" width=\"248\" height=\"249\"><\/figure><\/div><p> Excel&#8217;in sahip oldu\u011funuz verilere g\u00f6re bir grafik t\u00fcr\u00fc \u00f6nermesine izin vermek i\u00e7in \u00d6nerilen Grafikler d\u00fc\u011fmesini de kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47544\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Bouton-17-graphiques-recommandes.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6nerilen-grafik-d\u00fc\u011fmesi\" width=\"304\" height=\"107\"><\/figure><\/div><p> Verileri se\u00e7ip \u00f6nerilen grafik d\u00fc\u011fmesini 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-47546\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-cliquez-sur-le-bouton-graphique-recommande.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6nerilen grafik d\u00fc\u011fmesine t\u0131klay\u0131n\" width=\"563\" height=\"434\"><\/figure><\/div><p> Bir grafi\u011fi farkl\u0131 \u015fekillerde \u00f6zelle\u015ftirebilirsiniz. Grafi\u011fi se\u00e7tikten sonra, t\u00fcm \u00f6zelle\u015ftirme se\u00e7eneklerine sahip oldu\u011funuz <strong>Tasar\u0131m ve Grafik Format\u0131<\/strong> sekmelerine sahip olacaks\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47548\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-conception-et-format-du-graphique.png\" sizes=\"auto, \" srcset=\"\" alt=\"grafik-tasar\u0131m-ve-format\" width=\"232\" height=\"51\"><\/figure><\/div><h3 id=\"7-7-sorting-data\" class=\"wp-block-heading\"> 7. Verileri s\u0131ralama<\/h3><p> Excel size verileri s\u0131ralamak i\u00e7in g\u00fc\u00e7l\u00fc bir se\u00e7enek sunar. S\u0131ralama se\u00e7ene\u011fini a\u00e7mak i\u00e7in <strong>Veri sekmesine<\/strong> gitmeniz ve ard\u0131ndan <strong>S\u0131rala d\u00fc\u011fmesine<\/strong> t\u0131klaman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47550\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-bouton-de-tri.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u0131ralama d\u00fc\u011fmesi\" width=\"403\" height=\"122\"><\/figure><\/div><p> \u015eimdi burada tan\u0131mlaman\u0131z gereken 3 \u015fey var: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47552\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-3-choses-a-definir.png\" sizes=\"auto, \" srcset=\"\" alt=\"Tan\u0131mlanacak 3 \u015fey\" width=\"512\" height=\"238\"><\/figure><\/div><ol><li> <strong>S\u0131rala<\/strong> : S\u0131ralama temeli olarak kullan\u0131lacak s\u00fctun.<\/li><li> <strong>S\u0131ralama \u00f6l\u00e7\u00fct\u00fc<\/strong> : S\u0131ralama a\u00e7\u0131l\u0131r listesinde, de\u011ferleri s\u0131ralamak i\u00e7in 4 farkl\u0131 se\u00e7ene\u011finiz vard\u0131r. H\u00fccre de\u011ferini, h\u00fccre rengini, yaz\u0131 tipi rengini ve ko\u015fullu bi\u00e7imlendirmeyi kullanabilirsiniz.<\/li><li> <strong>S\u0131ralama<\/strong> : S\u0131ralama d\u00fczeni veya \u00f6zel bir d\u00fczen.<\/li><\/ol><p> Ayr\u0131ca birden fazla s\u0131ralama d\u00fczeyi de kullanabilirsiniz. Yeni bir seviye eklemek istiyorsan\u0131z, <strong>Seviye Ekle&#8217;ye t\u0131klaman\u0131z ve ard\u0131ndan yukar\u0131da tart\u0131\u015ft\u0131\u011f\u0131m\u0131z \u00fc\u00e7 \u00f6\u011feyi ayarlaman\u0131z yeterlidir<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47553\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-cliquez-sur-le-niveau-dajout.png\" sizes=\"auto, \" srcset=\"\" alt=\"ekleme d\u00fczeyine t\u0131klay\u0131n\" width=\"138\" height=\"123\"><\/figure><\/div><p> <em>\u0130lgili: <a href=\"https:\/\/exceladvisor.org\/tr\/tarihe-gore-sirala\/\">Tarihe, tarihsaatine g\u00f6re s\u0131ralay\u0131n ve ters tarihe g\u00f6re s\u0131ralay\u0131n<\/a><\/em><\/p><h3 id=\"8-8-find-and-replace-option\" class=\"wp-block-heading\"> 8. Bul ve de\u011fi\u015ftir se\u00e7ene\u011fi<\/h3><p> Di\u011fer uygulamalar gibi Excel&#8217;in de kendi <a href=\"https:\/\/exceladvisor.org\/tr\/bul-degistir\/\">bul ve de\u011fi\u015ftir se\u00e7ene\u011fi<\/a> vard\u0131r. Aramay\u0131 a\u00e7mak i\u00e7in kullan\u0131lan k\u0131sayol tu\u015fu <strong>Control + F<\/strong> , bulup de\u011fi\u015ftirmek i\u00e7in ise <strong>Control + R&#8217;dir.<\/strong><\/p><p> &#8220;Neyi bul&#8221; giri\u015f \u00e7ubu\u011funa bulmak istedi\u011finiz de\u011feri girin ve &#8220;\u015eununla de\u011fi\u015ftir&#8221; alan\u0131na de\u011fi\u015ftirmek istedi\u011finiz de\u011feri girin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47555\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/23-option-de-recherche-et-de-remplacement.png\" sizes=\"auto, \" srcset=\"\" alt=\"ara ve de\u011fi\u015ftir se\u00e7ene\u011fi\" width=\"433\" height=\"183\"><\/figure><\/div><p> Art\u0131k t\u00fcm de\u011ferleri de\u011fi\u015ftirmek veya bulmak istiyorsan\u0131z T\u00fcm\u00fcn\u00fc De\u011fi\u015ftir veya T\u00fcm\u00fcn\u00fc Bul butonlar\u0131n\u0131 kullan\u0131n, aksi halde tek bir de\u011fer i\u00e7in \u201cSonraki Bul\u201d ve \u201cDe\u011fi\u015ftir\u201d butonlar\u0131n\u0131 kullanabilirsiniz. Se\u00e7enekler butonuna t\u0131klad\u0131\u011f\u0131n\u0131zda kullanabilece\u011finiz geli\u015fmi\u015f se\u00e7eneklerin oldu\u011funu g\u00f6receksiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47557\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/24-options-avancees-de-recherche-et-remplacement.png\" sizes=\"auto, \" srcset=\"\" alt=\"geli\u015fmi\u015f bul ve de\u011fi\u015ftir se\u00e7enekleri\" width=\"473\" height=\"248\"><\/figure><\/div><ol><li> B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 arama yap\u0131n ve de\u011fi\u015ftirin.<\/li><li> \u00c7al\u0131\u015fma kitab\u0131n\u0131n tamam\u0131nda bulun ve de\u011fi\u015ftirin.<\/li><li> H\u00fccre bi\u00e7imini kullanarak bulun ve de\u011fi\u015ftirin.<\/li><li> Ayr\u0131ca yorumlardan ve derecelendirmelerden de de\u011ferler bulabilirsiniz.<\/li><\/ol><h3 id=\"9-9-paste-special-option\" class=\"wp-block-heading\"> 9. \u00d6zel Yap\u0131\u015ft\u0131rma Se\u00e7ene\u011fi<\/h3><p> \u00d6zel Yap\u0131\u015ft\u0131r se\u00e7ene\u011fi, de\u011ferleri bir h\u00fccreye nas\u0131l yap\u0131\u015ft\u0131rmak istedi\u011finiz konusunda size tam kontrol sa\u011flar.<\/p><p> \u00d6zel sayfa se\u00e7ene\u011fini a\u00e7mak i\u00e7in Ana Sayfa sekmesine gitmeniz, ard\u0131ndan \u201cYap\u0131\u015ft\u0131r\u201d a\u00e7\u0131l\u0131r men\u00fcs\u00fcne t\u0131klaman\u0131z ve \u00f6zel yap\u0131\u015ft\u0131r se\u00e7ene\u011fine t\u0131klaman\u0131z gerekir (\u00f6zel sayfay\u0131 i\u00e7erik men\u00fcs\u00fcnden de a\u00e7abilirsiniz). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47558\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Option-speciale-25-pates.png\" sizes=\"auto, \" srcset=\"\" alt=\"yap\u0131\u015ft\u0131r-\u00f6zel-se\u00e7enek\" width=\"241\" height=\"258\"><\/figure><\/div><p> \u00d6zel Yap\u0131\u015ft\u0131r ileti\u015fim kutusunda kullanabilece\u011finiz \u00e7e\u015fitli se\u00e7enekler vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47560\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/26-boite-de-dialogue-speciale-plusieurs-options.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zel-ileti\u015fim-\u00e7oklu-se\u00e7enekler\" width=\"386\" height=\"370\"><\/figure><\/div><p> Diyelim ki form\u00fcl\u00fcn\u00fcz olan bir h\u00fccreniz var, ancak yaln\u0131zca o h\u00fccrenin de\u011ferini <a href=\"https:\/\/exceladvisor.org\/tr\/kopyala-yapistir\/\">kopyalay\u0131p yap\u0131\u015ft\u0131rmak<\/a> istiyorsunuz. Bu durumda, bu h\u00fccreyi kopyalay\u0131p hedef h\u00fccredeki \u00f6zel yap\u0131\u015ft\u0131rma se\u00e7eneklerinden <a href=\"https:\/\/exceladvisor.org\/tr\/degerleri-yapistir\/\">\u201cDe\u011ferler\u201d<\/a> se\u00e7ene\u011fini kullanman\u0131z yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47562\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/27-utiliser-loption-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"de\u011ferleri kullan se\u00e7ene\u011fi\" width=\"191\" height=\"196\"><\/figure><\/div><p> Veya format\u0131 bir h\u00fccreden di\u011ferine kopyalay\u0131p yap\u0131\u015ft\u0131rmak istiyorsan\u0131z \u201cFormatlar\u201d se\u00e7ene\u011fini kullanabilirsiniz.<\/p><p> <em>\u0130lgili: <a href=\"https:\/\/exceladvisor.org\/tr\/ressam-formati\/\">Format Boyac\u0131s\u0131<\/a> | <a href=\"https:\/\/exceladvisor.org\/tr\/devrik-2\/\">Transpoze<\/a><\/em><\/p><h3 id=\"10-10-keyboard-shortcuts\" class=\"wp-block-heading\"> 10. Klavye k\u0131sayollar\u0131<\/h3><p> Excel 2007&#8217;den Excel 2019&#8217;a kadar ALT tu\u015funa basarak bir klavye k\u0131sayolu bulabilirsiniz. Buna bas\u0131ld\u0131\u011f\u0131nda, a\u015fa\u011f\u0131daki gibi \u015feritteki se\u00e7eneklere ait k\u0131sayol tu\u015flar\u0131 g\u00f6r\u00fcnt\u00fclenir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47563\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/28-raccourcis-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"Klavye k\u0131sayollar\u0131\" width=\"317\" height=\"164\"><\/figure><\/div><p> Ve buradan, Excel i\u00e7in en iyi seksen iki klavye k\u0131sayolunu kapsayan ( <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\"><strong>Excel K\u0131sayollar\u0131 Hile Sayfas\u0131<\/strong><\/a> ) indirebilirsiniz. <\/p><div id=\"ub-content-toggle-4f15e622-8710-4db4-ab3f-e2e2ae82f7bc\" class=\"wp-block-ub-content-toggle\" data-mobilecollapse=\"false\" data-desktopcollapse=\"true\"><div class=\"wp-block-ub-content-toggle-accordion myList\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-0-4f15e622-8710-4db4-ab3f-e2e2ae82f7bc\"><p class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-4f15e622-8710-4db4-ab3f-e2e2ae82f7bc\"> Temel bilgiler hakk\u0131nda daha fazla bilgi edinin <\/p><\/div><div id=\"ub-content-toggle-panel-0-4f15e622-8710-4db4-ab3f-e2e2ae82f7bc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hizli-erisim-cubugu\/\">Excel H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011fu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pire\/\">Excel&#8217;deki madde i\u015faretleri<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-damgasi\/\">Excel&#8217;de zaman damgas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kamis\/\">Excel&#8217;de \u00fcst\u00fc \u00e7izili<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bitisik-olmayan-hucreleri-sec\/\">Biti\u015fik olmayan h\u00fccreleri se\u00e7<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-hucreleri-vurgula\/\">Bo\u015f h\u00fccreleri vurgula<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ressam-formati\/\">Excel Doldurma Yasla<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ozel-carpim-yapistir\/\">\u00d6zel \u00e7arp\u0131m\u0131 yap\u0131\u015ft\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/delta\/\" data-wpil=\"url\">Excel&#8217;deki Delta sembol\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/derece\/\" data-wpil=\"url\">Excel&#8217;de derece sembol\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/\" data-wpil=\"url\">Form\u00fcl\u00fc Excel&#8217;de de\u011fere d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/\">Excel&#8217;de bir aral\u0131\u011f\u0131 birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/onay-isareti-2\/\" data-wpil=\"url\">Excel&#8217;de onay i\u015fareti<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/\">Negatif bir say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcrme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pire\/\">Excel&#8217;deki madde i\u015faretleri<\/a><\/li><li> Excel&#8217;deki sat\u0131r say\u0131s\u0131<\/li><\/ul><\/div><\/div><\/div><h2 id=\"11-intermediate-excel-skills\" class=\"wp-block-heading\"> <strong>Orta d\u00fczeyde Excel becerileri<\/strong><\/h2><p> \u015eimdi, temel konularda uzmanla\u015ft\u0131ktan sonra anlaman\u0131z gereken bir sonraki \u015fey orta d\u00fczey Excel becerileridir. Temel olarak bu beceriler, verileri etkili bir \u015fekilde y\u00f6netmek ve bunlarla \u00e7al\u0131\u015fmak i\u00e7in se\u00e7enekleri ve y\u00f6ntemleri i\u00e7erir.<\/p><h3 id=\"12-11-go-to-special\" class=\"wp-block-heading\"> 11. \u00d6zel&#8217;e gidin<\/h3><p> \u00d6ZEL&#8217;E G\u0130T se\u00e7ene\u011fi, \u00e7al\u0131\u015fma sayfas\u0131ndaki belirli bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na gitmenize yard\u0131mc\u0131 olur. A\u00e7mak i\u00e7in Ana Sayfa sekmesine gitmeniz gerekir \u279c D\u00fczenle \u279c Bul ve se\u00e7 \u279c \u00d6zele git. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47564\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/29-trouver-et-selectionner-aller-a-special.png\" sizes=\"auto, \" srcset=\"\" alt=\"bul ve se\u00e7 \u00f6zele git\" width=\"272\" height=\"403\"><\/figure><\/div><p> G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi kullanabilece\u011finiz ve farkl\u0131 h\u00fccre t\u00fcrlerini se\u00e7ebilece\u011finiz farkl\u0131 se\u00e7enekler var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47565\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/30-boites-de-dialogue-speciales-differentes-options.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6zel-ileti\u015fim-farkl\u0131-se\u00e7enekler\" width=\"283\" height=\"336\"><\/figure><\/div><p> \u00d6rne\u011fin, t\u00fcm bo\u015f h\u00fccreleri se\u00e7mek istiyorsan\u0131z, bo\u015f olan\u0131 se\u00e7ip Tamam&#8217;a t\u0131klaman\u0131z gerekir; bu, t\u00fcm bo\u015f h\u00fccreleri an\u0131nda se\u00e7ecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47566\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/31-selectionnez-le-blanc-et-cliquez-sur-ok.png\" sizes=\"auto, \" srcset=\"\" alt=\"Bo\u015falt ve t\u0131kla tamam\" width=\"296\" height=\"352\"><\/figure><\/div><p> Benzer \u015fekilde, form\u00fclleri ve d\u00f6nd\u00fcr\u00fclen say\u0131lar\u0131 i\u00e7eren h\u00fccreleri se\u00e7mek istiyorsan\u0131z form\u00fclleri se\u00e7meniz, ard\u0131ndan say\u0131lar\u0131 kontrol etmeniz ve ard\u0131ndan Tamam&#8217;\u0131 t\u0131klaman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47567\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/32-formules-de-selection-puis-coche.png\" sizes=\"auto, \" srcset=\"\" alt=\"form\u00fclleri se\u00e7 ve ard\u0131ndan onay i\u015faretini se\u00e7\" width=\"299\" height=\"355\"><\/figure><\/div><h3 id=\"13-12-pivot-table\" class=\"wp-block-heading\"> 12. Pivot Tablo<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\">Pivot tablolar<\/a> verileri analiz etmenin en iyi yollar\u0131ndan biridir. B\u00fcy\u00fck bir veri k\u00fcmesinden \u00f6zet tablo olu\u015fturabilirsiniz. Pivot tablo olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin:<\/p><ul><li> \u0130lk \u00f6nce Ekle sekmesine gidin ve pivot tablo d\u00fc\u011fmesine 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-47568\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/33-tableau-croise-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"Pivot tablo\" width=\"435\" height=\"323\"><\/figure><\/div><ul><li> Kaynak verilerini belirtmek i\u00e7in bir ileti\u015fim kutunuz olacakt\u0131r, ancak verileri zaten se\u00e7mi\u015f oldu\u011funuz i\u00e7in aral\u0131k otomatik olarak dikkate al\u0131n\u0131r. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47569\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/34-boite-de-dialogue-pour-specifier-les-donnees-source.png\" sizes=\"auto, \" srcset=\"\" alt=\"kaynak-verilerini-belirtmek i\u00e7in-ileti\u015fim kutusu\" width=\"438\" height=\"393\"><\/figure><\/div><ul><li> Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131zda, basit\u00e7e s\u00fcr\u00fckleyip b\u0131rakabilece\u011finiz pivot tablonun sat\u0131rlar\u0131n\u0131, s\u00fctunlar\u0131n\u0131 ve de\u011ferlerini tan\u0131mlayabilece\u011finiz a\u015fa\u011f\u0131daki gibi bir kenar \u00e7ubu\u011funa sahip olacaks\u0131n\u0131z. \u015eimdi sat\u0131rlara \u201cYa\u015f\u201d\u0131, s\u00fctuna \u201cE\u011fitim\u201di ve de\u011ferlere \u201cAd\u201d\u0131 ekleyin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47570\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/35-barre-laterale.png\" sizes=\"auto, \" srcset=\"\" alt=\"kenar \u00e7ubu\u011fu\" width=\"375\" height=\"365\"><\/figure><\/div><p> Her \u015feyi ayarlad\u0131ktan sonra a\u015fa\u011f\u0131daki gibi bir pivot tablonuz olacak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47572\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/36-tableau-croise-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"Pivot tablo\" width=\"604\" height=\"207\"><\/figure><\/div><p> <strong>Pivot tablolar hakk\u0131nda daha fazla bilgi edinin<\/strong><\/p><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rutbe-sutunu\/\">Pivot tabloda s\u0131ralama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-guncelleme-araligi\/\">Pivot tablo aral\u0131\u011f\u0131n\u0131 otomatik olarak g\u00fcncelle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\">PivotTable Hesaplanan Alan<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/grup-tarihleri\/\">Pivot tabloda tarihleri gruplama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dilimleyiciyi-birkac-pivot-tabloya-baglama\/\">Birden fazla pivot tabloyu tek bir dilimleyiciye ba\u011flay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-cizelgesi-filtresi\/\">Ge\u00e7erli pivot tabloya tarih zaman \u00e7izelgesi ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/her-seyi-yenile\/\">T\u00fcm pivot tablolar\u0131 yenile<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/birikimli-toplam\/\">Pivot tabloda toplam \u00e7al\u0131\u015ft\u0131rma<\/a><\/li><\/ul><h3 id=\"14-13-named-range\" class=\"wp-block-heading\"> 13. Adland\u0131r\u0131lm\u0131\u015f plaj<\/h3><p> Adland\u0131r\u0131lm\u0131\u015f aral\u0131k, bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na ad verilmesini i\u00e7erir. Excel&#8217;de her h\u00fccrenin <a href=\"https:\/\/exceladvisor.org\/tr\/satir-ve-sutun\/\">sat\u0131r ve s\u00fctun<\/a> birle\u015fiminden olu\u015fan kendi adresi vard\u0131r.<\/p><p> Ancak adland\u0131r\u0131lm\u0131\u015f aral\u0131kla, o h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na belirli (genel) bir ad verebilir ve ard\u0131ndan ona at\u0131fta bulunmak i\u00e7in bu ad\u0131 kullanabilirsiniz.<\/p><p> Diyelim ki A1 h\u00fccresinde bir vergi y\u00fczdeniz var ve art\u0131k referans\u0131 kullanmak yerine ona bir ad verebilir ve daha sonra bu ad\u0131 her hesaplamada kullanabilirsiniz.<\/p><ul><li> Adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k olu\u015fturmak i\u00e7in Form\u00fcl sekmesine gitmeniz gerekir \u279c Adlar\u0131 Tan\u0131mla \u279c Ad\u0131 Tan\u0131mla. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47573\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/37-gamme-nommee.png\" sizes=\"auto, \" srcset=\"\" alt=\"adland\u0131r\u0131lm\u0131\u015f aral\u0131k\" width=\"244\" height=\"120\"><\/figure><\/div><ul><li> \u015eimdi ad tan\u0131m\u0131 ileti\u015fim kutusunda a\u015fa\u011f\u0131dakileri tan\u0131mlaman\u0131z gerekir: <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47574\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/38-boite-de-dialogue-de-definition-du-nom.png\" sizes=\"auto, \" srcset=\"\" alt=\"tan\u0131m-ileti\u015fim-ad\u0131\" width=\"465\" height=\"287\"><\/figure><\/div><ol><li> Aral\u0131\u011f\u0131n ad\u0131.<\/li><li> Bu aral\u0131\u011f\u0131 \u00e7al\u0131\u015fma kitab\u0131n\u0131n tamam\u0131nda veya yaln\u0131zca \u00e7al\u0131\u015fma sayfas\u0131nda kullanma yetene\u011fi.<\/li><li> Eklemek istedi\u011finiz varsa yorum yap\u0131n.<\/li><li> Ve sonra h\u00fccrenin veya aral\u0131\u011f\u0131n adresi.<\/li><\/ol><p> Art\u0131k Tamam&#8217;\u0131 t\u0131klatt\u0131\u011f\u0131n\u0131zda, Excel bu ad\u0131 A1 h\u00fccresine atayacakt\u0131r ve bunu form\u00fcllerde A1 h\u00fccresine ba\u015fvurmak i\u00e7in kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47575\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/39-nom-a-la-cellule-a1.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccre ad\u0131-a1\" width=\"245\" height=\"133\"><\/figure><\/div><p> Benzer \u015fekilde, h\u00fccre aral\u0131\u011f\u0131 i\u00e7in adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k da olu\u015fturabilir ve ard\u0131ndan form\u00fcllerde buna ba\u015fvurabilirsiniz.<\/p><h3 id=\"15-14-drop-down-lists\" class=\"wp-block-heading\"> 14. A\u00e7\u0131l\u0131r men\u00fcler<\/h3><p> A\u00e7\u0131l\u0131r liste, asl\u0131nda verileri bir h\u00fccreye h\u0131zl\u0131 bir \u015fekilde girmenize yard\u0131mc\u0131 olabilecek \u00f6nceden tan\u0131mlanm\u0131\u015f bir de\u011ferler listesidir. Bir a\u00e7\u0131l\u0131r liste olu\u015fturmak i\u00e7in Veri sekmesine gitmeniz gerekir \u279c Veri Ara\u00e7lar\u0131 \u279c Veri Do\u011frulama \u279c Veri Do\u011frulama. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47576\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/40-listes-deroulantes.png\" sizes=\"auto, \" srcset=\"\" alt=\"a\u00e7\u0131l\u0131r listeler\" width=\"384\" height=\"216\"><\/figure><\/div><p> \u015eimdi veri do\u011frulama ileti\u015fim kutusunda izindeki listeyi se\u00e7meniz ve ard\u0131ndan kaynakta de\u011ferleri almak istedi\u011finiz aral\u0131\u011fa ba\u015fvurman\u0131z gerekir (ayr\u0131ca de\u011ferleri do\u011frudan kaynak giri\u015f alan\u0131na da ekleyebilirsiniz). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47577\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/41-boite-de-dialogue-de-validation-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"veri do\u011frulama ileti\u015fim kutusu\" width=\"420\" height=\"327\"><\/figure><\/div><p> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n<\/p><p> Art\u0131k h\u00fccreye d\u00f6nd\u00fc\u011f\u00fcn\u00fczde, h\u00fccreye eklenecek de\u011feri se\u00e7ebilece\u011finiz bir a\u00e7\u0131l\u0131r listeniz olacak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47578\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/42-liste-deroulante-a-partir-de-laquelle-vous-pouvez-selectionner-la-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"de\u011feri-se\u00e7ebilece\u011finiz-yerden-a\u00e7\u0131l\u0131r liste\" width=\"182\" height=\"128\"><\/figure><\/div><p> <strong>A\u00e7\u0131l\u0131r listeler hakk\u0131nda daha fazla bilgi edinin<\/strong><\/p><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/\">Ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/\">Dinamik a\u00e7\u0131l\u0131r liste<\/a><\/li><\/ul><h3 id=\"16-15-conditional-formatting\" class=\"wp-block-heading\"> 15. Ko\u015fullu Bi\u00e7imlendirme<\/h3><p> Ko\u015fullu bi\u00e7imlendirmenin temel fikri, bi\u00e7imlendirme i\u00e7in ko\u015fullar\u0131 ve form\u00fclleri kullanmakt\u0131r ve en iyi yan\u0131, tek t\u0131klamayla uygulayabilece\u011finiz 20&#8217;den fazla se\u00e7ene\u011fin olmas\u0131d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47579\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/43-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"ko\u015fullu bi\u00e7imlendirme\" width=\"252\" height=\"430\"><\/figure><\/div><p> Bir h\u00fccre aral\u0131\u011f\u0131ndaki <a href=\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/\">t\u00fcm yinelenen de\u011ferleri vurgulamak<\/a> istedi\u011finizi varsayal\u0131m, sadece Giri\u015f sekmesine gidin \u279c Ko\u015fullu Bi\u00e7imlendirme \u279c Kurallar\u0131 Vurgula \u279c Yinelenen De\u011ferler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47580\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/44-regles-de-surbrillance-de-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"ko\u015fullu bi\u00e7imlendirme vurgulama kurallar\u0131\" width=\"398\" height=\"439\"><\/figure><\/div><p> Ayr\u0131ca uygulayabilece\u011finiz veri \u00e7ubuklar\u0131, renk becerileri ve simgeleriniz de var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47581\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/45-competences-et-icones-de-couleurs-de-barres-de-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"veri-renkli-beceri-ve-simge-\u00e7ubuklar\u0131\" width=\"204\" height=\"345\"><\/figure><\/div><p> T\u00fcm se\u00e7enekleri inceledi\u011finizden emin olun ve <a href=\"https:\/\/exceladvisor.org\/tr\/formuller-1\/\" data-wpil=\"url\">ko\u015fullu bi\u00e7imlendirmede form\u00fcllerin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek istiyorsan\u0131z bu k\u0131lavuza g\u00f6z at\u0131n<\/a> .<\/p><h3 id=\"17-16-excel-table\" class=\"wp-block-heading\"> 16. Excel tablosu<\/h3><p> Excel tablosu normal verileri, verileri kolayca s\u0131ralayabilece\u011finiz, <a href=\"https:\/\/exceladvisor.org\/tr\/filtre-1\/\">filtreleyebilece\u011finiz<\/a> ve analiz edebilece\u011finiz yap\u0131land\u0131r\u0131lm\u0131\u015f bir tabloya d\u00f6n\u00fc\u015ft\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47582\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/46-tableau-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel tablosu\" width=\"408\" height=\"313\"><\/figure><\/div><p> Normal verilerinizi bir Excel tablosuna d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in <strong>Ctrl + T<\/strong> klavye k\u0131sayolunu kullanman\u0131z yeterlidir veya Ekle \u279c Tablo sekmesine de gidebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47583\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/47-inserer-un-tableau-donglets.png\" sizes=\"auto, \" srcset=\"\" alt=\"sekme tablosu ekle\" width=\"284\" height=\"169\"><\/figure><\/div><p> <strong><a href=\"https:\/\/support.office.com\/en-us\/article\/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c\">Microsoft Excel Tablolar\u0131<\/a> | <a href=\"https:\/\/exceladvisor.org\/tr\/tabloyu-yeniden-adlandir\/\">Excel tablosunu yeniden adland\u0131r\u0131n<\/a> | <a href=\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/\">Excel dilimleyici<\/a><\/strong><\/p><h3 id=\"18-17-idea-button\" class=\"wp-block-heading\"> 17. Fikir d\u00fc\u011fmesi<\/h3><p> Office 365 kullan\u0131yorsan\u0131z Microsoft taraf\u0131ndan sunulan ve a\u015fa\u011f\u0131dakileri olu\u015fturman\u0131n olas\u0131 yollar\u0131n\u0131 \u00f6nererek verilerinizi basit bir \u015fekilde analiz etmenize yard\u0131mc\u0131 olabilecek yeni Fikir d\u00fc\u011fmesine eri\u015febilirsiniz:<\/p><ul><li> PivotTable&#8217;lar<\/li><li> Trend Grafikleri<\/li><li> Frekans da\u011f\u0131l\u0131m tablosu<\/li><\/ul><p> Verileri se\u00e7meniz ve ard\u0131ndan ana sayfa sekmesinde bulunan fikir d\u00fc\u011fmesine 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-47584\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/48-bouton-didee.png\" sizes=\"auto, \" srcset=\"\" alt=\"fikir d\u00fc\u011fmesi\" width=\"74\" height=\"107\"><\/figure><\/div><p> Verileri analiz etmek ve ard\u0131ndan size olas\u0131 sonu\u00e7lar\u0131n bir listesini g\u00f6stermek birka\u00e7 saniye s\u00fcrer. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47585\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/49-liste-des-resultats-possibles.png\" sizes=\"auto, \" srcset=\"\" alt=\"olas\u0131 sonu\u00e7lar\u0131n listesi\" width=\"271\" height=\"385\"><\/figure><\/div><h3 id=\"19-18-using-sparklines\" class=\"wp-block-heading\"> 18. Mini Grafikleri Kullan\u0131n<\/h3><p> Mini grafikler, bir dizi veriye dayal\u0131 olarak bir h\u00fccreye ekleyebilece\u011finiz k\u00fc\u00e7\u00fck grafiklerdir.<\/p><p> Mini grafik eklemek i\u00e7in Ekle \u279c Mini Grafikler sekmesine gitmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47586\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/50-en-utilisant-des-sparklines.png\" sizes=\"auto, \" srcset=\"\" alt=\"mini grafikler kullan\u0131n\" width=\"534\" height=\"244\"><\/figure><\/div><p> Bir h\u00fccreye ekleyebilece\u011finiz 3 t\u00fcr mini grafik vard\u0131r.<\/p><ul><li> \u00c7ift<\/li><li> Kolon<\/li><li> Kazan kaybet <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47587\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/51-types-de-lignes-scintillantes.png\" sizes=\"auto, \" srcset=\"\" alt=\"mini \u00e7izgi t\u00fcrleri\" width=\"111\" height=\"120\"><\/figure><\/div><p> K\u00f6p\u00fckl\u00fc d\u00fc\u011fmeye t\u0131klad\u0131\u011f\u0131n\u0131zda, veri aral\u0131\u011f\u0131n\u0131 ve parlak hedef aral\u0131\u011f\u0131n\u0131 se\u00e7meniz gereken bir ileti\u015fim kutusu g\u00f6r\u00fcnecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47588\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boite-de-dialogue-de-52-boutons-scintillants.png\" sizes=\"auto, \" srcset=\"\" alt=\"ileti\u015fim kutusu parlak d\u00fc\u011fmesi\" width=\"305\" height=\"197\"><\/figure><\/div><p> Bunun d\u0131\u015f\u0131nda, mini \u00e7izgi sekmesinden rengini de\u011fi\u015ftirerek, i\u015faret\u00e7iler ekleyerek ve \u00e7ok daha fazlas\u0131n\u0131 yaparak bir mini \u00e7izgiyi \u00f6zelle\u015ftirme se\u00e7enekleriniz vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47589\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/53-options-pour-personnaliser-un-sparkline.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir mini \u00e7izgiyi-\u00f6zelle\u015ftirme se\u00e7enekleri\" width=\"510\" height=\"100\"><\/figure><\/div><figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\"><\/div><\/figure><h3 id=\"20-19-text-to-column\" class=\"wp-block-heading\"> 19. S\u00fctun metni<\/h3><p> Metni s\u00fctuna d\u00f6n\u00fc\u015ft\u00fcrme se\u00e7ene\u011fiyle, tek bir s\u00fctunu ay\u0131r\u0131c\u0131 kullanarak birden \u00e7ok s\u00fctuna b\u00f6lebilirsiniz. Verilerinizi temizlemenin ve d\u00f6n\u00fc\u015ft\u00fcrmenin en iyi yollar\u0131ndan biridir. <\/p><figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\"> https:\/\/www.youtube.com\/watch?v=nVwFmusomfEu0026t=9s<\/div><\/figure><p> \u0130simlerin bulundu\u011fu bir s\u00fctunun bulundu\u011fu ve ad ile soyad\u0131 aras\u0131nda bo\u015fluk bulunan a\u015fa\u011f\u0131daki tabloya bak\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47590\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/54-texte-en-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctundaki metin\" width=\"199\" height=\"316\"><\/figure><\/div><p> Ay\u0131r\u0131c\u0131 olarak bo\u015fluk kullanarak s\u00fctundaki metni kullanarak bu s\u00fctunu iki farkl\u0131 s\u00fctuna (ad ve soyad\u0131) b\u00f6lebilirsiniz.<\/p><ul><li> \u00d6ncelikle Veri sekmesine gidin ve Metni S\u00fctuna D\u00f6n\u00fc\u015ft\u00fcr 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-47591\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/55-cliquez-sur-le-texte-a-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"metni s\u00fctuna d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in t\u0131klay\u0131n\" width=\"164\" height=\"135\"><\/figure><\/div><ul><li> \u015eimdi ileti\u015fim kutusunda s\u0131n\u0131rlay\u0131c\u0131y\u0131 se\u00e7in ve ileri&#8217;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-47592\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/56-boite-de-dialogue-selectionner-le-delimiteur.png\" sizes=\"auto, \" srcset=\"\" alt=\"diyalog-se\u00e7im-s\u0131n\u0131rlay\u0131c\u0131\" width=\"549\" height=\"202\"><\/figure><\/div><ul><li> Bundan sonra alan\u0131 kontrol edin. G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi s\u00fctun de\u011ferlerini bo\u015fluk kullanarak ay\u0131rd\u0131. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47593\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/57-cochez-lespace.png\" sizes=\"auto, \" srcset=\"\" alt=\"alan\u0131 kontrol et\" width=\"556\" height=\"437\"><\/figure><\/div><ul><li> Sonunda ileri&#8217;yi t\u0131klay\u0131n ve ard\u0131ndan bitirin.<\/li><\/ul><p> Son&#8217;u t\u0131klad\u0131\u011f\u0131n\u0131z anda, bu tam ad s\u00fctununu iki farkl\u0131 s\u00fctuna ( <a href=\"https:\/\/exceladvisor.org\/tr\/ilk-son-kelimeyi-al\/\">ad ve soyad\u0131<\/a> ) d\u00f6n\u00fc\u015ft\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47594\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/58-une-colonne-de-noms-complets-en-deux-colonnes-differentes.png\" sizes=\"auto, \" srcset=\"\" alt=\"iki farkl\u0131 s\u00fctundaki tam adlardan olu\u015fan bir s\u00fctun\" width=\"264\" height=\"265\"><\/figure><\/div><h3 id=\"21-20-quick-analysis-tool\" class=\"wp-block-heading\"> 20.H\u0131zl\u0131 Tarama Arac\u0131<\/h3><p> Ad\u0131ndan da anla\u015f\u0131laca\u011f\u0131 gibi <a href=\"https:\/\/exceladvisor.org\/tr\/hizli-analiz-araci\/\">H\u0131zl\u0131 Analiz arac\u0131<\/a> , verileri bir veya iki t\u0131klamayla analiz etmenize olanak tan\u0131r. S\u00f6ylemeye \u00e7al\u0131\u015ft\u0131\u011f\u0131m \u015fey, verileri analiz etmenize ve sunman\u0131za yard\u0131mc\u0131 olabilecek se\u00e7ilmi\u015f se\u00e7eneklerden baz\u0131lar\u0131n\u0131 i\u00e7ermesidir.<\/p><p> A\u015fa\u011f\u0131da, se\u00e7ti\u011finiz andaki puanlar\u0131yla birlikte \u00f6\u011frencilerin verileri bulunur; ekran\u0131n alt k\u0131sm\u0131nda h\u0131zl\u0131 analiz arac\u0131 d\u00fc\u011fmesi olan k\u00fc\u00e7\u00fck bir simge bulunur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47595\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/59-outil-danalyse-rapide.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u0131zl\u0131 tarama arac\u0131\" width=\"364\" height=\"190\"><\/figure><\/div><p> Art\u0131k \u00fczerine t\u0131klad\u0131\u011f\u0131n\u0131zda, se\u00e7enekleri se\u00e7ebilece\u011finiz birka\u00e7 sekme g\u00f6sterilir. \u015eimdi her sekmeyi tek tek inceleyelim.<\/p><ul><li> <strong>Bi\u00e7imlendirme<\/strong> : Bu sekme, se\u00e7ili tabloya veri \u00e7ubuklar\u0131, renk \u00f6l\u00e7e\u011fi, simge k\u00fcmeleri ve di\u011fer ko\u015fullu bi\u00e7imlendirme kurallar\u0131 gibi ko\u015fullu bi\u00e7imlendirme eklemenizi sa\u011flar. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47596\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/60-onglet-de-formatage.png\" sizes=\"auto, \" srcset=\"\" alt=\"bi\u00e7imlendirme sekmesi\" width=\"378\" height=\"146\"><\/figure><\/div><ul><li> <strong>Grafikler:<\/strong> Bu sekme, se\u00e7ilen verilerle ekleyebilece\u011finiz \u00f6nerilen grafiklerden baz\u0131lar\u0131n\u0131 g\u00f6sterir veya belirli bir grafi\u011fi se\u00e7mek i\u00e7in di\u011fer grafiklere de t\u0131klayabilirsiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47597\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/61-graphiques-recommandes-dans-longlet-graphique.png\" sizes=\"auto, \" srcset=\"\" alt=\"grafik-sekmesinde \u00f6nerilen grafikler\" width=\"427\" height=\"165\"><\/figure><\/div><ul><li> <strong>Toplam:<\/strong> Bu sekmeden, ortalama say\u0131m, toplam toplam ve daha pek \u00e7ok temel form\u00fclden baz\u0131lar\u0131n\u0131 h\u0131zl\u0131 bir \u015fekilde ekleyebilirsiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47598\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/62-formules-de-base-dans-longlet-total.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplam-sekmesindeki temel form\u00fcller\" width=\"420\" height=\"162\"><\/figure><\/div><ul><li> <strong>Tablo<\/strong> : Bu sekmeden se\u00e7ilen verilerle bir pivot tablo ekleyebilir ve buna bir Excel tablosu da uygulayabilirsiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47599\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/63-tableau-croise-dynamique-dans-longlet-tableau.png\" sizes=\"auto, \" srcset=\"\" alt=\"tablo sekmesindeki pivot tablo\" width=\"430\" height=\"166\"><\/figure><\/div><ul><li> <strong>Mini Grafikler<\/strong> : Bu sekme, asl\u0131nda bir h\u00fccrede olu\u015fturabilece\u011finiz k\u00fc\u00e7\u00fck grafikler olan mini grafikler eklemenizi sa\u011flar. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47600\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Onglet-64-sparklines.png\" sizes=\"auto, \" srcset=\"\" alt=\"mini grafikler sekmesi\" width=\"373\" height=\"144\"><\/figure><\/div><h2 id=\"22-advanced-excel-skills\" class=\"wp-block-heading\"> <strong>\u0130leri Excel becerileri<\/strong><\/h2><p> Geli\u015fmi\u015f Excel becerileri daha \u00e7ok karma\u015f\u0131k sorunlar\u0131 \u00e7\u00f6zme ve Excel&#8217;de yap\u0131lan t\u00fcm i\u015fleri yaparken verimli olman\u0131z\u0131 sa\u011flamayla ilgilidir ve a\u015fa\u011f\u0131da uzmanla\u015fman\u0131z gereken en iyi geli\u015fmi\u015f Excel becerilerine sahipsiniz.<\/p><h3 id=\"23-21-advanced-excel-formulas\" class=\"wp-block-heading\"> 21. Geli\u015fmi\u015f Excel Form\u00fclleri<\/h3><p> GEL\u0130\u015eM\u0130\u015e EXCEL FORM\u00dcL\u00dc ( <a href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fclleri listesi<\/a> ), ba\u015fka t\u00fcrl\u00fc hesaplanamayan belirli bir de\u011feri hesaplamak i\u00e7in farkl\u0131 i\u015flevleri birle\u015ftirmeyi i\u00e7erir. A\u015fa\u011f\u0131da en \u00f6nemlilerinden baz\u0131lar\u0131n\u0131n bir listesi bulunmaktad\u0131r: <\/p><div id=\"ub-content-toggle-3aabcbf5-3f0c-456d-a1a8-b97f26911c89\" 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-3aabcbf5-3f0c-456d-a1a8-b97f26911c89\"><p class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-3aabcbf5-3f0c-456d-a1a8-b97f26911c89\"> Form\u00fcller hakk\u0131nda daha fazla bilgi edinin <\/p><\/div><div id=\"ub-content-toggle-panel-0-3aabcbf5-3f0c-456d-a1a8-b97f26911c89\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-maksimum-degerler\/\">En y\u00fcksek ortalama de\u011ferler<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/saat-farkini-hesapla\/\">Saat fark\u0131n\u0131 hesapla<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bilesik-faiz\/\">Bile\u015fik Faiz Hesaplay\u0131c\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sonunu-birlestirme\/\">Yeni sat\u0131rla birle\u015ftir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kosullu-siralama-toplami-carpim-siralamasi-eger\/\">IF SIRALAMA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-urun-2\/\">\u00d6ZET\u00dcR\u00dcN<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-urundeki-durum\/\">\u00d6ZET E\u011eER \u00c7ARPIM<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metin-iceren-hucreleri-say\/\">Metin i\u00e7eren h\u00fccreleri say<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayimlar-sayim-veya-mantiksal\/\">NOT.E\u011eER VEYA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/\">Benzersiz de\u011ferleri say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kelimeleri-say\/\">Kelimeleri say<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ayin-gunleri\/\">Bir aydaki toplam g\u00fcn say\u0131s\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/\">Ay sonu tarihini al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/referans-3d\/\">Excel 3D aral\u0131\u011f\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-harfler-olustur\/\">Rastgele Harf Olu\u015fturucu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gunun-adini-ogren\/\">Tarihten g\u00fcn\u00fc \u00e7\u0131kar<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ilk-son-kelimeyi-al\/\">\u0130lk ve son kelimeyi \u00e7\u0131kar\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iferror-gorunumu\/\">D\u00dc\u015eEYARA ile E\u011eERHATA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/\">E\u015eLE\u015eEN ENDEKS<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bastaki-sifirlar\/\">Ba\u015fa s\u0131f\u0131rlar\u0131 ekle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/maksimum-ise\/\">MAX IF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/\">Tarihten itibaren ay\u0131 al<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ceyrek\/\">\u00c7eyrek Form\u00fcl\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rapor\/\">Oran\u0131 hesapla<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/fazladan-bosluklari-kaldir\/\">Fazladan bo\u015fluklar\u0131 kald\u0131r\u0131n<\/a><\/li><li> \u0130lk karakteri sil<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cumle-durumu\/\">Ceza davas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kare-kok\/\">Kare k\u00f6k<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sumif-sumifler-veya-mantik\/\">NEREDE<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/joker-karakterli-sutif\/\">ETOPLA joker karakteri<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-degerlerin-toplami\/\">\u0130ki tarih aras\u0131ndaki ETOPLA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cift-yonlu-arama\/\">\u0130ki y\u00f6nl\u00fc arama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vssearch-eslesmesi\/\">MA\u00c7 G\u00d6R\u00dcNT\u00dcS\u00dc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/agirlikli-ortalama\/\">A\u011f\u0131rl\u0131kl\u0131 ortalama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vlookup-ozellikli-joker-karakterler\/\">Joker karakter D\u00dc\u015eEYARA<\/a><\/li><\/ul><\/div><\/div><\/div><h3 id=\"24-22-advanced-excel-charts\" class=\"wp-block-heading\"> 22. Geli\u015fmi\u015f Excel Grafikleri<\/h3><p> G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi Excel&#8217;deki grafiklerin \u00e7o\u011funu sadece birka\u00e7 t\u0131klamayla olu\u015fturabiliyorsunuz ancak t\u00fcm bu grafiklerin d\u0131\u015f\u0131nda geli\u015fmi\u015f grafikler de olu\u015fturabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-48308\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-competences-graphiques-avancees.png\" sizes=\"auto, \" srcset=\"\" alt=\"geli\u015fmi\u015f-grafik-becerileri-excel\" width=\"718\" height=\"437\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/gelismis-grafikler\/\">Geli\u015fmi\u015f Excel grafikleri<\/a> belirli bir amaca hizmet eder ve verilerin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 ve sunulaca\u011f\u0131n\u0131 \u00f6\u011frenmek i\u00e7in birka\u00e7 dakikan\u0131z\u0131 harcaman\u0131z\u0131 gerektirir. A\u015fa\u011f\u0131da, Excel&#8217;de olu\u015fturmay\u0131 \u00f6\u011frenebilece\u011finiz baz\u0131 geli\u015fmi\u015f grafiklerin bir listesi (e\u011fitimler) bulunmaktad\u0131r. <\/p><div id=\"ub-content-toggle-ac3cfe76-4e9d-4dab-b994-995e23df569b\" 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-ac3cfe76-4e9d-4dab-b994-995e23df569b\"><p class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ac3cfe76-4e9d-4dab-b994-995e23df569b\"> Grafikler hakk\u0131nda daha fazla bilgi edinin <\/p><\/div><div id=\"ub-content-toggle-panel-0-ac3cfe76-4e9d-4dab-b994-995e23df569b\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gozleme-grafigi\/\">G\u00f6zleme Boyama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/\">Kas\u0131rga grafi\u011fi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/termometre-masasi\/\">Termometre grafi\u011fi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hiz-gostergesi\/\" data-wpil=\"url\">H\u0131z g\u00f6stergesi tablosu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/piramit-diyagrami\/\">Piramit grafi\u011fi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kisi-tablosu\/\">Ki\u015fi Tablosu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kilometre-tasi-grafigi\/\">Ad\u0131m tablosu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/histogram\/\">Histogram<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sicaklik-haritasi\/\">S\u0131cakl\u0131k haritas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/huni-grafigi\/\">Sat\u0131\u015f Hunisi Tablosu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kursun-tahtasi\/\">Madde i\u015fareti grafi\u011fi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/piktogram\/\">Piktograf<\/a><\/li><\/ul><\/div><\/div><\/div><h3 id=\"25-23-visual-basic-for-applications\" class=\"wp-block-heading\"> 23. Uygulamalar i\u00e7in Visual Basic<\/h3><p> VBA, Microsoft Office uygulamalar\u0131na y\u00f6nelik <a href=\"https:\/\/exceladvisor.org\/tr\/nesneler\/\">nesne y\u00f6nelimli bir programlama dilidir<\/a> ve normalde manuel olarak ger\u00e7ekle\u015ftirdi\u011finiz etkinlikleri otomatikle\u015ftirmek amac\u0131yla VBA kodlar\u0131 yazmak i\u00e7in onu Excel&#8217;de kullanabilirsiniz. <\/p><div id=\"ub-content-toggle-b5163ad1-291d-4a05-8def-6a244e02ba68\" class=\"wp-block-ub-content-toggle\" data-mobilecollapse=\"false\" data-desktopcollapse=\"false\"><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"true\" aria-controls=\"ub-content-toggle-panel-0-b5163ad1-291d-4a05-8def-6a244e02ba68\"><p class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-b5163ad1-291d-4a05-8def-6a244e02ba68\"> VBA hakk\u0131nda daha fazla bilgi edinin <\/p><\/div><div id=\"ub-content-toggle-panel-0-b5163ad1-291d-4a05-8def-6a244e02ba68\" class=\"wp-block-ub-content-toggle-accordion-content-wrap\" role=\"region\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">VBA nedir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">Excel programlama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\">Makro kaydetme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Makro \u00e7al\u0131\u015ft\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\">VBA edit\u00f6r\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\">Ki\u015fisel Makrolar \u00c7al\u0131\u015fma Kitab\u0131<\/a><\/li><li> VBA kod kitapl\u0131\u011f\u0131<\/li><\/ul><\/div><\/div><\/div><h3 id=\"26-24-power-query\" class=\"wp-block-heading\"> 24. PowerQuery<\/h3><p> Verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z eminim ki kullanmadan \u00f6nce verileri temizlemeniz ve d\u00f6n\u00fc\u015ft\u00fcrmeniz gereken bir durumla kar\u015f\u0131la\u015f\u0131rs\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-48289\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/apprendre-la-requete-de-puissance.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6\u011frenme sorgusu\" width=\"487\" height=\"276\"><\/figure><\/div><p> Art\u0131k veri temizleme ve veri d\u00f6n\u00fc\u015ft\u00fcrme s\u0131k\u0131c\u0131 bir s\u00fcre\u00e7tir ve her g\u00fcn zaman\u0131n\u0131z\u0131n \u00e7o\u011funu buna harcaman\u0131z gerekir. Ancak Power Query ile t\u00fcm bu temizleme ve d\u00f6n\u00fc\u015ft\u00fcrme i\u015flemini yaln\u0131zca birka\u00e7 t\u0131klamayla ger\u00e7ekle\u015ftirebilirsiniz.<\/p><p> G\u00fc\u00e7 sorgusu temel olarak farkl\u0131 kaynaklardan <strong>veri \u00e7\u0131karabilece\u011finiz<\/strong> , <strong>d\u00f6n\u00fc\u015ft\u00fcrebilece\u011finiz<\/strong> ve ard\u0131ndan elektronik tabloya <strong>yeniden y\u00fckleyebilece\u011finiz<\/strong> bir ETL gibi \u00e7al\u0131\u015f\u0131r. Bu kapsaml\u0131 <strong><a href=\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\">Power Query<\/a><\/strong> e\u011fitimine g\u00f6z at\u0131n ve birden \u00e7ok Excel dosyas\u0131n\u0131 nas\u0131l birle\u015ftirece\u011finizi \u00f6\u011frenmeyi unutmay\u0131n.<\/p><h3 id=\"27-25-power-pivot\" class=\"wp-block-heading\"> 25.PowerPivot<\/h3><p> Power Pivot, temel olarak, birden fazla kaynaktan milyonlarca sat\u0131rl\u0131k verileri i\u00e7eri aktarmak ve ard\u0131ndan hesaplamalar (DAX) ger\u00e7ekle\u015ftirmek i\u00e7in kullanabilece\u011finiz bir veri modelleme tekni\u011fidir.<\/p><p> Power Pivot&#8217;u kullanmaya ba\u015flama \u2013 <a href=\"https:\/\/support.office.com\/en-us\/article\/power-pivot-overview-and-learning-f9001958-7901-4caa-ad80-028a6d2432ed\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Power Pivot - Overview and Learning (opens in a new tab)\">Power Pivot \u2013 Genel bak\u0131\u015f ve \u00f6\u011frenme<\/a><\/p><p> <strong>Daha fazla bilgi edin<\/strong><\/p><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tavsiye\/\" data-wpil=\"url\">Excel \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pencereyi-izle\/\">Excel \u0130zleme Penceresi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-formul-cubugu\/\">Excel Form\u00fcl \u00c7ubu\u011fu<\/a><\/li><\/ul>","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-1484","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>\u25b7 25 En \u0130yi Excel Becerisi (Temelden \u0130leri D\u00fczey&#039;e)<\/title>\n<meta name=\"description\" content=\"Bu k\u0131lavuz, Excel&#039;de uzmanla\u015fmak isteyen herkesin bilmesi gereken en iyi 25 Excel becerisini (Temel + Orta + \u0130leri) kapsar.\" \/>\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\/excel-becerileri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 25 En \u0130yi Excel Becerisi (Temelden \u0130leri D\u00fczey&#039;e)\" \/>\n<meta property=\"og:description\" content=\"Bu k\u0131lavuz, Excel&#039;de uzmanla\u015fmak isteyen herkesin bilmesi gereken en iyi 25 Excel becerisini (Temel + Orta + \u0130leri) kapsar.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-et-ouvrir-un-classeur.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=\"19 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\",\"name\":\"\u25b7 25 En \u0130yi Excel Becerisi (Temelden \u0130leri D\u00fczey&#39;e)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-et-ouvrir-un-classeur.png\",\"datePublished\":\"2023-11-22T10:39:02+00:00\",\"dateModified\":\"2023-12-10T05:59:26+00:00\",\"description\":\"Bu k\u0131lavuz, Excel&#39;de uzmanla\u015fmak isteyen herkesin bilmesi gereken en iyi 25 Excel becerisini (Temel + Orta + \u0130leri) kapsar.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-et-ouvrir-un-classeur.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-et-ouvrir-un-classeur.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"En i\u0307yi 25 excel becerisi (temelden i\u0307leri d\u00fczey&#39;e)\"}]},{\"@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":"\u25b7 25 En \u0130yi Excel Becerisi (Temelden \u0130leri D\u00fczey&#39;e)","description":"Bu k\u0131lavuz, Excel&#39;de uzmanla\u015fmak isteyen herkesin bilmesi gereken en iyi 25 Excel becerisini (Temel + Orta + \u0130leri) kapsar.","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\/excel-becerileri\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 25 En \u0130yi Excel Becerisi (Temelden \u0130leri D\u00fczey&#39;e)","og_description":"Bu k\u0131lavuz, Excel&#39;de uzmanla\u015fmak isteyen herkesin bilmesi gereken en iyi 25 Excel becerisini (Temel + Orta + \u0130leri) kapsar.","og_url":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-et-ouvrir-un-classeur.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"19 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/","url":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/","name":"\u25b7 25 En \u0130yi Excel Becerisi (Temelden \u0130leri D\u00fczey&#39;e)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-et-ouvrir-un-classeur.png","datePublished":"2023-11-22T10:39:02+00:00","dateModified":"2023-12-10T05:59:26+00:00","description":"Bu k\u0131lavuz, Excel&#39;de uzmanla\u015fmak isteyen herkesin bilmesi gereken en iyi 25 Excel becerisini (Temel + Orta + \u0130leri) kapsar.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/excel-becerileri\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-et-ouvrir-un-classeur.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-et-ouvrir-un-classeur.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"En i\u0307yi 25 excel becerisi (temelden i\u0307leri d\u00fczey&#39;e)"}]},{"@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\/1484","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=1484"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1484\/revisions"}],"predecessor-version":[{"id":2324,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1484\/revisions\/2324"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}