{"id":1824,"date":"2023-11-01T06:50:26","date_gmt":"2023-11-01T06:50:26","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/"},"modified":"2023-12-10T05:58:31","modified_gmt":"2023-12-10T05:58:31","slug":"pivot-tablo","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/","title":{"rendered":"100&#39;den fazla gizli pivottable p\u00fcf noktas\u0131"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3790281983\"><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>Pivot Tablolar, <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\"><strong>orta d\u00fczey Excel becerilerinden<\/strong><\/a> biridir ve bu, bu beceride ustala\u015fman\u0131z i\u00e7in en iyi 100 ipucunu ve p\u00fcf noktas\u0131n\u0131 g\u00f6steren geli\u015fmi\u015f bir Pivot Tablolar e\u011fitimidir. Ger\u00e7ek \u015fu ki, veri analizi, h\u0131zl\u0131 ve etkili raporlar olu\u015fturma veya \u00f6zetlenmi\u015f verileri sunma s\u00f6z konusu oldu\u011funda hi\u00e7bir \u015fey pivot tablonun yerini tutamaz.<\/p><p> Dinamik ve esnektir. Form\u00fclleri ve pivot tablolar\u0131 kar\u015f\u0131la\u015ft\u0131rsan\u0131z bile pivot tablolar\u0131n kullan\u0131m\u0131n\u0131n ve y\u00f6netiminin kolay oldu\u011funu g\u00f6receksiniz. Pivot tablo becerilerinizi kullanmak istiyorsan\u0131z en iyi yol, \u00f6\u011frenebilece\u011finiz ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131n\u0131n bir listesine sahip olmakt\u0131r.<\/p><p class=\"grey-note\"> Bu liste boyunca \u201cAnaliz Sekmesi\u201d ve \u201cTasar\u0131m Sekmesi\u201d kelimelerini kulland\u0131m. Bu iki sekmeyi Excel \u015feridinde g\u00f6rmek i\u00e7in \u00f6nce bir PivotTable se\u00e7melisiniz. Bunun d\u0131\u015f\u0131nda bu hileleri denemek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-des-conseils-de-pivot.xlsx\" rel=\"nofollow\">bu \u00f6rnek dosyay\u0131 mutlaka buradan indirin<\/a> . <\/p><div class=\"wp-block-group more-box is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> PivotTable Olu\u015fturmadan \u00d6nce Dikkat Edilmesi Gereken 5 \u015eey<\/h2><p> Pivot tablo olu\u015fturmadan \u00f6nce, kullanaca\u011f\u0131n\u0131z veri kayna\u011f\u0131 \u00fczerinde birka\u00e7 dakika \u00e7al\u0131\u015farak yap\u0131lmas\u0131 gereken herhangi bir d\u00fczeltme olup olmad\u0131\u011f\u0131n\u0131 kontrol etmelisiniz.<\/p><h3 class=\"wp-block-heading\"> 1. Kaynak verilerde bo\u015f s\u00fctun ve sat\u0131r yok<\/h3><p> Kaynak verilerde kontrol etmeniz gereken \u015feylerden biri de bo\u015f sat\u0131r veya s\u00fctun bulunmamas\u0131d\u0131r.<\/p><p> Bir pivot tablo olu\u015ftururken bo\u015f bir sat\u0131r\u0131n\u0131z veya s\u00fctununuz varsa, Excel yaln\u0131zca o sat\u0131ra veya s\u00fctuna kadar olan verileri al\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques-Excel-trucs-et-astuces-pour-supprimer-les-lignes-et-les-colonnes-balnk-des-donnees-source-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablolar Kaynak verilerden bo\u015f sat\u0131rlar\u0131 ve s\u00fctunlar\u0131 kald\u0131rmak i\u00e7in Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 2. De\u011fer s\u00fctununda bo\u015f h\u00fccre yok<\/h3><p> De\u011ferlerinizin bulundu\u011fu s\u00fctunda bo\u015f sat\u0131r ve s\u00fctun d\u0131\u015f\u0131nda bo\u015f h\u00fccre bulunmamal\u0131d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableaux-croises-dynamiques-trucs-et-astuces-pour-quil-ne-devrait-pas-y-avoir-de-cellule-vide-dans-la-colonne-de-valeur-1.png\" sizes=\"\" srcset=\"\" alt=\"De\u011fer s\u00fctununda bo\u015f h\u00fccre olmamas\u0131 gerekti\u011fine ili\u015fkin Excel pivot tablolar\u0131 ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131\"><\/figure><\/div><p> Bunu kontrol etmenin ana nedeni, De\u011ferler alan\u0131 s\u00fctununda bo\u015f bir h\u00fccreniz varsa: Excel&#8217;in, de\u011ferlerin TOPLAMI yerine pivottaki say\u0131y\u0131 uygulaymas\u0131d\u0131r.<\/p><h3 class=\"wp-block-heading\"> 3. Veriler do\u011fru formatta olmal\u0131d\u0131r<\/h3><p> Pivot tablo i\u00e7in kaynak verileri kulland\u0131\u011f\u0131n\u0131zda bunlar\u0131n do\u011fru formatta olmas\u0131 gerekir.<\/p><p> Diyelim ki bir s\u00fctunda tarihleriniz var ve bu s\u00fctun metin olarak bi\u00e7imlendirilmi\u015f. Bu durumda olu\u015fturdu\u011funuz <a href=\"https:\/\/exceladvisor.org\/tr\/grup-tarihleri\/\">pivot tabloda tarihleri grupland\u0131rman\u0131z<\/a> m\u00fcmk\u00fcn olmayacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Les-trucs-et-astuces-des-tableaux-croises-dynamiques-Excel-pour-le-format-des-donnees-devraient-etre-corrects-1.png\" sizes=\"\" srcset=\"\" alt=\"Veri Format\u0131na \u0130li\u015fkin Excel Pivot Tablo \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131 Do\u011fru Olmal\u0131\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 4. Kaynak veriler i\u00e7in bir tablo kullan\u0131n<\/h3><p> Pivot tablo olu\u015fturmadan \u00f6nce kaynak verilerinizi tabloya d\u00f6n\u00fc\u015ft\u00fcrmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-tableau-croise-dynamique-conseils-astuces-appliquer-le-tableau-aux-donnees-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Pivot Tablo Eklemenin P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Bir tablo, ona her yeni veri ekledi\u011finizde geni\u015fler ve bu, <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-guncelleme-araligi\/\">pivot tablonun veri kayna\u011f\u0131n\u0131 de\u011fi\u015ftirmeyi<\/a> kolayla\u015ft\u0131r\u0131r (neredeyse otomatik).<\/p><p> \u0130\u015fte ad\u0131mlar:<\/p><ol><li> Verilerinizin tamam\u0131n\u0131 veya h\u00fccrelerden birini se\u00e7in.<\/li><li> Ctrl + T k\u0131sayol tu\u015funa bas\u0131n.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><h3 class=\"wp-block-heading\"> 5. Veri toplamlar\u0131n\u0131 kald\u0131r\u0131n<\/h3><p> Son olarak, toplam\u0131 veri kayna\u011f\u0131ndan sildi\u011finizden emin olun. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableaux-croises-dynamiques-trucs-et-astuces-pour-supprimer-le-total-des-donnees-source-1.png\" sizes=\"\" srcset=\"\" alt=\"Kaynak Verilerden Toplam\u0131 Kald\u0131rmak i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Genel toplamlar\u0131 olan kaynak verileriniz varsa Excel bu toplamlar\u0131 de\u011fer olarak al\u0131r ve pivot tablo de\u011ferleri iki kat art\u0131r\u0131l\u0131r.<\/p><p class=\"qt-tip\"> \u0130pucu: Veri kayna\u011f\u0131na bir tablo uygulad\u0131ysan\u0131z Excel, pivot tablo olu\u015ftururken bu toplam\u0131 dahil etmez.<\/p><\/div><\/div><h2 class=\"wp-block-heading\"> Pivot tablo olu\u015ftururken size yard\u0131mc\u0131 olacak ipu\u00e7lar\u0131<\/h2><p> Art\u0131k veriler haz\u0131rland\u0131\u011f\u0131nda ve onunla bir pivot tablo olu\u015fturmaya haz\u0131r oldu\u011funuzda bu ipu\u00e7lar\u0131n\u0131 kullanabilirsiniz. <\/p><div id=\"ub-content-toggle-761886e1-cbb0-43cd-af8a-7398268ed6e5\" 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-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 1. \u00d6nerilen \u00d6zet Tablolar <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-0-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> \u00d6nerilen pivot tablolar\u0131 kontrol etmek i\u00e7in &#8220;Ekle&#8221; sekmesinde bir se\u00e7enek vard\u0131r. &#8220;\u00d6nerilen PivotTable&#8217;lar&#8221;a t\u0131klad\u0131\u011f\u0131n\u0131zda, size sahip oldu\u011funuz verilerle m\u00fcmk\u00fcn olabilecek bir dizi pivot tablo g\u00f6sterilir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-creer-un-tableau-croise-dynamique-a-laide-de-loption-de-pivot-recommandee-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 \u00d6nerilen Pivot Se\u00e7ene\u011fini Kullanarak Pivot Tablo Olu\u015fturmaya \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> Mevcut verilerle sahip oldu\u011funuz t\u00fcm olas\u0131l\u0131klar\u0131 g\u00f6rmek istedi\u011finizde bu se\u00e7enek \u00e7ok kullan\u0131\u015fl\u0131d\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 2. H\u0131zl\u0131 Analizden PivotTable Olu\u015fturma <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-1-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Excel&#8217;de, veri aral\u0131\u011f\u0131n\u0131 her se\u00e7ti\u011finizde g\u00f6r\u00fcnen h\u0131zl\u0131 bir ara\u00e7 \u00e7ubu\u011funa benzeyen &#8220;H\u0131zl\u0131 Analiz&#8221; ad\u0131 verilen bir ara\u00e7 vard\u0131r.<\/p><p> Ayr\u0131ca bu ara\u00e7tan bir pivot tablo da olu\u015fturabilirsiniz.<\/p><p> H\u0131zl\u0131 Analiz Arac\u0131 \u279c Tablolar \u279c Bo\u015f Pivot Tablo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-creer-un-tableau-croise-dynamique-a-laide-de-loutil-danalyse-rapide-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 H\u0131zl\u0131 Analiz Arac\u0131n\u0131 Kullanarak Pivot Tablo Olu\u015fturmaya \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 3. Pivot tablo i\u00e7in kaynak olarak harici \u00e7al\u0131\u015fma kitab\u0131 <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-2-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bu, hemen kullanmaya ba\u015flaman\u0131z\u0131 istedi\u011fim listedeki en yararl\u0131 pivot tablo ipu\u00e7lar\u0131ndan biridir.<\/p><p> Diyelim ki farkl\u0131 bir klas\u00f6rde bulunan bir \u00e7al\u0131\u015fma kitab\u0131ndan ge\u00e7i\u015f yapmak istiyorsunuz ve bu \u00e7al\u0131\u015fma kitab\u0131ndaki verileri ge\u00e7erli sayfan\u0131za eklemek istemiyorsunuz.<\/p><p> Mevcut dosyaya herhangi bir veri eklemeden bu dosyay\u0131 kaynak olarak ba\u011flayabilirsiniz, ad\u0131mlar a\u015fa\u011f\u0131dad\u0131r.<\/p><ul><li> PivotTable Olu\u015ftur ileti\u015fim kutusunda &#8220;Harici veri kayna\u011f\u0131 kullan&#8221; se\u00e7ene\u011fini se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-selectionner-une-source-de-donnees-externe-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Harici Veri Kayna\u011f\u0131 Se\u00e7mek i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\" width=\"402\" height=\"361\"><\/figure><\/div><ul><li> Bundan sonra Ba\u011flant\u0131lar sekmesine gidin ve &#8220;Daha fazlas\u0131 i\u00e7in g\u00f6z at&#8221; \u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-cliquer-sur-plus-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Daha Fazlas\u0131n\u0131 T\u0131klamak i\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div><ul><li> Kullanmak istedi\u011finiz dosyay\u0131 bulun ve se\u00e7in.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><li> \u015eimdi verilerinizin bulundu\u011fu sayfay\u0131 se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-selectionner-selectionner-une-feuille-de-calcul-1.png\" sizes=\"\" srcset=\"\" alt=\"excel pivot tablo ipu\u00e7lar\u0131 se\u00e7mek i\u00e7in ipu\u00e7lar\u0131 \u00e7al\u0131\u015fma sayfas\u0131 se\u00e7in\"><\/figure><\/div><ul><li> Tamam&#8217;a t\u0131klay\u0131n (iki kez). <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-tableau-croise-dynamique-conseils-astuces-pour-fichier-est-connecte-1.png\" sizes=\"\" srcset=\"\" alt=\"ba\u011fl\u0131 dosya i\u00e7in excel pivot tablo ipu\u00e7lar\u0131 ipu\u00e7lar\u0131\"><\/figure><\/div><p> Art\u0131k harici kaynak dosyas\u0131ndan t\u00fcm alan se\u00e7eneklerini i\u00e7eren bir pivot tablo olu\u015fturabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-3-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 4. Klasik \u00d6zet Tablo ve \u00d6zet Grafik Sihirbaz\u0131 <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-3-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Ekle sekmesinden PivotTable olu\u015fturmak yerine \u201cKlasik PivotTable ve PivotChart Sihirbaz\u0131\u201dn\u0131 da kullanabilirsiniz.<\/p><p> Klasik sihirbaz\u0131n ho\u015fuma giden tek yan\u0131, pivot tablo olu\u015fturmadan \u00f6nce <a href=\"https:\/\/exceladvisor.org\/tr\/pekistirmek\/\" data-wpil=\"url\">birden \u00e7ok \u00e7al\u0131\u015fma sayfas\u0131ndan veri \u00e7\u0131karma<\/a> se\u00e7ene\u011finin olmas\u0131d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-creer-un-tableau-croise-dynamique-a-laide-de-lassistant-de-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Pivot Tablo Sihirbaz\u0131n\u0131 Kullanarak Pivot Tablo Olu\u015fturman\u0131n P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Bu sihirbaz\u0131 a\u00e7man\u0131n kolay bir yolu klavye k\u0131sayolunu kullanmakt\u0131r: <strong><span style=\"color: #000000;\">Alt + D + P.<\/span><\/strong> <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-4-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 5. Arama alanlar\u0131 <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-4-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablo alan ayarlar\u0131nda alanlar\u0131 arama se\u00e7ene\u011fi vard\u0131r. Y\u00fczlerce b\u00fcy\u00fck s\u00fctunun bulundu\u011fu alanda arama yapabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-le-tableau-croise-dynamique-Excel-Astuces-pour-ajouter-des-champs-via-la-barre-de-recherche-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Arama \u00c7ubu\u011fu Arac\u0131l\u0131\u011f\u0131yla Alan Eklemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Arama kutusuna yazmaya ba\u015flad\u0131\u011f\u0131n\u0131zda s\u00fctunlar\u0131 filtrelemeye ba\u015flar. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-5-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 6. PivotTable Alan\u0131 Pencere Stilini De\u011fi\u015ftirin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-5-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> \u201cPivot tablo alan\u0131 penceresinin\u201d stilini de\u011fi\u015ftirmek i\u00e7in kullanabilece\u011finiz bir se\u00e7enek var. Sa\u011f \u00fcstteki di\u015fli \u00e7ark simgesini t\u0131klay\u0131n ve uygulamak istedi\u011finiz stili se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-changer-le-style-de-la-fenetre-de-champ-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo excel ipu\u00e7lar\u0131 alan penceresi stilini de\u011fi\u015ftirmek i\u00e7in p\u00fcf noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-6-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 7. Alan listenizin s\u0131ras\u0131n\u0131 s\u0131ralay\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-6-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> B\u00fcy\u00fck bir veri k\u00fcmeniz varsa, gerekli alanlar\u0131 bulmay\u0131 kolayla\u015ft\u0131rmak i\u00e7in alan listesini A&#8217;dan Z&#8217;ye s\u0131ralayabilirsiniz.<\/p><p> Sa\u011f \u00fcstteki di\u015fli \u00e7ark simgesini t\u0131klay\u0131n ve \u201cA&#8217;dan Z&#8217;ye S\u0131rala\u201dy\u0131 se\u00e7in. Varsay\u0131lan olarak alanlar kaynak verilere g\u00f6re s\u0131ralan\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-trier-la-liste-des-champs-1.png\" sizes=\"\" srcset=\"\" alt=\"excel-pivot-tablo-tavsiye-s\u0131ralama-alan-listesi i\u00e7in p\u00fcf noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-7-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 8. Alan listesini a\u00e7\/g\u00f6ster <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-7-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bana \u00f6yle geliyor ki, bir pivot tablo olu\u015fturup \u00fczerine t\u0131klad\u0131\u011f\u0131mda sa\u011f tarafta &#8220;Alan Listesi&#8221; beliriyor ve bu, bir pivot tabloya her t\u0131klad\u0131\u011f\u0131mda oluyor.<\/p><p> Ancak bunu devre d\u0131\u015f\u0131 b\u0131rakabilirsiniz ve bunu yapmak i\u00e7in \u201cPivotTable Analizi\u201d sekmesindeki \u201cGe\u00e7erli Liste D\u00fc\u011fmesine\u201d t\u0131klaman\u0131z yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-masquer-afficher-le-volet-de-la-liste-des-champs.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Alan Listesi B\u00f6lmesini Gizlemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\" width=\"513\" height=\"212\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-8-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 9. Bir pivot tabloya isim verin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-8-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir pivot tablo olu\u015fturduktan sonra yapman\u0131z gereken bir sonraki \u015feyin pivot tabloya isim vermek oldu\u011funu d\u00fc\u015f\u00fcn\u00fcyorum.<\/p><p> Bunun i\u00e7in Analiz sekmesi \u279c Pivot Tablo \u279c Pivot Tablo Se\u00e7enekleri&#8217;ne gidip yeni ad\u0131 girebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-changer-le-nom-dun-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131n Ad\u0131n\u0131 De\u011fi\u015ftirme P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-9-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 10. Excel&#8217;in \u00e7evrimi\u00e7i s\u00fcr\u00fcm\u00fcnde bir pivot tablo olu\u015fturun <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-9-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Son zamanlarda Excel \u00e7evrimi\u00e7i uygulamas\u0131na pivot tablo olu\u015fturma se\u00e7ene\u011fi eklendi (s\u0131n\u0131rl\u0131 se\u00e7enekler).<\/p><p> Excel&#8217;in web uygulamas\u0131nda bir pivot olu\u015fturmak kadar basittir:<\/p><p> Ekle sekmesinde tablo grubundaki \u201cPivot Tablo\u201d butonuna t\u0131klay\u0131n\u2026 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-Creer-un-tableau-croise-dynamique-dans-lapplication-en-ligne-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 \u0130pu\u00e7lar\u0131 Excel \u00c7evrimi\u00e7i Uygulamas\u0131nda PivotTable Olu\u015fturma\"><\/figure><\/div><p> \u2026sonra kaynak veri aral\u0131\u011f\u0131n\u0131 se\u00e7in\u2026 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-selectionner-les-donnees-pour-creer-un-tableau-croise-dynamique-dans-lapplication-en-ligne-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Excel Online Uygulamas\u0131nda Pivot Tablo Olu\u015fturmak \u0130\u00e7in Veri Se\u00e7meye \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> \u2026ve eklemek istedi\u011finiz e-tablo\u2026<\/p><p> \u2026ve sonunda Tamam&#8217;a t\u0131klay\u0131n. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-10-761886e1-cbb0-43cd-af8a-7398268ed6e5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-761886e1-cbb0-43cd-af8a-7398268ed6e5\"> 11. Excel&#8217;de Pivot Tablo Olu\u015fturmak i\u00e7in VBA Kodu <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-10-761886e1-cbb0-43cd-af8a-7398268ed6e5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablo olu\u015fturma s\u00fcrecinizi otomatikle\u015ftirmek istiyorsan\u0131z bunun i\u00e7in VBA kodunu kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-utiliser-le-code-vba-1.gif\" sizes=\"\" srcset=\"\" alt=\"vba kodunu kullanmak i\u00e7in Excel pivot tablo ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-1\/\" data-wpil=\"url\">Bu k\u0131lavuzda<\/a> makro kodu kullanarak pivot tablo olu\u015fturmak i\u00e7in ad\u0131m ad\u0131m basit bir s\u00fcre\u00e7ten bahsettim.<\/p><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> PivotTable&#8217;\u0131 PRO gibi bi\u00e7imlendirme<\/h2><p> Pivot tabloyu rapor olarak kullanabildi\u011finiz i\u00e7in varsay\u0131lan formatta baz\u0131 de\u011fi\u015fiklikler yapman\u0131z \u00f6nemlidir. <\/p><div id=\"ub-content-toggle-d1c55018-93c4-479e-a4a2-994e2ea23edc\" 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-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 1. Pivot tablo stilini de\u011fi\u015ftirin veya yeni bir stil olu\u015fturun <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-0-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Excel&#8217;de tek t\u0131klamayla uygulayabilece\u011finiz bir pivot tablo i\u00e7in \u00f6nceden tan\u0131mlanm\u0131\u015f bir\u00e7ok stil vard\u0131r.<\/p><p> Tasarlanan sekmede \u201cPivot Tablo Stili\u201dni bulabilir ve \u201cDi\u011fer\u201de t\u0131klad\u0131\u011f\u0131n\u0131zda be\u011fendi\u011finiz stili se\u00e7ebilirsiniz.<\/p><p> Ayr\u0131ca yeni, \u00f6zel bir stil de olu\u015fturabilirsiniz, bunu \u201cYeni Pivot Tablo Stili\u201d se\u00e7ene\u011fini kullanarak yapabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-appliquer-du-style-a-un-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 \u015eekillendirmek i\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> \u00d6zel stilinizle i\u015finiz bitti\u011finde, onu bir dahaki sefere kullanmak \u00fczere kaydedebilirsiniz; h\u00e2l\u00e2 orada olacakt\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 2. Pivot tabloyu g\u00fcncellerken h\u00fccre format\u0131n\u0131 koruyun <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-1-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> PivotTable Se\u00e7eneklerine gidin (PivotTable&#8217;a sa\u011f t\u0131klay\u0131n ve PivotTable Se\u00e7enekleri&#8217;ne gidin) ve \u201cG\u00fcncellerken h\u00fccre bi\u00e7imlendirmesini koru\u201d kutusunu i\u015faretleyin.<\/p><p> Bu se\u00e7ene\u011fin avantaj\u0131, pivot tablonuzu her g\u00fcncelledi\u011finizde sahip oldu\u011funuz format\u0131 kaybetmemenizdir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-les-tableaux-croises-dynamiques-Excel-Astuces-pour-conserver-la-mise-en-forme-des-cellules-lorsque-vous-mettez-a-jour-un-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 G\u00fcncelledi\u011finizde H\u00fccre Bi\u00e7imlendirmesini Korumaya Y\u00f6nelik \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 3. Bir pivot tabloyu g\u00fcncelledi\u011finizde otomatik geni\u015flik g\u00fcncellemesini devre d\u0131\u015f\u0131 b\u0131rak\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-2-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Birini bi\u00e7imlendirmenin yan\u0131 s\u0131ra onu da saklaman\u0131z gerekir ve bu da \u201cS\u00fctun Geni\u015fli\u011fi\u201ddir.<\/p><p> Bunu yapmak i\u00e7in &#8220;\u00d6zet Tablo Se\u00e7enekleri&#8221;ne gidin ve &#8220;G\u00fcncellemede s\u00fctun geni\u015fli\u011fini otomatik s\u0131\u011fd\u0131r&#8221; se\u00e7ene\u011finin i\u015faretini kald\u0131r\u0131n ve ard\u0131ndan Tamam&#8217;a t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-desactiver-la-mise-a-jour-automatique-de-la-largeur-lorsque-vous-mettez-a-jour-un-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 G\u00fcncelledi\u011finizde Otomatik Geni\u015flik G\u00fcncellemesini Devre D\u0131\u015f\u0131 B\u0131rakmaya Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-3-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 4. \u00d6\u011fe etiketlerini tekrarlay\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-3-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir pivot tabloda birden fazla \u00f6\u011fe kullan\u0131rken, en \u00fcstteki \u00f6\u011feler i\u00e7in etiketleri tekrarlaman\u0131z yeterlidir. Pivot tablonun yap\u0131s\u0131n\u0131 anlamay\u0131 kolayla\u015ft\u0131r\u0131r.<\/p><ul><li> Pivot tabloyu se\u00e7in ve \u201cTasar\u0131m\u201d sekmesine gidin.<\/li><li> Tasar\u0131m sekmesinde D\u00fczen \u279c Rapor D\u00fczeni \u279c T\u00fcm \u00d6\u011fe Etiketlerini Tekrarla&#8217;ya gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-repeter-toutes-les-etiquettes-darticles-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 T\u00fcm \u00d6\u011fe Etiketlerini Tekrarlamak i\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-4-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 5. De\u011ferleri bi\u00e7imlendirme <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-4-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> \u00c7o\u011fu durumda, pivot tablo olu\u015fturduktan sonra de\u011ferleri bi\u00e7imlendirmeniz gerekir.<\/p><p> \u00d6rne\u011fin say\u0131lar\u0131n ondal\u0131k basamak say\u0131s\u0131n\u0131 de\u011fi\u015ftirmek istiyorsan\u0131z. Tek yapman\u0131z gereken de\u011ferler s\u00fctununu se\u00e7ip \u201cH\u00fccreyi Bi\u00e7imlendir\u201d se\u00e7ene\u011fini a\u00e7mak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-formater-les-valeurs.png\" sizes=\"\" srcset=\"\" alt=\"De\u011ferleri Bi\u00e7imlendirmek i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> Ve bu se\u00e7enekten ondal\u0131k say\u0131lar\u0131 de\u011fi\u015ftirebilirsiniz. \u201cBi\u00e7im\u201d se\u00e7ene\u011finden di\u011fer se\u00e7enekleri bile de\u011fi\u015ftirebilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-5-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 6. Pivot tablolar\u0131n yaz\u0131 tipi stilini de\u011fi\u015ftirin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-5-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bi\u00e7imlendirmeyle ilgili en sevdi\u011fim \u015feylerden biri PivotTable&#8217;\u0131n &#8220;Yaz\u0131 Tipi Stili&#8221;ni de\u011fi\u015ftirmek.<\/p><p> Bi\u00e7im se\u00e7ene\u011fini kullanabilirsiniz ancak en kolay yol bunu Giri\u015f sekmesinden yapmakt\u0131r. Pivot tablonun tamam\u0131n\u0131 se\u00e7in, ard\u0131ndan yaz\u0131 tipi stilini se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-changer-le-style-de-police-des-tableaux-croises-dynamiques-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Pivot Tablo Yaz\u0131 Tipi Stilini De\u011fi\u015ftirmeye \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-6-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 7. Alt toplamlar\u0131 Gizle\/G\u00f6ster <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-6-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Birden fazla \u00f6\u011fe alan\u0131na sahip bir pivot tablo ekledi\u011finizde ana alan\u0131n alt toplamlar\u0131n\u0131 al\u0131rs\u0131n\u0131z.<\/p><p> Ancak bazen alt toplamlar\u0131 g\u00f6stermeye gerek yoktur. Bu durumda a\u015fa\u011f\u0131dakileri yaparak bunlar\u0131 gizleyebilirsiniz:<\/p><ul><li> Pivot tabloya t\u0131klay\u0131n ve Analiz sekmesine gidin.<\/li><li> Analiz sekmesinde D\u00fczen \u279c Alt Toplamlar \u279c Alt Toplamlar\u0131 G\u00f6sterme&#8217;ye gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-les-tableaux-croises-dynamiques-Excel-Astuces-pour-masquer-les-sous-totaux.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Alt Toplamlar\u0131 Gizlemeye Y\u00f6nelik \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-7-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 8. Genel toplam\u0131 gizle\/g\u00f6ster <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-7-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Alt toplamlarda oldu\u011fu gibi, genel toplamlar\u0131 da gizleyebilir ve g\u00f6sterebilirsiniz; bunu yapman\u0131n basit ad\u0131mlar\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p><ul><li> Pivot tabloya t\u0131klay\u0131n ve Analiz sekmesine gidin.<\/li><li> Analiz sekmesinde, Sat\u0131rlar ve S\u00fctunlar i\u00e7in D\u00fczen \u279c Genel Toplam \u279c Kapal\u0131&#8217;ya gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-le-tableau-croise-dynamique-Excel-Astuces-pour-masquer-les-totaux-generaux-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Genel Toplamlar\u0131 Gizlemeye Y\u00f6nelik \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-8-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 9. Pivot tabloda iki basamakl\u0131 format <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-8-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Normal bir pivot tabloda de\u011ferler s\u00fctununda yaln\u0131zca bir de\u011fer bi\u00e7imi bulunur.<\/p><p> Ancak a\u015fa\u011f\u0131daki gibi tek bir pivot tabloda farkl\u0131 formatlara sahip olman\u0131z\u0131 gerektiren baz\u0131 (nadir) durumlar da vard\u0131r. Bunu yapmak i\u00e7in <strong>\u00f6zel bi\u00e7imlendirmeyi kullanman\u0131z<\/strong> gerekir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-9-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 10. Pivot tabloya bir tema uygulay\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-9-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Excel&#8217;de kullanabilece\u011finiz \u00f6nceden tan\u0131mlanm\u0131\u015f renk temalar\u0131 vard\u0131r. Bu temalar pivot tablolara da uygulanabilir. \u201cD\u00fczen\u201d sekmesine gidin ve \u201cTemalar\u201d a\u00e7\u0131l\u0131r men\u00fcs\u00fcne t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-appliquer-le-theme-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Temay\u0131 Uygulama P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Tek t\u0131klamayla uygulayabilece\u011finiz veya mevcut bi\u00e7imlendirme stilinizi tema olarak kaydedebilece\u011finiz 32&#8217;den fazla tema vard\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-10-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 11. Pivot tablonun d\u00fczenini de\u011fi\u015ftirme <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-10-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Her pivot tablo i\u00e7in bir d\u00fczen se\u00e7ebilirsiniz.<\/p><p> Excel&#8217;de (e\u011fer s\u00fcr\u00fcm 2007 veya daha \u00fcst\u00fcn\u00fc kullan\u0131yorsan\u0131z) \u00fc\u00e7 farkl\u0131 d\u00fczene sahip olabilirsiniz. Tasar\u0131m sekmesinde D\u00fczen raporu \u279c D\u00fczen&#8217;e gidin ve uygulamak istedi\u011finiz d\u00fczeni se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-Modification-de-la-disposition-dun-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 \u0130pu\u00e7lar\u0131 PivotTable'\u0131n D\u00fczenini De\u011fi\u015ftirme\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-11-d1c55018-93c4-479e-a4a2-994e2ea23edc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-d1c55018-93c4-479e-a4a2-994e2ea23edc\"> 12. S\u00fctunlar ve \u00e7izgili sat\u0131rlar <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-11-d1c55018-93c4-479e-a4a2-994e2ea23edc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablo olu\u015ftururken ilk yapt\u0131\u011f\u0131m \u015feylerden biri &#8220;Markal\u0131 Sat\u0131r ve S\u00fctun&#8221; uygulamakt\u0131r.<\/p><p> Tasar\u0131m sekmesinden uygulay\u0131p \u201cBantl\u0131 S\u00fctun\u201d ve \u201cBantl\u0131 \u00c7izgiler\u201di kontrol edebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-le-tableau-croise-dynamique-Excel-Astuces-pour-appliquer-des-colonnes-et-des-lignes-en-bandes-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 \u015eeritli S\u00fctunlar ve Sat\u0131rlar Uygulamaya \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> Pivot tablodaki verileri filtreleme<\/h2><p> PivotTable&#8217;\u0131 en g\u00fc\u00e7l\u00fc veri analiz ara\u00e7lar\u0131ndan biri yapan \u015fey \u201cFiltreler\u201ddir. <\/p><div id=\"ub-content-toggle-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" 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-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 1. Filtreleri etkinle\u015ftirin\/devre d\u0131\u015f\u0131 b\u0131rak\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-0-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> T\u0131pk\u0131 normal bir filtre gibi, pivot tablodaki filtreleri de etkinle\u015ftirebilir\/devre d\u0131\u015f\u0131 b\u0131rakabilirsiniz. Filtreleri etkinle\u015ftirmek veya devre d\u0131\u015f\u0131 b\u0131rakmak i\u00e7in &#8220;Analiz Sekmesi&#8221;nde &#8220;Alan Ba\u015fl\u0131\u011f\u0131&#8221; d\u00fc\u011fmesini t\u0131klayabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-desactiver-les-filtres-1.png\" sizes=\"\" srcset=\"\" alt=\"Filtreleri Devre D\u0131\u015f\u0131 B\u0131rakmak i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 2. Filtrelenecek mevcut se\u00e7im <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-1-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tabloda bir veya daha fazla h\u00fccre se\u00e7tiniz ve yaln\u0131zca bu h\u00fccreleri filtrelemek istiyorsan\u0131z kullanabilece\u011finiz se\u00e7enek a\u015fa\u011f\u0131dad\u0131r.<\/p><p> H\u00fccreleri se\u00e7tikten sonra sa\u011f t\u0131klay\u0131n ve \u201cFiltre\u201dye gidin, ard\u0131ndan \u201cYaln\u0131zca se\u00e7ilen \u00f6\u011feleri sakla\u201dy\u0131 se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-la-selection-actuelle-au-filtre-1.png\" sizes=\"\" srcset=\"\" alt=\"Filtrelenecek mevcut se\u00e7im i\u00e7in pivot tablo excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 3. Se\u00e7imi gizle <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-2-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Se\u00e7ilen h\u00fccreleri filtrelemek gibi bunlar\u0131 da gizleyebilirsiniz. Bunu yapmak i\u00e7in &#8220;Filtre&#8221;ye gidin ve ard\u0131ndan &#8220;Se\u00e7ili \u00f6\u011feleri gizle&#8221;yi se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-masquer-la-selection-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Se\u00e7imi Gizlemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-3-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 4. De\u011fer ve etiket filtresi <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-3-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Belirli bir de\u011fer veya kritere g\u00f6re filtreleme yapmak i\u00e7in normal filtrelerin yan\u0131 s\u0131ra etiket filtreleri ve de\u011fer filtreleri kullan\u0131rs\u0131n\u0131z.<\/p><p> <strong>Etiket filtresi:<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-etiqueter-le-filtre-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Filtreyi Etiketlemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> <strong>De\u011fer filtresi:<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-filtrer-les-valeurs-1.png\" sizes=\"\" srcset=\"\" alt=\"De\u011ferleri Filtrelemek i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-4-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 5. Etiket ve de\u011fer filtresini birlikte kullan\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-4-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Yukar\u0131daki ipucunda da s\u00f6yledi\u011fim gibi Etiket ve De\u011fer alan\u0131na sahip olabilirsiniz ancak bu iki filtre se\u00e7ene\u011fini bir arada kullanmak i\u00e7in bir se\u00e7ene\u011fi etkinle\u015ftirmeniz gerekir.<\/p><ul><li> \u00d6ncelikle <span style=\"color: #000000;\">\u201cPivot Tablo Se\u00e7enekleri\u201dni a\u00e7\u0131n<\/span> ve \u201cToplam ve Filtre\u201d sekmesine gidin.<\/li><li> <span style=\"color: #000000;\">&#8220;Toplam ve filtre&#8221; sekmesinde &#8220;Alan ba\u015f\u0131na birden fazla filtreye izin ver&#8221; kutusunu i\u015faretleyin<\/span> .<\/li><li> Bundan sonra Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-autoriser-plusieurs-filtres-par-champ-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Alan Ba\u015f\u0131na Birden \u00c7ok Filtreye \u0130zin Vermeye \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-5-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 6. \u0130lk 10 de\u011feri filtreleyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-5-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Filtrelerde en sevdi\u011fim se\u00e7eneklerden biri <span style=\"color: #000000;\"><strong>\u201cEn \u0130yi 10 De\u011fer\u201de g\u00f6re<\/strong><\/span> filtrelemek. Bu filtre se\u00e7ene\u011fi anl\u0131k rapor olu\u015ftururken kullan\u0131\u015fl\u0131d\u0131r.<\/p><p> Bunu yapmak i\u00e7in \u201cDe\u011fer Filtresi\u201dne gidip \u201cEn \u0130yi 10\u201da ve ard\u0131ndan Tamam\u2019a t\u0131klamal\u0131s\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-filtrer-les-10-premieres-valeurs-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 En \u0130yi 10 De\u011feri Filtrelemek \u0130\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-6-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 7. PivotTable Alanlar\u0131 penceresindeki alanlar\u0131 filtreleyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-6-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablo olu\u015ftururken filtreleme yapmak istiyorsan\u0131z bunu \u201cPivot Field\u201d penceresinden yapabilirsiniz.<\/p><p> Bir s\u00fctundaki de\u011ferleri filtrelemek i\u00e7in sa\u011fdaki a\u015fa\u011f\u0131 oku t\u0131klay\u0131p de\u011ferleri gerekti\u011fi gibi filtreleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-filtrer-les-champs-de-la-fenetre-des-champs-pivotants-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable Alanlar\u0131 Penceresindeki Alanlar\u0131 Filtrelemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-7-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 8. Dilimleyici ekleyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-7-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablodaki verileri filtrelemek i\u00e7in buldu\u011fum en iyi \u015feylerden biri &#8220;Dilimleyici&#8221; kullanmakt\u0131r.<\/p><p> Dilimleyici eklemek i\u00e7in \u201cAnaliz Sekmesi\u201dne gitmeniz ve \u201cFiltre\u201d grubunda \u201cDilimleyici Ekle\u201d butonuna t\u0131klaman\u0131z, ard\u0131ndan dilimleyici eklemek istedi\u011finiz alan\u0131 se\u00e7ip Tamam&#8217;a t\u0131klaman\u0131z yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-ajouter-un-slicer-1.png\" sizes=\"\" srcset=\"\" alt=\"Dilimleyici eklemeye y\u00f6nelik Excel pivot tablo ipu\u00e7lar\u0131\"><\/figure><\/div><p> \u0130lgili: <a href=\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/\">Excel SLICER &#8211; Verilerin Nas\u0131l Filtrelenece\u011fine \u0130li\u015fkin Tam Bir K\u0131lavuz<\/a> <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-8-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 9. Dilimleyiciyi ve di\u011fer se\u00e7enekleri bi\u00e7imlendirin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-8-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir segment ekledikten sonra stilini ve bi\u00e7imini de\u011fi\u015ftirebilirsiniz.<\/p><ul><li> Dilimleyiciyi se\u00e7in ve Se\u00e7enekler sekmesine gidin.<\/li><li> &#8220;Dilimleyici Stilleri&#8221;nde a\u00e7\u0131l\u0131r men\u00fcy\u00fc t\u0131klay\u0131n ve uygulamak istedi\u011finiz stili se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-formater-un-slicer-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo excel ipu\u00e7lar\u0131 dilimleyiciyi bi\u00e7imlendirmeye y\u00f6nelik ipu\u00e7lar\u0131\"><\/figure><\/div><p> Stillerin yan\u0131 s\u0131ra ayarlar\u0131 ayarlar penceresinden de de\u011fi\u015ftirebilirsiniz: ayarlar penceresini a\u00e7mak i\u00e7in \u201cDilimleyici Ayarlar\u0131\u201d d\u00fc\u011fmesine t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-formater-un-segment-et-dautres-options-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Dilimleyiciyi Bi\u00e7imlendirmeye \u0130li\u015fkin \u0130pu\u00e7lar\u0131 ve Di\u011fer Se\u00e7enekler\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-9-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 10. T\u00fcm pivot tablolar i\u00e7in tek dilimleyici <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-9-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bazen birden fazla pivot tablonuz oldu\u011funda hepsini kontrol etmek zordur. Ancak <a href=\"https:\/\/exceladvisor.org\/tr\/dilimleyiciyi-birkac-pivot-tabloya-baglama\/\">tek bir segmenti birden fazla pivot tabloyla ba\u011flarsan\u0131z<\/a> t\u00fcm pivotlar\u0131 zahmetsizce kontrol edebilirsiniz.<\/p><ul><li> \u0130lk \u00f6nce bir dilimleyici yerle\u015ftirin.<\/li><li> Bundan sonra dilimleyiciye sa\u011f t\u0131klay\u0131n ve \u201cBa\u011flant\u0131lar\u0131 Bildir\u201d se\u00e7ene\u011fini se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-un-seul-segment-pour-toutes-les-connexions-de-rapport-de-tableaux-croises-dynamiques-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 T\u00fcm Pivot Tablo Rapor Ba\u011flant\u0131lar\u0131 i\u00e7in Tek Dilimleyici \u0130pu\u00e7lar\u0131\"><\/figure><\/div><ul><li> \u0130leti\u015fim kutusunda t\u00fcm pivotlar\u0131 se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n.<\/li><\/ul><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-un-seul-trancheur-pour-tous-les-tableaux-croises-dynamiques-Selectionnez-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 T\u00fcm Pivot Tablolar i\u00e7in Tek Dilimleyici \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> Art\u0131k t\u00fcm pivot tablolar\u0131 tek bir dilimleyiciyle filtreleyebilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-10-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 11. Bir zaman \u00e7izelgesi ekleyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-10-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Segmentin aksine zaman \u00e7izelgesi, tarihleri filtrelemek i\u00e7in \u00f6zel bir filtreleme arac\u0131d\u0131r ve normal filtreden \u00e7ok daha g\u00fc\u00e7l\u00fcd\u00fcr.<\/p><p> Dilimleyici eklemek i\u00e7in \u201cAnaliz Sekmesi\u201dne gitmeniz ve \u201cFiltre\u201d grubunda \u201c <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-cizelgesi-filtresi\/\">Zaman \u00c7izelgesi Ekle<\/a> \u201d d\u00fc\u011fmesine t\u0131klaman\u0131z ve ard\u0131ndan tarih s\u00fctununu se\u00e7ip Tamam&#8217;a t\u0131klaman\u0131z yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-ajouter-une-chronologie-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Zaman \u00c7izelgesi Eklemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-11-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 12. Zaman \u00e7izelgesi filtresini ve di\u011fer se\u00e7enekleri bi\u00e7imlendirin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-11-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir zaman \u00e7izelgesi ekledikten sonra stilini ve bi\u00e7imini de\u011fi\u015ftirebilirsiniz.<\/p><ul><li> Zaman \u00e7izelgesini se\u00e7in ve Se\u00e7enekler sekmesine gidin.<\/li><li> &#8220;Zaman \u00c7izelgesi Stilleri&#8221;nde a\u00e7\u0131l\u0131r men\u00fcy\u00fc t\u0131klay\u0131n ve uygulamak istedi\u011finiz stili se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-formater-un-filtre-de-chronologie-1.png\" sizes=\"\" srcset=\"\" alt=\"Zaman \u00c7izelgesi Filtresini Bi\u00e7imlendirmek i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Stillerin yan\u0131 s\u0131ra ayarlar\u0131 da de\u011fi\u015ftirebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-formater-un-filtre-de-chronologie-et-dautres-options.png\" sizes=\"\" srcset=\"\" alt=\"Zaman \u00c7izelgesi Filtresini ve Di\u011fer Se\u00e7enekleri Bi\u00e7imlendirmek i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-12-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 13. Joker Karakterleri Kullanarak Filtreleyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-12-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Filtrelenecek de\u011feri girmeniz gereken t\u00fcm filtre se\u00e7eneklerinde <a href=\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/\" data-wpil=\"url\">Excel joker karakterlerini<\/a> kullanabilirsiniz. A harfiyle ba\u015flayan de\u011ferleri filtrelemek i\u00e7in y\u0131ld\u0131z i\u015fareti kulland\u0131\u011f\u0131m a\u015fa\u011f\u0131daki \u00f6rneklere bak\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-les-caracteres-generiques-avec-des-filtres-1.gif\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Filtreli Joker Karakter \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-13-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-ae85802f-b8b7-4c4c-a931-4787b3a7003e\"> 14. T\u00fcm filtreleri temizleyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-13-ae85802f-b8b7-4c4c-a931-4787b3a7003e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Birka\u00e7 alana filtre uygulad\u0131ysan\u0131z, t\u00fcm bu filtreleri Analiz sekmesi \u279c Eylemler \u279c Temizle \u279c Filtreyi temizle se\u00e7ene\u011finden kald\u0131rabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-effacer-tous-les-filtres-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 T\u00fcm Filtreleri Temizlemenin P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> PivotTable&#8217;lardan En \u0130yi \u015eekilde Yararlanmak \u0130\u00e7in \u0130pu\u00e7lar\u0131<\/h2><p> Yukar\u0131da bahsetti\u011fim ipu\u00e7lar\u0131n\u0131 biliyorsan\u0131z pivot tabloyla \u00e7al\u0131\u015fmak daha kolay olabilir.<\/p><p> Bu ipu\u00e7lar\u0131 her hafta 2 saatten fazla tasarruf etmenize yard\u0131mc\u0131 olacakt\u0131r. <\/p><div id=\"ub-content-toggle-8342fb12-627e-4263-9b8e-642248002353\" 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-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 1. Pivot tabloyu manuel olarak yenileyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-0-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablolar dinamiktir, bu nedenle yeni veriler ekledi\u011finizde veya kaynak verilerdeki de\u011ferleri g\u00fcncelledi\u011finizde, pivot tablonun t\u00fcm yeni eklenen de\u011ferleri kaynaktan almas\u0131 i\u00e7in verileri yenilemeniz gerekir. Bir pivot tabloyu yenilemek basittir:<\/p><ul><li> Birincisi, bir pivota sa\u011f t\u0131klay\u0131n ve &#8220;Yenile&#8221;yi se\u00e7in.<\/li><li> \u0130kinci olarak, \u201cAnaliz\u201d sekmesine gidin ve \u201cYenile\u201d d\u00fc\u011fmesine t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-actualiser-manuellement-un-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 Manuel Olarak Yenilemek i\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 2. Dosya A\u00e7arken PivotTable&#8217;\u0131 Yenileyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-1-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Excel&#8217;de, \u00e7al\u0131\u015fma kitab\u0131n\u0131 her a\u00e7t\u0131\u011f\u0131n\u0131zda etkinle\u015ftirebilece\u011finiz ve pivot tablonun otomatik olarak yenilenmesini sa\u011flayabilece\u011finiz basit bir se\u00e7enek vard\u0131r. Bunu yapmak i\u00e7in i\u015fte basit ad\u0131mlar:<\/p><ul><li> \u00d6ncelikle pivot tabloya sa\u011f t\u0131klay\u0131n ve Pivot Tablo Se\u00e7enekleri&#8217;ne gidin.<\/li><li> Bundan sonra \u201cVeri\u201d sekmesine gidin ve \u201cDosyay\u0131 a\u00e7arken verileri yenile\u201d kutusunu i\u015faretleyin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-cocher-Actualiser-le-tableau-croise-dynamique-lors-de-louverture-dun-fichier-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Bir dosyay\u0131 a\u00e7arken PivotTable'\u0131 Yenile kutusunu i\u015faretlemeye y\u00f6nelik p\u00fcf noktalar\u0131\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k \u00e7al\u0131\u015fma kitab\u0131n\u0131 her a\u00e7t\u0131\u011f\u0131n\u0131zda bu pivot tablo an\u0131nda g\u00fcncellenecektir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 3. Belirli bir zaman aral\u0131\u011f\u0131ndan sonra verileri yenileyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-2-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablonuzu belirli bir aral\u0131ktan sonra otomatik olarak g\u00fcncellemek istiyorsan\u0131z bu ipucu tam size g\u00f6re.<\/p><p> \u2026\u0130\u015fte bunu nas\u0131l yapaca\u011f\u0131n\u0131z.<\/p><ul><li> \u00d6ncelikle PivotTable olu\u015ftururken \u201cPivotTable Olu\u015ftur\u201d penceresinde \u201cBu verileri veri modeline ekle\u201d kutusunu i\u015faretleyin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-ajouter-ces-donnees-au-modele-de-donnees-1.png\" sizes=\"\" srcset=\"\" alt=\"Bu verileri veri modeline eklemek i\u00e7in Excel pivot tablo ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131\"><\/figure><\/div><ul><li> Daha sonra pivot tabloyu olu\u015fturduktan sonra h\u00fccrelerden birini se\u00e7in ve \u201cAnaliz Sekmesi\u201dne gidin.<\/li><li> Analiz sekmesinde, Veri \u279c Veri Kayna\u011f\u0131n\u0131 D\u00fczenle \u279c Ba\u011flant\u0131 \u00d6zellikleri. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-cliquer-sur-les-proprietes-de-connexion-1.png\" sizes=\"\" srcset=\"\" alt=\"Ba\u011flant\u0131 \u00d6zelliklerini T\u0131klatmak i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><ul><li> \u015eimdi \u201cBa\u011flant\u0131 \u00d6zellikleri\u201dnde kullan\u0131m sekmesinde \u201cHer yenile\u201d kutusunu i\u015faretleyin ve dakikalar\u0131 girin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-ajouter-du-temps-pour-referencer-un-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 Yenilemek \u0130\u00e7in Zaman Eklemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k girdi\u011finiz bu belirli s\u00fcre sonunda pivotunuz otomatik olarak yenilenecektir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-3-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 4. Hata de\u011ferlerini de\u011fi\u015ftirin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-3-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bazen kaynak verilerinizde hatalar oldu\u011funda, bunlar ayn\u0131s\u0131n\u0131 pivotta da yans\u0131t\u0131r ve bu hi\u00e7 de iyi bir \u015fey de\u011fildir.<\/p><p> En iyi yol bu hatalar\u0131 anlaml\u0131 bir de\u011ferle de\u011fi\u015ftirmektir.<\/p><p> \u0130zlenecek ad\u0131mlar a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p><ul><li> \u00d6ncelikle pivot tablonuza sa\u011f t\u0131klay\u0131n ve Pivot Tablo Se\u00e7enekleri&#8217;ni a\u00e7\u0131n.<\/li><li> \u015eimdi \u201cD\u00fczen ve Format\u201d b\u00f6l\u00fcm\u00fcnde \u201cHata de\u011ferini g\u00f6stermek i\u00e7in\u201d kutusunu i\u015faretleyin ve de\u011feri giri\u015f kutusuna girin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-entrer-la-valeur-des-cellules-derreur-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 H\u00fccre De\u011feri Hatas\u0131n\u0131 Girme P\u00fcf Noktalar\u0131\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k t\u00fcm hatalar i\u00e7in belirtti\u011finiz de\u011fere sahip olacaks\u0131n\u0131z. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-4-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 5. Bo\u015f h\u00fccreleri de\u011fi\u015ftirin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-4-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Diyelim ki sat\u0131\u015f verileri i\u00e7in bir pivotunuz var ve baz\u0131 h\u00fccreler bo\u015f.<\/p><p> \u00c7\u00fcnk\u00fc bu h\u00fccrelerin neden bo\u015f oldu\u011funu bilmeyen bir ki\u015fi size bunu sorabilir. Bu nedenle onu anlaml\u0131 bir kelimeyle de\u011fi\u015ftirmek daha iyidir.<\/p><p> \u2026Bunun i\u00e7in izlemeniz gereken basit ad\u0131mlar.<\/p><ul><li> \u00d6ncelikle pivot tablonuza &#8220;sa\u011f t\u0131klay\u0131n&#8221; ve pivot tablo se\u00e7eneklerini a\u00e7\u0131n.<\/li><li> \u015eimdi \u201cYerle\u015fim ve Bi\u00e7im\u201d b\u00f6l\u00fcm\u00fcnde \u201cBo\u015f h\u00fccreleri g\u00f6stermek i\u00e7in\u201d kutusunu i\u015faretleyin ve de\u011feri giri\u015f kutusuna girin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-3.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo p\u00fcf noktalar\u0131 bo\u015f h\u00fccreler i\u00e7in de\u011fer girme\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k t\u00fcm bo\u015f h\u00fccreler i\u00e7in belirtti\u011finiz de\u011fere sahip olacaks\u0131n\u0131z. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-5-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 6. Say\u0131 bi\u00e7imini tan\u0131mlay\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-5-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Diyelim ki sat\u0131\u015f verileri i\u00e7in bir pivotunuz var ve baz\u0131 h\u00fccreler bo\u015f.<\/p><p> \u00c7\u00fcnk\u00fc bu h\u00fccrelerin neden bo\u015f oldu\u011funu bilmeyen bir ki\u015fi size bunu sorabilir. Bu nedenle onu anlaml\u0131 bir kelimeyle de\u011fi\u015ftirmek daha iyidir.<\/p><p> \u2026Bunun i\u00e7in izlemeniz gereken basit ad\u0131mlar.<\/p><ul><li> \u00d6ncelikle pivot tablonuza &#8220;sa\u011f t\u0131klay\u0131n&#8221; ve pivot tablo se\u00e7eneklerini a\u00e7\u0131n.<\/li><li> \u015eimdi \u201cYerle\u015fim ve Bi\u00e7im\u201d b\u00f6l\u00fcm\u00fcnde \u201cBo\u015f h\u00fccreleri g\u00f6stermek i\u00e7in\u201d kutusunu i\u015faretleyin ve de\u011feri giri\u015f kutusuna girin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-3.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo p\u00fcf noktalar\u0131 bo\u015f h\u00fccreler i\u00e7in de\u011fer girme\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Art\u0131k t\u00fcm bo\u015f h\u00fccreler i\u00e7in belirtti\u011finiz de\u011fere sahip olacaks\u0131n\u0131z. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-6-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 7. Her \u00f6\u011feden sonra bo\u015f bir sat\u0131r ekleyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-6-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> \u015eimdi birden fazla \u00f6\u011fe i\u00e7eren b\u00fcy\u00fck bir pivot tablonuz oldu\u011funu varsayal\u0131m.<\/p><p> Burada pivotta kar\u0131\u015f\u0131kl\u0131k olmamas\u0131 i\u00e7in her \u00f6\u011feden sonra bo\u015f bir sat\u0131r ekleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-ajouter-une-ligne-vide-apres-chaque-element-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Her \u00d6\u011feden Sonra Bo\u015f Bir Sat\u0131r Eklemek \u0130\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Takip etmek i\u00e7in \u015fu ad\u0131mlara g\u00f6z at\u0131n:<\/p><ul><li> Pivot tabloyu se\u00e7in ve Tasar\u0131m sekmesine gidin.<\/li><li> Tasar\u0131m sekmesinde, D\u00fczen \u279c Bo\u015f Sat\u0131rlar \u279c Her \u00d6\u011feden Sonra Bo\u015f Sat\u0131r Ekle&#8217;ye gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-ajouter-une-ligne-vide-apres-chaque-element-de-longlet-Conception-Selectionnez-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Tasar\u0131m Sekmesindeki Her \u00d6\u011feden Sonra Bo\u015f Bir Sat\u0131r Eklemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Bu se\u00e7ene\u011fin en iyi yan\u0131, raporunuzun daha net bir g\u00f6r\u00fcn\u00fcm\u00fcn\u00fc sunmas\u0131d\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-7-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 8. \u00d6\u011feleri pivot tabloya s\u00fcr\u00fckleyip b\u0131rak\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-7-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivotunuzda uzun bir \u00f6\u011fe listesi varsa, yaln\u0131zca s\u00fcr\u00fckleyip b\u0131rakarak bu \u00f6\u011felerin t\u00fcm\u00fcn\u00fc \u00f6zel bir s\u0131raya g\u00f6re d\u00fczenleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-de-tableau-croise-dynamique-pour-faire-glisser-et-deposer-des-elements-1.gif\" sizes=\"\" srcset=\"\" alt=\"\u00d6\u011feleri s\u00fcr\u00fckleyip b\u0131rakmak i\u00e7in Excel pivot tablo p\u00fcf noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-8-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 9. Birinden birden fazla pivot tablo olu\u015fturun <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-8-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Diyelim ki ayl\u0131k sat\u0131\u015f verilerinden bir pivot tablo olu\u015fturdunuz ve \u00fcr\u00fcnleri rapor filtresi olarak kulland\u0131n\u0131z.<\/p><p> \u201cRapor Filtre Sayfalar\u0131n\u0131 G\u00f6ster\u201d se\u00e7ene\u011fi ile her \u00fcr\u00fcn i\u00e7in pivot tablo i\u00e7eren birden fazla e-tablo olu\u015fturabilirsiniz.<\/p><p> Diyelim ki bir pivot filtrede 10 \u00fcr\u00fcn\u00fcn\u00fcz varsa tek t\u0131klamayla 10 farkl\u0131 e-tablo olu\u015fturabilirsiniz.<\/p><p> Bu ad\u0131mlar\u0131 takip et:<\/p><ul><li> Pivotunuzu se\u00e7in ve analiz sekmesine gidin.<\/li><li> Analiz sekmesinde PivotTable \u279c Se\u00e7enekler \u279c Rapor Filtresi Sayfalar\u0131n\u0131 G\u00f6ster&#8217;e gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-creer-une-feuille-de-calcul-separee-pour-chaque-element-1.png\" sizes=\"\" srcset=\"\" alt=\"Her \u00d6\u011fe i\u00e7in Ayr\u0131 Bir \u00c7al\u0131\u015fma Sayfas\u0131 Olu\u015fturmaya Y\u00f6nelik Excel PivotTable \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Art\u0131k d\u00f6rt ayr\u0131 \u00e7al\u0131\u015fma sayfas\u0131nda d\u00f6rt pivot tablonuz var. <\/p><figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-creer-une-feuille-de-calcul-separee-pour-chaque-option-delement.png\" sizes=\"\" srcset=\"\" alt=\"Her \u00d6\u011fe Se\u00e7ene\u011fi i\u00e7in Ayr\u0131 Bir \u00c7al\u0131\u015fma Sayfas\u0131 Olu\u015fturmaya Y\u00f6nelik Excel PivotTable \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-9-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 10. De\u011fer hesaplama se\u00e7ene\u011fi <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-9-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> De\u011fer alan\u0131na bir de\u011fer s\u00fctunu ekledi\u011finizde, SUM veya COUNT (bazen) g\u00f6sterilir, ancak burada hesaplayabilece\u011finiz birka\u00e7 \u015fey daha vard\u0131r:<\/p><p> \u201cDe\u011fer Ayarlar\u0131\u201d se\u00e7eneklerini a\u00e7mak i\u00e7in de\u011fer s\u00fctununda bir h\u00fccreyi se\u00e7in ve sa\u011f t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/conseils-sur-le-tableau-croise-dynamique-excel-astuces-pour-modifier-les-parametres-de-valeurs-pour-le-champ-de-valeur-1.png\" sizes=\"\" srcset=\"\" alt=\"de\u011fer alan\u0131 i\u00e7in de\u011fer ayarlar\u0131n\u0131 de\u011fi\u015ftirmeye y\u00f6nelik excel pivot tablo ipu\u00e7lar\u0131 ipu\u00e7lar\u0131\"><\/figure><\/div><p> Ba\u011flam men\u00fcs\u00fcnde \u201cDe\u011fer Alan\u0131 Ayarlar\u0131\u201dn\u0131 a\u00e7\u0131n ve ard\u0131ndan<\/p><p> &#8220;De\u011feri \u00f6zetleme \u00f6l\u00e7\u00fct\u00fc&#8221; alan\u0131nda pivotta g\u00f6r\u00fcnt\u00fclemek istedi\u011finiz hesaplama t\u00fcr\u00fcn\u00fc se\u00e7in. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-10-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 11. Toplam s\u00fctununu pivot tabloda \u00e7al\u0131\u015ft\u0131rmak <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-10-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Diyelim ki ayda bir pivot tablo sat\u0131\u015f\u0131n\u0131z var.<\/p><p> Art\u0131k t\u00fcm ay boyunca tam sat\u0131\u015f art\u0131\u015f\u0131n\u0131 g\u00f6stermek i\u00e7in pivot tablonuza bir toplam eklemek istiyorsunuz.<\/p><p> \u0130\u015fte ad\u0131mlar:<\/p><ul><li> \u00dczerine sa\u011f t\u0131klay\u0131n ve \u201cDe\u011fer Alan\u0131 Ayar\u0131\u201dna t\u0131klay\u0131n.<\/li><li> &#8220;De\u011ferleri \u015fu \u015fekilde g\u00f6ster&#8221; a\u00e7\u0131l\u0131r listesinde &#8220;K\u00fcm\u00fclatif toplam&#8221; se\u00e7ene\u011fini se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-ajouter-le-parametre-de-champ-de-valeur-totale-en-cours-dexecution-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Alan Parametresini \u00c7al\u0131\u015ft\u0131r\u0131rken Toplam De\u011fer Eklemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-ajouter-une-colonne-de-total-cumule-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 De\u011fi\u015fen Toplam S\u00fctun Eklemeye \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/birikimli-toplam\/\">Pivot tabloya de\u011fi\u015fen toplam ekleme hakk\u0131nda daha fazla bilgi edinin<\/a> . <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-11-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 12. PivotTable&#8217;a Sat\u0131r Ekleme <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-11-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> S\u0131ralama size \u015feyleri birbiriyle kar\u015f\u0131la\u015ft\u0131rman\u0131n daha iyi bir yolunu sunar\u2026<\/p><p> \u2026ve bir pivot tabloya s\u0131ralama s\u00fctunu eklemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/p><ul><li> \u00d6ncelikle ayn\u0131 veri alan\u0131n\u0131 pivota iki kez ekleyin.<\/li><li> Daha sonra ikinci alan i\u00e7in sa\u011f t\u0131klay\u0131p \u201cDe\u011fer Alan\u0131 Ayarlar\u0131\u201dn\u0131 a\u00e7\u0131n\u0131z.<\/li><li> \u201cDe\u011ferleri Farkl\u0131 G\u00f6ster\u201d sekmesine gidin ve \u201cB\u00fcy\u00fckten K\u00fc\u00e7\u00fc\u011fe S\u0131rala\u201dy\u0131 se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-ajouter-des-options-de-rangs-1.png\" sizes=\"\" srcset=\"\" alt=\"Sat\u0131r Se\u00e7enekleri Eklemek i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-ajouter-une-colonne-de-classement-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 S\u0131ralama S\u00fctunu Eklemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/rutbe-sutunu\/\">\u2026pivot tablodaki s\u0131ralama hakk\u0131nda daha fazla bilgi edinmek i\u00e7in buray\u0131 t\u0131klay\u0131n<\/a> . <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-12-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 13. Y\u00fczde pay\u0131 olu\u015fturun <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-12-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> \u00dcr\u00fcn sat\u0131\u015flar\u0131 i\u00e7in bir pivot tablonuz oldu\u011funu hayal edin.<\/p><p> \u015eimdi t\u00fcm \u00fcr\u00fcnlerin toplam sat\u0131\u015flardaki y\u00fczde pay\u0131n\u0131 hesaplamak istiyorsunuz.<\/p><p> Kullan\u0131lacak ad\u0131mlar:<\/p><ul><li> \u00d6ncelikle ayn\u0131 veri alan\u0131n\u0131 pivota iki kez ekleyin.<\/li><li> Daha sonra ikinci alan i\u00e7in sa\u011f t\u0131klay\u0131p \u201cDe\u011fer Alan\u0131 Ayarlar\u0131\u201dn\u0131 a\u00e7\u0131n\u0131z.<\/li><li> \u201cDe\u011ferleri farkl\u0131 g\u00f6ster\u201d sekmesine gidin ve \u201cgenel toplam\u0131n y\u00fczdesi\u201dni se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-creer-un-pourcentage-doptions-de-partage-1.png\" sizes=\"\" srcset=\"\" alt=\"Y\u00fczde Payla\u015f\u0131m Se\u00e7enekleri Olu\u015fturmak i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-creer-une-part-en-pourcentage-1.png\" sizes=\"\" srcset=\"\" alt=\"Y\u00fczde Payla\u015f\u0131m\u0131 Olu\u015fturmak i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> H\u0131zl\u0131 bir rapor olu\u015fturmak i\u00e7in de m\u00fckemmel bir se\u00e7enektir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-13-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 14. PivotTable&#8217;\u0131 Yeni Bir \u00c7al\u0131\u015fma Sayfas\u0131na Ta\u015f\u0131y\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-13-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> PivotTable olu\u015fturdu\u011funuzda Excel sizden PivotTable i\u00e7in yeni bir \u00e7al\u0131\u015fma sayfas\u0131 eklemenizi ister\u2026<\/p><p> &#8230;ancak mevcut bir pivot tabloyu yeni bir \u00e7al\u0131\u015fma sayfas\u0131na ta\u015f\u0131ma se\u00e7ene\u011fi de vard\u0131r.<\/p><ul><li> Bunu yapmak i\u00e7in &#8220;Analiz sekmesi&#8221; \u279c Eylemler \u279c Pivot tablolar\u0131 ta\u015f\u0131y\u0131n se\u00e7ene\u011fine gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-deplacer-un-tableau-croise-dynamique-vers-une-nouvelle-feuille-de-calcul-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 Yeni Bir \u00c7al\u0131\u015fma Sayfas\u0131na Ta\u015f\u0131maya \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-14-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 15. GetPivotData&#8217;y\u0131 devre d\u0131\u015f\u0131 b\u0131rak\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-14-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivottaki bir h\u00fccreye ba\u015fvurman\u0131z gereken bir durum vard\u0131r.<\/p><p> Ancak bir sorun olabilir \u00e7\u00fcnk\u00fc pivottaki bir h\u00fccreye ba\u015fvurdu\u011funuzda Excel ba\u015fvuru i\u00e7in otomatik olarak GetPivotData i\u015flevini kullan\u0131r.<\/p><p> En iyi \u015fey, onu devre d\u0131\u015f\u0131 b\u0131rakabilmenizdir ve i\u015fte ad\u0131mlar:<\/p><ul><li> Dosya sekmesi \u279c Se\u00e7enekler&#8217;e gidin.<\/li><li> Se\u00e7eneklerde Form\u00fcller \u279c Form\u00fcllerle \u00e7al\u0131\u015fma \u279c &#8220;Pivot tablo referans\u0131 i\u00e7in GetPivotData i\u015flevlerini kullan&#8221; se\u00e7ene\u011finin i\u015faretini kald\u0131r\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-le-tableau-croise-dynamique-Excel-Astuces-pour-desactiver-lobtention-de-donnees-pivot-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Pivot Verilerini Almay\u0131 Devre D\u0131\u015f\u0131 B\u0131rakma P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Bunun i\u00e7in VBA kodunu da kullanabilirsiniz:<\/p><p> SubdisableGetPivotData()<\/p><p> Application.GenerateGetPivotData = Yanl\u0131\u015f<\/p><p> Altyaz\u0131 biti\u015fi<\/p><p> <strong><span style=\"color: #ea493f;\">Bunlara g\u00f6z at\u0131n \u279c<\/span> En Faydal\u0131 100 Excel VBA Kodu + PDF Dosyas\u0131<\/strong> <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-15-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 16. Tarihleri pivot tabloda gruplay\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-15-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Aylara g\u00f6re bir pivot tablo olu\u015fturmak istedi\u011finizi ancak verilerinizde tarihlerin bulundu\u011funu hayal edin.<\/p><p> Bu durumda aylarca fazladan bir s\u00fctun eklemeniz gerekir.<\/p><p> Ancak en iyi yol, pivot tablodaki tarih grupland\u0131rma y\u00f6ntemlerini kullanarak olu\u015fturmakt\u0131r, bu y\u00f6ntemi kullanarak bir yard\u0131mc\u0131 s\u00fctun eklemenize gerek yoktur.<\/p><p> A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullan\u0131n:<\/p><ul><li> \u00d6ncelikle tarihi pivot tablonuza bir sat\u0131r \u00f6\u011fesi olarak eklemeniz gerekir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-regrouper-les-dates-ajouter-une-colonne-de-date-1.png\" sizes=\"\" srcset=\"\" alt=\"Tarihleri gruplamak i\u00e7in Excel pivot tablo ipu\u00e7lar\u0131 tarih s\u00fctunu ekleme\"><\/figure><\/div><ul><li> Pivot tabloya sa\u011f t\u0131klay\u0131n ve \u201cGrup\u2026\u201d se\u00e7ene\u011fini se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-grouper-les-dates-cliquez-sur-le-groupe-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo excel ipu\u00e7lar\u0131 tarihleri grupland\u0131rman\u0131n p\u00fcf noktalar\u0131 gruba t\u0131klay\u0131n\"><\/figure><\/div><ul><li> \u00d6l\u00e7\u00fct b\u00f6l\u00fcm\u00fcnde \u201cAy\u201d\u0131 se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-regrouper-les-dates-selectionner-le-mois-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel pivot tablo ipu\u00e7lar\u0131, ay\u0131 se\u00e7erek tarihleri grupland\u0131rmaya y\u00f6nelik p\u00fcf noktalar\u0131\"><\/figure><\/div><p> T\u00fcm tarihleri aylara g\u00f6re grupland\u0131r\u0131r ve bu se\u00e7enek hakk\u0131nda daha fazla bilgi edinmek istiyorsan\u0131z k\u0131lavuzun tamam\u0131n\u0131 burada bulabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-16-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 17. Say\u0131sal verileri pivot tabloda gruplay\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-16-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Tarihlerde oldu\u011fu gibi say\u0131sal de\u011ferleri de grupland\u0131rabilirsiniz.<\/p><p> Ad\u0131mlar basit.<\/p><ul><li> Pivot tabloya sa\u011f t\u0131klay\u0131n ve \u201cGrup\u2026\u201d se\u00e7ene\u011fini se\u00e7in.<\/li><li> Grup aral\u0131\u011f\u0131 olu\u015fturmak i\u00e7in de\u011feri &#8220;by&#8221; kutusuna girin ve Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-grouper-des-donnees-numeriques-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo excel ipu\u00e7lar\u0131 say\u0131sal verileri gruplamak i\u00e7in p\u00fcf noktalar\u0131\"><\/figure><\/div><p> \u2026Pivot tablo grupland\u0131rma se\u00e7ene\u011finin Excel&#8217;de histogram olu\u015fturman\u0131za nas\u0131l yard\u0131mc\u0131 olabilece\u011fini \u00f6\u011frenmek i\u00e7in buray\u0131 t\u0131klay\u0131n. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-17-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 18. <strong>Grup s\u00fctunlar\u0131<\/strong> <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-17-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> S\u00fctunlar\u0131 sat\u0131rlar gibi grupland\u0131rmak i\u00e7in sat\u0131rlarla ayn\u0131 ad\u0131mlar\u0131 uygulayabilirsiniz. Ancak bundan \u00f6nce bir s\u00fctun ba\u015fl\u0131\u011f\u0131 se\u00e7meniz gerekir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-18-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 19. Sat\u0131r ve s\u00fctunlar\u0131n grubunu \u00e7\u00f6z\u00fcn <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-18-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablonuzda gruplara ihtiyac\u0131n\u0131z olmad\u0131\u011f\u0131nda sa\u011f t\u0131klay\u0131p &#8220;Grubu \u00c7\u00f6z&#8221; se\u00e7ene\u011fini se\u00e7erek gruplar\u0131n grubunu \u00e7\u00f6zebilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-19-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 20. <strong>Hesaplamay\u0131 Pivot Tabloda Kullan\u0131n<\/strong> <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-19-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> \u0130leri d\u00fczey bir pivot tablo kullan\u0131c\u0131s\u0131 olmak i\u00e7in, bir pivot tabloda hesaplanan alan ve \u00f6\u011fenin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011frenmeniz gerekir.<\/p><p> Diyelim ki a\u015fa\u011f\u0131daki pivot tabloda mevcut veri alan\u0131n\u0131 10 ile \u00e7arparak alan ba\u015f\u0131na yeni veri olu\u015fturman\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-inserer-un-champ-personnalise-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00d6zel Alan Eklemeye Y\u00f6nelik Excel PivotTable \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> Bu durumda pivot tabloda ayr\u0131 bir s\u00fctun olu\u015fturmak yerine hesaplanm\u0131\u015f bir \u00f6\u011fe ekleyebilirsiniz.<\/p><p> \u279c <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\">pivot tabloda hesaplanm\u0131\u015f bir \u00f6\u011fe ve alan olu\u015fturmaya y\u00f6nelik eksiksiz bir k\u0131lavuz<\/a> <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-20-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 21. Kullan\u0131lan form\u00fcllerin listesi <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-20-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir pivot tabloya hesaplama ekledi\u011finizde veya hesaplanan alan veya \u00f6\u011fe i\u00e7eren bir pivot tablonuz oldu\u011funda, kullan\u0131lan form\u00fcllerin listesini g\u00f6rebilirsiniz.<\/p><p> Bunu yapmak i\u00e7in \u201cAnaliz Sekmesi\u201d \u279c Hesaplama \u279c Alanlar, \u00d6\u011feler ve K\u00fcmeler \u279c Form\u00fclleri Listele se\u00e7ene\u011fine gitmeniz yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-obtenir-la-liste-des-formules-utilisees-dans-lelement-du-tableau-croise-dynamique.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Pivot Tablo \u00d6\u011fesinde Kullan\u0131lan Form\u00fcllerin Listesini Almak \u0130\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> An\u0131nda pivot tabloda kullan\u0131lan form\u00fcllerin listesini i\u00e7eren yeni bir \u00e7al\u0131\u015fma sayfas\u0131 alacaks\u0131n\u0131z. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-21-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 22. Benzersiz de\u011ferlerin bir listesini al\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-21-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Tarihinizde yinelenen de\u011ferler varsa benzersiz de\u011ferlerin bir listesini almak i\u00e7in bir pivot tablo kullanabilirsiniz.<\/p><ul><li> \u00d6ncelikle bir pivot tablo eklemeniz ve ard\u0131ndan yinelenen de\u011ferlerin bulundu\u011fu s\u00fctunu sat\u0131r alan\u0131 olarak eklemeniz gerekir.<\/li><li> Daha sonra bu sat\u0131r alan\u0131n\u0131 pivottan kopyalay\u0131p de\u011fer olarak yap\u0131\u015ft\u0131r\u0131n.<\/li><li> Art\u0131k de\u011fer olarak sahip oldu\u011funuz liste, benzersiz de\u011ferlerin bir listesidir.<\/li><\/ul><p> Benzersiz de\u011ferleri kontrol etmek i\u00e7in pivot tablo kullanman\u0131n ho\u015fuma giden yan\u0131, bunun herkese uyan tek boyutlu bir kurulum olmas\u0131d\u0131r.<\/p><p> Tekrar tekrar olu\u015fturman\u0131za gerek yok. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-22-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 23. Veri i\u00e7ermeyen \u00f6\u011feleri g\u00f6ster <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-22-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Diyelim ki kaynak verilerinizde hi\u00e7bir de\u011ferin olmad\u0131\u011f\u0131 veya s\u0131f\u0131r de\u011ferin oldu\u011fu giri\u015fler var.<\/p><p> Alandan \u201cElemanlar\u0131 veri olmadan g\u00f6ster\u201d se\u00e7ene\u011fini aktif hale getirebilirsiniz.<\/p><ul><li> \u00d6ncelikle alana sa\u011f t\u0131klay\u0131n ve \u201cAlan Ayarlar\u0131\u201dn\u0131 a\u00e7\u0131n.<\/li><li> \u015eimdi \u201cYerle\u015fim ve Yazd\u0131rma\u201dya gidin ve \u201c\u00d6\u011feleri veri olmadan g\u00f6ster\u201d se\u00e7ene\u011fini i\u015faretleyin ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-le-tableau-croise-dynamique-Excel-Astuces-pour-afficher-les-elements-sans-donnees-1.png\" sizes=\"\" srcset=\"\" alt=\"Veri Olmayan \u00d6\u011feleri G\u00f6stermek i\u00e7in Excel Pivot Tablo \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Boom! Elinizde veri bulunmayan t\u00fcm \u00f6\u011feler pivot tabloda g\u00f6r\u00fcnt\u00fclenecektir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-23-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 24. \u00d6nceki de\u011ferden fark <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-23-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bu benim en sevdi\u011fim pivot tablo se\u00e7eneklerinden biri.<\/p><p> Bununla, mevcut de\u011ferlerin \u00f6nceki de\u011fere g\u00f6re fark\u0131n\u0131 g\u00f6steren bir s\u00fctun olu\u015fturabilirsiniz.<\/p><p> Diyelim ki ay de\u011ferlerine sahip bir pivotunuz var&#8230;<\/p><p> \u2026sonra bu se\u00e7enekle\u2026<\/p><p> \u2026a\u015fa\u011f\u0131daki gibi bir \u00f6nceki aya ait fark de\u011feri s\u00fctununu ekleyebilirsiniz.<\/p><p> \u0130\u015fte ad\u0131mlar:<\/p><ul><li> \u00d6ncelikle de\u011fer alan\u0131na iki kez de\u011ferlerinizin bulundu\u011fu s\u00fctunu eklemeniz gerekir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-inserer-la-colonne-de-difference-ajouter-deux-fois-la-colonne-de-valeur-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo excel ipu\u00e7lar\u0131 fark s\u00fctunu eklemek i\u00e7in p\u00fcf noktalar\u0131 de\u011fer s\u00fctununu iki kez ekleyin\"><\/figure><\/div><ul><li> Bundan sonra ikinci alan i\u00e7in \u201cDe\u011fer Ayar\u0131\u201d ve \u201cDe\u011feri Farkl\u0131 G\u00f6ster\u201d se\u00e7ene\u011fini a\u00e7\u0131n.<\/li><li> \u015eimdi, \u201cDe\u011ferleri Farkl\u0131 G\u00f6ster\u201d a\u00e7\u0131l\u0131r listesinde, \u201cFark\u201d\u0131 se\u00e7in ve \u201cTemel \u00d6\u011fe\u201dden \u201cAy\u201d ve \u201c(\u00d6nceki)\u201dyi se\u00e7in.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-inserer-la-colonne-de-difference-selectionner-precedent-parmi-les-options-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel pivot tablo ipu\u00e7lar\u0131 fark s\u00fctunu eklemek i\u00e7in p\u00fcf noktalar\u0131 se\u00e7eneklerden \u00f6ncekini se\u00e7in\"><\/figure><\/div><p> Bu, de\u011ferler s\u00fctununu an\u0131nda \u00f6ncekinden farkl\u0131 bir s\u00fctuna d\u00f6n\u00fc\u015ft\u00fcrecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-inserer-une-colonne-de-difference-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Fark S\u00fctunu Eklemek \u0130\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div>\n<\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-24-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 25. Ayr\u0131nt\u0131lar\u0131 G\u00f6ster&#8217;i devre d\u0131\u015f\u0131 b\u0131rak\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-24-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablodaki bir de\u011fer h\u00fccresine \u00e7ift t\u0131klad\u0131\u011f\u0131n\u0131zda bu de\u011ferin temelini olu\u015fturan veriler g\u00f6r\u00fcnt\u00fclenir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-desactiver-afficher-les-details-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Ayr\u0131nt\u0131lar\u0131 G\u00f6stermeyi Devre D\u0131\u015f\u0131 B\u0131rakma \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> Bu iyi bir \u015fey, ancak bunun ger\u00e7ekle\u015fmesi i\u00e7in her zaman ihtiyac\u0131n\u0131z olan s\u00fcre de\u011fil ve bu y\u00fczden gerekirse onu kapatabilirsiniz.<\/p><p> Tek yapman\u0131z gereken PivotTable Se\u00e7eneklerini a\u00e7\u0131p &#8220;Veri Sekmesi&#8221;ne gidip &#8220;Ayr\u0131nt\u0131lar\u0131 G\u00f6r\u00fcnt\u00fclemeyi Etkinle\u015ftir&#8221; se\u00e7ene\u011finin i\u015faretini kald\u0131rmakt\u0131r.<\/p><p> Ve ard\u0131ndan Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-25-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 26. PowerPoint&#8217;e \u00d6zet Tablo <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-25-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir pivot tabloyu PowerPoint slayd\u0131na yap\u0131\u015ft\u0131rman\u0131n basit ad\u0131mlar\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p><ul><li> \u00d6ncelikle bir pivot tablo se\u00e7in ve kopyalay\u0131n.<\/li><li> Bundan sonra PowerPoint slayt\u0131na gidin ve \u00f6zel yap\u0131\u015ft\u0131rma se\u00e7eneklerini a\u00e7\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-faire-pivoter-le-tableau-vers-Powerpoint-Paste-Special-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Powerpoint \u00d6zel Yap\u0131\u015ft\u0131rmada Tabloyu D\u00f6nd\u00fcrme \u0130pu\u00e7lar\u0131\"><\/figure><\/div><ul><li> \u015eimdi \u00f6zel yap\u0131\u015ft\u0131rma ileti\u015fim kutusunda \u201cMicrosoft Excel Grafik Nesnesi\u201dni se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n.<\/li><\/ul><p> Resim ekle<\/p><p> Pivot tabloda de\u011fi\u015fiklik yapmak i\u00e7in grafi\u011fe \u00e7ift t\u0131klaman\u0131z gerekir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-26-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 27. Word Belgesine \u00d6zet Tablo Ekleme <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-26-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Microsoft Word&#8217;e pivot tablo eklemek i\u00e7in PowerPoint&#8217;teki ad\u0131mlar\u0131n ayn\u0131s\u0131n\u0131 uygulaman\u0131z gerekir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-27-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 28. Alan ba\u015fl\u0131klar\u0131n\u0131 geni\u015fletin veya daralt\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-27-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir sat\u0131r veya s\u00fctunda birden fazla boyut alan\u0131n\u0131z varsa d\u0131\u015f alanlar\u0131 geni\u015fletebilir veya daraltabilirsiniz.<\/p><p> Geni\u015fletmek i\u00e7in + butonuna, daraltmak i\u00e7in \u2013 butonuna basman\u0131z gerekiyor\u2026 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-developper-ou-reduire-les-en-tetes-de-champ-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Alan Ba\u015fl\u0131klar\u0131n\u0131 Geni\u015fletmek veya Daraltmak i\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> &#8230;ve t\u00fcm gruplar\u0131 ayn\u0131 anda geni\u015fletmek veya daraltmak i\u00e7in sa\u011f t\u0131klay\u0131p se\u00e7ene\u011fi belirleyebilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-28-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 29. Gizle-g\u00f6ster geni\u015fletme veya daraltma d\u00fc\u011fmeleri <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-28-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir sat\u0131r veya s\u00fctunda birden fazla boyut alan\u0131n\u0131z varsa d\u0131\u015f alanlar\u0131 geni\u015fletebilir veya daraltabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-le-tableau-croise-dynamique-Excel-Astuces-pour-masquer-les-boutons-de-developpement-ou-de-reduction-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 Geni\u015fletme veya Daraltma D\u00fc\u011fmelerini G\u00f6stermeyi Gizlemeye Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-29-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 30. De\u011ferlerdeki say\u0131lar\u0131 yaln\u0131zca say\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-29-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tabloda say\u0131sal de\u011fere sahip h\u00fccrelerin say\u0131s\u0131n\u0131 sayabilece\u011finiz bir se\u00e7enek vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-utiliser-le-tableau-croise-dynamique-dans-une-feuille-de-calcul-protegee-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 Korumal\u0131 Bir \u00c7al\u0131\u015fma Sayfas\u0131nda Kullanmaya \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> Bunun i\u00e7in yapman\u0131z gereken tek \u015fey \u201cDe\u011fer Se\u00e7ene\u011fi\u201dni a\u00e7\u0131p \u201c\u00d6zet De\u011fer Alan\u0131\u201dnda \u201cSay\u0131y\u0131 Say\u201d se\u00e7ene\u011fini se\u00e7ip Tamam&#8217;a t\u0131klamak. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-30-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 31. \u00d6\u011feleri e\u015fle\u015fen de\u011fere g\u00f6re s\u0131ralay\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-30-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Evet, e\u015fle\u015fen de\u011ferlere g\u00f6re s\u0131ralama yapabilirsiniz.<\/p><ul><li> Tek yapman\u0131z gereken filtreyi a\u00e7mak ve &#8220;Di\u011fer s\u0131ralama se\u00e7enekleri&#8221;ni se\u00e7mek. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-trier-les-elements-en-fonction-dune-valeur-correspondante-ouvrir-le-filtre-1.png\" sizes=\"\" srcset=\"\" alt=\"excel-pivot-tablo-ipu\u00e7lar\u0131-\u00f6\u011feleri e\u015fle\u015fen bir de\u011fere g\u00f6re s\u0131ralamak i\u00e7in p\u00fcf noktalar\u0131 a\u00e7\u0131k filtre\"><\/figure><\/div><ul><li> Ard\u0131ndan \u201cEri\u015fim (A&#8217;dan Z&#8217;ye):\u201d se\u00e7ene\u011fini se\u00e7in ve s\u0131ralanacak s\u00fctunu se\u00e7in ve ard\u0131ndan Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-trier-les-elements-en-fonction-dune-valeur-correspondante-ouvrir-selectionner-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo excel ipu\u00e7lar\u0131 e\u015fle\u015fen de\u011fere g\u00f6re \u00f6\u011feleri s\u0131ralamak i\u00e7in p\u00fcf noktalar\u0131 a\u00e7\u0131k se\u00e7\"><\/figure><\/div><p> <strong>Not:<\/strong><\/p><p> Birden fazla de\u011fer s\u00fctununuz varsa s\u0131ralama d\u00fczeni i\u00e7in yaln\u0131zca bir s\u00fctun kullanabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-31-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 32. \u00d6zel s\u0131ralama d\u00fczeni <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-31-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Evet, pivot tablonuz i\u00e7in \u00f6zel bir s\u0131ralama d\u00fczeni kullanabilirsiniz.<\/p><ul><li> Bunu yapmak i\u00e7in, &#8220;Di\u011fer s\u0131ralama se\u00e7enekleri&#8221;ni a\u00e7t\u0131\u011f\u0131n\u0131zda, &#8220;Di\u011fer se\u00e7enekler&#8221;i t\u0131klay\u0131n ve &#8220;Rapor g\u00fcncellendi\u011finde otomatik olarak s\u0131rala&#8221; kutusunun i\u015faretini kald\u0131r\u0131n.<\/li><li> Bundan sonra s\u0131ralama d\u00fczenini se\u00e7in ve sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Yeni bir \u00f6zel s\u0131ralama d\u00fczeni olu\u015fturman\u0131z gerekir, ard\u0131ndan bunu Dosya sekmesi \u279c Se\u00e7enekler \u279c Geli\u015fmi\u015f \u279c Genel \u279c \u00d6zel Listeyi D\u00fczenle&#8217;den olu\u015fturabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-32-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 33. Ertelenmi\u015f d\u00fczen <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-32-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> \u201cD\u00fczen Gecikmeli G\u00fcncelleme\u201dyi etkinle\u015ftirirseniz ve daha sonra alanlar\u0131 alanlar aras\u0131nda s\u00fcr\u00fckleyip b\u0131rak\u0131rsan\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-le-tableau-croise-dynamique-Excel-Astuces-pour-la-mise-en-page-differee-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Tembel D\u00fczen \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> PivotTable alanlar\u0131n\u0131n k\u00f6\u015fesindeki a\u015fa\u011f\u0131daki G\u00fcncelle d\u00fc\u011fmesini t\u0131klamad\u0131\u011f\u0131n\u0131z s\u00fcrece PivotTable&#8217;\u0131n\u0131z g\u00fcncellenmez.<\/p><p> Bu, pivot tabloyu kontrol etmenizi kolayla\u015ft\u0131r\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-33-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 34. Alan ad\u0131n\u0131 de\u011fi\u015ftirin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-33-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir de\u011fer alan\u0131 ekledi\u011finizde alana alaca\u011f\u0131n\u0131z ad \u015fu \u015fekilde g\u00f6r\u00fcn\u00fcr: &#8220;Tutar Toplam\u0131&#8221; veya &#8220;Birim Say\u0131s\u0131&#8221;.<\/p><p> Ancak bazen (yani her zaman) bu ad\u0131 &#8220;Toplam\u0131&#8221; veya &#8220;Say\u0131s\u0131&#8221; olmayan bir adla de\u011fi\u015ftirmeniz gerekir.<\/p><p> Bunu yapmak i\u00e7in tek yapman\u0131z gereken \u201cSay\u0131\u201d veya \u201cToplam\u201d\u0131 h\u00fccreden kald\u0131rmak ve ismin sonuna bir bo\u015fluk eklemek.<\/p><p> Evet, bu o. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-34-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 35. Pivot tablonun tamam\u0131n\u0131 se\u00e7in <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-34-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir pivot tablonun tamam\u0131n\u0131 ayn\u0131 anda se\u00e7mek istiyorsan\u0131z:<\/p><p> Pivot tablo h\u00fccrelerinden birini se\u00e7in ve Control + A klavye k\u0131sayolunu kullan\u0131n.<\/p><p> Veya\u2026<\/p><p> Analiz sekmesine gidin \u279c \u279c T\u00fcm \u00d6zet Tablo&#8217;yu se\u00e7in. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-selectionner-lensemble-du-tableau-croise-dynamique-a-la-fois-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131n Tamam\u0131n\u0131 Ayn\u0131 Anda Se\u00e7mek \u0130\u00e7in P\u00fcf Noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-35-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 36. De\u011ferlere d\u00f6n\u00fc\u015ft\u00fcr\u00fcn <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-35-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir pivot tabloyu de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrmek istiyorsan\u0131z pivot tablonun tamam\u0131n\u0131 se\u00e7meniz yeterlidir ve ard\u0131ndan:<\/p><p> Kopyalamak i\u00e7in Control + C tu\u015flar\u0131n\u0131 kullan\u0131n, ard\u0131ndan \u00d6zel \u279c De\u011ferleri Yap\u0131\u015ft\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-36-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 37. Korumal\u0131 Bir Elektronik Tabloda PivotTable Kullan\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-36-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablo i\u00e7eren bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 korurken \u015funlar\u0131 kontrol etti\u011finizden emin olun:<\/p><p> <strong>\u201cPivotTable ve PivotChart&#8217;\u0131 kullan\u0131n\u201d<\/strong><\/p><p> &#8220;Bu e-tablonun t\u00fcm kullan\u0131c\u0131lar\u0131n\u0131n \u015funu yapmas\u0131na izin ver:&#8221; se\u00e7ene\u011finden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-utiliser-le-tableau-croise-dynamique-dans-une-feuille-de-calcul-protegee-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 Korumal\u0131 Bir \u00c7al\u0131\u015fma Sayfas\u0131nda Kullanmaya \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-37-8342fb12-627e-4263-9b8e-642248002353\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-8342fb12-627e-4263-9b8e-642248002353\"> 38. De\u011fer alan\u0131 ayarlar\u0131n\u0131 a\u00e7mak i\u00e7in \u00e7ift t\u0131klay\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-37-8342fb12-627e-4263-9b8e-642248002353\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Belirli bir de\u011fer s\u00fctunu i\u00e7in \u201cDe\u011fer Ayarlar\u0131\u201dn\u0131 a\u00e7mak istiyorsan\u0131z\u2026<\/p><p> \u2026BU Y\u00dcZDEN\u2026 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Conseils-sur-le-tableau-croise-dynamique-Excel-Astuces-pour-double-cliquer-pour-ouvrir-les-parametres-du-champ-de-valeur-1.png\" sizes=\"\" srcset=\"\" alt=\"De\u011fer Alan\u0131 Ayarlar\u0131n\u0131 A\u00e7mak \u0130\u00e7in \u00c7ift T\u0131klamaya Y\u00f6nelik Excel Pivot Tablo \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> \u2026en iyi yol s\u00fctun ba\u015fl\u0131\u011f\u0131na \u00e7ift t\u0131klamakt\u0131r.<\/p><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> Pivot tablolar\u0131n\u0131z\u0131 biraz daha m\u00fckemmel hale getirin<\/h2><p> Pivot tablolar rapor olu\u015fturman\u0131n en etkili ve en kolay yollar\u0131ndan biridir. Ve her zaman ba\u015fkalar\u0131yla ili\u015fkilerimizi payla\u015fmam\u0131z gerekiyor. Daha \u00f6nce pivot tabloyu kolayca payla\u015fman\u0131za yard\u0131mc\u0131 olabilecek baz\u0131 yararl\u0131 ipu\u00e7lar\u0131n\u0131 payla\u015fm\u0131\u015ft\u0131m. <\/p><div id=\"ub-content-toggle-9387390b-714e-4c3f-9992-be0edc44e22e\" 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-9387390b-714e-4c3f-9992-be0edc44e22e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9387390b-714e-4c3f-9992-be0edc44e22e\"> 1. PivotTable raporunun boyutunu k\u00fc\u00e7\u00fclt\u00fcr <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-0-9387390b-714e-4c3f-9992-be0edc44e22e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> E\u011fer b\u00f6yle d\u00fc\u015f\u00fcn\u00fcyorsan\u0131z: S\u0131f\u0131rdan bir pivot tablo olu\u015fturdu\u011funuzda Excel bir pivot \u00f6nbellek olu\u015fturur.<\/p><p> Yani s\u0131f\u0131rdan ne kadar \u00e7ok pivot tablo olu\u015fturursan\u0131z, Excel o kadar \u00e7ok pivot \u00f6nbellek olu\u015fturur ve dosyan\u0131z\u0131n daha fazla veri depolamas\u0131 gerekir.<\/p><p> Peki ama\u00e7 ne?<\/p><p> <strong>Veri kaynaklar\u0131ndan gelen t\u00fcm pivot tablolar\u0131n ayn\u0131 \u00f6nbelle\u011fe sahip oldu\u011fundan emin olun.<\/strong><\/p><p> Ama Puneet, bunu nas\u0131l yapabilirim?<\/p><p> Basit, ikinci, \u00fc\u00e7\u00fcnc\u00fc veya d\u00f6rd\u00fcnc\u00fcy\u00fc olu\u015fturman\u0131z gerekti\u011finde\u2026 sadece ilkini kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n ve \u00fczerinde de\u011fi\u015fiklik yap\u0131n. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-9387390b-714e-4c3f-9992-be0edc44e22e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9387390b-714e-4c3f-9992-be0edc44e22e\"> 2. Kaynak verileri silin; pivot tablo hala d\u00fczg\u00fcn \u00e7al\u0131\u015f\u0131yor <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-1-9387390b-714e-4c3f-9992-be0edc44e22e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Birine pivot tablo g\u00f6ndermeden \u00f6nce yapabilece\u011finiz ba\u015fka bir \u015fey de kaynak verileri silmektir.<\/p><p> Pivot tablonuz yine de do\u011fru \u015fekilde \u00e7al\u0131\u015facakt\u0131r.<\/p><p> Ayr\u0131ca kaynak verilere ihtiya\u00e7 duyan biri varsa, pivot tablonun genel toplam\u0131na t\u0131klayarak bu verilere ula\u015fabilir. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-9387390b-714e-4c3f-9992-be0edc44e22e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9387390b-714e-4c3f-9992-be0edc44e22e\"> 3. PivotTable&#8217;\u0131 Web Sayfas\u0131 Olarak Kaydetme [HTML] <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-2-9387390b-714e-4c3f-9992-be0edc44e22e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir pivot tabloyu birisiyle payla\u015fman\u0131n ba\u015fka bir yolu da bir web sayfas\u0131 olu\u015fturmakt\u0131r.<\/p><p> Evet, pivot tablolu basit bir HTML dosyas\u0131.<\/p><ul><li> Bunu yapmak i\u00e7in \u00e7al\u0131\u015fma kitab\u0131n\u0131 bir web sayfas\u0131 [html] olarak kaydetmeniz yeterlidir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-enregistrer-un-tableau-croise-dynamique-en-tant-que-page-Web-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 Web Sayfas\u0131 Olarak Kaydetmeye \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><ul><li> Web Olarak Yay\u0131nla sayfas\u0131nda pivot tabloyu se\u00e7in ve &#8220;Yay\u0131nla&#8221;y\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-enregistrer-un-tableau-croise-dynamique-en-tant-que-page-Web-en-tant-que-publication-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 Web Sayfas\u0131 Olarak G\u00f6nderi Olarak Kaydetmeye \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> Art\u0131k bu HTML web sayfas\u0131n\u0131 herkese g\u00f6nderebilirsiniz ve onlar da pivot tabloyu (d\u00fczenlenemez) cep telefonlar\u0131nda bile g\u00f6rebilirler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-enregistrer-un-tableau-croise-dynamique-en-tant-que-fichier-HTML-de-page-Web-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 PivotTable'\u0131 Web Sayfas\u0131 HTML Dosyas\u0131 Olarak Kaydetmeye \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-3-9387390b-714e-4c3f-9992-be0edc44e22e\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9387390b-714e-4c3f-9992-be0edc44e22e\"> 4. Web Adresinden \u00c7al\u0131\u015fma Kitab\u0131 Arac\u0131l\u0131\u011f\u0131yla PivotTable Olu\u015fturma <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-3-9387390b-714e-4c3f-9992-be0edc44e22e\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> A\u015fa\u011f\u0131daki gibi bir Excel dosyas\u0131 i\u00e7in bir web ba\u011flant\u0131n\u0131z oldu\u011funu varsayal\u0131m:<\/p><pre class=\"wp-block-preformatted\"> https:\/\/exceladvisor.org\/book1.xlsx<\/pre><p> Bu \u00e7al\u0131\u015fma kitab\u0131nda verileriniz var ve bu verilerle bir pivot tablo olu\u015fturman\u0131z gerekiyor.<\/p><p> Bunun i\u00e7in POWER QUERY anahtar\u0131d\u0131r.<\/p><p> <strong>\u015euna g\u00f6z at\u0131n: <a href=\"https:\/\/exceladvisor.org\/tr\/guc-talebi\/\">Power Query \u00d6rnekleri + \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131<\/a><\/strong><\/p><ul><li> \u00d6ncelikle Veri sekmesine gidin \u279c Veri Al ve D\u00f6n\u00fc\u015ft\u00fcr \u279c Web&#8217;den. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-les-tableaux-croises-dynamiques-Astuces-pour-creer-un-tableau-croise-dynamique-a-laide-de-Power-uery-en-obtenant-des-donnees-a-partir-dun-lien-Web-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Bir Web Ba\u011flant\u0131s\u0131ndan Veri Alarak G\u00fc\u00e7 Kullanarak Pivot Tablo Olu\u015fturma \u0130pu\u00e7lar\u0131\"><\/figure><\/div><ul><li> \u015eimdi \u201cWeb&#8217;den\u201d ileti\u015fim kutusunda \u00e7al\u0131\u015fma kitab\u0131n\u0131n web adresini girin ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-creer-un-tableau-croise-dynamique-a-laide-de-Power-uery-en-obtenant-des-donnees-a-partir-dun-lien-Web-ajouter-une-URL-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Bir Web Ba\u011flant\u0131s\u0131ndan Veri Alarak G\u00fc\u00e7 Kullanarak Pivot Tablo Olu\u015fturman\u0131n P\u00fcf Noktalar\u0131 URL Ekle\"><\/figure><\/div><ul><li> Bundan sonra e-tabloyu se\u00e7in ve &#8220;Y\u00fckle&#8221;ye t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-creer-un-tableau-croise-dynamique-a-laide-de-power-uery-en-obtenant-des-donnees-a-partir-dun-lien-Web-selectionner-une-feuille-de-calcul-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo excel ipu\u00e7lar\u0131 power uery kullanarak pivot tablo olu\u015fturman\u0131n p\u00fcf noktalar\u0131 bir web ba\u011flant\u0131s\u0131ndan veri alma bir \u00e7al\u0131\u015fma sayfas\u0131 se\u00e7in\"><\/figure><\/div><ul><li> Daha sonra PivotTable raporunu se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel.png\" sizes=\"\" srcset=\"\" alt=\"excel-pivot-tablo-ipu\u00e7lar\u0131-bir-web-ba\u011flant\u0131s\u0131-add-url'sinden-veri-alma-ile-g\u00fc\u00e7-uery-kullanarak-pivot-tablo olu\u015fturman\u0131n p\u00fcf noktalar\u0131\"><\/figure><\/div><p> Bu noktada girdi\u011finiz web adresinden \u00e7al\u0131\u015fma kitab\u0131na ba\u011flanan bo\u015f bir pivot tablonuz var.<\/p><p> Art\u0131k diledi\u011finiz gibi bir pivot tablo olu\u015fturabilirsiniz.<\/p><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> CF ile pivot tabloda neler yapabilirsiniz?<\/h2><p> Bana g\u00f6re ko\u015fullu bi\u00e7imlendirme ak\u0131ll\u0131 bi\u00e7imlendirmedir. Eminim buna kat\u0131l\u0131yorsunuzdur. Pivot tablo s\u00f6z konusu oldu\u011funda CF bir cazibe gibi \u00e7al\u0131\u015f\u0131r. <\/p><div id=\"ub-content-toggle-1804045a-7d4b-4bcc-951b-9921560ab0f5\" 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-1804045a-7d4b-4bcc-951b-9921560ab0f5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-1804045a-7d4b-4bcc-951b-9921560ab0f5\"> 1. Genel CF se\u00e7eneklerinin uygulanmas\u0131 <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-0-1804045a-7d4b-4bcc-951b-9921560ab0f5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tabloyla birlikte kullan\u0131labilecek t\u00fcm CF se\u00e7enekleri mevcuttur.<\/p><p> \u279c <a href=\"https:\/\/exceladvisor.org\/tr\/kosullu-bicimlendirmeyi-uygula\/\">Pivot tablolarda CF kullanman\u0131n t\u00fcm farkl\u0131 yollar\u0131n\u0131<\/a> \u00f6\u011frenmenize yard\u0131mc\u0131 olabilecek k\u0131lavuzu burada bulabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-1804045a-7d4b-4bcc-951b-9921560ab0f5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-1804045a-7d4b-4bcc-951b-9921560ab0f5\"> 2. \u0130lk 10 de\u011feri vurgulay\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-1-1804045a-7d4b-4bcc-951b-9921560ab0f5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Filtrelemek yerine pivot tablodaki ilk 10 de\u011feri vurgulayabilirsiniz.<\/p><p> Bunu yapmak i\u00e7in ko\u015fullu bi\u00e7imlendirmeyi kullanman\u0131z gerekir.<\/p><p> Ad\u0131mlar a\u015fa\u011f\u0131dad\u0131r:<\/p><ul><li> Pivot tablonuzun de\u011fer s\u00fctunundaki h\u00fccrelerden birini se\u00e7in.<\/li><li> Ana Sayfa sekmesine gidin \u279c Stiller \u279c Ko\u015fullu Bi\u00e7imlendirme.<\/li><li> \u015eimdi Ko\u015fullu Bi\u00e7imlendirme&#8217;de \u00dcst\/Alt Kurallar\u0131 \u279c \u0130lk 10 \u00d6\u011fe&#8217;ye gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-appliquer-les-10-meilleures-options-de-mise-en-forme-conditionnelle-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 En \u0130yi 10 Ko\u015fullu Bi\u00e7imlendirme Se\u00e7ene\u011fini Uygulamaya Y\u00f6nelik P\u00fcf Noktalar\u0131\"><\/figure><\/div><ul><li> Sahip oldu\u011funuz penceredeki rengi se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-appliquer-les-10-meilleures-options-de-mise-en-forme-conditionnelle-selectionner-la-couleur-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo excel ipu\u00e7lar\u0131 en iyi 10 ko\u015fullu bi\u00e7imlendirme se\u00e7ene\u011fini uygulamak i\u00e7in p\u00fcf noktalar\u0131 renk se\u00e7in\"><\/figure><\/div><ul><li> Ve sonunda Tamam&#8217;a t\u0131klay\u0131n.<\/li><\/ul><p> Bu se\u00e7enek, bir pivot tabloyla h\u0131zl\u0131 raporlar olu\u015ftururken ve bir kez size \u00e7ok kullan\u0131\u015fl\u0131d\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-1804045a-7d4b-4bcc-951b-9921560ab0f5\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-1804045a-7d4b-4bcc-951b-9921560ab0f5\"> 3. CF&#8217;yi Pivot Tablodan \u00c7\u0131kar\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-2-1804045a-7d4b-4bcc-951b-9921560ab0f5\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyerek ko\u015fullu bi\u00e7imlendirmeyi pivot tablodan kolayca kald\u0131rabilirsiniz:<\/p><ul><li> \u00d6ncelikle pivot tablo h\u00fccrelerinden birini se\u00e7in.<\/li><li> Bundan sonra, Ana Sayfa sekmesine gidin \u279c Stiller \u279c Ko\u015fullu Bi\u00e7imlendirme \u279c Kurallar\u0131 Temizle \u279c \u201cBu pivot tablonun kurallar\u0131n\u0131 temizle\u201d. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-effacer-tout-le-formatage-conditionnel-1.png\" sizes=\"\" srcset=\"\" alt=\"T\u00fcm Ko\u015fullu Bi\u00e7imlendirmeyi Temizlemek i\u00e7in Excel PivotTable \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Birden fazla pivot tablonuz varsa CF&#8217;leri tek tek silmelisiniz.<\/p><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> Raporlar\u0131n\u0131z\u0131 g\u00f6rselle\u015ftirmek i\u00e7in pivot tablolar\u0131 i\u00e7eren pivot grafikleri kullan\u0131n<\/h2><p> Pivot tablonun b\u00fcy\u00fck bir hayran\u0131y\u0131m.<\/p><p> Pivot tabloyu nas\u0131l do\u011fru kullanaca\u011f\u0131n\u0131z\u0131 biliyorsan\u0131z, en iyi Excel ara\u00e7lar\u0131ndan birinden en iyi \u015fekilde yararlanabilirsiniz.<\/p><p> K\u0131sa s\u00fcrede pivot tablo PRO&#8217;su olmak i\u00e7in kullanabilece\u011finiz baz\u0131 ipu\u00e7lar\u0131n\u0131 burada bulabilirsiniz ve pivot tablo hakk\u0131nda her \u015feyi \u00f6\u011frenmek istiyorsan\u0131z <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/\" data-wpil=\"url\">bu k\u0131lavuzdan bilgi alabilirsiniz<\/a> . <\/p><div id=\"ub-content-toggle-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\" 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-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\"> 1. Pivot tablo ekleme <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-0-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/\" data-wpil=\"url\">Pivot tablo eklemek<\/a> i\u00e7in basit bir klavye k\u0131sayolu payla\u015ft\u0131m, ancak a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 da kullanabilirsiniz:<\/p><ul><li> Pivot tablodan bir h\u00fccre se\u00e7in ve <strong><span style=\"color: #000000;\">\u201cAnaliz Sekmesi\u201dne gidin<\/span><\/strong> .<\/li><li> \u201cAnaliz\u201d sekmesinde \u201c\u00d6zet Grafik\u201de t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-pour-inserer-un-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Pivot Tablo Eklemenin P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Sahip oldu\u011funuz pivot tablodan an\u0131nda bir pivot tablo olu\u015fturacakt\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\"> 2. PivotChart ve PivotTable Kullanarak Histogram Olu\u015fturma <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-1-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Pivot tablo ve pivot grafik, Excel&#8217;de histogram olu\u015fturman\u0131n en sevdi\u011fim yoludur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-Conseils-sur-le-tableau-croise-dynamique-Astuces-pour-creer-un-histogramme-a-laide-dun-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Pivot Tablo Kullanarak Histogram Olu\u015fturmaya \u0130li\u015fkin \u0130pu\u00e7lar\u0131\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/histogram\/\">\u0130\u015fte bunun i\u00e7in ad\u0131m ad\u0131m bir k\u0131lavuz.<\/a> <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\"> 3. PivotTable D\u00fc\u011fmelerini Devre D\u0131\u015f\u0131 B\u0131rak\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-2-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Yeni bir pivot tablo ekledi\u011finizde, onu filtrelemek i\u00e7in bazen ger\u00e7ekten kullan\u0131\u015fl\u0131 olmayan d\u00fc\u011fmeler gelir.<\/p><p> Ve e\u011fer b\u00f6yle d\u00fc\u015f\u00fcn\u00fcyorsan\u0131z hepsini veya bir k\u0131sm\u0131n\u0131 gizleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/conseils-de-tableau-croise-dynamique-excel-astuces-un-tableau-croise-dynamique-avec-des-boutons-de-filtre-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo ipu\u00e7lar\u0131 excel ipu\u00e7lar\u0131 filtre d\u00fc\u011fmeleri i\u00e7eren bir pivot tablo\"><\/figure><\/div><p> Se\u00e7ilen <strong><span style=\"color: #000000;\">d\u00fc\u011fmeyi gizlemek i\u00e7in d\u00fc\u011fmeye sa\u011f t\u0131klay\u0131n<\/span><\/strong> ve \u201cGrafikteki De\u011fer Alan\u0131 D\u00fc\u011fmesini Gizle\u201d se\u00e7ene\u011fini se\u00e7in veya t\u00fcm d\u00fc\u011fmeleri gizlemek i\u00e7in \u201cGrafikteki T\u00fcm Alan D\u00fc\u011fmelerini Gizle\u201d se\u00e7ene\u011fine t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-tableau-croise-dynamique-conseils-astuces-masquer-les-boutons-de-filtre-du-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel PivotTable \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131 PivotTable Filtre D\u00fc\u011fmelerini Gizleme\"><\/figure><\/div><p> PivotTable&#8217;daki t\u00fcm d\u00fc\u011fmeleri gizledi\u011finizde, grafi\u011fin alt\u0131ndaki filtre d\u00fc\u011fmesi de gizlenir <strong><span style=\"color: #000000;\">, ancak yine de PivotTable, Dilimleyici veya Zaman \u00c7izelgesi filtresini kullanarak filtreleyebilirsiniz<\/span><\/strong> . <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-3-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\"> 4. PowerPoint&#8217;e \u00d6zet Tablo Ekleme <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-3-cfe2bfae-33d9-40f3-94c7-eae98cc301fc\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> Bir pivot tabloyu PowerPoint slayd\u0131na yap\u0131\u015ft\u0131rman\u0131n basit ad\u0131mlar\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p><ul><li> \u00d6ncelikle bir pivot tablo se\u00e7in ve kopyalay\u0131n.<\/li><li> Bundan sonra PowerPoint slayt\u0131na gidin ve <strong><span style=\"color: #000000;\">\u00d6zel Yap\u0131\u015ft\u0131rma Se\u00e7enekleri&#8217;ni a\u00e7\u0131n<\/span><\/strong> . <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-copier-le-tableau-croise-dynamique-vers-power-point-slide-open-psate-special-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo excel ipu\u00e7lar\u0131 pivot tabloyu power point slayt g\u00f6sterisine kopyalamak i\u00e7in p\u00fcf noktalar\u0131 \u00f6zel a\u00e7\u0131k yap\u0131\u015ft\u0131rma\"><\/figure><\/div><ul><li> \u015eimdi \u00f6zel yap\u0131\u015ft\u0131rma ileti\u015fim kutusunda <strong><span style=\"color: #000000;\">\u201cMicrosoft Excel Grafik Nesnesi\u201dni se\u00e7in<\/span><\/strong> ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-excel-conseils-astuces-pour-copier-un-tableau-croise-dynamique-vers-une-diapositive-power-point-selectionner-lobjet-graphique-microsoft-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel Pivot Tablo \u0130pu\u00e7lar\u0131 Pivot Tabloyu Power Point Slayt\u0131na Kopyalamak i\u00e7in \u0130pu\u00e7lar\u0131 Bir Microsoft Excel Grafik Nesnesi Se\u00e7in\"><\/figure><\/div><p> Pivot tabloda de\u011fi\u015fiklik yapmak i\u00e7in \u00fczerine \u00e7ift t\u0131klaman\u0131z gerekir.<\/p><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> PivotTable \u00c7al\u0131\u015fman\u0131z\u0131 H\u0131zland\u0131racak Klavye K\u0131sayollar\u0131<\/h2><p> Hepimiz klavye k\u0131sayollar\u0131n\u0131 seviyoruz. SA\u011e? Burada pivot tablo \u00e7al\u0131\u015fmalar\u0131n\u0131z\u0131 h\u0131zland\u0131rmak i\u00e7in kullanabilece\u011finiz yayg\u0131n fakat kullan\u0131\u015fl\u0131 klavye k\u0131sayollar\u0131ndan baz\u0131lar\u0131n\u0131 listeledim. <\/p><div id=\"ub-content-toggle-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\" 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-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"> 1. Bir pivot tablo olu\u015fturun <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-0-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> <strong>Alt + N + V<\/strong><\/p><p> Bu k\u0131sayol tu\u015funu kullanmak i\u00e7in kaynak veriyi se\u00e7ti\u011finizden veya etkin h\u00fccrenin kaynak veriden oldu\u011fundan emin olun. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-1-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"> 2. Se\u00e7ilen pivot tablo \u00f6\u011felerini grupland\u0131r\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-1-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> <strong>Alt + \u00dcst Karakter + Sa\u011f Ok<\/strong><\/p><p> Diyelim ki aylar\u0131n yer ald\u0131\u011f\u0131 bir pivot tablonuz var ve ilk alt\u0131 veya son alt\u0131 ay\u0131 grupland\u0131rmak istiyorsunuz.<\/p><p> Tek yapman\u0131z gereken bu alt\u0131 h\u00fccreyi se\u00e7ip bu k\u0131sayol tu\u015funu kullanmak. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-2-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"> 3. Se\u00e7ilen pivot tablo \u00f6\u011felerinin grubunu \u00e7\u00f6z\u00fcn <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-2-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> <strong>Alt + \u00dcst Karakter + Sol Ok<\/strong><\/p><p> T\u0131pk\u0131 bir \u00f6\u011fe grubu olu\u015fturabildi\u011finiz gibi, bu k\u0131sayol da bu \u00f6\u011felerin gruptaki grubunu \u00e7\u00f6zmenize yard\u0131mc\u0131 olur. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-3-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"> 4. Se\u00e7ilen \u00f6\u011feyi veya alan\u0131 gizleyin <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-3-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> <strong>Ctrl + \u2013<\/strong><\/p><p> Bu k\u0131sayol tu\u015fu se\u00e7ilen h\u00fccreleri gizleyecektir.<\/p><p> Asl\u0131nda h\u00fccreyi gizlemez ancak onlar\u0131 filtreler; daha sonra filtre se\u00e7eneklerinden bunlar\u0131 temizleyebilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-4-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"> 5. Hesaplanan Alan penceresini a\u00e7\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-4-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> <strong>Ctrl + \u2013<\/strong><\/p><p> Bu k\u0131sayol tu\u015funu kullanmak i\u00e7in de\u011fer alan\u0131 s\u00fctununda bir h\u00fccre se\u00e7melisiniz.<\/p><p> Ve bu k\u0131sayol tu\u015funa bast\u0131\u011f\u0131n\u0131zda <strong><span style=\"color: #000000;\">\u201c<\/span><\/strong> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\"><strong><span style=\"color: #000000;\">Hesaplanan Alan<\/span><\/strong><\/a> <strong><span style=\"color: #000000;\">\u201d<\/span><\/strong> penceresi a\u00e7\u0131l\u0131r. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-5-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"> Eski \u00d6zet Tablo Sihirbaz\u0131&#8217;n\u0131 a\u00e7\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-5-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> <strong>Alt + D ve P<\/strong><\/p><p> Bu klavye k\u0131sayolunda daha sonra tu\u015flara basman\u0131z gerekiyor. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-6-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"> 7. Etkin h\u00fccreye ili\u015fkin alanlar\u0131n listesini a\u00e7\u0131n <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-6-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> <strong>Alt + a\u015fa\u011f\u0131 ok<\/strong><\/p><p> Bu tu\u015f alanlar\u0131n listesini a\u00e7ar. <\/p><\/div><\/div><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-7-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"><h3 class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\"> 8. PivotTable&#8217;dan PivotChart Ekleme <\/h3><div class=\"wp-block-ub-content-toggle-accordion-toggle-wrap right\"><\/div><\/div><div id=\"ub-content-toggle-panel-7-9ee80016-730a-4eaf-965d-e3a3d1c1c6c2\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><p> <strong>Alt+F1<\/strong><\/p><p> Bu klavye k\u0131sayolunu kullanmak i\u00e7in pivot tablodaki bir h\u00fccreyi se\u00e7melisiniz. Bu tu\u015f mevcut sayfaya bir pivot tablo ekler.<\/p><p> <strong>F11<\/strong><\/p><p> Ve yeni bir \u00e7al\u0131\u015fma sayfas\u0131na pivot eklemek istiyorsan\u0131z yaln\u0131zca yukar\u0131daki anahtar\u0131 kullanman\u0131z gerekir. <\/p><\/div><\/div><\/div><ul id=\"ub_styled_list-ee33a0bf-286a-454d-a920-a3a0db3e5da0\" class=\"ub_styled_list\"><li class=\"ub_styled_list_item\"> <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\"><strong>Excel Klavye K\u0131sayollar\u0131 Hile Sayfas\u0131<\/strong><\/a><\/li><\/ul><h2 class=\"wp-block-heading\"> Sonunda<\/h2><p> S\u00f6yledi\u011fim gibi pivot tablolar, verileri raporlama ve analiz etme konusunda k\u0131sa s\u00fcrede daha iyi olman\u0131za yard\u0131mc\u0131 olabilecek ara\u00e7lardan biridir.<\/p><p> Bu ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 sayesinde zamandan daha fazla tasarruf edebilirsiniz. Bana sorarsan\u0131z \u00f6nce en az 10 ipucu kullanmaya ba\u015flaman\u0131z\u0131, ard\u0131ndan sonraki 10 ipucuna ge\u00e7menizi istiyorum.<\/p><p> Ama \u015fimdi bana bir \u015feyi s\u00f6ylemelisin: <strong>En sevdi\u011fin pivot tablo ipucu hangisi?<\/strong><\/p><h2 class=\"wp-block-heading\"> <strong>Bunlar\u0131 mutlaka okuyun<\/strong> <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-108\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ekle-genel-toplami-sil\/\">PivotTable&#8217;da Genel Toplam Ekle-Kald\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/birikimli-toplam\/\">Pivot tabloya de\u011fi\u015fen toplam ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-guncelleme-araligi\/\">Bir pivot tabloyu otomatik olarak g\u00fcncelleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tabloda-hesaplama\/\">Pivot tablodaki form\u00fcller<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/veri-kaynagini-degistir\/\">Pivot tablonun veri kayna\u011f\u0131n\u0131 de\u011fi\u015ftirme<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><\/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-1824","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>Pivot Tablo 2023 i\u00e7in 100+ \u0130pucu<\/title>\n<meta name=\"description\" content=\"Excel becerilerinizi tamamen yeni bir seviyeye ta\u015f\u0131mak istiyorsan\u0131z pivot tablolarda daha iyi olman\u0131z gerekir\" \/>\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\/pivot-tablo\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pivot Tablo 2023 i\u00e7in 100+ \u0130pucu\" \/>\n<meta property=\"og:description\" content=\"Excel becerilerinizi tamamen yeni bir seviyeye ta\u015f\u0131mak istiyorsan\u0131z pivot tablolarda daha iyi olman\u0131z gerekir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:58:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques-Excel-trucs-et-astuces-pour-supprimer-les-lignes-et-les-colonnes-balnk-des-donnees-source-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"36 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\",\"name\":\"Pivot Tablo 2023 i\u00e7in 100+ \u0130pucu\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques-Excel-trucs-et-astuces-pour-supprimer-les-lignes-et-les-colonnes-balnk-des-donnees-source-1.png\",\"datePublished\":\"2023-11-01T06:50:26+00:00\",\"dateModified\":\"2023-12-10T05:58:31+00:00\",\"description\":\"Excel becerilerinizi tamamen yeni bir seviyeye ta\u015f\u0131mak istiyorsan\u0131z pivot tablolarda daha iyi olman\u0131z gerekir\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques-Excel-trucs-et-astuces-pour-supprimer-les-lignes-et-les-colonnes-balnk-des-donnees-source-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques-Excel-trucs-et-astuces-pour-supprimer-les-lignes-et-les-colonnes-balnk-des-donnees-source-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"100&#39;den fazla gizli pivottable p\u00fcf noktas\u0131\"}]},{\"@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":"Pivot Tablo 2023 i\u00e7in 100+ \u0130pucu","description":"Excel becerilerinizi tamamen yeni bir seviyeye ta\u015f\u0131mak istiyorsan\u0131z pivot tablolarda daha iyi olman\u0131z gerekir","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\/pivot-tablo\/","og_locale":"tr_TR","og_type":"article","og_title":"Pivot Tablo 2023 i\u00e7in 100+ \u0130pucu","og_description":"Excel becerilerinizi tamamen yeni bir seviyeye ta\u015f\u0131mak istiyorsan\u0131z pivot tablolarda daha iyi olman\u0131z gerekir","og_url":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:58:31+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques-Excel-trucs-et-astuces-pour-supprimer-les-lignes-et-les-colonnes-balnk-des-donnees-source-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"36 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/","url":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/","name":"Pivot Tablo 2023 i\u00e7in 100+ \u0130pucu","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques-Excel-trucs-et-astuces-pour-supprimer-les-lignes-et-les-colonnes-balnk-des-donnees-source-1.png","datePublished":"2023-11-01T06:50:26+00:00","dateModified":"2023-12-10T05:58:31+00:00","description":"Excel becerilerinizi tamamen yeni bir seviyeye ta\u015f\u0131mak istiyorsan\u0131z pivot tablolarda daha iyi olman\u0131z gerekir","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/pivot-tablo\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques-Excel-trucs-et-astuces-pour-supprimer-les-lignes-et-les-colonnes-balnk-des-donnees-source-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableaux-croises-dynamiques-Excel-trucs-et-astuces-pour-supprimer-les-lignes-et-les-colonnes-balnk-des-donnees-source-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"100&#39;den fazla gizli pivottable p\u00fcf noktas\u0131"}]},{"@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\/1824","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=1824"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1824\/revisions"}],"predecessor-version":[{"id":2251,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1824\/revisions\/2251"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}