\u00d6rne\u011fin, birka\u00e7 y\u0131l boyunca her \u00fc\u00e7 ayda bir toplam sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren bir veri k\u00fcmeniz olabilir ve bu \u00fc\u00e7 ayl\u0131k verileri y\u0131ll\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 art arda \u00fc\u00e7 y\u0131l boyunca her \u00fc\u00e7 ayda bir toplam sat\u0131\u015flar\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setini Excel’e girece\u011fiz:<\/span> <\/p>\n Daha sonra, orijinal veri k\u00fcmesindeki t\u00fcm benzersiz y\u0131llar\u0131n bir listesini almak i\u00e7in D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n Art\u0131k orijinal veri k\u00fcmesindeki t\u00fcm benzersiz y\u0131llar\u0131n bir listesine sahibiz.<\/span><\/p>\n Not<\/strong> : Bu form\u00fcl, A s\u00fctunundaki her h\u00fccrenin sa\u011f\u0131ndaki d\u00f6rt karakteri \u00e7\u0131karmak i\u00e7in SA\u011e<\/strong> i\u015flevini kullan\u0131r, ard\u0131ndan d\u00f6rt karakterden olu\u015fan benzersiz birle\u015fimlerin, yani benzersiz y\u0131llar\u0131n bir listesini elde etmek i\u00e7in BENZERS\u0130Z<\/strong> i\u015flevini kullan\u0131r.<\/span><\/p>\n Son olarak, ilk y\u0131l\u0131n sat\u0131\u015f 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 \u00fc\u00e7 ayl\u0131k verileri ba\u015far\u0131yla y\u0131ll\u0131k verilere d\u00f6n\u00fc\u015ft\u00fcrd\u00fck.<\/span><\/p>\n Not<\/strong> : Bu \u00f6rnekte yaln\u0131zca \u00fc\u00e7 benzersiz y\u0131l\u0131m\u0131z vard\u0131, ancak \u00fc\u00e7 ayl\u0131k verileri istedi\u011finiz say\u0131da y\u0131la ait y\u0131ll\u0131k verilere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in tam olarak ayn\u0131 form\u00fclleri 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 \u00fc\u00e7 ayl\u0131k verileri y\u0131ll\u0131k verilere d\u00f6n\u00fc\u015ft\u00fcrmek isteyebilirsiniz. \u00d6rne\u011fin, birka\u00e7 y\u0131l boyunca her \u00fc\u00e7 ayda bir toplam sat\u0131\u015flara ili\u015fkin bilgileri i\u00e7eren bir veri k\u00fcmeniz olabilir ve bu \u00fc\u00e7 ayl\u0131k verileri y\u0131ll\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 […]<\/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-5057","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qan1.png\")
<\/p>\n 1. Ad\u0131m: Orijinal verileri girin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qan2.png\")
<\/p>\n Ad\u0131m 2: Benzersiz Y\u0131llar\u0131 Bulun<\/strong><\/span><\/h2>\n
=SINGLE(RIGHT( A2:A13<\/span> , 4))<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qan3.png\")
<\/p>\n 3. Ad\u0131m: Her y\u0131l\u0131n toplam\u0131n\u0131 hesaplay\u0131n<\/strong><\/span><\/h2>\n
=SUMIF( A2:A13<\/span> , \"*\"& D2<\/span> &\"*\", B2:B13<\/span> )<\/strong><\/pre>\n![\"Excel](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/qan4.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":"