{"id":38186,"date":"2026-01-25T12:30:38","date_gmt":"2026-01-25T09:30:38","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/"},"modified":"2026-01-25T12:30:38","modified_gmt":"2026-01-25T09:30:38","slug":"microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/","title":{"rendered":"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi"},"content":{"rendered":"

Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi<\/h2>\n

G\u00fcn\u00fcm\u00fcz dijital d\u00fcnyas\u0131nda veri, i\u015f kararlar\u0131ndan ki\u015fisel finans y\u00f6netimine kadar her alanda kritik bir rol oynamaktad\u0131r. Verileri anlamak, onlardan anlaml\u0131 bilgiler \u00e7\u0131karmak ve bu bilgileri kullanarak daha bilin\u00e7li kararlar almak, bireyler ve kurumlar i\u00e7in vazge\u00e7ilmez bir yetkinlik haline gelmi\u015ftir. Microsoft Excel, bu karma\u015f\u0131k g\u00f6r\u00fcnen veri analizi s\u00fcrecine ad\u0131m atmak isteyenler i\u00e7in g\u00fc\u00e7l\u00fc, eri\u015filebilir ve kullan\u0131c\u0131 dostu bir ara\u00e7t\u0131r. Bu rehber, Excel’i kullanarak temel veri analizi becerilerini nas\u0131l edinece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacak ve sizi verilerin d\u00fcnyas\u0131na davet edecektir.<\/p>\n

1. Excel’e Giri\u015f ve Veri Haz\u0131rl\u0131\u011f\u0131<\/h3>\n

Veri analizine ba\u015flamadan \u00f6nce, Excel’in temel yap\u0131s\u0131n\u0131 anlamak ve verilerinizi do\u011fru bir \u015fekilde haz\u0131rlamak b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. Temiz ve d\u00fczenli veri, do\u011fru analizlerin temelidir.<\/p>\n

1.1. Excel Aray\u00fcz\u00fcn\u00fc Tan\u0131ma<\/h4>\n

Excel, \u00e7al\u0131\u015fma sayfalar\u0131 ad\u0131 verilen \u0131zgaralardan olu\u015fur. Her \u00e7al\u0131\u015fma sayfas\u0131, harflerle belirtilen s\u00fctunlar ve say\u0131larla belirtilen sat\u0131rlardan meydana gelir. Bu s\u00fctun ve sat\u0131rlar\u0131n kesi\u015fim noktalar\u0131na “h\u00fccre” denir. Her h\u00fccrenin benzersiz bir adresi vard\u0131r (\u00f6rne\u011fin, A1, B5). Form\u00fcller ve veriler bu h\u00fccrelere girilir. \u015eerit men\u00fcs\u00fc (Ribbon), dosya, giri\u015f, ekle, form\u00fcller gibi sekmelerle d\u00fczenlenmi\u015f \u00e7e\u015fitli ara\u00e7 ve komutlara eri\u015fmenizi sa\u011flar.<\/p>\n

1.2. Veri Giri\u015fi ve Temel Bi\u00e7imlendirme<\/h4>\n

Verilerinizi do\u011frudan h\u00fccrelere yazabilir veya ba\u015fka kaynaklardan (CSV, metin dosyalar\u0131, veritabanlar\u0131) i\u00e7e aktarabilirsiniz. Verilerinizi girerken tutarl\u0131 olmak \u00f6nemlidir. \u00d6rne\u011fin, tarihleri her zaman ayn\u0131 formatta girmeye \u00f6zen g\u00f6sterin. H\u00fccreleri bi\u00e7imlendirmek (yaz\u0131 tipi, boyut, renk, hizalama, say\u0131 formatlar\u0131) verilerinizi daha okunabilir hale getirir. \u00d6rne\u011fin, parasal de\u011ferleri para birimi format\u0131nda, y\u00fczdeleri y\u00fczde format\u0131nda g\u00f6stermek anla\u015f\u0131l\u0131rl\u0131\u011f\u0131 art\u0131r\u0131r.<\/p>\n

\n\/\/ \u00d6rnek veri giri\u015fi ve bi\u00e7imlendirme\n\/\/ A1 h\u00fccresine \"\u00dcr\u00fcn Ad\u0131\" yaz\u0131n\n\/\/ B1 h\u00fccresine \"Sat\u0131\u015f Miktar\u0131\" yaz\u0131n\n\/\/ C1 h\u00fccresine \"Birim Fiyat\" yaz\u0131n\n\/\/ D1 h\u00fccresine \"Toplam Sat\u0131\u015f\" yaz\u0131n\n\/\/ A2 h\u00fccresine \"Klavye\", B2 h\u00fccresine 150, C2 h\u00fccresine 25 yaz\u0131n\n\/\/ D2 h\u00fccresine \"=B2*C2\" form\u00fcl\u00fcn\u00fc girin\n\/\/ C s\u00fctununu \"Para Birimi\" olarak bi\u00e7imlendirin\n<\/pre>\n
<\/code><\/p>\n
1.3. Veri Temizli\u011fi ve D\u00fczenleme<\/h4>\n
Ham veriler genellikle hatalar, eksiklikler veya tutars\u0131zl\u0131klar i\u00e7erir. Excel, bu verileri temizlemek i\u00e7in \u00e7e\u015fitli ara\u00e7lar sunar:<\/p>\n
    \n
  • Bo\u015fluklar\u0131 Kald\u0131rma:<\/strong> Metin verilerindeki gereksiz bo\u015fluklar\u0131 (ba\u015f\u0131nda, sonunda veya kelimeler aras\u0131nda birden fazla) \"K\u0131rp\" (TRIM) fonksiyonu ile temizleyebilirsiniz.<\/li>\n
  • Yinelenenleri Silme:<\/strong> \"Veri\" sekmesindeki \"Yinelenenleri Kald\u0131r\" (Remove Duplicates) \u00f6zelli\u011fi ile belirli bir s\u00fctun veya t\u00fcm veri aral\u0131\u011f\u0131ndaki m\u00fckerrer kay\u0131tlar\u0131 kolayca silebilirsiniz.<\/li>\n
  • Veri Do\u011frulama:<\/strong> H\u00fccrelere girilebilecek veri t\u00fcrlerini veya de\u011fer aral\u0131klar\u0131n\u0131 k\u0131s\u0131tlayarak gelecekteki hatalar\u0131 \u00f6nleyebilirsiniz.<\/li>\n<\/ul>\n
    1.4. Veri T\u00fcrlerini Anlama<\/h4>\n
    Excel'de veriler temel olarak d\u00f6rt ana t\u00fcrde s\u0131n\u0131fland\u0131r\u0131l\u0131r: Say\u0131, Metin, Tarih\/Saat ve Mant\u0131ksal (Do\u011fru\/Yanl\u0131\u015f). Her veri t\u00fcr\u00fcn\u00fcn kendine \u00f6zg\u00fc \u00f6zellikleri vard\u0131r ve farkl\u0131 form\u00fcllerle i\u015flenir. \u00d6rne\u011fin, metin verileri \u00fczerinde matematiksel i\u015flemler yapamazs\u0131n\u0131z. Verilerinizin do\u011fru t\u00fcrde oldu\u011fundan emin olmak, form\u00fcllerinizin do\u011fru \u00e7al\u0131\u015fmas\u0131 i\u00e7in kritiktir.<\/p>\n
    2. Temel Hesaplamalar ve Form\u00fcller<\/h3>\n
    Excel'in g\u00fcc\u00fc, karma\u015f\u0131k hesaplamalar\u0131 otomatikle\u015ftiren form\u00fcller ve fonksiyonlar\u0131ndad\u0131r. Bu b\u00f6l\u00fcm, en s\u0131k kullan\u0131lan temel form\u00fclleri ve bunlar\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 a\u00e7\u0131klayacakt\u0131r.<\/p>\n
    2.1. Toplama, \u00c7\u0131karma, \u00c7arpma, B\u00f6lme<\/h4>\n
    Excel'de temel matematiksel i\u015flemler, t\u0131pk\u0131 bir hesap makinesinde oldu\u011fu gibi +, -, *, \/ operat\u00f6rleri kullan\u0131larak yap\u0131l\u0131r. Her form\u00fcl\u00fcn ba\u015f\u0131na e\u015fittir (=) i\u015fareti konulur.<\/p>\n
      \n
    • Toplama: =A1+A2<\/code><\/li>\n
    • \u00c7\u0131karma: =B5-B4<\/code><\/li>\n
    • \u00c7arpma: =C2*D2<\/code><\/li>\n
    • B\u00f6lme: =E10\/F10<\/code><\/li>\n<\/ul>\n
      2.2. SUM, AVERAGE, COUNT, MAX, MIN Fonksiyonlar\u0131<\/h4>\n
      Bu fonksiyonlar, b\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde h\u0131zl\u0131 \u00f6zet istatistikler elde etmek i\u00e7in vazge\u00e7ilmezdir:<\/p>\n
        \n
      • SUM (TOPLA):<\/strong> Belirtilen bir aral\u0131ktaki t\u00fcm say\u0131lar\u0131 toplar. \u00d6rn: =TOPLA(A1:A10)<\/code><\/li>\n
      • AVERAGE (ORTALAMA):<\/strong> Belirtilen bir aral\u0131ktaki say\u0131lar\u0131n ortalamas\u0131n\u0131 hesaplar. \u00d6rn: =ORTALAMA(B1:B10)<\/code><\/li>\n
      • COUNT (SAY):<\/strong> Belirtilen bir aral\u0131ktaki say\u0131 i\u00e7eren h\u00fccre say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. \u00d6rn: =SAY(C1:C10)<\/code><\/li>\n
      • MAX (MAK):<\/strong> Belirtilen bir aral\u0131ktaki en b\u00fcy\u00fck de\u011feri bulur. \u00d6rn: =MAK(D1:D10)<\/code><\/li>\n
      • MIN (M\u0130N):<\/strong> Belirtilen bir aral\u0131ktaki en k\u00fc\u00e7\u00fck de\u011feri bulur. \u00d6rn: =M\u0130N(E1:E10)<\/code><\/li>\n<\/ul>\n
        2.3. G\u00f6receli ve Mutlak H\u00fccre Referanslar\u0131<\/h4>\n
        Form\u00fclleri kopyalarken h\u00fccre referanslar\u0131n\u0131n nas\u0131l de\u011fi\u015fti\u011fini anlamak \u00e7ok \u00f6nemlidir:<\/p>\n
          \n
        • G\u00f6receli Referanslar (A1):<\/strong> Bir form\u00fcl\u00fc ba\u015fka bir h\u00fccreye kopyalad\u0131\u011f\u0131n\u0131zda, referanslar otomatik olarak yeni konumlar\u0131na g\u00f6re ayarlan\u0131r. Bu, \u00e7o\u011fu durumda istedi\u011fimiz davran\u0131\u015ft\u0131r.<\/li>\n
        • Mutlak Referanslar ($A$1):<\/strong> Bir h\u00fccre referans\u0131n\u0131n \u00f6n\u00fcne dolar ($) i\u015fareti koyarak onu mutlak hale getirirsiniz. Bu, form\u00fcl\u00fc kopyalad\u0131\u011f\u0131n\u0131zda referans\u0131n sabit kalmas\u0131n\u0131 sa\u011flar. \u00d6rne\u011fin, =$A$1<\/code> her zaman A1 h\u00fccresine ba\u015fvurur. =A$1<\/code> sat\u0131r\u0131 sabitler, =$A1<\/code> s\u00fctunu sabitler.<\/li>\n<\/ul>\n
          2.4. Mant\u0131ksal Fonksiyonlar: IF (E\u011eER)<\/h4>\n
          IF fonksiyonu, belirli bir ko\u015fulun do\u011fru olup olmad\u0131\u011f\u0131n\u0131 test etmenizi ve ko\u015fula ba\u011fl\u0131 olarak farkl\u0131 sonu\u00e7lar d\u00f6nd\u00fcrmenizi sa\u011flar. Yap\u0131s\u0131: =E\u011eER(mant\u0131ksal_test; do\u011fruysa_de\u011fer; yanl\u0131\u015fsa_de\u011fer)<\/code><\/p>\n
          \n\/\/ \u00d6rnek: E\u011fer sat\u0131\u015f miktar\u0131 100'den b\u00fcy\u00fckse \"Hedef A\u015f\u0131ld\u0131\", de\u011filse \"Hedef Alt\u0131nda\" yaz.\n=E\u011eER(B2>100; \"Hedef A\u015f\u0131ld\u0131\"; \"Hedef Alt\u0131nda\")\n<\/pre>\n
          <\/code><\/p>\n
          3. Veri Filtreleme ve S\u0131ralama<\/h3>\n
          B\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken, belirli bilgilere odaklanmak veya verileri belirli bir d\u00fczene sokmak i\u00e7in filtreleme ve s\u0131ralama ara\u00e7lar\u0131 paha bi\u00e7ilmezdir.<\/p>\n
          3.1. Temel Veri S\u0131ralama<\/h4>\n
          Verilerinizi artan veya azalan d\u00fczende s\u0131ralamak i\u00e7in \"Veri\" sekmesindeki \"S\u0131rala\" (Sort) \u00f6zelli\u011fini kullanabilirsiniz. Tek bir s\u00fctuna g\u00f6re s\u0131ralayabilece\u011finiz gibi, \"\u00d6zel S\u0131ralama\" (Custom Sort) se\u00e7ene\u011fi ile birden fazla s\u00fctuna g\u00f6re de s\u0131ralama yapabilirsiniz. \u00d6rne\u011fin, \u00f6nce departmana g\u00f6re, sonra sat\u0131\u015f miktar\u0131na g\u00f6re s\u0131ralama.<\/p>\n
          3.2. Otomatik Filtre Uygulama<\/h4>\n
          Veri aral\u0131\u011f\u0131n\u0131z\u0131n ba\u015fl\u0131k sat\u0131r\u0131n\u0131 se\u00e7ip \"Veri\" sekmesindeki \"Filtre\" (Filter) d\u00fc\u011fmesine t\u0131klayarak otomatik filtreleri etkinle\u015ftirebilirsiniz. Her s\u00fctun ba\u015fl\u0131\u011f\u0131nda a\u00e7\u0131l\u0131r oklar belirecektir. Bu oklara t\u0131klayarak belirli de\u011ferleri se\u00e7ebilir veya metin\/say\u0131 filtreleri uygulayabilirsiniz.<\/p>\n
          3.3. Geli\u015fmi\u015f Filtreleme Se\u00e7enekleri<\/h4>\n
          Otomatik filtreler, metin, say\u0131 ve tarih filtreleri gibi geli\u015fmi\u015f se\u00e7enekler sunar:<\/p>\n
            \n
          • Metin Filtreleri:<\/strong> \"\u015eunu i\u00e7erir\", \"\u015eununla ba\u015flar\", \"\u015eununla bitmez\" gibi se\u00e7eneklerle metin verilerini filtreleyebilirsiniz.<\/li>\n
          • Say\u0131 Filtreleri:<\/strong> \"B\u00fcy\u00fckt\u00fcr\", \"K\u00fc\u00e7\u00fckt\u00fcr\", \"Aras\u0131nda\", \"\u0130lk 10\" gibi se\u00e7eneklerle say\u0131sal verileri filtreleyebilirsiniz.<\/li>\n
          • Tarih Filtreleri:<\/strong> \"Bu Ay\", \"Ge\u00e7en Y\u0131l\", \"Belirli Bir Aral\u0131k\" gibi se\u00e7eneklerle tarih verilerini filtreleyebilirsiniz.<\/li>\n<\/ul>\n
            3.4. \u00c7oklu Kriterlere G\u00f6re Filtreleme<\/h4>\n
            Farkl\u0131 s\u00fctunlardaki filtreleri birle\u015ftirerek birden fazla kritere g\u00f6re filtreleme yapabilirsiniz. \u00d6rne\u011fin, \"B\u00f6lge\" s\u00fctununda \"Do\u011fu\" olanlar\u0131 filtreleyip, ard\u0131ndan \"Sat\u0131\u015f Miktar\u0131\" s\u00fctununda 100'den b\u00fcy\u00fck olanlar\u0131 filtreleyerek sadece Do\u011fu b\u00f6lgesindeki y\u00fcksek sat\u0131\u015flar\u0131 g\u00f6rebilirsiniz.<\/p>\n
            4. Ko\u015fullu Bi\u00e7imlendirme ile Verileri G\u00f6rselle\u015ftirme<\/h3>\n
            Ko\u015fullu bi\u00e7imlendirme, verilerinizdeki belirli kal\u0131plar\u0131, e\u011filimleri ve istisnalar\u0131 h\u0131zl\u0131ca g\u00f6rselle\u015ftirmek i\u00e7in g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Belirli kriterlere uyan h\u00fccrelerin otomatik olarak bi\u00e7imlendirilmesini sa\u011flar.<\/p>\n
            4.1. Ko\u015fullu Bi\u00e7imlendirmeye Giri\u015f<\/h4>\n
            \"Giri\u015f\" sekmesindeki \"Ko\u015fullu Bi\u00e7imlendirme\" (Conditional Formatting) d\u00fc\u011fmesi alt\u0131nda bir\u00e7ok haz\u0131r kural ve \u00f6zelle\u015ftirme se\u00e7ene\u011fi bulunur. Bir veri aral\u0131\u011f\u0131 se\u00e7tikten sonra bu araca t\u0131klayarak kurallar\u0131 uygulayabilirsiniz.<\/p>\n
            4.2. Kurallar Olu\u015fturma<\/h4>\n
            Ko\u015fullu bi\u00e7imlendirme kurallar\u0131 \u015funlar\u0131 i\u00e7erebilir:<\/p>\n
              \n
            • De\u011ferlere G\u00f6re:<\/strong> \"B\u00fcy\u00fckt\u00fcr\", \"K\u00fc\u00e7\u00fckt\u00fcr\", \"Aras\u0131nda\", \"E\u015fittir\" gibi say\u0131sal de\u011ferlere dayal\u0131 kurallar.<\/li>\n
            • Metin \u0130\u00e7eriklerine G\u00f6re:<\/strong> \"\u015eunu i\u00e7eren metin\" kural\u0131 ile belirli bir kelime veya ifadeyi i\u00e7eren h\u00fccreleri vurgulayabilirsiniz.<\/li>\n
            • Tarihlere G\u00f6re:<\/strong> \"Bir Tarih Olu\u015fumu\" kural\u0131 ile ge\u00e7mi\u015f veya gelecek tarihleri vurgulayabilirsiniz.<\/li>\n
            • Yinelenen\/Benzersiz De\u011ferler:<\/strong> Veri k\u00fcmenizdeki yinelenen veya benzersiz de\u011ferleri otomatik olarak bulup vurgulayabilirsiniz.<\/li>\n<\/ul>\n
              4.3. Veri \u00c7ubuklar\u0131, Renk \u00d6l\u00e7ekleri ve Simge K\u00fcmeleri<\/h4>\n
              Bu g\u00f6rselle\u015ftirme ara\u00e7lar\u0131, verilerin da\u011f\u0131l\u0131m\u0131n\u0131 ve b\u00fcy\u00fckl\u00fc\u011f\u00fcn\u00fc an\u0131nda anlaman\u0131za yard\u0131mc\u0131 olur:<\/p>\n
                \n
              • Veri \u00c7ubuklar\u0131 (Data Bars):<\/strong> H\u00fccre i\u00e7indeki de\u011ferin b\u00fcy\u00fckl\u00fc\u011f\u00fcne g\u00f6re bir \u00e7ubuk yerle\u015ftirir. Daha b\u00fcy\u00fck de\u011ferler daha uzun \u00e7ubuklara sahip olur.<\/li>\n
              • Renk \u00d6l\u00e7ekleri (Color Scales):<\/strong> H\u00fccrelerin de\u011ferlerine g\u00f6re bir renk gradyan\u0131 uygular. \u00d6rne\u011fin, en d\u00fc\u015f\u00fck de\u011ferler k\u0131rm\u0131z\u0131, ortalama de\u011ferler sar\u0131, en y\u00fcksek de\u011ferler ye\u015fil olabilir.<\/li>\n
              • Simge K\u00fcmeleri (Icon Sets):<\/strong> H\u00fccrelerin de\u011ferlerini belirli bir e\u015fik aral\u0131\u011f\u0131na g\u00f6re simgelerle (oklar, trafik \u0131\u015f\u0131klar\u0131, y\u0131ld\u0131zlar) temsil eder.<\/li>\n<\/ul>\n
                4.4. \u00d6nemli Veri Noktalar\u0131n\u0131 Vurgulama<\/h4>\n
                Ko\u015fullu bi\u00e7imlendirme sayesinde, sat\u0131\u015f hedeflerini a\u015fan \u00fcr\u00fcnleri, stok seviyesi kritik d\u00fczeyde olan kalemleri veya belirli bir e\u015fi\u011fin \u00fczerindeki harcamalar\u0131 an\u0131nda g\u00f6rebilirsiniz. Bu, karar verme s\u00fcre\u00e7lerini h\u0131zland\u0131r\u0131r ve dikkat gerektiren alanlara odaklanman\u0131z\u0131 sa\u011flar.<\/p>\n
                5. Pivot Tablolar ile \u00d6zet Veri Analizi<\/h3>\n
                Pivot tablolar, b\u00fcy\u00fck veri k\u00fcmelerini \u00f6zetlemek, analiz etmek, ke\u015ffetmek ve sunmak i\u00e7in Excel'in en g\u00fc\u00e7l\u00fc ara\u00e7lar\u0131ndan biridir. Karma\u015f\u0131k verilerden h\u0131zl\u0131ca anlaml\u0131 \u00f6zetler \u00e7\u0131karman\u0131z\u0131 sa\u011flar.<\/p>\n
                5.1. Pivot Tablo Nedir ve Neden Kullan\u0131l\u0131r?<\/h4>\n
                Pivot tablo, ham verileri farkl\u0131 boyutlarda (sat\u0131rlar, s\u00fctunlar, de\u011ferler, filtreler) yeniden d\u00fczenleyerek ve \u00f6zetleyerek anlaml\u0131 bilgiler sunan interaktif bir tablodur. \u00d6rne\u011fin, binlerce sat\u0131\u015f kayd\u0131ndan olu\u015fan bir listeden, her bir \u00fcr\u00fcn\u00fcn ayl\u0131k toplam sat\u0131\u015flar\u0131n\u0131 veya her bir b\u00f6lgedeki ortalama sat\u0131\u015f miktar\u0131n\u0131 saniyeler i\u00e7inde \u00e7\u0131karabilirsiniz. Karma\u015f\u0131k sorulara h\u0131zl\u0131ca yan\u0131t bulmak i\u00e7in idealdir.<\/p>\n
                5.2. Pivot Tablo Olu\u015fturma Ad\u0131mlar\u0131<\/h4>\n
                  \n
                1. Analiz etmek istedi\u011finiz veri aral\u0131\u011f\u0131n\u0131 se\u00e7in.<\/li>\n
                2. \"Ekle\" (Insert) sekmesine gidin ve \"Pivot Tablo\" (PivotTable) d\u00fc\u011fmesine t\u0131klay\u0131n.<\/li>\n
                3. Yeni bir \u00e7al\u0131\u015fma sayfas\u0131 veya mevcut bir \u00e7al\u0131\u015fma sayfas\u0131 se\u00e7in.<\/li>\n
                4. \"PivotTable Alanlar\u0131\" (PivotTable Fields) b\u00f6lmesi a\u00e7\u0131lacakt\u0131r.<\/li>\n<\/ol>\n
                  5.3. Alanlar\u0131 D\u00fczenleme<\/h4>\n
                  PivotTable Alanlar\u0131 b\u00f6lmesinde, veri ba\u015fl\u0131klar\u0131n\u0131z listelenir. Bu alanlar\u0131 a\u015fa\u011f\u0131daki d\u00f6rt b\u00f6lmeye s\u00fcr\u00fckleyip b\u0131rakarak pivot tablonuzu olu\u015fturursunuz:<\/p>\n
                    \n
                  • Filtreler (Filters):<\/strong> Tablonun tamam\u0131n\u0131 belirli kriterlere g\u00f6re filtrelemek i\u00e7in kullan\u0131l\u0131r.<\/li>\n
                  • S\u00fctunlar (Columns):<\/strong> Verileri s\u00fctun ba\u015fl\u0131klar\u0131 olarak g\u00f6r\u00fcnt\u00fcler.<\/li>\n
                  • Sat\u0131rlar (Rows):<\/strong> Verileri sat\u0131r ba\u015fl\u0131klar\u0131 olarak g\u00f6r\u00fcnt\u00fcler.<\/li>\n
                  • De\u011ferler (Values):<\/strong> \u00d6zetlenecek say\u0131sal verileri i\u00e7erir (toplam, ortalama, say\u0131m vb.). Varsay\u0131lan olarak genellikle \"Toplam\" al\u0131r. Alan ayarlar\u0131ndan de\u011fi\u015ftirebilirsiniz.<\/li>\n<\/ul>\n
                    \u00d6rne\u011fin, \"\u00dcr\u00fcn Ad\u0131\"n\u0131 Sat\u0131rlar'a, \"B\u00f6lge\"yi S\u00fctunlar'a ve \"Sat\u0131\u015f Miktar\u0131\"n\u0131 De\u011ferler'e s\u00fcr\u00fckleyerek her \u00fcr\u00fcn\u00fcn her b\u00f6lgedeki sat\u0131\u015f miktar\u0131n\u0131 \u00f6zetleyebilirsiniz.<\/p>\n
                    5.4. Dilimleyiciler (Slicers) ve Zaman \u00c7izelgeleri (Timelines)<\/h4>\n
                    Pivot tablolar\u0131n\u0131z\u0131 daha interaktif hale getirmek i\u00e7in dilimleyiciler ve zaman \u00e7izelgeleri kullanabilirsiniz:<\/p>\n
                      \n
                    • Dilimleyiciler:<\/strong> Pivot tablonuzu h\u0131zl\u0131 ve g\u00f6rsel bir \u015fekilde filtrelemek i\u00e7in d\u00fc\u011fmeler sunar. \u00d6rne\u011fin, \"Departman\" i\u00e7in bir dilimleyici ekleyerek tek t\u0131klamayla belirli departmanlar\u0131n verilerini g\u00f6rebilirsiniz.<\/li>\n
                    • Zaman \u00c7izelgeleri:<\/strong> Tarih verilerine sahip pivot tablolar i\u00e7in \u00f6zel bir dilimleyicidir. Y\u0131llara, aylara, \u00e7eyreklere veya g\u00fcnlere g\u00f6re kolayca filtreleme yapman\u0131z\u0131 sa\u011flar.<\/li>\n<\/ul>\n
                      6. Grafikler ve G\u00f6rselle\u015ftirme<\/h3>\n
                      Veri analizi, sadece say\u0131lar\u0131 incelemekle kalmaz, ayn\u0131 zamanda bu say\u0131lar\u0131n hikayesini anlatmay\u0131 da gerektirir. Excel grafikleri, karma\u015f\u0131k verileri anla\u015f\u0131l\u0131r ve etkileyici g\u00f6rsel hikayelere d\u00f6n\u00fc\u015ft\u00fcrmenin en iyi yoludur.<\/p>\n
                      6.1. Do\u011fru Grafik T\u00fcr\u00fcn\u00fc Se\u00e7me<\/h4>\n
                      Verilerinizin t\u00fcr\u00fcne ve anlatmak istedi\u011finiz hikayeye g\u00f6re do\u011fru grafik t\u00fcr\u00fcn\u00fc se\u00e7mek \u00e7ok \u00f6nemlidir:<\/p>\n
                        \n
                      • S\u00fctun\/\u00c7ubuk Grafikler:<\/strong> Farkl\u0131 kategoriler aras\u0131ndaki kar\u015f\u0131la\u015ft\u0131rmalar\u0131 g\u00f6stermek i\u00e7in idealdir (\u00f6rn: \u00fcr\u00fcn sat\u0131\u015flar\u0131).<\/li>\n
                      • \u00c7izgi Grafikler:<\/strong> Zaman i\u00e7indeki e\u011filimleri veya veri noktalar\u0131 aras\u0131ndaki ili\u015fkileri g\u00f6stermek i\u00e7in kullan\u0131l\u0131r (\u00f6rn: ayl\u0131k gelir de\u011fi\u015fimi).<\/li>\n
                      • Pasta Grafikler:<\/strong> Bir b\u00fct\u00fcn\u00fcn par\u00e7alar\u0131n\u0131 g\u00f6stermek i\u00e7in kullan\u0131l\u0131r, ancak genellikle 5-7'den fazla kategori olmad\u0131\u011f\u0131nda daha etkilidir (\u00f6rn: pazar paylar\u0131).<\/li>\n
                      • Da\u011f\u0131l\u0131m Grafikleri:<\/strong> \u0130ki say\u0131sal de\u011fi\u015fken aras\u0131ndaki ili\u015fkiyi g\u00f6stermek i\u00e7in kullan\u0131l\u0131r (\u00f6rn: reklam harcamas\u0131 ile sat\u0131\u015f aras\u0131ndaki ili\u015fki).<\/li>\n<\/ul>\n
                        6.2. Grafik Olu\u015fturma ve \u00d6zelle\u015ftirme<\/h4>\n
                          \n
                        1. Grafi\u011fe d\u00f6n\u00fc\u015ft\u00fcrmek istedi\u011finiz verileri se\u00e7in.<\/li>\n
                        2. \"Ekle\" (Insert) sekmesine gidin ve \"\u00d6nerilen Grafikler\" (Recommended Charts) veya do\u011frudan bir grafik t\u00fcr\u00fc se\u00e7in.<\/li>\n
                        3. Excel, se\u00e7ti\u011finiz verilere g\u00f6re bir grafik olu\u015fturacakt\u0131r.<\/li>\n
                        4. Grafi\u011fi se\u00e7ti\u011finizde, sa\u011f \u00fcst k\u00f6\u015fede \u00e7\u0131kan \"+\" (Grafik \u00d6\u011feleri), f\u0131r\u00e7a (Grafik Stilleri) ve filtre (Grafik Filtreleri) d\u00fc\u011fmeleriyle grafi\u011fi \u00f6zelle\u015ftirebilirsiniz.<\/li>\n<\/ol>\n
                          6.3. Grafik \u00d6\u011felerini Anlama<\/h4>\n
                          Bir grafi\u011fin ana \u00f6\u011feleri \u015funlard\u0131r:<\/p>\n
                            \n
                          • Grafik Ba\u015fl\u0131\u011f\u0131:<\/strong> Grafi\u011fin ne hakk\u0131nda oldu\u011funu a\u00e7\u0131klar.<\/li>\n
                          • Eksen Ba\u015fl\u0131klar\u0131:<\/strong> X ve Y eksenlerinin neyi temsil etti\u011fini belirtir.<\/li>\n
                          • G\u00f6sterge (Legend):<\/strong> Grafikteki farkl\u0131 veri serilerini tan\u0131mlar.<\/li>\n
                          • Veri Etiketleri:<\/strong> Do\u011frudan grafik \u00fczerindeki veri noktalar\u0131n\u0131n de\u011ferlerini g\u00f6sterir.<\/li>\n
                          • Veri Tablosu:<\/strong> Grafi\u011fin alt\u0131nda kullan\u0131lan verileri bir tablo olarak g\u00f6sterir.<\/li>\n<\/ul>\n
                            6.4. Trendleri ve \u0130li\u015fkileri G\u00f6rselle\u015ftirme<\/h4>\n
                            Grafikler, verilerdeki e\u011filimleri (y\u00fckseli\u015f, d\u00fc\u015f\u00fc\u015f), mevsimsel kal\u0131plar\u0131, anormallikleri ve de\u011fi\u015fkenler aras\u0131ndaki ili\u015fkileri \u00e7\u0131plak g\u00f6zle g\u00f6rmemizi sa\u011flar. \u00d6rne\u011fin, bir \u00e7izgi grafi\u011fi ile sat\u0131\u015flar\u0131n y\u0131l boyunca nas\u0131l de\u011fi\u015fti\u011fini kolayca g\u00f6zlemleyebilir, bir s\u00fctun grafi\u011fi ile farkl\u0131 \u00fcr\u00fcnlerin performans\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rabilirsiniz. G\u00f6rselle\u015ftirme, verilerin arkas\u0131ndaki hikayeyi anlatman\u0131n en etkili yoludur.<\/p>\n
                            Sonu\u00e7<\/h3>\n
                            Microsoft Excel, temel veri analizi i\u00e7in inan\u0131lmaz derecede g\u00fc\u00e7l\u00fc ve esnek bir ara\u00e7t\u0131r. Bu rehberde ele ald\u0131\u011f\u0131m\u0131z konular \u2013 veri haz\u0131rl\u0131\u011f\u0131, temel form\u00fcller, filtreleme, s\u0131ralama, ko\u015fullu bi\u00e7imlendirme, pivot tablolar ve grafikler \u2013 veri d\u00fcnyas\u0131na sa\u011flam bir ba\u015flang\u0131\u00e7 yapman\u0131z\u0131 sa\u011flayacakt\u0131r. Bu becerileri kazanarak, g\u00fcnl\u00fck i\u015flerinizde daha bilin\u00e7li kararlar alabilir, verilerinizdeki gizli kal\u0131plar\u0131 ortaya \u00e7\u0131karabilir ve sunumlar\u0131n\u0131z\u0131 daha etkili hale getirebilirsiniz. Excel'in sundu\u011fu olanaklar s\u0131n\u0131rs\u0131zd\u0131r ve pratik yapt\u0131k\u00e7a veri analizi yolculu\u011funuzda daha da ileriye gideceksiniz.<\/p>\n
                            SSS (S\u0131k Sorulan Sorular)<\/h3>\n
                            1. Excel'de g\u00f6receli ve mutlak h\u00fccre referanslar\u0131 aras\u0131ndaki fark nedir?<\/h4>\n
                            G\u00f6receli referanslar (\u00f6rn: A1)<\/strong>, bir form\u00fcl\u00fc kopyalad\u0131\u011f\u0131n\u0131zda hedefe g\u00f6re otomatik olarak de\u011fi\u015fir. \u00d6rne\u011fin, A1'deki form\u00fcl\u00fc B1'e kopyalarsan\u0131z A1, B1'e d\u00f6n\u00fc\u015f\u00fcr. Mutlak referanslar (\u00f6rn: $A$1)<\/strong> ise dolar i\u015faretiyle sabitlenir ve form\u00fcl\u00fc kopyalasan\u0131z bile referans de\u011fi\u015fmez. Bu, bir sabiti veya belirli bir h\u00fccredeki bir de\u011feri birden fazla hesaplamada kullanmak istedi\u011finizde \u00e7ok kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n
                            2. Excel \u00e7ok b\u00fcy\u00fck veri k\u00fcmelerini analiz edebilir mi?<\/h4>\n
                            Evet, Excel modern s\u00fcr\u00fcmlerinde (Excel 2007 ve sonras\u0131) 1.048.576 sat\u0131r ve 16.384 s\u00fctun kapasitesine sahiptir. Bu, \u00e7o\u011fu temel veri analizi ihtiyac\u0131 i\u00e7in yeterince b\u00fcy\u00fckt\u00fcr. Ancak, milyonlarca sat\u0131r\u0131 a\u015fan \u00e7ok b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in Power Query veya Power Pivot gibi Excel eklentileri veya Python, R gibi daha geli\u015fmi\u015f veri analizi ara\u00e7lar\u0131 daha uygun olabilir.<\/p>\n
                            3. Yeni ba\u015flayanlar i\u00e7in Excel'de veri analizi yaparken yap\u0131lan yayg\u0131n hatalar nelerdir?<\/h4>\n
                            Yayg\u0131n hatalar aras\u0131nda veri temizli\u011fini atlamak, form\u00fcllerde yanl\u0131\u015f h\u00fccre referanslar\u0131 kullanmak, verileri tutars\u0131z formatlarda girmek, grafik t\u00fcr\u00fcn\u00fc yanl\u0131\u015f se\u00e7mek ve pivot tablo olu\u015ftururken veri aral\u0131\u011f\u0131n\u0131 dinamik yapmamak (yeni veriler eklendi\u011finde tablonun g\u00fcncellenmemesi) say\u0131labilir. Her zaman verilerinizi kontrol edin ve form\u00fcllerinizi k\u00fc\u00e7\u00fck bir \u00f6rnekle test edin.<\/p>\n
                            4. Excel'de veri analizi becerilerimi daha da geli\u015ftirmek i\u00e7in nereden ba\u015flayabilirim?<\/h4>\n
                            Excel'de veri analizi becerilerinizi geli\u015ftirmek i\u00e7in bir\u00e7ok kaynak bulunmaktad\u0131r. Microsoft'un kendi destek sayfalar\u0131, online kurs platformlar\u0131 (Coursera, Udemy, edX), YouTube'daki e\u011fitim kanallar\u0131 ve bloglar harika ba\u015flang\u0131\u00e7 noktalar\u0131d\u0131r. Ayr\u0131ca, Power Query, Power Pivot ve VBA gibi daha geli\u015fmi\u015f Excel ara\u00e7lar\u0131n\u0131 \u00f6\u011frenmek, yeteneklerinizi bir \u00fcst seviyeye ta\u015f\u0131yacakt\u0131r.<\/p>\n
                            5. Pivot tablolar\u0131n temel faydas\u0131 nedir?<\/h4>\n
                            Pivot tablolar\u0131n temel faydas\u0131, b\u00fcy\u00fck ve karma\u015f\u0131k veri k\u00fcmelerini h\u0131zl\u0131 bir \u015fekilde \u00f6zetleyerek, farkl\u0131 a\u00e7\u0131lardan inceleyerek ve anlaml\u0131 raporlar olu\u015fturarak karar verme s\u00fcre\u00e7lerini desteklemesidir. Kullan\u0131c\u0131lar\u0131n verilerle interaktif bir \u015fekilde oynamas\u0131na, farkl\u0131 sorular sormas\u0131na ve an\u0131nda yan\u0131tlar almas\u0131na olanak tan\u0131r, bu da veri ke\u015ffini ve i\u00e7g\u00f6r\u00fc elde etmeyi kolayla\u015ft\u0131r\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"G\u00fcn\u00fcm\u00fcz dijital d\u00fcnyas\u0131nda veri, i\u015f kararlar\u0131ndan ki\u015fisel finans y\u00f6netimine kadar her alanda kritik bir rol oynamaktad\u0131r. Verileri anlamak, onlarda…","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-38186","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"\nMicrosoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi\" \/>\n<meta property=\"og:description\" content=\"G\u00fcn\u00fcm\u00fcz dijital d\u00fcnyas\u0131nda veri, i\u015f kararlar\u0131ndan ki\u015fisel finans y\u00f6netimine kadar her alanda kritik bir rol oynamaktad\u0131r. Verileri anlamak, onlarda...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-25T09:30:38+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi\",\"datePublished\":\"2026-01-25T09:30:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/\"},\"wordCount\":2770,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/\",\"name\":\"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-01-25T09:30:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","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:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/","og_locale":"tr_TR","og_type":"article","og_title":"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi","og_description":"G\u00fcn\u00fcm\u00fcz dijital d\u00fcnyas\u0131nda veri, i\u015f kararlar\u0131ndan ki\u015fisel finans y\u00f6netimine kadar her alanda kritik bir rol oynamaktad\u0131r. Verileri anlamak, onlarda...","og_url":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-01-25T09:30:38+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"14 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi","datePublished":"2026-01-25T09:30:38+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/"},"wordCount":2770,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/","url":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/","name":"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-01-25T09:30:38+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/microsoft-excel-ile-temel-veri-analizi-baslangic-rehberi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Microsoft Excel ile Temel Veri Analizi: Ba\u015flang\u0131\u00e7 Rehberi"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/38186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=38186"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/38186\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=38186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=38186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=38186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}