![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/1-1.png\")
<\/a>Google Drive Ekran G\u00f6r\u00fcnt\u00fcs\u00fc<\/p><\/div>\n
Belge a\u00e7\u0131ld\u0131\u011f\u0131nda sat\u0131r ve s\u00fctunlardan olu\u015fan bo\u015f bir e-tablo g\u00f6receksiniz, buras\u0131 verilerinizin ya\u015fayaca\u011f\u0131 yerdir.<\/p>\n
\u0130\u015fte bir sat\u0131r.<\/p>\n
![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/2.png\")
<\/a>Google E-Tablolar Sat\u0131r Ekran G\u00f6r\u00fcnt\u00fcs\u00fc<\/p><\/div>\n
Ve i\u015fte bir s\u00fctun.<\/p>\n
![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/4.png\")
<\/a>Google E-Tablolar S\u00fctun Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n
Bo\u015f bir e-tablo kullanmaya ba\u015flad\u0131\u011f\u0131n\u0131zda, ba\u015fl\u0131klar\u0131n\u0131z i\u00e7in her zaman en \u00fcst sat\u0131r\u0131 kullanman\u0131z \u00f6nerilir. Bunlar veri kategorilerinizin adlar\u0131d\u0131r; \u00f6rne\u011fin NAME (\u0130S\u0130M). Birazdan bunun bir \u00f6rne\u011fini g\u00f6receksiniz.<\/p>\n
\u015eimdilik A s\u00fctunundaki azalan alanlara a\u015fa\u011f\u0131daki verileri girin:<\/p>\n
\u0130S\u0130M<\/strong> B s\u00fctununa maa\u015flar\u0131 a\u015fa\u011f\u0131daki gibi girin:<\/p>\n MAA\u015e<\/strong> Say\u0131larda olas\u0131 bi\u00e7imlendirme sorunlar\u0131n\u0131 \u00f6nlemek i\u00e7in noktalama i\u015faretlerinden ka\u00e7\u0131n\u0131n. Verilerinizi d\u00fczenleme ve s\u0131ralama amac\u0131yla etiketlemek i\u00e7in her zaman s\u00fctun ba\u015fl\u0131klar\u0131n\u0131 ekledi\u011finizden emin olun. Ba\u015fl\u0131klar\u0131 kullanarak nas\u0131l s\u0131ralama ve filtreleme yapaca\u011f\u0131n\u0131z\u0131 daha sonra g\u00f6sterece\u011fiz.<\/p>\n Google E-Tablolar\u0131n \u0130lk \u0130ki Sat\u0131r\u0131n\u0131n Adland\u0131r\u0131lma Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Temel Form\u00fclleri Kullanmak<\/strong><\/p>\n Her form\u00fcl \u201c=\u201d i\u015faretiyle ba\u015flar. Form\u00fcl\u00fcn\u00fcz\u00fc yazarken dikkatli olun \u00e7\u00fcnk\u00fc Google istedi\u011finizi d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fc \u015feyi otomatik olarak doldurmaya \u00e7al\u0131\u015facak ve bu da hataya yol a\u00e7acakt\u0131r bu nedenle form\u00fcllerinizi her zaman iki kez kontrol edin.<\/strong><\/p>\n \u00d6denen maa\u015flar\u0131n toplam\u0131n\u0131 g\u00f6rmek i\u00e7in B s\u00fctunundaki t\u00fcm \u00e7al\u0131\u015fanlar\u0131n y\u0131ll\u0131k maa\u015flar\u0131n\u0131 A s\u00fctununda toplayaca\u011f\u0131z. A\u015fa\u011f\u0131daki resimde B2’den B6’ya kadar g\u00f6rebilirsiniz. Bir form\u00fclde Google’\u0131n veri setinin ba\u015flang\u0131\u00e7 \u200b\u200bve biti\u015f h\u00fccrelerini tan\u0131mas\u0131 i\u00e7in bu \u201c=TOPLA(B2:B6)\u201d \u015fekilde\u00a0 yazaca\u011f\u0131z.<\/p>\n Google E-Tablolar Toplama Form\u00fcl\u00fc Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr<\/p><\/div>\n <\/p>\n Ayr\u0131ca \u201c=ORTALAMA(B2:B6)\u201d form\u00fcl\u00fcn\u00fc kullanarak \u00e7al\u0131\u015fanlar\u0131n ortalama maa\u015f\u0131n\u0131 da a\u015fa\u011f\u0131daki gibi hesaplayabiliriz.<\/p>\n Google E-Tablolar Ortalama Form\u00fcl\u00fc Ekran G\u00f6r\u00fcnt\u00fcs\u00fc.<\/p><\/div>\n Bu \u00f6rnekte ortalama maa\u015f 496000’dir. Ayk\u0131r\u0131 de\u011ferlere dikkat edin! A6 h\u00fccresindeki Mark’\u0131n ayk\u0131r\u0131 bir de\u011fer oldu\u011funa dikkat edin, maa\u015f\u0131 di\u011ferlerinden \u00e7ok daha fazla ve bu nedenle t\u00fcm \u00e7al\u0131\u015fanlar\u0131n ortalama maa\u015f\u0131 daha \u00e7arp\u0131k. (Di\u011fer t\u00fcm \u00e7al\u0131\u015fanlar\u0131n ortalama 496.000’den az kazand\u0131\u011f\u0131n\u0131 unutmay\u0131n.)<\/p>\n Gazeteciler genellikle hikayelerinde ortalamalar\u0131 kullan\u0131r ancak bu hesaplama verileri adil olmayan bir \u015fekilde yanl\u0131\u015f aktar\u0131labilir \u00e7\u00fcnk\u00fc ortalama, bireysel tutarlar\u0131n toplanmas\u0131 ve girdi say\u0131s\u0131na b\u00f6l\u00fcnmesiyle hesaplan\u0131r.<\/p>\n Ger\u00e7ek istatistiksel resme daha sad\u0131k kalabilmek i\u00e7in listelenen t\u00fcm de\u011ferlerin orta noktas\u0131nda yer alan de\u011feri bulmay\u0131 sa\u011flayan medyan\u0131 hesaplamak genellikle daha iyidir.<\/p>\n Google E-Tablolar Medyan Form\u00fcl\u00fcn Ekran G\u00f6r\u00fcnt\u00fcs\u00fc.<\/p><\/div>\n Bu durumda medyan 410.000, bu \u015firketin \u00e7al\u0131\u015fanlar\u0131n\u0131n tipik maa\u015f\u0131n\u0131 \u00e7ok daha ger\u00e7ek\u00e7i bir \u015fekilde temsil eder. (\u0130ki \u00e7al\u0131\u015fan\u0131n ortalamadan daha fazla, iki \u00e7al\u0131\u015fan\u0131n daha az ve birinin de tam olarak bu kadar kazand\u0131\u011f\u0131n\u0131 unutmay\u0131n.) Ayk\u0131r\u0131 de\u011ferleri kabul etmek ve bunlar\u0131n etkilerini anlamak, do\u011fru ve \u015feffaf habercilik i\u00e7in \u00e7ok \u00f6nemlidir.<\/p>\n \u015eimdi yeni maa\u015flarla yeni bir C s\u00fctunu olu\u015fturuyoruz ve yeni toplam\u0131 g\u00f6rmek istiyoruz. Form\u00fcl\u00fc tekrar yazmak yerine B8’e t\u0131kl\u0131yoruz ve yukar\u0131da o h\u00fccreyi dolduran form\u00fcl\u00fc g\u00f6rebiliyoruz.<\/p>\n Google E-Tablolar Yeni Toplama Form\u00fcl\u00fc Ekran G\u00f6r\u00fcnt\u00fcs\u00fc.<\/p><\/div>\n Yeni toplam maa\u015f i\u00e7in B8 h\u00fccresini kopyalay\u0131p C8 h\u00fccresine yap\u0131\u015ft\u0131rabiliriz; Google E-Tablolar, yeni C s\u00fctunumuzdaki veri alanlar\u0131n\u0131 kullanacak \u015fekilde form\u00fcl\u00fc otomatik olarak ayarlayacakt\u0131r.<\/p>\n Google E-Tablolar Otomatik Form\u00fcl Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Ancak dikkatli olun. \u0130lk form\u00fcl\u00fcn\u00fczde bir hata yaparsan\u0131z onu di\u011fer h\u00fccrelere kopyalamak yaln\u0131zca hatay\u0131 tekrarlayacakt\u0131r. T\u0131pk\u0131 bir r\u00f6portaj s\u0131ras\u0131nda bir kayna\u011f\u0131n size verdi\u011fi herhangi bir bilgiyi do\u011frulad\u0131\u011f\u0131n\u0131z gibi, toplad\u0131\u011f\u0131n\u0131z bilgilerin do\u011fru oldu\u011fundan emin olmak i\u00e7in form\u00fcllerinizi her zaman iki kez kontrol edin.<\/p>\n Form\u00fclleri kopyalaman\u0131n daha h\u0131zl\u0131 bir yolu, form\u00fcl\u00fcn bulundu\u011fu h\u00fccreye t\u0131klamak, imlecinizi sa\u011f alt k\u00f6\u015fede mavi nokta g\u00f6rd\u00fc\u011f\u00fcn\u00fcz yere ta\u015f\u0131makt\u0131r. Burada bir \u201c+\u201d i\u015fareti g\u00f6r\u00fcnecektir. Form\u00fcl\u00fc kopyalamak i\u00e7in t\u0131klay\u0131n ve imlecinizi sa\u011fa s\u00fcr\u00fckleyin.<\/p>\n Google E-Tablolar Form\u00fcllerini Kopyalaman\u0131n K\u0131sa Yolu Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n <\/p>\n \u015eimdi D s\u00fctununda FARK ba\u015fl\u0131\u011f\u0131yla yeni bir s\u00fctun yaparsak, eski maa\u015f\u0131 yenisinden \u00e7\u0131kararak maa\u015flar\u0131n ne kadar ayarland\u0131\u011f\u0131n\u0131 h\u0131zl\u0131 bir \u015fekilde hesaplayabiliriz.<\/p>\n Google E-Tablolar FARK<\/strong> Form\u00fcl\u00fc Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Girdikten sonra, Google E-Tablolar ayn\u0131 hesaplamay\u0131 di\u011fer sat\u0131rlar i\u00e7in \u00f6nerecektir. \u00d6neriyi kabul etmek i\u00e7in onay i\u015faretini t\u0131klayabilir veya imleci tekrar D2’nin sa\u011f alt k\u00f6\u015fesine getirip di\u011fer sat\u0131rlar boyunca a\u015fa\u011f\u0131, D6’ya s\u00fcr\u00fckleyebilirsiniz. Alternatif olarak, D2’nin sa\u011f alt k\u00f6\u015fesindeki mavi noktaya \u00e7ift t\u0131klayabilirsiniz. Bu, alttaki t\u00fcm sat\u0131rlar i\u00e7in form\u00fcl\u00fc otomatik olarak dolduracakt\u0131r.<\/p>\n Google E-Tablolar \u00d6NER\u0130 Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n <\/p>\n \u0130ki maa\u015f aras\u0131ndaki maa\u015f y\u00fczde de\u011fi\u015fimini bulmak i\u00e7in yeni maa\u015f\u0131 al\u0131p eski maa\u015f\u0131 \u00e7\u0131karmam\u0131z ve sonucu eski maa\u015fa b\u00f6lmemiz gerekiyor. \u0130\u015fte bunu hat\u0131rlaman\u0131za yard\u0131mc\u0131 olacak bir an\u0131msat\u0131c\u0131: kendinize \u015funu sorun: “\u00c7ocukken matemati\u011fi sever miydim?” “Hay\u0131r!” N-O-O = (Yeni \u2013 Eski) \/ Eski.<\/strong> (Form\u00fcl\u00fc hat\u0131rlaman\u0131n bu m\u00fckemmel yolu i\u00e7in gazeteci Sarah Cohen’e te\u015fekk\u00fcr ederiz).<\/p>\n Form\u00fcl\u00fc matematikte oldu\u011fu gibi yazaca\u011f\u0131z, Google E-Tablolar’a hangi i\u015flemin ilk \u00f6nce ger\u00e7ekle\u015fece\u011fini belirtmek i\u00e7in parantezleri () kullanarak yazaca\u011f\u0131z, bizim \u00f6rne\u011fimizde C2-B2.<\/p>\n Google E-Tablolar Y\u00fczde De\u011fi\u015fimi Hesaplama Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n <\/p>\n Ancak y\u00fczde de\u011fi\u015fim sonu\u00e7lar\u0131n\u0131 kolayca hikayelerimiz i\u00e7in kullanamayabiliriz.<\/p>\n Google E-Tablolar Y\u00fczde De\u011fi\u015fimi Sonu\u00e7lar\u0131 Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n <\/p>\n Bunu d\u00fczeltmek i\u00e7in, E s\u00fctununun \u00fcst k\u0131sm\u0131na t\u0131klayabiliriz, bu s\u00fctundaki t\u00fcm h\u00fccreleri vurgular, ard\u0131ndan \u00fcst sayfa men\u00fcs\u00fcnde Bi\u00e7imlendir’i t\u0131klay\u0131p Say\u0131 > Y\u00fczde’ye gidip s\u00fctunun tamam\u0131n\u0131 bi\u00e7imlendirmek i\u00e7in t\u0131klayabiliriz.<\/p>\n Google E-Tablolarda B\u0130\u00c7\u0130MLEND\u0130RME Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Google E-Tablolarda B\u0130\u00c7\u0130MLEND\u0130RME Sonucu Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n <\/p>\n \u015eimdi b\u00fct\u00fcn\u00fcn y\u00fczdesini hesaplamak i\u00e7in yeni bir F s\u00fctunu olu\u015fturaca\u011f\u0131z. Bunu ba\u015farmak i\u00e7in par\u00e7ay\u0131 b\u00fct\u00fcne, yani C2’ye (Andy’nin yeni maa\u015f\u0131) C8’e (yeni maa\u015flar\u0131n toplam\u0131) b\u00f6lmemiz gerekiyor.<\/p>\n Google E-Tablolar B\u00fct\u00fcn\u00fcn Y\u00fczdesini Hesaplama Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Daha \u00f6nce de belirtti\u011fimiz gibi, \u015fimdi ayn\u0131 hesaplamay\u0131 3’ten 6’ya kadar olan sat\u0131rlar i\u00e7in yapmak istersek, F2 h\u00fccresini s\u00fcr\u00fckleyerek form\u00fcl\u00fc F s\u00fctununun geri kalan\u0131na uygular\u0131z. Ancak bunu yapt\u0131\u011f\u0131m\u0131zda baz\u0131 yanl\u0131\u015flar yapar\u0131z veya garip sonu\u00e7lara ula\u015f\u0131r\u0131z.<\/p>\n Google E-Tablolarda Hesaplama Sonucu Garip Sonu\u00e7lar Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Bunun nedeni, bir form\u00fcl\u00fc kopyalay\u0131p di\u011fer sat\u0131rlara uygulad\u0131\u011f\u0131n\u0131zda, Google E-Tablolar’\u0131n yeni hesaplamay\u0131 yapmak i\u00e7in ilgili alanlar\u0131 kullanarak form\u00fcl\u00fc her zaman a\u015fa\u011f\u0131 do\u011fru ta\u015f\u0131maya devam etmesidir. Bu, F2 h\u00fccresindeki form\u00fcl\u00fcn C2\/C8, F3 h\u00fccresindeki form\u00fcl\u00fcn C3\/C9, F4’\u00fcn C4\/C10, F5’in C5\/C11 ve F6’n\u0131n C6\/C12 oldu\u011fu anlam\u0131na gelir.<\/p>\n \u201c$\u201d \u00e7apa<\/strong> arac\u0131n\u0131 kullanarak bu sorunu \u00f6nleyebiliriz. Form\u00fcl\u00fcm\u00fcz i\u00e7in her zaman belirli bir h\u00fccreyi kullanmak isteyece\u011fimizden, \u00e7apa Google E-Tablolar’a form\u00fcl\u00fc belirli bir h\u00fccreden ta\u015f\u0131mamas\u0131n\u0131 s\u00f6yleyen bir komuttur.<\/p>\n Bu durumda C8 h\u00fccresi (TOPLAM YEN\u0130 MAA\u015e), her zaman yeni maa\u015flar\u0131 b\u00f6lmek isteyece\u011fimiz h\u00fccredir. C8’i form\u00fcl\u00fcm\u00fcze sabitlemek i\u00e7in onu \u201cC2\/$C$8\u201d<\/strong> olarak yazaca\u011f\u0131z. Bu form\u00fclde iki \u00e7apa g\u00f6rebilirsiniz \u00e7\u00fcnk\u00fc Google E-Tablolara \u201cC s\u00fctunundan ayr\u0131lmay\u0131n ve 8. sat\u0131rdan ayr\u0131lmay\u0131n\u201d diyoruz. \u00c7apay\u0131 her zaman ilgili sat\u0131r ve s\u00fctunun \u00f6n\u00fcne<\/strong> koyun, sonras\u0131na<\/strong> de\u011fil.<\/p>\n Google E-Tablolarda \u00c7APA Kullan\u0131m Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Bundan sonra tekrar F s\u00fctununu se\u00e7ip \u00fcst men\u00fcye gidebiliriz ve \u201c#B\u00d6L\/0!\u201d hata mesajlar\u0131 yerine do\u011fru y\u00fczdeleri g\u00f6rmek i\u00e7in Say\u0131 > Y\u00fczde’yi t\u0131klayabiliriz.<\/p>\n Grafik Olu\u015fturmak<\/b><\/p>\n Gazeteciler olarak g\u00f6rselleri kullanarak insanlar\u0131n verileri anlamalar\u0131na yard\u0131mc\u0131 olmak istiyoruz. Bu \u00f6rnek \u00e7al\u0131\u015fma \u00fczerinden gidersek eski ve yeni maa\u015f\u0131 g\u00f6stermek istiyoruz, bu nedenle A1’den C6’ya kadar h\u00fccreleri se\u00e7memiz gerekecek.<\/p>\n Google E-Tablolarda Grafik Olu\u015fturma Ekran G\u00f6r\u00fcnt\u00fcs\u00fc.<\/p><\/div>\n Verileri se\u00e7tikten sonra \u00fcst men\u00fcdeki Ekle’ye ve ard\u0131ndan Grafik’e t\u0131klay\u0131n.<\/p>\n Google E-Tablolarda Grafik Ekleme B\u00f6l\u00fcm\u00fc Ekran G\u00f6r\u00fcnt\u00fcs\u00fc.<\/p><\/div>\n Google E-Tablolar sizin i\u00e7in bir grafik olu\u015fturacakt\u0131r ancak fareyle sa\u011fa gidip grafi\u011fi de\u011fi\u015ftirebilir, Grafik D\u00fczenleyici arac\u0131n\u0131 kullanarak grafi\u011finizi \u00f6zelle\u015ftirebilirsiniz.<\/p>\n Google E-Tablolar Grafik D\u00fczenleyici Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Ayr\u0131ca daha \u00f6nce F s\u00fctununda hesaplad\u0131\u011f\u0131m\u0131z t\u00fcm tutar\u0131n y\u00fczdelerini i\u00e7eren bir pasta grafi\u011fi de yapabiliriz. Bunu yapmak i\u00e7in A s\u00fctununda isimlerin ve F s\u00fctununda y\u00fczdelerin olmas\u0131 gerekir. \u0130ki s\u00fctun yan yana olmad\u0131\u011f\u0131ndan A1’e t\u0131klay\u0131p imleci s\u00fcr\u00fckleyemeyiz. Bu durumda A1’e t\u0131kl\u0131yoruz, bas\u0131l\u0131 tutuyoruz, A6’ya s\u00fcr\u00fckleyip b\u0131rak\u0131yoruz ve se\u00e7imi tamaml\u0131yoruz.<\/p>\n Daha sonra imleci F1’e getiriyoruz, Mac i\u00e7in Command veya Windows i\u00e7in Control tu\u015funa bas\u0131yoruz, bas\u0131l\u0131 tutuyoruz ve ard\u0131ndan imleci F6’ya do\u011fru s\u00fcr\u00fckleyiyoruz. B\u00f6ylece, pasta grafi\u011fimiz i\u00e7in tam olarak istedi\u011fimiz verileri se\u00e7ecektir.<\/p>\n Google E-Tablolar Pasta Grafik Yapma Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Bir kez daha \u00fcst men\u00fcdeki Ekle > Grafik se\u00e7ene\u011fine t\u0131kl\u0131yoruz ve Google E-Tablolar bir pasta grafik olu\u015fturacakt\u0131r.<\/p>\n Google E-Tablolar Pasta Grafik Ekleme Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n <\/p>\n Grafiklerinizi \u00f6zelle\u015ftirdikten sonra hikayeleriniz i\u00e7in ayr\u0131 ayr\u0131 kaydedebilirsiniz. Grafi\u011fin sa\u011f \u00fcst k\u00f6\u015fesindeki \u00fc\u00e7 dikey noktay\u0131 t\u0131klay\u0131n, “Grafi\u011fi indir” se\u00e7ene\u011fine gidin ve tercih etti\u011finiz dosya t\u00fcr\u00fcn\u00fc se\u00e7in.<\/p>\n Google E-Tablolar “Grafik \u0130ndir” Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Peki ya bize uzun bir veri listesi sunulsayd\u0131 ve bundan bir hikaye \u00e7\u0131karmak isteseydik? S\u0131ralama, verileri farkl\u0131 \u015fekillerde g\u00f6rmenin ve rakamlarda ilgin\u00e7 bir \u015fey olup olmad\u0131\u011f\u0131n\u0131 g\u00f6rmenin en iyi yollar\u0131ndan biridir.<\/p>\n \u00d6rne\u011fin, bu e-tabloda \u00fclkelere g\u00f6re ya\u015fam beklentisine bakaca\u011f\u0131z. Bunu kendiniz denemek i\u00e7in belgenin bir kopyas\u0131n\u0131 al\u0131n.<\/a><\/p>\n Elektronik tabloyu a\u00e7t\u0131ktan sonra A s\u00fctununa t\u0131klay\u0131n, bas\u0131l\u0131 tutun ve imleci do\u011frudan C s\u00fctununa s\u00fcr\u00fckleyin, b\u00f6ylece a\u015fa\u011f\u0131daki \u00fc\u00e7 s\u00fctun ve t\u00fcm veri sat\u0131rlar\u0131 se\u00e7ilir. Ard\u0131ndan \u00fcst men\u00fcde Veri > S\u0131ralama aral\u0131\u011f\u0131 > Geli\u015fmi\u015f aral\u0131k s\u0131ralama se\u00e7enekleri’ne t\u0131klay\u0131n.<\/p>\n Google E-Tablolarda Uzun Veri Listelerini S\u0131ralama Ekran G\u00f6r\u00fcnt\u00fcs\u00fc<\/p><\/div>\n \u00d6ncelikle, Google E-Tablolar’\u0131n ilk sat\u0131r 1’in bir veri sat\u0131r\u0131 de\u011fil, s\u00fctunlar\u0131n\u0131z\u0131n ba\u015fl\u0131klar\u0131\/adlar\u0131 oldu\u011funu bilmesi i\u00e7in “Verilerde ba\u015fl\u0131k sat\u0131r\u0131 var” se\u00e7ene\u011fini i\u015faretledi\u011finizden emin olun.<\/p>\n Google E-Tablolar Verilerde Ba\u015fl\u0131k Sat\u0131r\u0131 Var Ekran G\u00f6r\u00fcnt\u00fcs\u00fc.<\/p><\/div>\n A’dan Z’ye \u201cS\u0131rala: Erkek Ya\u015fam Beklentisi\u201d se\u00e7ene\u011fini se\u00e7erseniz erkeklerin ya\u015fam beklentisinin en d\u00fc\u015f\u00fck de\u011ferden (A) en y\u00fcksek de\u011fere (Z) kadar oldu\u011fu \u00fclkeleri g\u00f6receksiniz.<\/p>\n Google E-Tablolar A-Z S\u0131ralama Ekran G\u00f6r\u00fcnt\u00fcs\u00fc<\/p><\/div>\n <\/p>\n Google E-Tablolar S\u0131ralama Sonucu Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr<\/p><\/div>\n \u00d6te yandan, Z’den A’ya kadar se\u00e7im yaparsan\u0131z, bu size ilk olarak en y\u00fcksek de\u011fere sahip \u00fclkeleri verir, bizim \u00f6rne\u011fimizde bu \u0130svi\u00e7re’yi g\u00f6stermektedir.<\/p>\n Ancak baz\u0131 \u00fclkelerin hi\u00e7bir verisinin olmad\u0131\u011f\u0131n\u0131 da g\u00f6rebilirsiniz. Y\u00fczlerce sat\u0131r\u0131 s\u0131ralayarak hangi \u00fclkelerin verilerinin eksik oldu\u011funu h\u0131zl\u0131 bir \u015fekilde g\u00f6rebilir ve bulgular\u0131n\u0131z\u0131 yanl\u0131\u015f aktarmamak i\u00e7in haberinizde yer verebilirsiniz.<\/p>\n Sat\u0131rlar\u0131 ve S\u00fctunlar\u0131 Dondur<\/b><\/p>\n Son olarak, son ipu\u00e7lar\u0131m\u0131z i\u00e7in yeni bir veri seti kullanaca\u011f\u0131z. Avrupal\u0131 \u200b\u200bfutbolcular\u0131n maa\u015flar\u0131na ili\u015fkin bu belgenin bir kopyas\u0131n\u0131 olu\u015fturunuz l\u00fctfen.<\/a><\/p>\n A\u00e7t\u0131\u011f\u0131n\u0131zda ve kayd\u0131rd\u0131\u011f\u0131n\u0131zda, a\u015fa\u011f\u0131 kayd\u0131rd\u0131k\u00e7a \u00fcst sat\u0131r ba\u015fl\u0131klar\u0131n\u0131n kayboldu\u011funu g\u00f6r\u00fcrs\u00fcn\u00fcz. Bu bilgilerin her zaman g\u00f6r\u00fcn\u00fcr kalmas\u0131n\u0131 istiyorsan\u0131z sorun olabilir. Bu sorunu d\u00fczeltmek i\u00e7in 1. sat\u0131ra sa\u011f t\u0131klay\u0131n ve altta Di\u011fer sat\u0131r eylemlerini g\u00f6r\u00fcnt\u00fcle > 1. sat\u0131ra kadar dondur’a t\u0131klay\u0131n\u0131z.<\/p>\n Google E-Tablolar Sat\u0131r \/S\u00fctun Dondurma Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Art\u0131k a\u015fa\u011f\u0131 kayd\u0131rd\u0131\u011f\u0131n\u0131zda \u00fcst sat\u0131r\u0131n her zaman g\u00f6r\u00fcn\u00fcr kalaca\u011f\u0131n\u0131 g\u00f6receksiniz. Ayn\u0131s\u0131n\u0131 s\u00fctunlarla da yapabilirsiniz, A s\u00fctununa sa\u011f t\u0131klay\u0131p dondurmay\u0131 deneyebilirsiniz.<\/p>\n Fikrinizi de\u011fi\u015ftirirseniz ayn\u0131 ad\u0131mlar\u0131 izleyin; b\u00f6ylece blo\u011fu kald\u0131rmak i\u00e7in “Dondurmay\u0131 \u00c7\u00f6z” se\u00e7ene\u011fine t\u0131klayabilirsiniz.<\/p>\n Filtreleri Kullanma<\/b><\/p>\n Ya yaln\u0131zca belirli bir veri setini g\u00f6rmek istersek? Filtre se\u00e7ene\u011fini kullanaca\u011f\u0131z.<\/p>\n Verileriniz i\u00e7in filtreleri etkinle\u015ftirmek amac\u0131yla, verilerde herhangi bir yeri t\u0131klaman\u0131z ve ard\u0131ndan \u00fcst men\u00fcde Veri > Filtre olu\u015ftur’u t\u0131klaman\u0131z yeterlidir.<\/p>\n Google E-Tablolar F\u0130LTRELEME Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n <\/p>\n Art\u0131k \u00fcst sat\u0131rdaki ba\u015fl\u0131k alanlar\u0131nda, s\u00fctun adlar\u0131n\u0131n yan\u0131nda ters \u00fc\u00e7gen d\u00fc\u011fmelerin g\u00f6r\u00fcnd\u00fc\u011f\u00fcn\u00fc g\u00f6receksiniz.<\/p>\n Google E-Tablolar Filtre Uygulama Sonras\u0131 Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n <\/p>\n C1’de Nation’\u0131n yan\u0131ndaki ters \u00fc\u00e7gene t\u0131klay\u0131n ve se\u00e7ilen t\u00fcm verileri kald\u0131rmak i\u00e7in “Temizle”ye t\u0131klay\u0131n, ard\u0131ndan de GER’i se\u00e7in ve Tamam’a t\u0131klay\u0131n.<\/p>\n Google E-Tablolar Spesifik Filtre Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Art\u0131k en \u00e7ok kazanan Alman futbolcular\u0131n t\u00fcm\u00fcn\u00fc g\u00f6rebileceksiniz. Bu i\u015flemi birden fazla \u00fclke i\u00e7in tekrarlayabilirsiniz.<\/p>\n Google E-Tablolar \u00c7OKLU F\u0130LTRELEME Ekran G\u00f6r\u00fcnt\u00fcs\u00fcd\u00fcr.<\/p><\/div>\n Ancak sat\u0131rlar\u0131n art\u0131k ard\u0131\u015f\u0131k say\u0131 s\u0131ras\u0131na g\u00f6re listelenmedi\u011fini, 1’den 6’ya, 13’ten 19’a ve 97’ye kadar gitti\u011fini unutmay\u0131n.<\/p>\n Bunun nedeni, Google E-Tablolar’\u0131n g\u00f6rmek istemedi\u011finize karar verdi\u011finiz verileri gizlemesine ra\u011fmen silmemesidir.<\/p>\n Dolay\u0131s\u0131yla bu durumda, daha \u00f6nce yapt\u0131\u011f\u0131m\u0131z gibi listenin alt\u0131ndaki =SUM i\u015flevini kullanamazs\u0131n\u0131z [=SUM(G6:G97)] . \u00c7\u00fcnk\u00fc Alman olmayan futbolcular\u0131n gizli sat\u0131rlar\u0131 da dahil olmak \u00fczere 1. sat\u0131rdan 97. sat\u0131ra kadar t\u00fcm verileri ekleyecektir.<\/p>\n Hesaplamalar\u0131n\u0131z i\u00e7in yine de bu belirli verileri kullanmak istiyorsan\u0131z verileri se\u00e7in, kopyalay\u0131n ve ard\u0131ndan yeni bir sayfa olu\u015fturmak i\u00e7in belgenizin sol alt k\u0131sm\u0131ndaki art\u0131 i\u015faretini t\u0131klay\u0131n.<\/p>\n Google E-Tablolar Yeni Tablo Ekleme Ekran G\u00f6r\u00fcnt\u00fcs\u00fc.<\/p><\/div>\n <\/p>\n \u015eimdi verileri yap\u0131\u015ft\u0131r\u0131n, sat\u0131rlar\u0131n bir kez daha do\u011fru \u015fekilde numaraland\u0131r\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6receksiniz. Bunun nedeni art\u0131k gizli veri olmamas\u0131 ve ara\u015ft\u0131rman\u0131z i\u00e7in verileri hesaplamak amac\u0131yla =TOPLA veya di\u011fer i\u015flevleri kullanabilmenizdir.<\/p>\n Web sitemizde daha bir\u00e7ok ipucu ve ara\u00e7 bulabilirsiniz. Ayr\u0131ca, Bir Ara\u015ft\u0131rmay\u0131 Mahvedebilecek 10 Basit Veri Hatas\u0131na<\/a> g\u00f6z at\u0131n veya Kaynak Merkezimizin veri k\u0131lavuzlar\u0131n\u0131 inceleyiniz!<\/a><\/p>\n Bu k\u0131lavuz, 19-22 Eyl\u00fcl 2023 tarihleri \u200b\u200baras\u0131nda \u0130sve\u00e7’in G\u00f6teborg kentinde, 2023 K\u00fcresel Ara\u015ft\u0131rmac\u0131 Gazetecilik Konferans\u0131’nda d\u00fczenlenen bir oturumdan al\u0131nan ipu\u00e7lar\u0131na ve tekniklere dayanmaktad\u0131r. Oturumda konu\u015fmac\u0131lar aras\u0131nda Missouri \u00dcniversitesi Gazetecilik Okulu profes\u00f6r\u00fc Mark Horvit, Kaas & Mulvad’\u0131n kurucu orta\u011f\u0131 Tommy Kaas ve NBC News Investigations’\u0131n k\u0131demli edit\u00f6r\u00fc Andrew Lehren yer al\u0131yor. Oturum kayd\u0131n\u0131n tamam\u0131n\u0131 YouTube kanal\u0131m\u0131zdan izleyebilirsiniz<\/a>. Yaz\u0131da netlik sa\u011flamak i\u00e7in GIJN’in \u00e7evrim i\u00e7i yap\u0131mc\u0131s\u0131 Leonardo Peralta taraf\u0131ndan d\u00fczenlendi ve k\u0131salt\u0131ld\u0131.<\/p>\n \n
\nAndy
\nJohn
\nMary
\nSally
\nMark<\/p>\n
\n450000
\n380000
\n410000
\n290000
\n950000<\/p>\n![\"Google](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/5.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/6.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/7.png\")
<\/a>![\"Google](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/8.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/9.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/10.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/11.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/12.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/13.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/14.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/15.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/16.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/17.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/18.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/19.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/20.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/21.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/22.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/23.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/24.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/25.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/26.png\")
<\/a>
\nUzun Veri Listelerini S\u0131ralama<\/b><\/p>\n![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/27.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/28.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/29.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/30.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/31.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/32.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/33.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/34.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/35.png\")
<\/a>![\"\"](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/07\/36.png\")
<\/a>
\n![](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/05\/40-140x140.png\")
Mark Horvit<\/a>,<\/strong> Missouri \u00dcniversitesi Gazetecilik Okulu’nda ara\u015ft\u0131rmac\u0131 gazetecilik dersleri veren bir profes\u00f6rd\u00fcr ve okulun Eyalet H\u00fck\u00fcmeti Raporlama Program\u0131n\u0131n y\u00f6neticisidir. Ayn\u0131 zamanda Gazetecilik Meslekleri Fak\u00fcltesi’nin ba\u015fkan\u0131d\u0131r. Horvit daha \u00f6nce Ara\u015ft\u0131rmac\u0131 Muhabirler ve Edit\u00f6rler (IRE) ve Ulusal Bilgisayar Destekli Habercilik Enstit\u00fcs\u00fc’nde (NICAR) genel m\u00fcd\u00fcr olarak g\u00f6rev yapt\u0131 ve burada d\u00fcnya \u00e7ap\u0131nda ara\u015ft\u0131rmac\u0131 habercilik ve veri gazetecili\u011fi konusunda e\u011fitimler verdi. Horvit, IRE’ye kat\u0131lmadan \u00f6nce 20 y\u0131l boyunca muhabir ve edit\u00f6r olarak \u00e7al\u0131\u015ft\u0131.<\/p>\n![](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/05\/41-140x140.png\")
Tommy Kaas<\/a>,<\/strong> karma\u015f\u0131k verilerdeki haberleri ve kal\u0131plar\u0131 bulma ve sonu\u00e7lar\u0131 \u00e7evrimi\u00e7i sunma konusunda uzmanla\u015fm\u0131\u015f Kaas & Mulvad<\/a>‘\u0131n (2007’de kuruldu) edit\u00f6r\u00fcd\u00fcr. Tommy, Roskilde \u00dcniversitesi Gazetecilik Program\u0131’nda \u00f6\u011fretim g\u00f6revlisi olarak \u00e7al\u0131\u015fmak da dahil olmak \u00fczere, \u00e7e\u015fitli Danimarka medyas\u0131nda ve Veri Gazetecili\u011fi e\u011fitiminde uzun y\u0131llara dayanan deneyime sahiptir. Ayn\u0131 zamanda Computerst\u00f8ttet Journalistik 1997 ve DICAR 1999 i\u00e7in Foreningen’in kurucu orta\u011f\u0131d\u0131r.<\/p>\n
![](\"https:\/\/gijn.org\/wp-content\/uploads\/2024\/05\/42-140x140.png\")
Andrew W. Lehren<\/a>, NBC News Investigations ekibinde k\u0131demli edit\u00f6r olarak g\u00f6rev yapmaktad\u0131r. Pandemi ve ekonomik yard\u0131m \u00e7abalar\u0131 hakk\u0131nda haberler yapm\u0131\u015f ve \u0130mplant Dosyalar\u0131, \u00c7in Dosyalar\u0131 ve FinCEN Dosyalar\u0131 da dahil olmak \u00fczere be\u015f Uluslararas\u0131 Ara\u015ft\u0131rmac\u0131 Gazeteciler Konsorsiyumu i\u015fbirli\u011finde \u00e7al\u0131\u015fmalara liderlik etmi\u015ftir. Faul toplar\u0131 nedeniyle yaralanan insanlar \u00fczerine yapt\u0131\u011f\u0131 \u00e7al\u0131\u015fmalar, Major League Baseball’un t\u00fcm stadyumlar\u0131nda koruma \u00f6nlemlerini geni\u015fletmesine yol a\u00e7t\u0131. Daha \u00f6nce The New York Times’ta yakla\u015f\u0131k 13 y\u0131l muhabir olarak ulusal, uluslararas\u0131 ve ara\u015ft\u0131rmac\u0131 hikayeler \u00fczerinde \u00e7al\u0131\u015fm\u0131\u015ft\u0131r. WikiLeaks’in diplomatik kablolar\u0131, Afganistan ve Irak sava\u015f kay\u0131tlar\u0131n\u0131 ve Guantanamo tutuklu dosyalar\u0131n\u0131 analiz eden gazetenin ba\u015f muhabirlerinden biriydi. Bu hikayeler A\u00e7\u0131k S\u0131rlar adl\u0131 \u00e7ok satan bir kitapta derlendi. ABD ila\u00e7lar\u0131n\u0131 kirleten standart alt\u0131 \u00c7in kimyasallar\u0131n\u0131 inceleyen Pulitzer \u00f6d\u00fcll\u00fc diziye katk\u0131da bulundu. Missouri \u00dcniversitesi ve Lehigh \u00dcniversitesi’nden dereceler ald\u0131.<\/p>\n","protected":false},"excerpt":{"rendered":"