{"id":3171,"date":"2023-07-18T21:05:26","date_gmt":"2023-07-18T21:05:26","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/"},"modified":"2023-07-18T21:05:26","modified_gmt":"2023-07-18T21:05:26","slug":"excel-pivot-tablo-filtresi-tarih-araligi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/","title":{"rendered":"Excel: pivot tabloyu tarih aral\u0131\u011f\u0131na g\u00f6re filtreleme"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Genellikle Excel&#8217;deki bir pivot tablonun sat\u0131rlar\u0131n\u0131 belirli bir tarih aral\u0131\u011f\u0131na g\u00f6re filtrelemek isteyebilirsiniz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Neyse ki, pivot tablonun <strong>Sat\u0131r Etiketleri<\/strong> s\u00fctunu a\u00e7\u0131l\u0131r men\u00fcs\u00fcndeki <strong>Tarih Filtreleri<\/strong> se\u00e7ene\u011fini kullanarak bunu yapmak kolayd\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: Excel&#8217;de PivotTable&#8217;\u0131 Tarih Aral\u0131\u011f\u0131na g\u00f6re filtreleme<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Diyelim ki Excel&#8217;de farkl\u0131 tarihlerdeki sat\u0131\u015f say\u0131s\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahibiz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26924 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot1.jpg\" alt=\"\" width=\"465\" height=\"460\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu veriler i\u00e7in PivotTable olu\u015fturmadan \u00f6nce, Tarih s\u00fctunundaki h\u00fccrelerden birine t\u0131klay\u0131n ve Excel&#8217;in h\u00fccreyi <strong>tarih<\/strong> bi\u00e7imi olarak tan\u0131d\u0131\u011f\u0131ndan emin olun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26925 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot2.jpg\" alt=\"\" width=\"538\" height=\"510\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra, <strong>A1:B10<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulayabilir, ard\u0131ndan \u00fcst \u015feritteki <strong>Ekle<\/strong> sekmesine t\u0131klayabilir, ard\u0131ndan <strong>PivotTable&#8217;a<\/strong> t\u0131klay\u0131p her tarih i\u00e7in toplam sat\u0131\u015flar\u0131 \u00f6zetlemek \u00fczere a\u015fa\u011f\u0131daki pivot tabloyu ekleyebiliriz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26926 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot3.jpg\" alt=\"\" width=\"485\" height=\"428\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi pivot tabloyu yaln\u0131zca 01\/05\/2022 ile 01\/13\/2022 aras\u0131ndaki tarihleri g\u00f6sterecek \u015fekilde filtrelemek istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Bu filtreyi uygulamak i\u00e7in <strong>Sat\u0131r Etiketleri&#8217;nin<\/strong> yan\u0131ndaki a\u00e7\u0131l\u0131r oku t\u0131klay\u0131n, ard\u0131ndan <strong>Tarih Filtreleri&#8217;ni<\/strong> ve ard\u0131ndan <strong>Aras\u0131nda&#8217;y\u0131<\/strong> t\u0131klay\u0131n:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26934\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtredaterange1.jpg\" alt=\"Excel Pivot Tablo Filtresi Tarih Aral\u0131\u011f\u0131\" width=\"556\" height=\"460\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A\u00e7\u0131lan yeni pencerede tarih aral\u0131\u011f\u0131na kar\u015f\u0131l\u0131k gelen kutulara 01\/05\/2022 ve 01\/13\/2022 tarihlerini girin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26935 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtredaterange2.jpg\" alt=\"\" width=\"464\" height=\"524\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Tamam&#8217;\u0131<\/strong> t\u0131klad\u0131\u011f\u0131n\u0131zda pivot tablo sat\u0131rlar\u0131 yaln\u0131zca bu tarih aral\u0131\u011f\u0131n\u0131 g\u00f6sterecek \u015fekilde otomatik olarak filtrelenir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26936 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtredaterange3.jpg\" alt=\"\" width=\"450\" height=\"421\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu filtreyi kald\u0131rmak i\u00e7in <strong>Sat\u0131r Etiketleri&#8217;nin<\/strong> yan\u0131ndaki filtre simgesini ve ard\u0131ndan <strong>Tarih Filtresini Temizle&#8217;yi<\/strong> t\u0131klaman\u0131z yeterlidir.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/pivot-tablo-excelin-ilk-10'u\/\" target=\"_blank\" rel=\"noopener\">Excel: PivotTable&#8217;daki \u0130lk 10 De\u011fer Nas\u0131l Filtrelenir?<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-pivot-tabloyu-toplam-genele-gore-sirala\/\" target=\"_blank\" rel=\"noopener\">Excel: Pivot tabloyu genel toplama g\u00f6re s\u0131ralama<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-iki-pivot-tablo-arasindaki-farki-hesaplar\/\" target=\"_blank\" rel=\"noopener\">Excel: iki pivot tablo aras\u0131ndaki fark nas\u0131l hesaplan\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Genellikle Excel&#8217;deki bir pivot tablonun sat\u0131rlar\u0131n\u0131 belirli bir tarih aral\u0131\u011f\u0131na g\u00f6re filtrelemek isteyebilirsiniz. Neyse ki, pivot tablonun Sat\u0131r Etiketleri s\u00fctunu a\u00e7\u0131l\u0131r men\u00fcs\u00fcndeki Tarih Filtreleri se\u00e7ene\u011fini kullanarak bunu yapmak kolayd\u0131r. A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir. \u00d6rnek: Excel&#8217;de PivotTable&#8217;\u0131 Tarih Aral\u0131\u011f\u0131na g\u00f6re filtreleme Diyelim ki Excel&#8217;de farkl\u0131 tarihlerdeki sat\u0131\u015f say\u0131s\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-3171","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: PivotTable&#039;\u0131 Tarih Aral\u0131\u011f\u0131na G\u00f6re Filtreleme - Statoryaller<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#039;deki bir pivot tablonun tarih aral\u0131\u011f\u0131na g\u00f6re nas\u0131l filtrelenece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: PivotTable&#039;\u0131 Tarih Aral\u0131\u011f\u0131na G\u00f6re Filtreleme - Statoryaller\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#039;deki bir pivot tablonun tarih aral\u0131\u011f\u0131na g\u00f6re nas\u0131l filtrelenece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T21:05:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot1.jpg\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/\",\"name\":\"Excel: PivotTable&#39;\u0131 Tarih Aral\u0131\u011f\u0131na G\u00f6re Filtreleme - Statoryaller\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-18T21:05:26+00:00\",\"dateModified\":\"2023-07-18T21:05:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;deki bir pivot tablonun tarih aral\u0131\u011f\u0131na g\u00f6re nas\u0131l filtrelenece\u011fi a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: pivot tabloyu tarih aral\u0131\u011f\u0131na g\u00f6re filtreleme\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: PivotTable&#39;\u0131 Tarih Aral\u0131\u011f\u0131na G\u00f6re Filtreleme - Statoryaller","description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;deki bir pivot tablonun tarih aral\u0131\u011f\u0131na g\u00f6re nas\u0131l filtrelenece\u011fi a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel: PivotTable&#39;\u0131 Tarih Aral\u0131\u011f\u0131na G\u00f6re Filtreleme - Statoryaller","og_description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;deki bir pivot tablonun tarih aral\u0131\u011f\u0131na g\u00f6re nas\u0131l filtrelenece\u011fi a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/","og_site_name":"Statorials","article_published_time":"2023-07-18T21:05:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot1.jpg"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/","url":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/","name":"Excel: PivotTable&#39;\u0131 Tarih Aral\u0131\u011f\u0131na G\u00f6re Filtreleme - Statoryaller","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-18T21:05:26+00:00","dateModified":"2023-07-18T21:05:26+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, bir \u00f6rnekle Excel&#39;deki bir pivot tablonun tarih aral\u0131\u011f\u0131na g\u00f6re nas\u0131l filtrelenece\u011fi a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-pivot-tablo-filtresi-tarih-araligi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel: pivot tabloyu tarih aral\u0131\u011f\u0131na g\u00f6re filtreleme"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=3171"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/3171\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=3171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=3171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=3171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}