Neyse ki, pivot tablonun Sat\u0131r Etiketleri<\/strong> s\u00fctunundaki a\u00e7\u0131l\u0131r men\u00fcdeki s\u0131ralama se\u00e7eneklerini kullanarak bunu yapmak kolayd\u0131r.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir.<\/span><\/p>\n Diyelim ki Excel’de farkl\u0131 tarihlerdeki sat\u0131\u015f say\u0131s\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahibiz:<\/span> <\/p>\n Bu veriler i\u00e7in PivotTable olu\u015fturmadan \u00f6nce, Tarih s\u00fctunundaki h\u00fccrelerden birine t\u0131klay\u0131n ve Excel’in h\u00fccreyi tarih<\/strong> bi\u00e7imi olarak tan\u0131d\u0131\u011f\u0131ndan emin olun:<\/span> <\/p>\n Daha sonra, A1:B10<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulayabilir, ard\u0131ndan \u00fcst \u015feritteki Ekle<\/strong> sekmesine t\u0131klayabilir, ard\u0131ndan PivotTable’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 Excel tarih bi\u00e7imini tan\u0131d\u0131\u011f\u0131ndan PivotTable’\u0131 tarihe g\u00f6re en eskiden en yeniye do\u011fru otomatik olarak s\u0131ralar.<\/span><\/span><\/p>\n Ancak en yeniden en eskiye do\u011fru s\u0131ralamak istiyorsak sat\u0131r etiketlerinin<\/strong> yan\u0131ndaki a\u00e7\u0131l\u0131r oka t\u0131klay\u0131p En Yeniden En Eskiye S\u0131rala’y\u0131<\/strong> t\u0131klayabiliriz:<\/span> <\/p>\n Pivot tablo sat\u0131rlar\u0131 otomatik olarak en yeniden en eskiye do\u011fru s\u0131ralanacakt\u0131r:<\/span> <\/p>\n En eskiden en yeniye do\u011fru s\u0131ralamak i\u00e7in Sat\u0131r Etiketleri’nin<\/strong> yan\u0131ndaki a\u00e7\u0131l\u0131r oku tekrar t\u0131klaman\u0131z ve ard\u0131ndan Eskiden Yeniye S\u0131rala se\u00e7ene\u011fini<\/strong> t\u0131klaman\u0131z yeterlidir.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: PivotTable’daki \u0130lk 10 De\u011fer Nas\u0131l Filtrelenir?<\/a> Genellikle Excel’deki bir pivot tablonun sat\u0131rlar\u0131n\u0131 tarihe g\u00f6re s\u0131ralamak isteyebilirsiniz. Neyse ki, pivot tablonun Sat\u0131r Etiketleri s\u00fctunundaki a\u00e7\u0131l\u0131r men\u00fcdeki s\u0131ralama se\u00e7eneklerini kullanarak bunu yapmak kolayd\u0131r. A\u015fa\u011f\u0131daki \u00f6rnek bunun nas\u0131l yap\u0131laca\u011f\u0131n\u0131 tam olarak g\u00f6stermektedir. \u00d6rnek: Excel’de PivotTable’\u0131 Tarihe G\u00f6re S\u0131ralama Diyelim ki Excel’de farkl\u0131 tarihlerdeki sat\u0131\u015f say\u0131s\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setine sahibiz: Bu veriler i\u00e7in PivotTable […]<\/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-3170","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \u00d6rnek: Excel’de PivotTable’\u0131 Tarihe G\u00f6re S\u0131ralama<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot1.jpg\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot2.jpg\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot3.jpg\")
<\/p>\n![\"Excel,](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot4.jpg\")
<\/p>\n![\"PivotTable](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/date-de-tri-pivot5.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h3>\n
Excel: Pivot tabloyu genel toplama g\u00f6re s\u0131ralama<\/a>
Excel: iki pivot tablo aras\u0131ndaki fark nas\u0131l hesaplan\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"