{"id":1657,"date":"2023-11-13T08:55:32","date_gmt":"2023-11-13T08:55:32","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/"},"modified":"2023-12-10T05:59:31","modified_gmt":"2023-12-10T05:59:31","slug":"excel-dilimleyici","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/","title":{"rendered":"Excel dilimleyici: excel&#39;deki verileri filtrelemenin en i\u0307yi yolu"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1165839444\"><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>Excel&#8217;de verileri h\u0131zl\u0131 bir \u015fekilde analiz etmenin en iyi yollar\u0131ndan biri filtreleri kullanmakt\u0131r ve verileri filtrelemenin en iyi yolu da SLICER&#8217;\u0131 kullanmakt\u0131r, nokta.<\/p><p> Slicer, veri filtreleme deneyiminizi \u00f6nemli \u00f6l\u00e7\u00fcde geli\u015ftirir. H\u0131zl\u0131, g\u00fc\u00e7l\u00fc ve kullan\u0131m\u0131 kolayd\u0131r.<\/p><p> Bu nedenle <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\">ileri d\u00fczey Excel becerilerimizin<\/a> bir par\u00e7as\u0131d\u0131r ve bug\u00fcn bu e\u011fitimde bunu ayr\u0131nt\u0131l\u0131 olarak inceleyece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Excel dilimleyici nedir<\/h2><p> Excel dilimleyici, bir s\u00fctundaki verileri filtrelemek i\u00e7in kullanabilece\u011finiz bir dizi d\u00fc\u011fmedir. Standart bir filtreden farkl\u0131 olarak, filtrelemek i\u00e7in kullanabilece\u011finiz t\u00fcm mevcut \u00f6\u011feleri d\u00fc\u011fmeler halinde g\u00f6sterir. Bir tablo veya pivot tabloya ba\u011flay\u0131p istedi\u011finiz gibi \u00f6zelle\u015ftirebilirsiniz (Renk, Font, Butonlar vb.).<\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de tablo i\u00e7eren bir segment ekleme<\/h2><p> Bir Excel tablosuna D\u0130L\u0130MLEME eklemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin.<\/p><ol><li> Verileri (\u0130ND\u0130R) bir Excel tablosuna d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u00f6ncelikle <span style=\"background-color: #ffff00;\"><strong>CTRL+T tu\u015flar\u0131na bas\u0131n<\/strong><\/span> veya ayr\u0131ca Ekle sekmesine gidip tabloya da t\u0131klayabilirsiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"Verileri d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in 1-ctrlt tu\u015funa bas\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appuyez-sur-ctrlt-pour-convertir-les-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"527\" height=\"421\"><\/li><li> Bundan sonra, tablo h\u00fccrelerinden birini se\u00e7in ve ard\u0131ndan \u2192 <strong><span style=\"background-color: #ffff00;\">Sekme Ekle \u2192 Dilimleyici se\u00e7ene\u011fine<\/span><\/strong> gidin (dilimleyici d\u00fc\u011fmesine t\u0131klay\u0131n). <br><img loading=\"lazy\" decoding=\"async\" title=\"2-Tablodan herhangi bir h\u00fccreyi se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionnez-nimporte-quelle-cellule-du-tableau.png\" sizes=\"auto, \" srcset=\"\" alt=\"Select any cell from the table\" width=\"721\" height=\"98\"><\/li><li> D\u00fc\u011fmeye t\u0131klad\u0131\u011f\u0131n\u0131zda, dilimleyici eklemek \u00fczere t\u00fcm <span style=\"background-color: #ffff00;\"><strong>s\u00fctun adlar\u0131n\u0131<\/strong><\/span> se\u00e7ebilece\u011finiz bir ileti\u015fim kutusu a\u00e7\u0131l\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-t\u00fcm-ba\u015fl\u0131klar\u0131n-oldu\u011fu-bir-ileti\u015fim kutunuz var\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vous-avez-une-boite-de-dialogue-avec-tous-les-en-tetes.png\" sizes=\"auto, \" srcset=\"\" alt=\"you have dialogue box with all the headers\" width=\"281\" height=\"518\"><\/li><li> Sonunda, filtre olarak kullanmak istedi\u011finiz <strong><span style=\"background-color: #ffff00;\">s\u00fctunu i\u015faretleyin<\/span><\/strong> (birden fazla s\u00fctunu da i\u015faretleyebilirsiniz) ve Tamam&#8217;\u0131 t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-kullanmak istedi\u011finiz s\u00fctunu kontrol edin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cochez-la-colonne-que-vous-souhaitez-utiliser.png\" sizes=\"auto, \" srcset=\"\" alt=\"tick mark the column that you want to use\" width=\"280\" height=\"515\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Pivot tablolu bir dilimleyici ekleme<\/h2><ul><li> Pivot tablonun herhangi bir yerine t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"6-pivot dizili-bir-dilimleyici-ekleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-inserer-un-slicer-avec-un-tableau-croise-dynamique.png\" sizes=\"\" srcset=\"\" alt=\"insert a slicer with a pivot table\"><\/li><li> Bundan sonra \u2192 Ekle \u2192 Dilimleyici se\u00e7ene\u011fine gidin. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-giri\u015fli dilimleyici\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-aller-a-inserer-la-trancheuse.png\" sizes=\"auto, \" srcset=\"\" alt=\"go to insert slicer\" width=\"617\" height=\"84\"><\/li><li> Segmentte kullanmak istedi\u011finiz s\u00fctunu se\u00e7in. Burada alan\u0131 se\u00e7tik. <br><img loading=\"lazy\" decoding=\"async\" title=\"8-dilimleyicide kullanmak istedi\u011finiz s\u00fctunu se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-selectionnez-la-colonne-que-vous-souhaitez-utiliser-dans-le-slicer.png\" sizes=\"auto, \" srcset=\"\" alt=\"select the column that you want to use in the slicer\" width=\"323\" height=\"594\"><\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-sonunda-tamam-t\u0131klay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-a-la-fin-cliquez-sur-ok.png\" sizes=\"auto, \" srcset=\"\" alt=\"in the end click ok\" width=\"282\" height=\"184\"><\/li><\/ul><p> <em>\u0130lgili: <a href=\"https:\/\/exceladvisor.org\/tr\/dilimleyiciyi-birkac-pivot-tabloya-baglama\/\">Excel&#8217;de tek bir dilimleyiciyi birden \u00e7ok pivot tabloyla ba\u011flama\/ba\u011flama<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de Dilimleyici Nas\u0131l Kullan\u0131l\u0131r<\/h2><p> Art\u0131k Dilimleyicileri nas\u0131l yerle\u015ftirece\u011fimizi bildi\u011fimiz i\u00e7in Dilimleyicileri nas\u0131l kullanaca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz. \u015eimdi \u00fc\u00e7 \u00f6nemli konuyu tart\u0131\u015faca\u011f\u0131z.<\/p><h3 class=\"wp-block-heading\"> 1. Tek Dilimleyici \u00f6\u011fesini se\u00e7in<\/h3><p> Olduk\u00e7a basit. Dilimleyiciyi yerle\u015ftirir yerle\u015ftirmez verilerinizi filtrelemek i\u00e7in herhangi bir d\u00fc\u011fmeyi t\u0131klars\u0131n\u0131z. \u00c7ok basit bir \u00f6rnekle anlamaya \u00e7al\u0131\u015fal\u0131m.<\/p><p> Buraya bir B\u00f6lge dilimleyici ekledik. Maviyle vurgulanan d\u00fc\u011fmelerin (Do\u011fu, Kuzey, G\u00fcney ve Bat\u0131) t\u00fcm\u00fc se\u00e7ilir. Bu nedenle pivotta d\u00f6rt b\u00f6lgenin tamam\u0131ndan verileri g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52926\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-insere-une-trancheuse-dun.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir dilimleyici yerle\u015ftirdim\" width=\"564\" height=\"249\"><\/figure><\/div><p> Art\u0131k verilerimizi yaln\u0131zca kuzey b\u00f6lgesi i\u00e7in filtrelememiz gerekiyor. Kuzey d\u00fc\u011fmesine t\u0131klay\u0131n. Pivot tablo verileri otomatik olarak filtrelenecektir. Kuzey d\u00fc\u011fmesine t\u0131klad\u0131\u011f\u0131n\u0131zda di\u011fer t\u00fcm d\u00fc\u011fmeler bulan\u0131kla\u015facakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52927\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-filtrer-les-donnees-pour-la-zone-nord.png\" sizes=\"auto, \" srcset=\"\" alt=\"kuzey b\u00f6lgesi i\u00e7in verileri filtrele\" width=\"513\" height=\"287\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 2. Birden fazla biti\u015fik \u00f6\u011feyi se\u00e7in<\/h3><p> Peki iki veya daha fazla b\u00f6lgeden veri se\u00e7memiz gerekirse ne olur? Diyelim ki verileri Do\u011fu ve Bat\u0131 b\u00f6lgelerine g\u00f6re filtrelememiz gerekiyor. Bu \u00e7ok kolay. Sadece Ctrl tu\u015funa bas\u0131n ve filtrelemeniz gereken d\u00fc\u011fmelere t\u0131klay\u0131n.<\/p><p> Burada oldu\u011fu gibi Ctrl tu\u015funa bas\u0131p Do\u011fu ve Bat\u0131&#8217;ya t\u0131klayaca\u011f\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" title=\"Do\u011fu ve bat\u0131 b\u00f6lgesi i\u00e7in 12-filtre verisi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-filtrer-les-donnees-pour-la-zone-est-et-ouest.png\" sizes=\"\" srcset=\"\" alt=\"filter the data for east and west zone\"><\/figure><\/div><p> Ayr\u0131ca basit\u00e7e t\u0131klay\u0131p s\u00fcr\u00fckleyerek iki veya daha fazla ard\u0131\u015f\u0131k d\u00fc\u011fmeyi se\u00e7ebilirsiniz. Burada verileri Do\u011fu ve Kuzey, Kuzey veya G\u00fcney veya G\u00fcney ve Bat\u0131 olarak se\u00e7seydik bu y\u00f6ntemi kullanabilirdik.<\/p><h3 class=\"wp-block-heading\"> 3. Se\u00e7ilen \u00f6\u011feleri temizleyin<\/h3><p> Son ve en \u00f6nemli \u015fey filtreleri kald\u0131rmakt\u0131r. T\u00fcm filtreler kald\u0131r\u0131ld\u0131\u011f\u0131nda t\u00fcm verileriniz g\u00f6r\u00fcn\u00fcr olacak ve t\u00fcm d\u00fc\u011fmeler vurgulanacakt\u0131r. Bunu dilimleyicinin sa\u011f \u00fcst k\u00f6\u015fesindeki d\u00fc\u011fmeye basit bir t\u0131klamayla yapabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Segment format\u0131<\/h2><p> Art\u0131k dilimleyicilerle nas\u0131l \u00e7al\u0131\u015f\u0131laca\u011f\u0131n\u0131 bildi\u011fimize g\u00f6re bi\u00e7imlendirmeyle ba\u015flayal\u0131m.<\/p><blockquote class=\"wp-block-quote\"><p> <em>Yararl\u0131 ve sunulabilir raporlar s\u00f6z konusu oldu\u011funda format \u00f6nemli bir rol oynar. \u0130yi organize edilmi\u015f, g\u00f6z al\u0131c\u0131 ve g\u00fczel bir rapor di\u011ferlerinden daha fazla izleyici \u00e7ekecektir. Bu nedenle raporlar\u0131 ve Dilimleyicileri d\u00fczenlemek ve bi\u00e7imlendirmek \u00e7ok \u00f6nemlidir.<\/em><\/p><\/blockquote><h3 class=\"wp-block-heading\"> 1. Ba\u015fl\u0131klar\u0131 kald\u0131r\u0131n<\/h3><p> \u00d6zellikle bir kontrol paneli olu\u015ftururken \u00e7o\u011fu zaman raporlar\u0131m\u0131zda yer kalm\u0131yor. Dilimleyiciniz daha fazla yer kaplarsa endi\u015felenmeyin. Bunu birka\u00e7 \u015fekilde k\u0131saltabiliriz; bunlardan biri ba\u015fl\u0131klar\u0131 kald\u0131rmakt\u0131r.<\/p><p> \u00d6rne\u011fimizde Kuzey, Do\u011fu, Bat\u0131 ve G\u00fcney&#8217;in B\u00f6lgeler oldu\u011funu biliyoruz, dolay\u0131s\u0131yla &#8220;B\u00f6lge&#8221; ba\u015fl\u0131\u011f\u0131na ihtiyac\u0131m\u0131z yok. Ba\u015fl\u0131\u011f\u0131 kald\u0131ral\u0131m ve yerden tasarruf edelim.<\/p><p> Dilimleyici \u2192 Sa\u011f T\u0131klama \u2192 Dilimleyici Ayarlar\u0131&#8217;n\u0131 se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52930\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-selectionnez-le-slicer-cliquez-avec-le-bouton-droit-de-la-souris-sur-les-parametres-du-slicer.png\" sizes=\"auto, \" srcset=\"\" alt=\"dilimleyiciyi se\u00e7in dilimleyici ayarlar\u0131na sa\u011f t\u0131klay\u0131n\" width=\"215\" height=\"619\"><\/figure><\/div><p> \u201cBa\u015fl\u0131\u011f\u0131 g\u00f6ster\u201d se\u00e7ene\u011finin yan\u0131ndaki kutunun i\u015faretini kald\u0131r\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52931\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-decochez-la-case-contre-len-tete-daffichage.png\" sizes=\"auto, \" srcset=\"\" alt=\"ekran ba\u015fl\u0131\u011f\u0131n\u0131n yan\u0131ndaki kutunun i\u015faretini kald\u0131r\u0131n\" width=\"553\" height=\"372\"><\/figure><\/div><p> Ba\u015fl\u0131k kald\u0131r\u0131ld\u0131 ve biraz yer kazanabildik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52932\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-len-tete-est-supprime.png\" sizes=\"auto, \" srcset=\"\" alt=\"ba\u015fl\u0131k kald\u0131r\u0131ld\u0131\" width=\"314\" height=\"171\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 2. Yaz\u0131 tipini de\u011fi\u015ftirin<\/h3><p> Bilmeniz gereken bir sonraki \u015fey dilimleyicinin yaz\u0131 tipini nas\u0131l de\u011fi\u015ftirece\u011finizdir.<\/p><ul><li> Ba\u015flamak i\u00e7in \u015feritten ihtiya\u00e7lar\u0131n\u0131za en uygun stili se\u00e7in.<\/li><li> \u015eimdi sa\u011f t\u0131klay\u0131n ve kopyaya t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"17-sa\u011f t\u0131klama ve \u00e7ift t\u0131klama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-clic-droit-et-clic-sur-le-doublon.png\" sizes=\"auto, \" srcset=\"\" alt=\"right click and click on the duplicate\" width=\"497\" height=\"179\"><\/li><li> Burada \u201cDilimleme Elemanlar\u0131\u201d ileti\u015fim kutusu a\u00e7\u0131lacakt\u0131r. <br><img loading=\"lazy\" decoding=\"async\" title=\"18-burada-bir-dilimleyici-elemanlar\u0131-ileti\u015fim kutusu-a\u00e7\u0131lacak\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-ici-une-boite-de-dialogue-elements-slicer-va-souvrir.png\" sizes=\"auto, \" srcset=\"\" alt=\"here a dialogue box slicer elements will open\" width=\"467\" height=\"320\"><\/li><li> Ka\u00e7\u0131rm\u0131\u015f olman\u0131z durumunda, yinelenen dilimleyici stiline sa\u011f t\u0131klay\u0131n ve D\u00fczenle&#8217;ye t\u0131klay\u0131n.<\/li><li> \u015eimdi dilimleyicinin tamam\u0131na t\u0131klay\u0131n ve ard\u0131ndan Format&#8217;a t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"Dilimleyici her yerde 19 t\u0131klama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-clic-sur-tout-le-slicer.png\" sizes=\"auto, \" srcset=\"\" alt=\"click on the whole slicer\" width=\"552\" height=\"584\"><\/li><li> Yaz\u0131 tipini, kenarl\u0131klar\u0131 ve dolguyu gerekti\u011fi gibi \u00f6zelle\u015ftirin.<\/li><li> Tamam tu\u015funa bas\u0131n.<\/li><\/ul><h3 class=\"wp-block-heading\"> 3. S\u0131n\u0131rlar\u0131 Kald\u0131r\u0131n<\/h3><p> Kenarl\u0131klar\u0131 kald\u0131rmak, yaz\u0131 tipini de\u011fi\u015ftirmek kadar kolayd\u0131r. \u00d6ncelikle yaz\u0131 tipini de\u011fi\u015ftirmek i\u00e7in izledi\u011finiz ad\u0131mlar\u0131 tekrarlay\u0131n.<\/p><ul><li> Yinelenen dilimleyici stili \u2192 D\u00fczenle \u2192 Format \u2192 Kenarl\u0131k&#8217;\u0131 se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"20-kenarl\u0131klar\u0131 kald\u0131r\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-supprimer-les-bordures.png\" sizes=\"auto, \" srcset=\"\" alt=\"remove borders\" width=\"441\" height=\"198\"><\/li><li> Kenarl\u0131klar\u0131 kald\u0131rmak istedi\u011fimiz i\u00e7in \u201cYok\u201d se\u00e7ene\u011fini t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"21-kenarl\u0131klar\u0131-kald\u0131r\u0131n-sonra-hi\u00e7biri-t\u0131klay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-supprimez-les-bordures-alors-cliquez-sur-aucune.png\" sizes=\"auto, \" srcset=\"\" alt=\"remove borders so click on none\" width=\"459\" height=\"486\"><\/li><li> \u015eimdi Tamam&#8217;a t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"22-\u015fimdi-vur-tamam\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-maintenant-frappe-ok.png\" sizes=\"auto, \" srcset=\"\" alt=\"now hit ok\" width=\"551\" height=\"124\"><\/li><\/ul><h3 class=\"wp-block-heading\"> 4. Veri i\u00e7ermeyen \u00f6\u011feleri silin<\/h3><p> Bazen herhangi bir veri i\u00e7ermediklerinden dolay\u0131 vurgulanmayan \u00f6\u011felerle kar\u015f\u0131la\u015fabilirsiniz. \u00c7\u00fcnk\u00fc burada \u00fcr\u00fcn\u00fc se\u00e7ti\u011fimde \u201cChoco\u201d Do\u011fu ve G\u00fcney b\u00f6lgeleri aktif olmuyor. Bu, bu iki b\u00f6lgede \u201cChoco\u201d sat\u0131\u015f\u0131n\u0131n olmad\u0131\u011f\u0131 anlam\u0131na geliyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52939\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/23-supprimer-des-elements-sans-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"veri i\u00e7ermeyen \u00f6\u011feleri kald\u0131r\" width=\"496\" height=\"297\"><\/figure><\/div><p> Bu sivilcelerin saklanmas\u0131 her zaman tavsiye edilir. Nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6relim. <\/p><ul class=\"rich-text block-editor-rich-text__editable\" role=\"textbox\" contenteditable=\"true\" spellcheck=\"false\" aria-multiline=\"true\" aria-label=\"Write list\u2026\"><li> \u00d6ncelikle dilimleyiciye sa\u011f t\u0131klay\u0131n ve Dilimleyici Ayarlar\u0131 se\u00e7ene\u011fini se\u00e7in.<\/li><li> Art\u0131k \u201cDilimleyici Ayarlar\u0131\u201d penceresini g\u00f6receksiniz.<\/li><li> \u201cVeri i\u00e7ermeyen \u00f6\u011feleri gizle\u201d kutusunu i\u015faretleyin. <br><img loading=\"lazy\" decoding=\"async\" title=\"24-veri i\u00e7ermeyen-\u00f6\u011felerin-gizlenmesine kar\u015f\u0131-kutuyu i\u015faretleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/24-cochez-la-case-pour-masquer-les-elements-sans-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"tick the box against hide item with no data\" width=\"486\" height=\"326\"><\/li><li> Buraday\u0131z. <br><img loading=\"lazy\" decoding=\"async\" title=\"25-i\u015fte ba\u015fl\u0131yoruz\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/25-on-y-va.png\" sizes=\"auto, \" srcset=\"\" alt=\"here we go\" width=\"419\" height=\"244\"><\/li><\/ul><h3 class=\"wp-block-heading\"> 5. S\u00fctunlar\u0131 ve d\u00fc\u011fmeleri \u00f6zelle\u015ftirin<\/h3><p> \u00c7o\u011fu zaman segment, s\u00fctun benzeri yap\u0131s\u0131ndan dolay\u0131 kontrol panelinize veya raporunuza s\u0131\u011fmayabilir. Beklemek!! E\u011fer durum buysa, o zaman dilimleyicide d\u00fc\u011fmelerin da\u011f\u0131t\u0131m\u0131n\u0131 d\u00fczenleyebilece\u011finizi bilmelisiniz.<\/p><p> <strong>Dilimleyiciyi se\u00e7in \u2192 Dilimleyici (\u00fcst \u015ferit) \u2192 D\u00fc\u011fmeler<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52942\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/26-colonnes-et-boutons-personnalises.png\" sizes=\"auto, \" srcset=\"\" alt=\"s\u00fctunlar\u0131 ve d\u00fc\u011fmeleri \u00f6zelle\u015ftirin\" width=\"560\" height=\"151\"><\/figure><\/div><p> Burada s\u00fctun say\u0131s\u0131n\u0131 gerekti\u011fi kadar art\u0131r\u0131n. S\u00fctun say\u0131s\u0131n\u0131 3&#8217;e \u00e7\u0131kard\u0131m ve dilimleyicim art\u0131k \u00fc\u00e7 s\u00fctuna sahip ve yatay olarak da\u011f\u0131t\u0131lm\u0131\u015f durumda. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52943\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/27-slicer-a-maintenant-trois-colonnes-et-setale-horizontalement.png\" sizes=\"auto, \" srcset=\"\" alt=\"dilimleyicinin art\u0131k \u00fc\u00e7 s\u00fctunu var ve yatay olarak yay\u0131l\u0131yor\" width=\"695\" height=\"211\"><\/figure><\/div><p class=\"qt-tip\"> \u0130pucu: Ayn\u0131 sekmeden d\u00fc\u011fmelerin y\u00fcksekli\u011fini ve geni\u015fli\u011fini de ayarlayabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52944\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/28-regler-la-hauteur-et-la-largeur-des-boutons.png\" sizes=\"auto, \" srcset=\"\" alt=\"d\u00fc\u011fmelerin y\u00fcksekli\u011fini ve geni\u015fli\u011fini ayarlay\u0131n\" width=\"795\" height=\"102\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 6. Boyutu \u00f6zelle\u015ftirin<\/h3><p> D\u00fc\u011fmeleri bi\u00e7imlendirmek i\u00e7in fazladan zaman harcamak istemiyorsan\u0131z veya s\u00fctunlar ve d\u00fc\u011fme boyutlar\u0131yla oynamak istemiyorsan\u0131z. Tek yapman\u0131z gereken Boyut se\u00e7ene\u011fini kullanarak <strong>dilimleyicinin boyutlar\u0131n\u0131 ayarlamakt\u0131r<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52946\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/29-personnaliser-la-taille.png\" sizes=\"auto, \" srcset=\"\" alt=\"boyutu \u00f6zelle\u015ftir\" width=\"811\" height=\"86\"><\/figure><\/div><p> Fareyi de kullanabilirsiniz ancak \u00fczerinde iyi bir kontrole sahip olman\u0131z gerekir. T\u00fcm bu kar\u0131\u015f\u0131kl\u0131\u011f\u0131 \u00f6nlemek i\u00e7in dilimleyici \u2192 <strong>Dilimleyici (\u00dcst \u015eerit) \u2192 Boyut \u00f6\u011fesini<\/strong> se\u00e7meniz yeterlidir. Burada Dilimleyicinin y\u00fcksekli\u011fini ve geni\u015fli\u011fini bir b\u00fct\u00fcn olarak ayarlayabilirsiniz. Her \u00f6\u011feyle oynaman\u0131za gerek yok.<\/p><h3 class=\"wp-block-heading\"> 7. Dilimleyiciyi yeniden adland\u0131r\u0131n<\/h3><p> Bir Dilimleyiciyi yeniden adland\u0131rmak veya Dilimleyici ba\u015fl\u0131\u011f\u0131n\u0131za k\u00fc\u00e7\u00fck bir a\u00e7\u0131klama eklemek isterseniz ne olur? <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52947\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/30-renommer-un-slicer.png\" sizes=\"auto, \" srcset=\"\" alt=\"dilimleyiciyi yeniden adland\u0131r\" width=\"788\" height=\"109\"><\/figure><\/div><p> Bunu sadece tek bir t\u0131klamayla yapabilirsiniz. Dilimleyiciyi se\u00e7in \u2192 Dilimleyici (\u00fcst \u015ferit) \u2192 Dilimleyici a\u00e7\u0131klamas\u0131 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52948\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/31-selectionnez-la-legende-du-trancheur.png\" sizes=\"auto, \" srcset=\"\" alt=\"b\u00f6l\u00fcm a\u00e7\u0131klamas\u0131n\u0131 se\u00e7\" width=\"721\" height=\"149\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 8. Dilimleyicileri hizalay\u0131n<\/h3><p> \u00d6\u011frenmeniz gereken bir sonraki \u00f6nemli \u015fey hizalamad\u0131r. Birden fazla dilimleyiciniz oldu\u011funda, daha iyi bir sunum i\u00e7in bunlar\u0131 her zaman hizalaman\u0131z \u00f6nerilir. T\u00fcm dilimleyicileri se\u00e7 \u2192 Dilimleyici (\u00fcst \u015ferit) \u2192 D\u00fczenle \u2192 Hizala <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52949\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/32-selectionner-larrangement-du-trancheur.png\" sizes=\"auto, \" srcset=\"\" alt=\"dilimleyiciyi se\u00e7 atamay\u0131 d\u00fczenle\" width=\"228\" height=\"411\"><\/figure><\/div><p> Burada, birden fazla dilimleyiciniz oldu\u011fu halde ikiden fazla dilimleyiciniz oldu\u011funda kullan\u0131\u015fl\u0131 olan birka\u00e7 se\u00e7ene\u011finiz vard\u0131r. \u00c7o\u011fu zaman dilimleyicileri takt\u0131\u011f\u0131n\u0131zda birbirlerinin \u00fczerine basamaklan\u0131rlar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52950\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/33-en-cascade-les-uns-sur-les-autres.png\" sizes=\"auto, \" srcset=\"\" alt=\"birbirinin \u00fczerine d\u00f6k\u00fcl\u00fcyor\" width=\"353\" height=\"370\"><\/figure><\/div><p> \u0130yi da\u011f\u0131lmam\u0131\u015flar. Bunlar\u0131 raporunuzda veya kontrol panelinizde iyi bir \u015fekilde d\u00fczenlemek i\u00e7in Align ad\u0131nda h\u0131zl\u0131 bir \u00e7\u00f6z\u00fcm\u00fcm\u00fcz var.<\/p><p> <strong>Hizala:<\/strong> Bu se\u00e7enek, t\u00fcm segmentlerinizi raporun sa\u011f\u0131nda, \u00fcst\u00fcnde, ortas\u0131nda ve alt\u0131nda d\u00fczenlemenize yard\u0131mc\u0131 olur. Dilimleyicilerinizi nereye yerle\u015ftirmek istedi\u011finize karar vermeniz gerekir.<\/p><ul><li> \u0130lk \u00f6nce t\u00fcm dilimleyicileri se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"34-t\u00fcm dilimleyicileri se\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/34-selectionner-tous-les-trancheurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"select all the slicers\" width=\"352\" height=\"331\"><\/li><li> Bundan sonra \u00dcste Hizala&#8217;y\u0131 t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"35-\u00fcst hizalamada t\u0131klama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/35-cliquez-sur-aligner-en-haut.png\" sizes=\"auto, \" srcset=\"\" alt=\"click on align top\" width=\"372\" height=\"260\"><\/li><li> T\u00fcm dilimleyicilerin \u00fcstten ortak bir ba\u015flang\u0131\u00e7 noktas\u0131 olacakt\u0131r.<\/li><li> \u015eimdi en sa\u011fdaki dilimleyiciyi se\u00e7in ve sa\u011fa s\u00fcr\u00fckleyin. Burada t\u00fcm dilimleyicilerinizin ihtiya\u00e7 duyaca\u011f\u0131 yakla\u015f\u0131k alan\u0131 d\u00fc\u015f\u00fcnmeniz gerekir.<\/li><li> Tekrar t\u00fcm dilimleyicileri se\u00e7in ve yatay olarak da\u011f\u0131t se\u00e7ene\u011fine t\u0131klay\u0131n. Bazen b\u00f6l\u00fcmler aras\u0131ndaki bo\u015fluklar\u0131 ayarlamak i\u00e7in birden \u00e7ok kez t\u0131klaman\u0131z gerekebilir. <br><img loading=\"lazy\" decoding=\"async\" title=\"36-en sa\u011fdaki dilimleyiciyi se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/36-selectionner-le-slicer-le-plus-a-droite.png\" sizes=\"auto, \" srcset=\"\" alt=\"select the most right slicer\" width=\"520\" height=\"183\"><\/li><\/ul><p> Ayn\u0131 \u015fekilde dilimleyicinizi dikey olarak da da\u011f\u0131tabilirsiniz.<\/p><p> <strong>Izgaraya Yasla ve \u015eekle Yasla<\/strong> : Zaman\u0131n\u0131z k\u0131s\u0131tl\u0131ysa ve raporunuzda veya kontrol panelinizde birden fazla \u015fekil varsa, t\u00fcm segmentleri se\u00e7ip \u015eekle Yasla&#8217;y\u0131 t\u0131klaman\u0131z yeterlidir. Bu, k\u0131lavuza yasla se\u00e7ene\u011fini otomatik olarak vurgulayacakt\u0131r.<\/p><ol><li> \u015eekle Yap\u0131\u015f, \u015feklinizi raporunuzdaki veya kontrol panelinizdeki di\u011fer \u015fekillere s\u0131\u011fd\u0131rman\u0131za yard\u0131mc\u0131 olur.<\/li><li> Izgaraya Yap\u0131\u015f, dilimleyicinizi veya \u015fekillerinizi \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131n s\u00fctunlar\u0131na ve sat\u0131rlar\u0131na g\u00f6re ayarlar.<\/li><\/ol><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excel-ilerlemesi\/\">\u0130leri D\u00fczey Excel Dersleri<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kamera-araci\/\">Excel Kamera Arac\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/\">Excel&#8217;de Hedef Bulucu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pencereyi-izle\/\">Excel&#8217;de pencereyi izle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/macta-varsayilan-olarak-excel\/\">Mac&#8217;te Excel&#8217;i Varsay\u0131lan Yap\u0131n<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kisisellestirilmis-listeler\/\">Excel&#8217;de \u00d6zel Liste<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excelde-pdf\/\">Excel&#8217;e PDF ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-duzeltme\/\">Excel&#8217;de otomatik d\u00fczeltme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/resim-ekle\/\">Excel&#8217;de bir h\u00fccreye resim ekleme<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1657","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 Dilimleyici: Excel&#039;deki verileri filtrelemenin en iyi yolu<\/title>\n<meta name=\"description\" content=\"Excel dilimleyici, bir s\u00fctundaki veya tablonun tamam\u0131ndaki verileri filtrelemek i\u00e7in kullanabilece\u011finiz d\u00fc\u011fmelerin bulundu\u011fu bir kutudur.\" \/>\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-dilimleyici\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Dilimleyici: Excel&#039;deki verileri filtrelemenin en iyi yolu\" \/>\n<meta property=\"og:description\" content=\"Excel dilimleyici, bir s\u00fctundaki veya tablonun tamam\u0131ndaki verileri filtrelemek i\u00e7in kullanabilece\u011finiz d\u00fc\u011fmelerin bulundu\u011fu bir kutudur.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:59:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appuyez-sur-ctrlt-pour-convertir-les-donnees.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=\"8 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/\",\"name\":\"Excel Dilimleyici: Excel&#39;deki verileri filtrelemenin en iyi yolu\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appuyez-sur-ctrlt-pour-convertir-les-donnees.png\",\"datePublished\":\"2023-11-13T08:55:32+00:00\",\"dateModified\":\"2023-12-10T05:59:31+00:00\",\"description\":\"Excel dilimleyici, bir s\u00fctundaki veya tablonun tamam\u0131ndaki verileri filtrelemek i\u00e7in kullanabilece\u011finiz d\u00fc\u011fmelerin bulundu\u011fu bir kutudur.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appuyez-sur-ctrlt-pour-convertir-les-donnees.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appuyez-sur-ctrlt-pour-convertir-les-donnees.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel dilimleyici: excel&#39;deki verileri filtrelemenin en i\u0307yi yolu\"}]},{\"@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 Dilimleyici: Excel&#39;deki verileri filtrelemenin en iyi yolu","description":"Excel dilimleyici, bir s\u00fctundaki veya tablonun tamam\u0131ndaki verileri filtrelemek i\u00e7in kullanabilece\u011finiz d\u00fc\u011fmelerin bulundu\u011fu bir kutudur.","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-dilimleyici\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel Dilimleyici: Excel&#39;deki verileri filtrelemenin en iyi yolu","og_description":"Excel dilimleyici, bir s\u00fctundaki veya tablonun tamam\u0131ndaki verileri filtrelemek i\u00e7in kullanabilece\u011finiz d\u00fc\u011fmelerin bulundu\u011fu bir kutudur.","og_url":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:59:31+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appuyez-sur-ctrlt-pour-convertir-les-donnees.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"8 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/","url":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/","name":"Excel Dilimleyici: Excel&#39;deki verileri filtrelemenin en iyi yolu","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appuyez-sur-ctrlt-pour-convertir-les-donnees.png","datePublished":"2023-11-13T08:55:32+00:00","dateModified":"2023-12-10T05:59:31+00:00","description":"Excel dilimleyici, bir s\u00fctundaki veya tablonun tamam\u0131ndaki verileri filtrelemek i\u00e7in kullanabilece\u011finiz d\u00fc\u011fmelerin bulundu\u011fu bir kutudur.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appuyez-sur-ctrlt-pour-convertir-les-donnees.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appuyez-sur-ctrlt-pour-convertir-les-donnees.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel dilimleyici: excel&#39;deki verileri filtrelemenin en i\u0307yi yolu"}]},{"@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\/1657","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=1657"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1657\/revisions"}],"predecessor-version":[{"id":2330,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1657\/revisions\/2330"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}