\u00d6rne\u011fin, belirli bir y\u0131l\u0131n her ay\u0131na ait toplam sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren bir veri setiniz olabilir ve bu ayl\u0131k verileri \u00fc\u00e7 ayl\u0131k verilere d\u00f6n\u00fc\u015ft\u00fcrmek isteyebilirsiniz:<\/span> <\/p>\n Neyse ki bunu Excel’de yapmak kolayd\u0131r ve a\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnekte bunun nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n \u0130lk olarak, bir perakende ma\u011fazas\u0131nda her ay toplam sat\u0131\u015flar\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setini Excel’e girece\u011fiz:<\/span> <\/p>\n Daha sonra D s\u00fctununa \u00e7eyreklerin listesini yazabiliriz:<\/span> <\/p>\n Son olarak ilk \u00e7eyrek sat\u0131\u015flar\u0131n\u0131n toplam\u0131n\u0131 hesaplamak i\u00e7in E2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p E s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Sonu\u00e7tan \u015funu g\u00f6rebiliriz:<\/span><\/p>\n Art\u0131k ayl\u0131k verileri ba\u015far\u0131yla \u00fc\u00e7 ayl\u0131k verilere d\u00f6n\u00fc\u015ft\u00fcrd\u00fck.<\/span><\/p>\n Not<\/strong> : Bu \u00f6rnekte her \u00e7eyre\u011fe ait sat\u0131\u015flar\u0131n toplam\u0131n\u0131 hesaplamak i\u00e7in SUM<\/strong> fonksiyonunu kulland\u0131k, ancak her \u00e7eyrekteki ortalama sat\u0131\u015flar\u0131 hesaplamak istiyorsan\u0131z ORTALAMA<\/strong> gibi farkl\u0131 bir fonksiyonu kullanabilirsiniz.<\/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 Verileri Excel’de \u00e7eyre\u011fe g\u00f6re grupland\u0131rma<\/a> \u00c7o\u011fu zaman ayl\u0131k verileri \u00fc\u00e7 ayl\u0131k verilere d\u00f6n\u00fc\u015ft\u00fcrmek isteyebilirsiniz. \u00d6rne\u011fin, belirli bir y\u0131l\u0131n her ay\u0131na ait toplam sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren bir veri setiniz olabilir ve bu ayl\u0131k verileri \u00fc\u00e7 ayl\u0131k verilere d\u00f6n\u00fc\u015ft\u00fcrmek isteyebilirsiniz: Neyse ki bunu Excel’de yapmak kolayd\u0131r ve a\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnekte bunun nas\u0131l yap\u0131laca\u011f\u0131 g\u00f6sterilmektedir. 1. Ad\u0131m: Orijinal verileri girin \u0130lk […]<\/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-5058","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qmon1.png\")
<\/p>\n 1. Ad\u0131m: Orijinal verileri girin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qmon2.png\")
<\/p>\n Ad\u0131m 2: \u00c7eyrek Listesi Olu\u015fturun<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qmon3.png\")
<\/p>\n 3. Ad\u0131m: Her \u00e7eyre\u011fin toplam\u0131n\u0131 hesaplay\u0131n<\/strong><\/span><\/h2>\n
=SUM(OFFSET( B$2,3<\/span> *ROWS( B$2:B2<\/span> )-3,,3))<\/strong><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qmon4.png\")
<\/p>\n\n
Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel’de \u00e7eyre\u011fe g\u00f6re nas\u0131l eklenir<\/a>
Excel’de tarihi \u00e7eyre\u011fe ve y\u0131la nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"