{"id":2107,"date":"2023-10-15T14:27:37","date_gmt":"2023-10-15T14:27:37","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/"},"modified":"2023-12-10T06:01:15","modified_gmt":"2023-12-10T06:01:15","slug":"excel-istatistik-fonksiyonlari","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/","title":{"rendered":"Excel&#39;de istatistiksel i\u015flevler nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-671991886\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <h2 class=\"wp-block-heading\">ORTALAMA i\u015flevi<\/h2><p> Excel&#8217;deki ORTALAMA i\u015flevi, Microsoft Excel&#8217;deki \u0130statistiksel \u0130\u015flevler kategorisinde listelenir. Fonksiyona girdi\u011finiz say\u0131sal de\u011ferlerin ortalamas\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Basit bir ifadeyle, fonksiyonda belirtti\u011finiz t\u00fcm de\u011ferleri toplar, ard\u0131ndan say\u0131ya b\u00f6ler ve sonucu d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>=ORTALAMA(say\u01311,say\u01312,\u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>say\u01311<\/strong> : Ortalamay\u0131 hesaplamak i\u00e7in kullanmak istedi\u011finiz ilk say\u0131.<\/li><li> <strong>[say\u01312]<\/strong> : Ortalama almak i\u00e7in kullanmak istedi\u011finiz ikinci say\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> ORTALAMA i\u015flevinde ustala\u015fmak i\u00e7in bunu bir \u00f6rnekte denememiz gerekiyor ve a\u015fa\u011f\u0131da deneyebilece\u011finiz bir \u00f6rnek var: <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36861\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-moyenne-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ortalama-i\u015flev-\u00f6rnek-1\" width=\"638\" height=\"424\"><\/figure><\/div><p> \u0130lk \u00f6rnekte arg\u00fcmanlar\u0131 do\u011frudan fonksiyona girdik.<\/p><p> \u0130kinci \u00f6rnekte say\u0131lar\u0131 i\u00e7eren bir aral\u0131ktan bahsettik. S\u00fcrekli aral\u0131k kullanarak s\u0131n\u0131rs\u0131z h\u00fccreye ba\u015fvurabilirsiniz ve dinamik aral\u0131\u011fa ba\u015fvurmak istiyorsan\u0131z bunun i\u00e7in bir tablo kullanabilirsiniz.<\/p><p> S\u00fcrekli aral\u0131k kullanarak s\u0131n\u0131rs\u0131z h\u00fccreye ba\u015fvurabilirsiniz ve dinamik aral\u0131\u011fa ba\u015fvurmak istiyorsan\u0131z bunun i\u00e7in bir tablo kullanabilirsiniz.<\/p><p> \u00dc\u00e7\u00fcnc\u00fc \u00f6rnekte h\u00fccrelerin metin de\u011feri olarak formatland\u0131\u011f\u0131 bir aral\u0131ktan bahsettik. Bu durumda ortalamay\u0131 hesaplamak i\u00e7in bu metin say\u0131lar\u0131n\u0131 ger\u00e7ek say\u0131lara d\u00f6n\u00fc\u015ft\u00fcrebilirsiniz.<\/p><p> D\u00f6rd\u00fcnc\u00fc \u00f6rnekte, her h\u00fccredeki her de\u011ferin \u00f6n\u00fcnde bir kesme i\u015fareti var ve bu nedenle fonksiyon taraf\u0131ndan g\u00f6z ard\u0131 ediliyor.<\/p><h2 class=\"wp-block-heading\"> ORTALAMA<\/h2><p> Excel ORTALAMAA i\u015flevi, Microsoft Excel&#8217;in \u0130statistiksel \u0130\u015flevler kategorisinde listelenir. \u0130\u015flevde <strong>belirtti\u011finiz say\u0131lar\u0131n ortalamas\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr<\/strong> ancak AVERAGE ve AVERAGEA&#8217;dan farkl\u0131 olarak Boolean de\u011ferlerini ve metin olarak bi\u00e7imlendirilmi\u015f say\u0131lar\u0131 dikkate al\u0131r.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>=ORTALAMAA(de\u011fer1,de\u011fer2,\u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer1<\/strong> : Metin olarak depolanan bir say\u0131, mant\u0131ksal de\u011fer veya say\u0131 olan bir de\u011fer.<\/li><li> <strong>[de\u011fer2]<\/strong> : Say\u0131, mant\u0131ksal de\u011fer veya metin olarak depolanan say\u0131 olan bir de\u011fer.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> ORTALAMAA i\u015flevinde uzmanla\u015fmak i\u00e7in onu bir \u00f6rnekte denememiz gerekiyor ve a\u015fa\u011f\u0131da deneyebilece\u011finiz bir \u00f6rnek var: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36865\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-moyennea-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ortalama-i\u015flev-\u00f6rnek-1\" width=\"614\" height=\"449\"><\/figure><\/div><p> Fonksiyonun d\u00f6nd\u00fcrd\u00fc\u011f\u00fc de\u011fer 10.17 yani \u201c(0+0+1+10+20+30)\/6\u201dd\u0131r.<\/p><h2 class=\"wp-block-heading\"> ORTALAMA E\u011eER<\/h2><p> Excel ORTALAMA E\u011eER i\u015flevi, Microsoft Excel&#8217;in \u0130statistiksel \u0130\u015flevler kategorisinde listelenir. <strong>Belirtti\u011finiz \u00e7e\u015fitli ko\u015fullar\u0131 kar\u015f\u0131layan say\u0131lar\u0131n ortalamas\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr<\/strong> . ORTALAMAIF&#8217;den farkl\u0131 olarak, birden fazla ko\u015fulu ve yaln\u0131zca t\u00fcm ko\u015fullar\u0131 kar\u015f\u0131layan ortalama say\u0131lar\u0131 tan\u0131mlayabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>= E\u011eERORTALAMA(ortalama_aral\u0131k, \u00f6l\u00e7\u00fct_aral\u0131\u011f\u01311, \u00f6l\u00e7\u00fct1, [\u00f6l\u00e7\u00fct_aral\u0131\u011f\u01312, \u00f6l\u00e7\u00fct2], \u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>\u200bcriteria_range1:<\/strong> Durumu test etmek istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>kriter1:<\/strong> test etmek istedi\u011finiz bir ko\u015ful.<\/li><li> <strong>[criteria_range2]:<\/strong> Durumu test etmek istedi\u011finiz ikinci h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>[kriter 1]:<\/strong> test etmek istedi\u011finiz ikinci bir ko\u015ful.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> E\u011eERORTALAMA i\u015flevinde ustala\u015fmak i\u00e7in bunu bir \u00f6rnekte denememiz gerekiyor ve a\u015fa\u011f\u0131da deneyebilece\u011finiz bir \u00f6rnek var:<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte, &#8220;Peter&#8221; sat\u0131c\u0131s\u0131 taraf\u0131ndan ve &#8220;B&#8221; \u00fcr\u00fcn\u00fc i\u00e7in sat\u0131lan ortalama miktar\u0131 hesaplamak amac\u0131yla ORTALAMAIFS fonksiyonunu kulland\u0131k. Kriterleri do\u011frudan fonksiyona ekledik ve B \u00fcr\u00fcn\u00fcn\u00fc satan Peter&#8217;dan iki girdimiz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36870\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-moyenne-dexcel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ortalamalar-i\u015flev-\u00f6rnek-1\" width=\"676\" height=\"596\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, miktar\u0131 20 birimden b\u00fcy\u00fck olan ve ad\u0131 B olan meyvelerin ortalama fiyat\u0131n\u0131 hesaplamak i\u00e7in y\u0131ld\u0131z i\u015faretli AVERAGEIFS&#8217;yi kulland\u0131k.<\/p><p> A\u015fa\u011f\u0131daki verilerde bu kriterleri kar\u015f\u0131layan iki meyvemiz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36871\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-moyenne-Excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ortalamalar-i\u015flev-\u00f6rnek-2\" width=\"588\" height=\"570\"><\/figure><\/div><h2 class=\"wp-block-heading\"> COUNT i\u015flevi<\/h2><p> Excel COUNT i\u015flevi, Microsoft Excel&#8217;in \u0130statistiksel \u0130\u015flevler kategorisinde listelenir. <strong>Belirtti\u011finiz de\u011ferlerden bir say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, yaln\u0131zca o say\u0131n\u0131n de\u011ferlerini dikkate al\u0131r ve sonu\u00e7ta bunlar\u0131n say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>= COUNT(de\u011fer1, [de\u011fer2], \u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer1:<\/strong> do\u011frudan i\u015fleve girilen bir h\u00fccre ba\u015fvurusu, dizi veya say\u0131.<\/li><li> [de\u011fer2]: do\u011frudan fonksiyona girilen bir h\u00fccre referans\u0131, dizi veya say\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> COUNT i\u015flevinde ustala\u015fmak i\u00e7in bunu bir \u00f6rnekte denememiz gerekiyor ve a\u015fa\u011f\u0131da deneyebilece\u011finiz bir \u00f6rnek var:<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte A1:A10 aral\u0131\u011f\u0131ndaki h\u00fccreleri saymak i\u00e7in bu fonksiyonu kulland\u0131k ve sonu\u00e7ta 8 sonucunu d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36883\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-comptage-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-count-fonksiyon-\u00f6rnek-1\" width=\"600\" height=\"534\"><\/figure><\/div><p> A3 h\u00fccresinde mant\u0131ksal bir de\u011ferimiz var ve A7 h\u00fccresinde bir miktar metin var. COUNT her iki h\u00fccreyi de yok sayd\u0131. Ancak fonksiyona do\u011frudan mant\u0131ksal bir de\u011fer girerseniz, onu sayacakt\u0131r. A\u015fa\u011f\u0131daki \u00f6rnekte \u00e7ift t\u0131rnak kullanarak mant\u0131ksal bir de\u011fer ve say\u0131 ekledik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36885\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-comptage-excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-count-fonksiyon-\u00f6rnek-2\" width=\"620\" height=\"411\"><\/figure><\/div><h2 class=\"wp-block-heading\"> NBVAL i\u015flevi<\/h2><p> Excel COUNTA i\u015flevi, Microsoft Excel&#8217;in \u0130statistiksel \u0130\u015flevler kategorisinde listelenir. <strong>Belirtti\u011finiz de\u011ferlerin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr<\/strong> . COUNT&#8217;tan farkl\u0131 olarak t\u00fcm de\u011fer t\u00fcrlerini dikkate al\u0131r ancak bo\u015f olan (H\u00fccreleri) yok sayar. Basit\u00e7e s\u00f6ylemek gerekirse t\u00fcm h\u00fccreler bo\u015f de\u011fildir.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>= COUNTA(de\u011fer1, [de\u011fer2], \u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer1:<\/strong> bir de\u011fer, h\u00fccre ba\u015fvurusu, h\u00fccre aral\u0131\u011f\u0131 veya dizi.<\/li><li> <strong>[de\u011fer2]:<\/strong> bir de\u011fer, h\u00fccre ba\u015fvurusu, h\u00fccre aral\u0131\u011f\u0131 veya dizi<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> COUNTA i\u015flevinde uzmanla\u015fmak i\u00e7in bunu bir \u00f6rnekte denememiz gerekiyor ve a\u015fa\u011f\u0131da deneyebilece\u011finiz bir \u00f6rnek var:<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte A1:A11 aral\u0131\u011f\u0131ndaki h\u00fccreleri saymak i\u00e7in COUNTA fonksiyonunu kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36887\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-counta-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-counta-i\u015flevi-\u00f6rnek-1\" width=\"585\" height=\"529\"><\/figure><\/div><p> Aral\u0131kta toplam 11 h\u00fccre var ve i\u015flev 10 d\u00f6nd\u00fcrd\u00fc. Aral\u0131kta i\u015flev taraf\u0131ndan g\u00f6z ard\u0131 edilen bo\u015f bir h\u00fccrem var. Geri kalan h\u00fccrelerde say\u0131lar, metinler, mant\u0131ksal de\u011ferler ve bir sembol bulunur.<\/p><h2 class=\"wp-block-heading\"> HESAP BO\u015e<\/h2><p> Excel COUNTBLANK i\u015flevi, Microsoft Excel&#8217;in \u0130statistiksel \u0130\u015flevler kategorisinde listelenir. <strong>Bo\u015f veya de\u011fersiz h\u00fccrelerin say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit\u00e7e s\u00f6ylemek gerekirse, metin, say\u0131 veya hata i\u00e7eren h\u00fccreleri saymaz, ancak bo\u015f de\u011fer d\u00f6nd\u00fcren form\u00fclleri sayar.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>=COUNTBLANK(aral\u0131k)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>aral\u0131k:<\/strong> Bo\u015f h\u00fccreleri saymak istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> COUNTBLANK i\u015flevinde ustala\u015fmak i\u00e7in bunu bir \u00f6rnekte denememiz gerekiyor ve a\u015fa\u011f\u0131da deneyebilece\u011finiz bir \u00f6rnek var:<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte, A2:A8 aral\u0131\u011f\u0131ndaki bo\u015f h\u00fccreleri saymak i\u00e7in COUNTBLANK i\u015flevini kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36890\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-countblank-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-countblank-fonksiyonu-\u00f6rnek-1\" width=\"622\" height=\"554\"><\/figure><\/div><p> Bu aral\u0131kta toplam 3 bo\u015f h\u00fccremiz var, ancak A7 h\u00fccresi bo\u015f h\u00fccreyle sonu\u00e7lanan bir form\u00fcl i\u00e7eriyor.<\/p><p> \u0130\u015flev 2 de\u011ferini d\u00f6nd\u00fcrd\u00fc \u00e7\u00fcnk\u00fc A4 ve A5 h\u00fccreleri tek bo\u015f, de\u011fersiz h\u00fccrelerdi.<\/p><h2 class=\"wp-block-heading\"> 8. NB.IF<\/h2><p> Excel COUNTIF i\u015flevi, Microsoft Excel&#8217;in \u0130statistiksel \u0130\u015flevler kategorisinde listelenir. <strong>Belirtti\u011finiz ko\u015fulu kar\u015f\u0131layan say\u0131lar\u0131n say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, yaln\u0131zca ko\u015fulu kar\u015f\u0131layan de\u011fer say\u0131s\u0131n\u0131 dikkate al\u0131r ve hesaplar.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>= E\u011eERSAY(aral\u0131k, \u00f6l\u00e7\u00fct)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>aral\u0131k:<\/strong> Kriterlere uyan h\u00fccreleri saymak istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>kriterler:<\/strong> h\u00fccreleri saymak i\u00e7in kontrol edilecek bir kriter (b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131).<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> COUNTIF i\u015flevinde ustala\u015fmak i\u00e7in bunu bir \u00f6rnekte denememiz gerekiyor ve a\u015fa\u011f\u0131da deneyebilece\u011finiz bir \u00f6rnek var:<\/p><h3 class=\"wp-block-heading\"> Mant\u0131ksal i\u015fle\u00e7leri \u00f6l\u00e7\u00fct olarak kullan\u0131n<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte 75&#8217;in \u00fczerinde puan alan \u00f6\u011frenci say\u0131s\u0131n\u0131 saymak i\u00e7in &#8220;&gt;75&#8221; (mant\u0131ksal operat\u00f6r) kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36893\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-countif-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-countif-fonksiyon-\u00f6rnek-1\" width=\"824\" height=\"694\"><\/figure><\/div><p> Mant\u0131ksal bir operat\u00f6r kullanmak istiyorsan\u0131z onu \u00e7ift t\u0131rnak i\u00e7ine alman\u0131z gerekir.<\/p><h3 class=\"wp-block-heading\"> <strong>Tarihleri \u200b\u200b\u00f6l\u00e7\u00fct olarak kullanma<\/strong><\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, 4 Temmuz&#8217;da ka\u00e7 \u00e7al\u0131\u015fan\u0131n bir hafta izinli oldu\u011funu bulmak i\u00e7in kriterlerdeki bir tarihi kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36895\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-countif-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-countif-fonksiyon-\u00f6rnek-2\" width=\"710\" height=\"632\"><\/figure><\/div><p> \u0130\u015fleve do\u011frudan bir tarih ekledi\u011finizde COUNTIF, metni otomatik olarak tarihe d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte ayn\u0131 tarihi say\u0131 olarak ekledik ve bildi\u011finiz gibi Excel tarihi say\u0131 olarak sakl\u0131yor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36897\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-countif-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-countif-fonksiyon-\u00f6rnek-3\" width=\"729\" height=\"648\"><\/figure><\/div><p> Yani Excel&#8217;in tarih sistemine g\u00f6re bir tarihi temsil eden bir say\u0131 da ekleyebilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Not.IF<\/h2><p> Excel COUNTIFS i\u015flevi, Microsoft Excel&#8217;in \u0130statistiksel \u0130\u015flevler kategorisinde listelenir. <strong>Belirtti\u011finiz \u00e7e\u015fitli ko\u015fullar\u0131 kar\u015f\u0131layan say\u0131lar\u0131n say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> COUNTIF&#8217;in aksine, birden fazla ko\u015fulu tan\u0131mlayabilir ve yaln\u0131zca bu ko\u015fullar\u0131n t\u00fcm\u00fcn\u00fc kar\u015f\u0131layan say\u0131lar\u0131 sayabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>= \u00c7OKE\u011eERSAY(\u00f6l\u00e7\u00fct_aral\u0131\u011f\u01311, \u00f6l\u00e7\u00fct1, [\u00f6l\u00e7\u00fct_aral\u0131\u011f\u01312, \u00f6l\u00e7\u00fct2]\u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>\u00d6l\u00e7\u00fct_aral\u0131\u011f\u01311:<\/strong> \u00d6l\u00e7\u00fct1&#8217;i kullanarak de\u011ferlendirmek istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>\u00f6l\u00e7\u00fct1:<\/strong> \u00f6l\u00e7\u00fct_aral\u0131\u011f\u01311 i\u00e7in de\u011ferlendirmek istedi\u011finiz \u00f6l\u00e7\u00fctler.<\/li><li> <strong>[kriter_aral\u0131\u011f\u01312]:<\/strong> \u00d6l\u00e7\u00fct1&#8217;i kullanarak de\u011ferlendirmek istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>[kriter2]:<\/strong> Kriter_aral\u0131\u011f\u01311 i\u00e7in de\u011ferlendirmek istedi\u011finiz kriter.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> COUNTIFS i\u015flevinde uzmanla\u015fmak i\u00e7in bunu bir \u00f6rnekte denememiz gerekiyor ve a\u015fa\u011f\u0131da deneyebilece\u011finiz bir \u00f6rnek var:<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte 25 ya\u015f \u00fcst\u00fc kad\u0131nlar\u0131 saymak i\u00e7in COUNTIFS&#8217;i kulland\u0131k.<\/p><p> Ve iki de\u011ferlendirme kriteri belirledim; biri &#8220;Kad\u0131n&#8221;, di\u011feri ise &#8220;&gt;25&#8243;ten b\u00fcy\u00fck say\u0131ya sahip h\u00fccreleri saymak i\u00e7in bir b\u00fcy\u00fckt\u00fcr operat\u00f6r\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-39611\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-countifs-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-countif'ler-fonksiyon-\u00f6rnek-1\" width=\"649\" height=\"617\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, ad\u0131 A harfiyle ba\u015flayan ve ya\u015f\u0131 25&#8217;in \u00fczerinde olan ki\u015finin say\u0131s\u0131n\u0131 saymak i\u00e7in bir kriterde y\u0131ld\u0131z i\u015fareti, di\u011ferinde &gt; operat\u00f6r\u00fcn\u00fc kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-39612\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-countifs-fonction-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-countif'ler-fonksiyon-\u00f6rnek-2\" width=\"596\" height=\"556\"><\/figure><\/div><h2 class=\"wp-block-heading\"> MAKS<\/h2><p> Excel MAX i\u015flevi, Microsoft Excel&#8217;in \u0130statistiksel \u0130\u015flevler kategorisinde listelenir. <strong>De\u011ferler listesinden en b\u00fcy\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/strong> MAX maksimum anlam\u0131na gelir ve bir de\u011fer listesi belirtti\u011finizde en y\u00fcksek de\u011feri arar ve sonu\u00e7ta o de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>= MAX(say\u01311, [say\u01312], \u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>say\u01311:<\/strong> bir say\u0131, say\u0131y\u0131 i\u00e7eren bir h\u00fccre veya en b\u00fcy\u00fck say\u0131y\u0131 almak istedi\u011finiz say\u0131lar\u0131 i\u00e7eren bir h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>[say\u01312]:<\/strong> Say\u0131, en b\u00fcy\u00fck say\u0131y\u0131 elde etmek istedi\u011finiz say\u0131lar\u0131 i\u00e7eren bir say\u0131y\u0131 veya h\u00fccre aral\u0131\u011f\u0131n\u0131 i\u00e7eren bir h\u00fccredir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> MAX fonksiyonunda ustala\u015fmak i\u00e7in bunu bir \u00f6rnekte denememiz gerekiyor ve a\u015fa\u011f\u0131da deneyebilece\u011finiz bir \u00f6rnek var:<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte say\u0131lar\u0131 virg\u00fclle ay\u0131rarak do\u011frudan fonksiyona girdim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37130\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-max-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-max-i\u015flev-\u00f6rnek-1\" width=\"451\" height=\"343\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Not:<\/strong> \u00c7ift t\u0131rnak kullanarak da say\u0131 girebilirsiniz.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rnekte bir aral\u0131\u011fa referans verdik ve sonu\u00e7ta en y\u00fcksek de\u011fer olarak 1861 de\u011ferini d\u00f6nd\u00fcrd\u00fc. Ayr\u0131ca bir diziye de ba\u015fvurabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-max-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-max-i\u015flev-\u00f6rnek-2\" width=\"421\" height=\"591\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte bir hata de\u011feriyle kar\u015f\u0131la\u015ft\u0131k ve fonksiyon sonu\u00e7ta bir hata de\u011feri d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37132\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-max-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-max-i\u015flev-\u00f6rnek-3\" width=\"424\" height=\"468\"><\/figure><\/div><h2 class=\"wp-block-heading\"> dk.<\/h2><p> MIN i\u015flevi, de\u011ferler listesindeki en d\u00fc\u015f\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr. MIN minimum anlam\u0131na gelir ve bir de\u011fer listesi belirtti\u011finizde en d\u00fc\u015f\u00fck de\u011feri arar ve sonu\u00e7ta o de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> <em>= MIN(say\u01311, [say\u01312], \u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>say\u01311:<\/strong> say\u0131, say\u0131y\u0131 i\u00e7eren h\u00fccre veya en k\u00fc\u00e7\u00fck say\u0131y\u0131 almak istedi\u011finiz say\u0131lar\u0131 i\u00e7eren h\u00fccre aral\u0131\u011f\u0131.<\/li><li> <strong>[say\u01312]:<\/strong> bir say\u0131, bir say\u0131y\u0131 i\u00e7eren bir h\u00fccre veya en k\u00fc\u00e7\u00fck say\u0131y\u0131 almak istedi\u011finiz say\u0131lar\u0131 i\u00e7eren bir h\u00fccre aral\u0131\u011f\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte say\u0131lar\u0131 virg\u00fclle ay\u0131rarak do\u011frudan fonksiyona girdik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37189\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-min-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-min-fonksiyon-\u00f6rnek-1\" width=\"483\" height=\"337\"><\/figure><\/div><p> \u00c7ift t\u0131rnak kullanarak da bir say\u0131 girebilirsiniz. \u015eimdi a\u015fa\u011f\u0131daki \u00f6rnekte bir aral\u0131\u011fa referans verdik ve sonu\u00e7ta 1861 de\u011ferini d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37192\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-min-fonction-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-min-fonksiyon-\u00f6rnek-2\" width=\"407\" height=\"524\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte bir hata de\u011feriyle kar\u015f\u0131la\u015ft\u0131k ve fonksiyon sonu\u00e7ta bir hata de\u011feri d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37194\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-min-fonction-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-min-fonksiyon-\u00f6rnek-3\" width=\"403\" height=\"461\"><\/figure><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2107","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de istatistiksel i\u015flevler nas\u0131l kullan\u0131l\u0131r? (\u00d6rnekler)<\/title>\n<meta name=\"description\" content=\"\u00d6rnekler ve \u00f6rnek dosyalar ile Excel&#039;in en iyi istatistiksel fonksiyonlar\u0131n\u0131 kullanabilirsiniz.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de istatistiksel i\u015flevler nas\u0131l kullan\u0131l\u0131r? (\u00d6rnekler)\" \/>\n<meta property=\"og:description\" content=\"\u00d6rnekler ve \u00f6rnek dosyalar ile Excel&#039;in en iyi istatistiksel fonksiyonlar\u0131n\u0131 kullanabilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-moyenne-exemple-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"10 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/\",\"name\":\"Excel&#39;de istatistiksel i\u015flevler nas\u0131l kullan\u0131l\u0131r? (\u00d6rnekler)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-moyenne-exemple-1.png\",\"datePublished\":\"2023-10-15T14:27:37+00:00\",\"dateModified\":\"2023-12-10T06:01:15+00:00\",\"description\":\"\u00d6rnekler ve \u00f6rnek dosyalar ile Excel&#39;in en iyi istatistiksel fonksiyonlar\u0131n\u0131 kullanabilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-moyenne-exemple-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-moyenne-exemple-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de istatistiksel i\u015flevler nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de istatistiksel i\u015flevler nas\u0131l kullan\u0131l\u0131r? (\u00d6rnekler)","description":"\u00d6rnekler ve \u00f6rnek dosyalar ile Excel&#39;in en iyi istatistiksel fonksiyonlar\u0131n\u0131 kullanabilirsiniz.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de istatistiksel i\u015flevler nas\u0131l kullan\u0131l\u0131r? (\u00d6rnekler)","og_description":"\u00d6rnekler ve \u00f6rnek dosyalar ile Excel&#39;in en iyi istatistiksel fonksiyonlar\u0131n\u0131 kullanabilirsiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:15+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-moyenne-exemple-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"10 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/","url":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/","name":"Excel&#39;de istatistiksel i\u015flevler nas\u0131l kullan\u0131l\u0131r? (\u00d6rnekler)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-moyenne-exemple-1.png","datePublished":"2023-10-15T14:27:37+00:00","dateModified":"2023-12-10T06:01:15+00:00","description":"\u00d6rnekler ve \u00f6rnek dosyalar ile Excel&#39;in en iyi istatistiksel fonksiyonlar\u0131n\u0131 kullanabilirsiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-moyenne-exemple-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-moyenne-exemple-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/excel-istatistik-fonksiyonlari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de istatistiksel i\u015flevler nas\u0131l kullan\u0131l\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2107"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2107\/revisions"}],"predecessor-version":[{"id":2493,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2107\/revisions\/2493"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}