Neyse ki Excel’in yerle\u015fik i\u015flevleri sayesinde bunu yapmak kolayd\u0131r.<\/span><\/p>\n A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, pratikte Excel’de bir \u00f6zet tablosunun nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n \u00d6ncelikle bir firman\u0131n \u00fcr\u00fcn sat\u0131\u015flar\u0131na ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri setini girece\u011fiz:<\/span> <\/p>\n Daha sonra, B s\u00fctunundaki benzersiz \u00fcr\u00fcn adlar\u0131n\u0131 tan\u0131mlamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanaca\u011f\u0131z:<\/span><\/p>\n Bu form\u00fcl\u00fc F2<\/b> h\u00fccresine yazabiliriz:<\/span> <\/p>\n Bu form\u00fcl\u00fcn B s\u00fctunundan \u00fc\u00e7 benzersiz \u00fcr\u00fcn ad\u0131n\u0131 \u00e7\u0131karabildi\u011fini g\u00f6rebiliriz.<\/span><\/p>\n Daha sonra a\u015fa\u011f\u0131daki form\u00fclleri kullanarak sat\u0131lan toplam adetleri, sat\u0131lan ortalama adetleri ve her bir \u00fcr\u00fcn i\u00e7in toplam geliri hesaplayabiliriz:<\/span><\/p>\n Sat\u0131lan toplam birim say\u0131s\u0131:<\/strong><\/span><\/p>\n Ortalama sat\u0131lan birim say\u0131s\u0131:<\/strong><\/span><\/p>\n Toplam gelir:<\/strong><\/span><\/p>\n Bu form\u00fclleri s\u0131ras\u0131yla G2<\/strong> , H2<\/strong> ve I2<\/strong> h\u00fccrelerine yazabiliriz:<\/span> <\/p>\n Art\u0131k orijinal veri k\u00fcmemizdeki \u00fc\u00e7 \u00fcr\u00fcn\u00fcn her biri i\u00e7in sat\u0131lan toplam birimleri, sat\u0131lan ortalama birimleri ve toplam geliri g\u00f6steren bir \u00f6zet tablomuz var.<\/span><\/p>\n Son olarak, \u00f6zet tablosunun her h\u00fccresinin etraf\u0131na kenarl\u0131k eklemekten ve \u00f6zet tablosunu daha estetik hale getirmek i\u00e7in arka plan renkleri eklemekten \u00e7ekinmeyin:<\/span> <\/p>\n \u00d6zet tablosunun okunmas\u0131 art\u0131k daha da kolay.<\/span><\/p>\n Not<\/strong> : \u00d6zet tablomuzda ortalama de\u011ferleri ve toplam de\u011ferleri hesaplamay\u0131 se\u00e7iyoruz, ancak minimum, maksimum, medyan, aral\u0131k ve di\u011fer metrikler gibi di\u011fer ilgi \u00e7ekici de\u011ferleri de hesaplamaktan \u00e7ekinmeyin.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel’de Ke\u015fif Ama\u00e7l\u0131 Veri Analizi Nas\u0131l Ger\u00e7ekle\u015ftirilir?<\/a> \u00c7o\u011fu zaman bir veri k\u00fcmesinin de\u011ferlerini \u00f6zetlemek i\u00e7in Excel’de bir \u00f6zet tablosu olu\u015fturmak isteyebilirsiniz. Neyse ki Excel’in yerle\u015fik i\u015flevleri sayesinde bunu yapmak kolayd\u0131r. A\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, pratikte Excel’de bir \u00f6zet tablosunun nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6sterir. 1. Ad\u0131m: Orijinal verileri girin \u00d6ncelikle bir firman\u0131n \u00fcr\u00fcn sat\u0131\u015flar\u0131na ili\u015fkin bilgileri i\u00e7eren a\u015fa\u011f\u0131daki veri setini girece\u011fiz: Ad\u0131m 2: Benzersiz […]<\/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-3175","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n 1. Ad\u0131m: Orijinal verileri girin<\/strong><\/span><\/h3>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-recapitulatifexcel1.jpg\")
<\/p>\n Ad\u0131m 2: Benzersiz De\u011ferleri Bulun<\/strong><\/span><\/h3>\n
=SINGLE( B2:B13<\/span> )\n<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-recapitulatifexcel2.jpg\")
<\/p>\n 3. Ad\u0131m: Her de\u011fi\u015fken i\u00e7in \u00f6zet istatistikleri hesaplay\u0131n<\/strong><\/span><\/h3>\n
=SUMIF( $B$2:$B$13<\/span> , F2<\/span> , $C$2:$C$13<\/span> )<\/strong><\/pre>\n =AVERAGEIF( $B$2:$B$13<\/span> , F2<\/span> , $C$2:$C$13<\/span> )<\/strong><\/pre>\n =SUMIF( $B$2:$B$13<\/span> , F2<\/span> , $D$2:$D$13<\/span> )<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-recapitulatifexcel3.jpg\")
<\/p>\n 4. Ad\u0131m: \u00d6zet tablosunu bi\u00e7imlendirin (iste\u011fe ba\u011fl\u0131)<\/strong><\/span><\/h3>\n
![\"Excel'deki](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tableau-recapitulatifexcel4.jpg\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h3>\n
Excel’de gruba g\u00f6re toplam nas\u0131l hesaplan\u0131r<\/a>
Excel’de gruba g\u00f6re sayma<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"