{"id":23851,"date":"2026-08-21T02:17:04","date_gmt":"2026-08-20T23:17:04","guid":{"rendered":"https:\/\/www.cenuta.com\/blog\/?p=23851"},"modified":"2026-08-21T02:17:05","modified_gmt":"2026-08-20T23:17:05","slug":"yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi","status":"publish","type":"post","link":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/","title":{"rendered":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken En Temel Excel Form\u00fclleri: Veri Analizinde \u0130lk Ad\u0131m (2026 Rehberi)"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_71 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0130\u00e7indekiler<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a8ca0e9507eb\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a8ca0e9507eb\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#Giris_Excel_Bir_Hesap_Makinesinden_Cok_Daha_Fazlasidir\" title=\"Giri\u015f: Excel Bir Hesap Makinesinden \u00c7ok Daha Fazlas\u0131d\u0131r\">Giri\u015f: Excel Bir Hesap Makinesinden \u00c7ok Daha Fazlas\u0131d\u0131r<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#Bolum_1_Formullerin_Anatomisi_ve_Temel_Kurallar\" title=\"B\u00f6l\u00fcm 1: Form\u00fcllerin Anatomisi ve Temel Kurallar\">B\u00f6l\u00fcm 1: Form\u00fcllerin Anatomisi ve Temel Kurallar<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#Hucre_Basvurulari_ve_Noktalama_Isaretleri\" title=\"H\u00fccre Ba\u015fvurular\u0131 ve Noktalama \u0130\u015faretleri\">H\u00fccre Ba\u015fvurular\u0131 ve Noktalama \u0130\u015faretleri<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#Bolum_2_Hayat_Kurtaran_Temel_Matematiksel_Formuller\" title=\"B\u00f6l\u00fcm 2: Hayat Kurtaran Temel Matematiksel Form\u00fcller\">B\u00f6l\u00fcm 2: Hayat Kurtaran Temel Matematiksel Form\u00fcller<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#1_TOPLA_SUM\" title=\"1. TOPLA (SUM)\">1. TOPLA (SUM)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#2_ORTALAMA_AVERAGE\" title=\"2. ORTALAMA (AVERAGE)\">2. ORTALAMA (AVERAGE)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#3_BUYUK_LARGE_ve_KUCUK_SMALL\" title=\"3. B\u00dcY\u00dcK (LARGE) ve K\u00dc\u00c7\u00dcK (SMALL)\">3. B\u00dcY\u00dcK (LARGE) ve K\u00dc\u00c7\u00dcK (SMALL)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#Bolum_3_Mantiksal_Formuller_Excelin_Zekasi\" title=\"B\u00f6l\u00fcm 3: Mant\u0131ksal Form\u00fcller (Excel&#8217;in Zekas\u0131)\">B\u00f6l\u00fcm 3: Mant\u0131ksal Form\u00fcller (Excel&#8217;in Zekas\u0131)<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#4_EGER_IF\" title=\"4. E\u011eER (IF)\">4. E\u011eER (IF)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#5_EGERSAY_COUNTIF\" title=\"5. E\u011eERSAY (COUNTIF)\">5. E\u011eERSAY (COUNTIF)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#Bolum_4_Arama_ve_Basvuru_Formulleri_Veri_Dedektifligi\" title=\"B\u00f6l\u00fcm 4: Arama ve Ba\u015fvuru Form\u00fclleri (Veri Dedektifli\u011fi)\">B\u00f6l\u00fcm 4: Arama ve Ba\u015fvuru Form\u00fclleri (Veri Dedektifli\u011fi)<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#6_DUSEYARA_VLOOKUP\" title=\"6. D\u00dc\u015eEYARA (VLOOKUP)\">6. D\u00dc\u015eEYARA (VLOOKUP)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#Bolum_5_Metin_Duzenleme_Formulleri\" title=\"B\u00f6l\u00fcm 5: Metin D\u00fczenleme Form\u00fclleri\">B\u00f6l\u00fcm 5: Metin D\u00fczenleme Form\u00fclleri<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#7_BIRLESTIR_CONCATENATE_veya_Metin_Birlestirme_Isareti\" title=\"7. B\u0130RLE\u015eT\u0130R (CONCATENATE) veya Metin Birle\u015ftirme (&amp;) \u0130\u015fareti\">7. B\u0130RLE\u015eT\u0130R (CONCATENATE) veya Metin Birle\u015ftirme (&amp;) \u0130\u015fareti<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#8_BUYUKHARF_UPPER_KUCUKHARF_LOWER_ve_YAZIMDUZENI_PROPER\" title=\"8. B\u00dcY\u00dcKHARF (UPPER), K\u00dc\u00c7\u00dcKHARF (LOWER) ve YAZIM.D\u00dcZEN\u0130 (PROPER)\">8. B\u00dcY\u00dcKHARF (UPPER), K\u00dc\u00c7\u00dcKHARF (LOWER) ve YAZIM.D\u00dcZEN\u0130 (PROPER)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#Bolum_6_Excelde_Sik_Karsilasilan_Hatalar_Hata_Kodlarini_Okumak\" title=\"B\u00f6l\u00fcm 6: Excel&#8217;de S\u0131k Kar\u015f\u0131la\u015f\u0131lan Hatalar (Hata Kodlar\u0131n\u0131 Okumak)\">B\u00f6l\u00fcm 6: Excel&#8217;de S\u0131k Kar\u015f\u0131la\u015f\u0131lan Hatalar (Hata Kodlar\u0131n\u0131 Okumak)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#Sonuc_Hata_Yapmaktan_Korkmayin_Denemeye_Devam_Edin\" title=\"Sonu\u00e7: Hata Yapmaktan Korkmay\u0131n, Denemeye Devam Edin\">Sonu\u00e7: Hata Yapmaktan Korkmay\u0131n, Denemeye Devam Edin<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Giris_Excel_Bir_Hesap_Makinesinden_Cok_Daha_Fazlasidir\"><\/span>Giri\u015f: Excel Bir Hesap Makinesinden \u00c7ok Daha Fazlas\u0131d\u0131r<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Dijitalle\u015fen i\u015f d\u00fcnyas\u0131nda, mesle\u011finiz ne olursa olsun kar\u015f\u0131n\u0131za \u00e7\u0131kacak en evrensel yaz\u0131l\u0131mlar\u0131n ba\u015f\u0131nda Microsoft Excel gelir. Bir\u00e7ok ki\u015fi Excel&#8217;i yaln\u0131zca verilerin alt alta yaz\u0131ld\u0131\u011f\u0131 devasa bir tablo veya geli\u015fmi\u015f bir hesap makinesi olarak g\u00f6r\u00fcr. Oysa Excel, i\u00e7indeki form\u00fcller ve fonksiyonlar sayesinde saatler s\u00fcrecek manuel hesaplamalar\u0131, mant\u0131ksal e\u015fle\u015ftirmeleri ve veri analizlerini saniyeler i\u00e7inde tamamlayabilen muazzam bir veri i\u015fleme motorudur.<\/p>\n\n\n\n<p>E\u011fer daha \u00f6nce h\u00fccrelerin i\u00e7ine sadece say\u0131lar yaz\u0131p bunlar\u0131 manuel olarak toplad\u0131ysan\u0131z, Excel&#8217;in ger\u00e7ek g\u00fcc\u00fcyle hen\u00fcz tan\u0131\u015fmam\u0131\u015fs\u0131n\u0131z demektir. Verileri birbirine ba\u011flamak, belirli ko\u015fullara g\u00f6re sonu\u00e7lar \u00fcretmek ve devasa listeler i\u00e7inden arad\u0131\u011f\u0131n\u0131z\u0131 saniyesinde bulmak, sadece birka\u00e7 temel form\u00fcl\u00fc \u00f6\u011frenmekten ge\u00e7er. Bu kapsaml\u0131 rehberde, yeni ba\u015flayanlar\u0131n hayat\u0131n\u0131 kurtaracak, veri okuryazarl\u0131\u011f\u0131n\u0131z\u0131 s\u0131f\u0131rdan al\u0131p ileri seviyeye ta\u015f\u0131yacak en kritik Excel form\u00fcllerini, pratik kullan\u0131m senaryolar\u0131 ve \u00e7\u00f6z\u00fcm stratejileriyle birlikte inceliyoruz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bolum_1_Formullerin_Anatomisi_ve_Temel_Kurallar\"><\/span>B\u00f6l\u00fcm 1: Form\u00fcllerin Anatomisi ve Temel Kurallar<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Herhangi bir form\u00fcl\u00fc yazmaya ba\u015flamadan \u00f6nce, Excel&#8217;in dilini anlaman\u0131z gerekir. Excel, i\u00e7ine yazd\u0131\u011f\u0131n\u0131z bir metnin normal bir yaz\u0131 m\u0131 yoksa hesaplanmas\u0131 gereken bir komut mu oldu\u011funu tek bir i\u015faretten anlar: <strong>E\u015fittir (<code>=<\/code>) \u0130\u015fareti.<\/strong><\/p>\n\n\n\n<p>Excel&#8217;de istisnas\u0131z her form\u00fcl <code>=<\/code> i\u015fareti ile ba\u015flamak zorundad\u0131r. E\u015fittir i\u015faretini koyduktan sonra fonksiyonun ad\u0131n\u0131 yazar, ard\u0131ndan parantez <code>()<\/code> a\u00e7arak hesaplanacak h\u00fccreleri belirtirsiniz.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Hucre_Basvurulari_ve_Noktalama_Isaretleri\"><\/span>H\u00fccre Ba\u015fvurular\u0131 ve Noktalama \u0130\u015faretleri<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Excel form\u00fcllerinin i\u00e7inde y\u00f6nlendirme yaparken kullan\u0131lan iki kritik noktalama i\u015fareti vard\u0131r:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u0130ki Nokta \u00dcst \u00dcste (<code>:<\/code>):<\/strong> Bir &#8220;Aral\u0131k&#8221; (Range) belirtir. \u00d6rne\u011fin; <code>A1:A10<\/code> ifadesi, A1 h\u00fccresinden ba\u015flay\u0131p A10 h\u00fccresine kadar olan (A1 ve A10 dahil) t\u00fcm h\u00fccreleri kapsar.<\/li>\n\n\n\n<li><strong>Noktal\u0131 Virg\u00fcl (<code>;<\/code>):<\/strong> Ba\u011f\u0131ms\u0131z h\u00fccreleri ay\u0131rmak i\u00e7in kullan\u0131l\u0131r (Baz\u0131 \u0130ngilizce Excel versiyonlar\u0131nda virg\u00fcl <code>,<\/code> olarak kullan\u0131l\u0131r). \u00d6rne\u011fin; <code>A1; A10<\/code> ifadesi, sadece A1 ve sadece A10 h\u00fccresini ifade eder, aradaki h\u00fccreler hesaba kat\u0131lmaz.<\/li>\n<\/ul>\n\n\n\n<p>Bu temel mant\u0131\u011f\u0131 anlamak ad\u0131na, h\u00fccrelere kendi de\u011ferlerinizi girerek an\u0131nda sonu\u00e7lar\u0131 g\u00f6rebilece\u011finiz \u015fu interaktif arac\u0131 inceleyebilirsiniz:<\/p>\n\n\n\n<p>JSON<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"widgetSpec\": {\n    \"id\": \"excel-formula-sandbox\",\n    \"height\": \"600px\",\n    \"prompt\": \"Objective: Create an interactive spreadsheet sandbox allowing users to test basic formulas like SUM, AVERAGE, and IF.\\nData State: initialValues: generic dataset (e.g., a table with items and values).\\nStrategy: Standard Layout.\\nLibraries: HTML Table with basic JS calculation logic.\\nInputs:\\n- A 3x4 editable grid of numbers.\\n- A formula input field.\\nBehavior: Parse simple formulas dynamically and display the result in real-time below the grid. Provide a few preset examples as buttons.\"\n  }\n}\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bolum_2_Hayat_Kurtaran_Temel_Matematiksel_Formuller\"><\/span>B\u00f6l\u00fcm 2: Hayat Kurtaran Temel Matematiksel Form\u00fcller<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Verileri analiz etmenin ilk ad\u0131m\u0131 onlar\u0131 \u00f6l\u00e7mek ve matematiksel i\u015flemlere tabi tutmakt\u0131r. \u0130\u015fte en \u00e7ok kullanaca\u011f\u0131n\u0131z o temel form\u00fcller:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_TOPLA_SUM\"><\/span>1. TOPLA (SUM)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Excel&#8217;in en ikonik ve en \u00e7ok kullan\u0131lan form\u00fcl\u00fcd\u00fcr. H\u00fccrelerin i\u00e7indeki say\u0131sal de\u011ferleri toplar. Tek tek <code>A1+A2+A3<\/code> yazmak yerine binlerce sat\u0131r\u0131 tek bir komutla toplayabilirsiniz.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Nas\u0131l Yaz\u0131l\u0131r:<\/strong> <code>=TOPLA(A1:A100)<\/code><\/li>\n\n\n\n<li><strong>Ne \u0130\u015fe Yarar:<\/strong> A1 ile A100 h\u00fccreleri aras\u0131ndaki t\u00fcm say\u0131lar\u0131 toplar.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_ORTALAMA_AVERAGE\"><\/span>2. ORTALAMA (AVERAGE)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Bir veri setinin aritmetik ortalamas\u0131n\u0131 almak i\u00e7in kullan\u0131l\u0131r. \u00d6\u011frenci notlar\u0131, ayl\u0131k sat\u0131\u015f cirolar\u0131 veya g\u00fcnl\u00fck s\u0131cakl\u0131k ortalamalar\u0131 gibi verileri analiz ederken manuel olarak b\u00f6lme i\u015flemi yapman\u0131za gerek kalmaz.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Nas\u0131l Yaz\u0131l\u0131r:<\/strong> <code>=ORTALAMA(B1:B12)<\/code><\/li>\n\n\n\n<li><strong>Ne \u0130\u015fe Yarar:<\/strong> Belirtilen aral\u0131ktaki t\u00fcm say\u0131lar\u0131 toplar ve h\u00fccre say\u0131s\u0131na b\u00f6lerek ortalamay\u0131 verir.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_BUYUK_LARGE_ve_KUCUK_SMALL\"><\/span>3. B\u00dcY\u00dcK (LARGE) ve K\u00dc\u00c7\u00dcK (SMALL)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Bir liste i\u00e7indeki en y\u00fcksek veya en d\u00fc\u015f\u00fck de\u011ferleri (\u00f6rne\u011fin &#8220;En y\u00fcksek 3. sat\u0131\u015f miktar\u0131&#8221;) bulmak istedi\u011finizde devreye girer. <em>M\u0130N<\/em> ve <em>MAKS<\/em> form\u00fclleri sadece en u\u00e7 noktalar\u0131 bulurken, bu form\u00fcller size s\u0131ralama esnekli\u011fi sunar.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Nas\u0131l Yaz\u0131l\u0131r:<\/strong> <code>=B\u00dcY\u00dcK(C1:C50; 2)<\/code><\/li>\n\n\n\n<li><strong>Ne \u0130\u015fe Yarar:<\/strong> C1 ile C50 aras\u0131ndaki de\u011ferlerden en b\u00fcy\u00fck <strong>2.<\/strong> say\u0131y\u0131 getirir.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bolum_3_Mantiksal_Formuller_Excelin_Zekasi\"><\/span>B\u00f6l\u00fcm 3: Mant\u0131ksal Form\u00fcller (Excel&#8217;in Zekas\u0131)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Matematiksel i\u015flemler bittikten sonra, Excel&#8217;e belirli \u015fartlar sunarak karar vermesini sa\u011flayabilirsiniz. Excel&#8217;i sadece bir tablo olmaktan \u00e7\u0131kar\u0131p bir &#8220;yaz\u0131l\u0131ma&#8221; d\u00f6n\u00fc\u015ft\u00fcren ad\u0131m budur.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_EGER_IF\"><\/span>4. E\u011eER (IF)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>E\u011fer form\u00fcl\u00fc, bir ko\u015fulun do\u011fru mu yoksa yanl\u0131\u015f m\u0131 oldu\u011funu test eder ve sonuca g\u00f6re sizin belirledi\u011finiz farkl\u0131 \u00e7\u0131kt\u0131lar\u0131 ekrana yans\u0131t\u0131r.<\/p>\n\n\n\n<p>Lise \u00f6\u011fretmeni <strong>Erkan<\/strong>, y\u00fczlerce \u00f6\u011frencisinin not listesini haz\u0131rlamaktad\u0131r. Notu 50&#8217;den b\u00fcy\u00fck olan \u00f6\u011frencilerin kar\u015f\u0131s\u0131na &#8220;Ge\u00e7ti&#8221;, k\u00fc\u00e7\u00fck olanlar\u0131n kar\u015f\u0131s\u0131na &#8220;Kald\u0131&#8221; yazmas\u0131 gerekmektedir. Erkan manuel olarak tek tek yazmak yerine, listenin ilk sat\u0131r\u0131na \u015fu form\u00fcl\u00fc yazar ve a\u015fa\u011f\u0131 \u00e7eker:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Nas\u0131l Yaz\u0131l\u0131r:<\/strong> <code>=E\u011eER(D2>=50; \"Ge\u00e7ti\"; \"Kald\u0131\")<\/code><\/li>\n\n\n\n<li><strong>Ne \u0130\u015fe Yarar:<\/strong> Excel, D2 h\u00fccresine bakar. E\u011fer oradaki rakam 50&#8217;ye e\u015fit veya b\u00fcy\u00fckse h\u00fccreye &#8220;Ge\u00e7ti&#8221; yazar. De\u011filse &#8220;Kald\u0131&#8221; yazar. Mant\u0131ksal testlerin kalbidir.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_EGERSAY_COUNTIF\"><\/span>5. E\u011eERSAY (COUNTIF)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Devasa bir liste i\u00e7inde belirli bir kelimenin, \u015fart\u0131n veya rakam\u0131n ka\u00e7 kez ge\u00e7ti\u011fini sayman\u0131z\u0131 sa\u011flar.<\/p>\n\n\n\n<p>\u0130nsan kaynaklar\u0131 uzman\u0131 <strong>Murat<\/strong>, 500 ki\u015filik personel listesinde ka\u00e7 ki\u015finin &#8220;\u0130stanbul&#8221; ofisinde \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 saymak istemektedir.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Nas\u0131l Yaz\u0131l\u0131r:<\/strong> <code>=E\u011eERSAY(E2:E501; \"\u0130stanbul\")<\/code><\/li>\n\n\n\n<li><strong>Ne \u0130\u015fe Yarar:<\/strong> E2 ile E501 aras\u0131ndaki h\u00fccreleri tek tek kontrol eder ve sadece i\u00e7inde tam olarak &#8220;\u0130stanbul&#8221; yazan h\u00fccrelerin say\u0131s\u0131n\u0131 verir.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bolum_4_Arama_ve_Basvuru_Formulleri_Veri_Dedektifligi\"><\/span>B\u00f6l\u00fcm 4: Arama ve Ba\u015fvuru Form\u00fclleri (Veri Dedektifli\u011fi)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u0130ki farkl\u0131 Excel dosyas\u0131n\u0131 veya sekmesini birbirine ba\u011flamak istedi\u011finizde kullanaca\u011f\u0131n\u0131z form\u00fcller bu grupta yer al\u0131r. \u0130leri seviye Excel bilgisinin ilk kap\u0131s\u0131d\u0131r.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6_DUSEYARA_VLOOKUP\"><\/span>6. D\u00dc\u015eEYARA (VLOOKUP)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Excel denilince akla gelen en me\u015fhur ve belki de i\u015f d\u00fcnyas\u0131nda en \u00e7ok talep edilen form\u00fcld\u00fcr. Bir de\u011feri belirli bir tablonun ilk s\u00fctununda arar ve o de\u011ferin bulundu\u011fu sat\u0131rdaki ba\u015fka bir bilgiyi kar\u015f\u0131n\u0131za getirir.<\/p>\n\n\n\n<p>E-ticaret depo sorumlusu <strong>Zeynep<\/strong>, elindeki 10.000 sat\u0131rl\u0131k \u00fcr\u00fcn kodu (SKU) listesinde yer alan \u00fcr\u00fcnlerin g\u00fcncel fiyatlar\u0131n\u0131, bir ba\u015fka sayfada bulunan &#8220;Fiyat Listesi&#8221;nden bulup e\u015fle\u015ftirmek zorundad\u0131r. Zeynep bu zorlu s\u00fcreci D\u00dc\u015eEYARA ile saniyeler i\u00e7inde \u00e7\u00f6zer:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Nas\u0131l Yaz\u0131l\u0131r:<\/strong> <code>=D\u00dc\u015eEYARA(A2; Sayfa2!A1:D10000; 3; YANLI\u015e)<\/code><\/li>\n\n\n\n<li><strong>Ne \u0130\u015fe Yarar:<\/strong> A2 h\u00fccresindeki \u00fcr\u00fcn kodunu al\u0131r, Sayfa2&#8217;deki tablonun ilk s\u00fctununda bu kodu arar, buldu\u011fu an o sat\u0131rdaki <strong>3.<\/strong> s\u00fctuna (Fiyat s\u00fctununa) gider ve fiyat\u0131 al\u0131p Zeynep&#8217;in h\u00fccresine getirir. Sondaki &#8220;YANLI\u015e&#8221; (FALSE) ifadesi, sonucun tam ve birebir e\u015fle\u015fmesi gerekti\u011fini (yakla\u015f\u0131k de\u011fer istemedi\u011finizi) belirtir.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bolum_5_Metin_Duzenleme_Formulleri\"><\/span>B\u00f6l\u00fcm 5: Metin D\u00fczenleme Form\u00fclleri<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Veritabanlar\u0131ndan veya sistemlerden d\u0131\u015fa aktar\u0131lan (Export) veriler genellikle karma\u015f\u0131k ve d\u00fczensizdir. \u0130simler k\u00fc\u00e7\u00fck harfle yaz\u0131lm\u0131\u015f olabilir veya ad ile soyad farkl\u0131 h\u00fccrelerde yer alabilir. Bu durumu toparlamak i\u00e7in metin form\u00fclleri kullan\u0131l\u0131r.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7_BIRLESTIR_CONCATENATE_veya_Metin_Birlestirme_Isareti\"><\/span>7. B\u0130RLE\u015eT\u0130R (CONCATENATE) veya Metin Birle\u015ftirme (<code>&amp;<\/code>) \u0130\u015fareti<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Farkl\u0131 h\u00fccrelerdeki verileri tek bir h\u00fccrede toplamak i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n<p>M\u00fc\u015fteri ili\u015fkileri y\u00f6neticisi <strong>Sevgi<\/strong>, e-posta kampanyas\u0131 haz\u0131rlamak i\u00e7in A s\u00fctunundaki &#8220;Ad&#8221; ve B s\u00fctunundaki &#8220;Soyad&#8221; verilerini C s\u00fctununda birle\u015ftirmelidir. Aksi halde mail \u015fablonu d\u00fczg\u00fcn \u00e7al\u0131\u015fmayacakt\u0131r.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Nas\u0131l Yaz\u0131l\u0131r:<\/strong> <code>=B\u0130RLE\u015eT\u0130R(A2; \" \"; B2)<\/code> veya <code>=A2 &amp; \" \" &amp; B2<\/code><\/li>\n\n\n\n<li><strong>Ne \u0130\u015fe Yarar:<\/strong> A2 h\u00fccresindeki kelimeyi al\u0131r, araya bir bo\u015fluk (<code>\" \"<\/code>) koyar ve B2 h\u00fccresindeki kelimeyi ekleyerek ikisini tek bir metin haline getirir. (\u00d6rn: &#8220;Ali&#8221; ve &#8220;Y\u0131lmaz&#8221; h\u00fccreleri &#8220;Ali Y\u0131lmaz&#8221; olur).<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8_BUYUKHARF_UPPER_KUCUKHARF_LOWER_ve_YAZIMDUZENI_PROPER\"><\/span>8. B\u00dcY\u00dcKHARF (UPPER), K\u00dc\u00c7\u00dcKHARF (LOWER) ve YAZIM.D\u00dcZEN\u0130 (PROPER)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Metinlerin b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf uyumunu otomatik olarak d\u00fczeltir.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>=B\u00dcY\u00dcKHARF(A1)<\/code>: a1 h\u00fccresindeki t\u00fcm harfleri b\u00fcy\u00fct\u00fcr. (ahmet -> AHMET)<\/li>\n\n\n\n<li><code>=YAZIM.D\u00dcZEN\u0130(A1)<\/code>: Sadece kelimelerin ilk harflerini b\u00fcy\u00fct\u00fcr, geri kalan\u0131n\u0131 k\u00fc\u00e7\u00fclt\u00fcr. (aHMet yILmaz -> Ahmet Y\u0131lmaz)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bolum_6_Excelde_Sik_Karsilasilan_Hatalar_Hata_Kodlarini_Okumak\"><\/span>B\u00f6l\u00fcm 6: Excel&#8217;de S\u0131k Kar\u015f\u0131la\u015f\u0131lan Hatalar (Hata Kodlar\u0131n\u0131 Okumak)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Form\u00fcl yazarken her \u015fey her zaman kusursuz gitmez. Kar\u015f\u0131n\u0131za \u00e7\u0131kan o garip i\u015faretlerin asl\u0131nda Excel&#8217;in size neyin yanl\u0131\u015f gitti\u011fini s\u00f6yleme \u015fekli oldu\u011funu bilmelisiniz:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><td><strong>Hata Kodu<\/strong><\/td><td><strong>Hatan\u0131n Anlam\u0131<\/strong><\/td><td><strong>\u00c7\u00f6z\u00fcm Yolu<\/strong><\/td><\/tr><\/thead><tbody><tr><td><strong><code>#DE\u011eER!<\/code> (#VALUE!)<\/strong><\/td><td>Yanl\u0131\u015f veri t\u00fcr\u00fcyle i\u015flem yapmaya \u00e7al\u0131\u015f\u0131yorsunuz.<\/td><td>Bir say\u0131y\u0131, i\u00e7inde harf veya bo\u015fluk olan bir metinle toplamaya\/\u00e7arpmaya \u00e7al\u0131\u015fm\u0131\u015f olabilirsiniz. H\u00fccrelerin say\u0131 format\u0131nda oldu\u011fundan emin olun.<\/td><\/tr><tr><td><strong><code>#YOK<\/code> (#N\/A)<\/strong><\/td><td>Arad\u0131\u011f\u0131n\u0131z de\u011fer bulunamad\u0131.<\/td><td>Genellikle D\u00dc\u015eEYARA (VLOOKUP) form\u00fcl\u00fcnde arad\u0131\u011f\u0131n\u0131z \u00fcr\u00fcn kodu veya isim kar\u015f\u0131 tabloda ger\u00e7ekten yoksa bu hatay\u0131 al\u0131rs\u0131n\u0131z.<\/td><\/tr><tr><td><strong><code>#SAYI\/0!<\/code> (#DIV\/0!)<\/strong><\/td><td>Bir say\u0131y\u0131 s\u0131f\u0131ra b\u00f6lmeye \u00e7al\u0131\u015f\u0131yorsunuz.<\/td><td>Matematikte s\u0131f\u0131ra b\u00f6lme tan\u0131ms\u0131zd\u0131r. Form\u00fcl\u00fcn\u00fczdeki b\u00f6len h\u00fccrenin bo\u015f veya &#8220;0&#8221; olmad\u0131\u011f\u0131ndan emin olun.<\/td><\/tr><tr><td><strong><code>#BA\u015eV!<\/code> (#REF!)<\/strong><\/td><td>Ba\u015fvuru yap\u0131lan (referans g\u00f6sterilen) h\u00fccre silinmi\u015f.<\/td><td>Form\u00fcl\u00fcn\u00fcz\u00fcn beslendi\u011fi bir sat\u0131r\u0131 veya s\u00fctunu yanl\u0131\u015fl\u0131kla sildiyseniz (\u00d6rn: C s\u00fctununu topla dediniz ama C s\u00fctununu sildiniz) bu hatay\u0131 al\u0131rs\u0131n\u0131z. Form\u00fcl\u00fc g\u00fcncelleyin.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc_Hata_Yapmaktan_Korkmayin_Denemeye_Devam_Edin\"><\/span>Sonu\u00e7: Hata Yapmaktan Korkmay\u0131n, Denemeye Devam Edin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Microsoft Excel, ilk bak\u0131\u015fta o devasa men\u00fcleri ve bitmek bilmeyen \u0131zgara yap\u0131s\u0131yla karma\u015f\u0131k g\u00f6r\u00fcnebilir. Ancak t\u0131pk\u0131 yeni bir yabanc\u0131 dil \u00f6\u011frenmek gibi, Excel&#8217;in form\u00fcl dili de pratik yapt\u0131k\u00e7a ve mant\u0131\u011f\u0131n\u0131 kavrad\u0131k\u00e7a inan\u0131lmaz derecede kolayla\u015f\u0131r.<\/p>\n\n\n\n<p>Burada listelenen temel form\u00fcller (TOPLA, E\u011eER, D\u00dc\u015eEYARA vb.), d\u00fcnyadaki finansal analizlerin, sat\u0131\u015f raporlamalar\u0131n\u0131n ve veri d\u00fczenlemelerinin %80&#8217;inden fazlas\u0131n\u0131 tek ba\u015f\u0131na halletmektedir. Form\u00fcllerin i\u00e7ine dalmaktan, h\u00fccreleri birbirine ba\u011flamaktan ve k\u0131rm\u0131z\u0131 renkte hata kodlar\u0131 almaktan korkmay\u0131n. Kar\u015f\u0131la\u015ft\u0131\u011f\u0131n\u0131z her <code>#DE\u011eER!<\/code> hatas\u0131, size veri yap\u0131lar\u0131n\u0131 nas\u0131l daha temiz hale getirece\u011finizi \u00f6\u011freten bir f\u0131rsatt\u0131r. \u00d6\u011frendi\u011finiz bu temel kurallarla tablolar\u0131n\u0131z\u0131 olu\u015fturmaya ba\u015flay\u0131n; \u00e7ok k\u0131sa bir s\u00fcre i\u00e7inde verilerin asl\u0131nda size ne kadar anla\u015f\u0131l\u0131r hikayeler anlatt\u0131\u011f\u0131n\u0131 fark edeceksiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Giri\u015f: Excel Bir Hesap Makinesinden \u00c7ok Daha Fazlas\u0131d\u0131r Dijitalle\u015fen i\u015f<a href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/\">&#8230;<\/a><\/p>\n","protected":false},"author":6,"featured_media":23852,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-23851","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken En Temel Excel Form\u00fclleri: Veri Analizinde \u0130lk Ad\u0131m (2026 Rehberi) - Cenuta Blog\" \/>\n<meta property=\"og:description\" content=\"Giri\u015f: Excel Bir Hesap Makinesinden \u00c7ok Daha Fazlas\u0131d\u0131r Dijitalle\u015fen i\u015f...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/\" \/>\n<meta property=\"og:site_name\" content=\"Cenuta Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/cenutacom\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-20T23:17:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-20T23:17:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2026\/08\/excell.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cenutacom\" \/>\n<meta name=\"twitter:site\" content=\"@cenutacom\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Baran O\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.cenuta.com\/blog\/#organization\",\"name\":\"Cenuta Telekom\u00fcnikasyon Anonim \u015eirketi\",\"url\":\"https:\/\/www.cenuta.com\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/cenutacom\",\"https:\/\/www.instagram.com\/cenutacom\/\",\"https:\/\/www.linkedin.com\/company\/cenuta\",\"https:\/\/www.youtube.com\/cenuta\",\"https:\/\/twitter.com\/cenutacom\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.cenuta.com\/blog\/#logo\",\"inLanguage\":\"tr\",\"url\":\"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2020\/08\/logo_siyah.png\",\"contentUrl\":\"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2020\/08\/logo_siyah.png\",\"width\":805,\"height\":200,\"caption\":\"Cenuta Telekom\u00fcnikasyon Anonim \u015eirketi\"},\"image\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cenuta.com\/blog\/#website\",\"url\":\"https:\/\/www.cenuta.com\/blog\/\",\"name\":\"Cenuta Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cenuta.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#primaryimage\",\"inLanguage\":\"tr\",\"url\":\"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2026\/08\/excell.jpg\",\"contentUrl\":\"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2026\/08\/excell.jpg\",\"width\":1536,\"height\":768},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#webpage\",\"url\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/\",\"name\":\"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken En Temel Excel Form\u00fclleri: Veri Analizinde \u0130lk Ad\u0131m (2026 Rehberi) - Cenuta Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#primaryimage\"},\"datePublished\":\"2026-08-20T23:17:04+00:00\",\"dateModified\":\"2026-08-20T23:17:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.cenuta.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken En Temel Excel Form\u00fclleri: Veri Analizinde \u0130lk Ad\u0131m (2026 Rehberi)\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/#\/schema\/person\/0732262cd1d893b0f6ff806f442df9d5\"},\"headline\":\"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken En Temel Excel Form\u00fclleri: Veri Analizinde \u0130lk Ad\u0131m (2026 Rehberi)\",\"datePublished\":\"2026-08-20T23:17:04+00:00\",\"dateModified\":\"2026-08-20T23:17:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#webpage\"},\"wordCount\":1681,\"publisher\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2026\/08\/excell.jpg\",\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.cenuta.com\/blog\/#\/schema\/person\/0732262cd1d893b0f6ff806f442df9d5\",\"name\":\"Baran O\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.cenuta.com\/blog\/#personlogo\",\"inLanguage\":\"tr\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1e4899262d57e005522a1b8ea0b9dea4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1e4899262d57e005522a1b8ea0b9dea4?s=96&d=mm&r=g\",\"caption\":\"Baran O\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"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:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/","og_locale":"tr_TR","og_type":"article","og_title":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken En Temel Excel Form\u00fclleri: Veri Analizinde \u0130lk Ad\u0131m (2026 Rehberi) - Cenuta Blog","og_description":"Giri\u015f: Excel Bir Hesap Makinesinden \u00c7ok Daha Fazlas\u0131d\u0131r Dijitalle\u015fen i\u015f...","og_url":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/","og_site_name":"Cenuta Blog","article_publisher":"https:\/\/www.facebook.com\/cenutacom","article_published_time":"2026-08-20T23:17:04+00:00","article_modified_time":"2026-08-20T23:17:05+00:00","og_image":[{"width":1536,"height":768,"url":"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2026\/08\/excell.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_creator":"@cenutacom","twitter_site":"@cenutacom","twitter_misc":{"Yazan:":"Baran O","Tahmini okuma s\u00fcresi":"9 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.cenuta.com\/blog\/#organization","name":"Cenuta Telekom\u00fcnikasyon Anonim \u015eirketi","url":"https:\/\/www.cenuta.com\/blog\/","sameAs":["https:\/\/www.facebook.com\/cenutacom","https:\/\/www.instagram.com\/cenutacom\/","https:\/\/www.linkedin.com\/company\/cenuta","https:\/\/www.youtube.com\/cenuta","https:\/\/twitter.com\/cenutacom"],"logo":{"@type":"ImageObject","@id":"https:\/\/www.cenuta.com\/blog\/#logo","inLanguage":"tr","url":"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2020\/08\/logo_siyah.png","contentUrl":"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2020\/08\/logo_siyah.png","width":805,"height":200,"caption":"Cenuta Telekom\u00fcnikasyon Anonim \u015eirketi"},"image":{"@id":"https:\/\/www.cenuta.com\/blog\/#logo"}},{"@type":"WebSite","@id":"https:\/\/www.cenuta.com\/blog\/#website","url":"https:\/\/www.cenuta.com\/blog\/","name":"Cenuta Blog","description":"","publisher":{"@id":"https:\/\/www.cenuta.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cenuta.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"ImageObject","@id":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#primaryimage","inLanguage":"tr","url":"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2026\/08\/excell.jpg","contentUrl":"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2026\/08\/excell.jpg","width":1536,"height":768},{"@type":"WebPage","@id":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#webpage","url":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/","name":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken En Temel Excel Form\u00fclleri: Veri Analizinde \u0130lk Ad\u0131m (2026 Rehberi) - Cenuta Blog","isPartOf":{"@id":"https:\/\/www.cenuta.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#primaryimage"},"datePublished":"2026-08-20T23:17:04+00:00","dateModified":"2026-08-20T23:17:05+00:00","breadcrumb":{"@id":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.cenuta.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken En Temel Excel Form\u00fclleri: Veri Analizinde \u0130lk Ad\u0131m (2026 Rehberi)"}]},{"@type":"Article","@id":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#article","isPartOf":{"@id":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#webpage"},"author":{"@id":"https:\/\/www.cenuta.com\/blog\/#\/schema\/person\/0732262cd1d893b0f6ff806f442df9d5"},"headline":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken En Temel Excel Form\u00fclleri: Veri Analizinde \u0130lk Ad\u0131m (2026 Rehberi)","datePublished":"2026-08-20T23:17:04+00:00","dateModified":"2026-08-20T23:17:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#webpage"},"wordCount":1681,"publisher":{"@id":"https:\/\/www.cenuta.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.cenuta.com\/blog\/yeni-baslayanlar-icin-bilinmesi-gereken-en-temel-excel-formulleri-veri-analizinde-ilk-adim-2026-rehberi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cenuta.com\/blog\/wp-content\/uploads\/2026\/08\/excell.jpg","inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/www.cenuta.com\/blog\/#\/schema\/person\/0732262cd1d893b0f6ff806f442df9d5","name":"Baran O","image":{"@type":"ImageObject","@id":"https:\/\/www.cenuta.com\/blog\/#personlogo","inLanguage":"tr","url":"https:\/\/secure.gravatar.com\/avatar\/1e4899262d57e005522a1b8ea0b9dea4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1e4899262d57e005522a1b8ea0b9dea4?s=96&d=mm&r=g","caption":"Baran O"}}]}},"_links":{"self":[{"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/posts\/23851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/comments?post=23851"}],"version-history":[{"count":1,"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/posts\/23851\/revisions"}],"predecessor-version":[{"id":23853,"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/posts\/23851\/revisions\/23853"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/media\/23852"}],"wp:attachment":[{"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/media?parent=23851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/categories?post=23851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cenuta.com\/blog\/wp-json\/wp\/v2\/tags?post=23851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}