{"id":7082,"date":"2022-05-17T17:13:21","date_gmt":"2022-05-17T14:13:21","guid":{"rendered":"https:\/\/www.niobehosting.com\/blog\/?p=7082"},"modified":"2022-07-04T15:49:17","modified_gmt":"2022-07-04T12:49:17","slug":"excel-formulleri","status":"publish","type":"post","link":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/","title":{"rendered":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri"},"content":{"rendered":"\n

\u0130\u015f hayat\u0131nda, e\u011fitim hayat\u0131nda en \u00e7ok kulland\u0131\u011f\u0131m\u0131z programlardan biri Excel oluyor. Microsoft\u2019un geli\u015ftirdi\u011fi ve piyasaya sundu\u011fu Excel, temel tablolama i\u015flemlerine sahip bir yaz\u0131l\u0131md\u0131r. Y\u0131llard\u0131r yaln\u0131zca temel tablolama i\u015flemleri konusunda yard\u0131mc\u0131 olabilece\u011fi d\u00fc\u015f\u00fcn\u00fclen Excel\u2019in \u00e7ok farkl\u0131 kullan\u0131m alanlar\u0131 da mevcut. Excel <\/strong>ile g\u00fcnl\u00fck hayatta size yard\u0131mc\u0131 olabilecek, hayat\u0131n\u0131z\u0131 kurtaracak bir\u00e7ok i\u015fi de yapabilirsiniz. Tabi ki bunun i\u00e7in de en \u00f6nemli Excel form\u00fcllerini <\/strong>bilmeniz gerekiyor. Biz de bu yaz\u0131m\u0131zda sizler i\u00e7in bu form\u00fclleri ara\u015ft\u0131rd\u0131k.\u00a0<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Excel Kullan\u0131m\u0131<\/h2>\n\n\n\n

Excel\u2019de sat\u0131rlar ve s\u00fctunlar bulunur. Bu sat\u0131r ve s\u00fctunlar asl\u0131nda birer h\u00fccredir. Excel\u2019in \u00e7al\u0131\u015fma sistemi h\u00fccrelerden olu\u015fur ve bu h\u00fccreler bize sat\u0131r ve s\u00fctun olarak yans\u0131r. Bu sat\u0131r ve s\u00fctunlar tarih, saat, metin ya da rakam gibi form\u00fcllerle tan\u0131mlanabilir. Bu h\u00fccrelerin her biri tek tek tutulabilece\u011fi gibi toplu bir \u015fekilde de tutulabilir. Toplu tutulan h\u00fccreler sol \u00fcst k\u00f6\u015fede aktif olur. <\/p>\n\n\n\n

Excel, g\u00fcndelik hayat\u0131m\u0131zda, i\u015f ve e\u011fitim hayat\u0131m\u0131zda bize b\u00fcy\u00fck kolayl\u0131klar sa\u011flar. Tablolar\u0131 kolay bir \u015fekilde s\u0131n\u0131fland\u0131rmam\u0131za ve verileri do\u011fru bir \u015fekilde d\u00fczenlememize yard\u0131mc\u0131 olur.<\/p>\n\n\n\n

Form\u00fclleri kullanabilmek i\u00e7in \u2018\u2018=\u2019\u2019 ibaresini kullanmak zorunludur. E\u015fittir ibaresinden sonra girece\u011fimiz kelimelere g\u00f6re form\u00fcller ve kullan\u0131mlar de\u011fi\u015fiklik g\u00f6sterir. Yaz\u0131lan form\u00fcl, ana men\u00fcde yer alan form\u00fcl \u00e7ubu\u011funda g\u00f6r\u00fcn\u00fcr. H\u00fccreler de koordinatlar\u0131na g\u00f6re isim al\u0131r. \u00d6rnek verecek olursak; B2 h\u00fccresi, B s\u00fctununda yer alan 2. sat\u0131r\u0131<\/strong> ifade eder. <\/p>\n\n\n\n

Form\u00fclde yer alan \u2018\u2018:\u2019\u2019 ise hangi h\u00fccrelerin aras\u0131na konduysa o aral\u0131kta t\u00fcm h\u00fccreleri kapsar. \u2018\u2018;\u2019\u2019 ise sadece ad\u0131 yaz\u0131lan h\u00fccrenin i\u015fleme al\u0131nmas\u0131n\u0131 sa\u011flar. <\/p>\n\n\n\n

Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri<\/h2>\n\n\n\n

Excel\u2019de kullanabilece\u011finiz ve hayat\u0131n\u0131z\u0131 bir hayli kolayla\u015ft\u0131racak bir\u00e7ok form\u00fcl bulunuyor. Bu form\u00fclleri kullanarak siz de gerekli i\u015flemleri k\u0131sa bir s\u00fcrede ger\u00e7ekle\u015ftirebilirsiniz. \u015eimdi gelin tek tek bu form\u00fclleri inceleyelim. <\/p>\n\n\n\n

 =Ortalama (=Average) Form\u00fcl\u00fc<\/h3>\n\n\n\n

Belirli h\u00fccrelerin ortalamas\u0131n\u0131 alman\u0131za yarayan bu form\u00fclde;<\/p>\n\n\n\n

  • Sonucun g\u00f6sterilece\u011fi h\u00fccreye \u2018\u2018=\u2019\u2019girmeniz gerekiyor. Sonras\u0131nda ise i\u015flev ekle butonuna t\u0131klay\u0131n.<\/li>
  • Burada \u2018\u2018ORTALAMA\u2019\u2019<\/strong> komutunu se\u00e7in. H\u00fccreler otomatik olarak se\u00e7ilecektir fakat siz diledi\u011finiz h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7ebilirsiniz. <\/li>
  • Form\u00fcl\u00fc kapatana kadar h\u00fccreler mavi \u00e7er\u00e7eve i\u00e7inde yer alacakt\u0131r.<\/li>
  • Form\u00fcl\u00fc el ile de yazabilirsiniz. =ortalama (B2:B9) yazarsan\u0131z bu h\u00fccreler aras\u0131ndaki de\u011ferlerin ortalamas\u0131n\u0131 elde etmi\u015f olursunuz. <\/li><\/ul>\n\n\n\n

    =Topla (=Sum) Form\u00fcl\u00fc<\/h3>\n\n\n\n
    • Bir s\u00fctunda yer alan h\u00fccrelerdeki say\u0131lar\u0131 toplamaya yarayan bir form\u00fcld\u00fcr.<\/li>
    • Sonucun g\u00f6sterilmesini istedi\u011finiz h\u00fccreye \u2018\u2018=\u2019\u2019 simgesini girin. Daha sonra ana men\u00fcde yer alan form\u00fcller sekmesinden sol \u00fcst k\u0131s\u0131mda yer alan i\u015flev ekle butonuna t\u0131klay\u0131n.<\/li>
    • Burada \u2018\u2018TOPLA\u2019\u2019 komutunu se\u00e7meniz gerekiyor. Burada da toplanmas\u0131n\u0131 istedi\u011finiz h\u00fccrelerin aral\u0131\u011f\u0131n\u0131 siz se\u00e7ebilirsiniz.\u00a0<\/li>
    • Hangi h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7tiyseniz burada yer alan t\u00fcm de\u011ferler toplan\u0131r ve sonu\u00e7 form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131z h\u00fccrede g\u00f6sterilir.\u00a0<\/li>
    • Form\u00fcl\u00fc elle yazmak i\u00e7in =TOPLA(B2:B9) <\/strong>yazman\u0131z da yeterli olacakt\u0131r.<\/li><\/ul>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      =Mak (=Max) Form\u00fcl\u00fc<\/h3>\n\n\n\n
      • Belirli h\u00fccreler aras\u0131nda en y\u00fcksek de\u011fere sahip olan\u0131 g\u00f6rmek i\u00e7in kullan\u0131l\u0131r.<\/li>
      • Sonucun g\u00f6sterilmesini istedi\u011finiz h\u00fccreye \u2018\u2018=\u2019\u2019 simgesini girin ve i\u015flev ekle butonuna t\u0131klay\u0131n. <\/li>
      • Daha sonra \u2018\u2018MAK\u2019\u2019 komutunu se\u00e7meniz gerekiyor. Burada da istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131n\u0131 siz se\u00e7ebilirsiniz.<\/li>
      • Bu form\u00fcl kapat\u0131lana dek h\u00fccrelerin yer ald\u0131\u011f\u0131 k\u0131s\u0131m \u00e7er\u00e7eveli bir \u015fekilde g\u00f6r\u00fcn\u00fcr.<\/li>
      • Bu form\u00fcl\u00fc elle yazmak i\u00e7in ise; =MAK(B2:B9) <\/strong>yazman\u0131z yeterli olacakt\u0131r.<\/li>
      • E\u011fer en b\u00fcy\u00fck de\u011feri de\u011fil de en k\u00fc\u00e7\u00fck de\u011feri elde etmek istiyorsan\u0131z ise M\u0130N<\/strong> yazman\u0131z gerekiyor. Mak yazd\u0131\u011f\u0131n\u0131z yerlere Min yazarak minimum de\u011feri elde edebilirsiniz.<\/li><\/ul>\n\n\n\n

        \u015eimdi Form\u00fcl\u00fc<\/h3>\n\n\n\n

        Excel kullan\u0131rken tarihi \u00f6\u011frenmek isterseniz bu form\u00fcl\u00fc kullanabilirsiniz. =\u015eimdi()<\/strong> form\u00fcl\u00fc ile hangi tarihe gitmek istiyorsan\u0131z o tarihi yazman\u0131z gerekiyor. Bulundu\u011funuz tarihten 5 g\u00fcn \u00f6nceye gitmek istiyorsan\u0131z ilgili h\u00fccreye =\u015eimdi(5) yazman\u0131z yeterli olacakt\u0131r.<\/p>\n\n\n\n

        Say Form\u00fcl\u00fc<\/h3>\n\n\n\n
        • Belirli bir aral\u0131kta ka\u00e7 h\u00fccre oldu\u011funu belirlemek i\u00e7in kullan\u0131lan bir form\u00fcld\u00fcr. Bu form\u00fcl\u00fc kullanmak i\u00e7in sonucun g\u00f6sterilece\u011fi h\u00fccreye =ba\u011f_de\u011f_say(B2:B9) <\/strong>yaz\u0131ld\u0131\u011f\u0131nda o h\u00fccre aral\u0131\u011f\u0131nda dolu ya da bo\u015f fark etmeksizin ka\u00e7 h\u00fccre oldu\u011fu g\u00f6r\u00fcnt\u00fclenir.<\/li>
        • E\u011fer bu h\u00fccrelerden ka\u00e7\u0131n\u0131n dolu oldu\u011funu (yani veri oldu\u011funu) \u00f6\u011frenmek istiyorsak bunu da tek tek saymam\u0131za gerek yok. Bu kez farkl\u0131 bir form\u00fcl bize yard\u0131mc\u0131 olacak. Bu form\u00fcl de =ba\u011f_de\u011f_dolu_say(B2:B9)<\/strong> oluyor. Bu form\u00fcl ile de B2 ile B9 h\u00fccreleri aras\u0131nda ka\u00e7 tane dolu h\u00fccre oldu\u011funu kolay bir \u015fekilde bulabiliriz.<\/li><\/ul>\n\n\n\n

          E\u011fer Form\u00fcl\u00fc<\/h3>\n\n\n\n
          • En \u00e7ok i\u015fe yarayan form\u00fcllerden biri olan E\u011fer form\u00fcl\u00fc \u015fart ifadesi olu\u015fturur. \u00d6rnek verecek olursak; y\u00fcksek maa\u015fl\u0131 \u00e7al\u0131\u015fanlar\u0131 \u00f6\u011frenmek istiyoruz. Bunun i\u00e7in 10000 TL\u2019yi e\u011fer yani ko\u015ful olarak belirlememiz gerekiyor. 10000\u2019den y\u00fcksek miktarlar direkt kar\u015f\u0131m\u0131za y\u00fcksek olarak \u00e7\u0131kacakt\u0131r.<\/li>
          • Bu form\u00fcl i\u00e7in ise ilgili h\u00fccreye =E\u011fer(C2>10000; \u2018\u2018y\u00fcksek\u2019\u2019; \u2018\u2018d\u00fc\u015f\u00fck\u2019\u2019)<\/strong> yazman\u0131z yeterli olacakt\u0131r. Sonras\u0131nda ilgili veriler kar\u015f\u0131n\u0131za \u00e7\u0131kacak. Bu form\u00fcl\u00fc kopyalayarak di\u011fer t\u00fcm h\u00fccrelerde deneyebilirsiniz.<\/li><\/ul>\n\n\n\n

            Birle\u015ftir Form\u00fcl\u00fc<\/h3>\n\n\n\n
            • Bu form\u00fcl ile iki farkl\u0131 h\u00fccreyi \u00e7ok kolay bir \u015fekilde birle\u015ftirirsiniz.<\/li>
            • Bunun i\u00e7in yapman\u0131z gereken birle\u015ftirmek istedi\u011finiz iki h\u00fccreye de \u2018\u2018birle\u015ftir(A1:B2)<\/strong> yazmak olacakt\u0131r.<\/li><\/ul>\n\n\n\n

              D\u00fc\u015feyara Form\u00fcl\u00fc<\/h3>\n\n\n\n
              • Bu form\u00fcl ile tablodaki veriler ile ba\u015fka alandaki verileri kar\u015f\u0131la\u015ft\u0131rabilirsiniz.<\/li>
              • D\u00fc\u015feyara form\u00fcl\u00fc d\u00f6rt temel bilgi \u00e7er\u00e7evesinde de\u011ferlendirilir. Bunlar\u0131n ilki aranan de\u011fer, ikinci arama de\u011ferinin bulundu\u011fu aral\u0131k, \u00fc\u00e7\u00fcnc\u00fc d\u00f6n\u00fc\u015f de\u011feri i\u00e7eren s\u00fctun numaras\u0131, d\u00f6rd\u00fcnc\u00fcs\u00fc ise elde edilmek istenen sonucun mant\u0131ksal de\u011feridir. Bunun form\u00fcl\u00fc ise; d\u00fc\u015feyara(aranan_de\u011fer, tablo_dizini, s\u00fctun_indis_say\u0131s\u0131,(aral\u0131k_bak)) <\/strong>olarak bilinir. <\/li>
              • Bu form\u00fcl ile farkl\u0131 iki tablodaki de\u011ferler kolayl\u0131kla kar\u015f\u0131la\u015ft\u0131r\u0131labilir.<\/li><\/ul>\n\n\n\n

                \u0130ndis Form\u00fcl\u00fc<\/h3>\n\n\n\n
                • \u0130ndis, Excel\u2019de \u00e7ok s\u0131k kullan\u0131lmaz fakat b\u00fcy\u00fck i\u015flevlere sahiptir. D\u00fc\u015feyara bazen kullan\u0131lamaz ve bu durumda devreye indis form\u00fcl\u00fc girer. \u0130ndis\u2019in fark\u0131 ise de\u011fi\u015fken aral\u0131k d\u00f6nd\u00fcrebilmesidir. <\/li>
                • \u0130ndis form\u00fcl\u00fc ise ; =indis(dizi,sat\u0131r say\u0131s\u0131, s\u00fctun say\u0131s\u0131)<\/strong> olarak bilinir. Bu form\u00fcl\u00fc ilgili h\u00fccreye yazarak herhangi bir h\u00fccrenin herhangi bir s\u00fctun ile kesi\u015fti\u011fi h\u00fccreleri bulabilirsiniz.<\/li><\/ul>\n\n\n\n

                  Etopla Form\u00fcl\u00fc<\/h3>\n\n\n\n
                  • Toplu komutundan farkl\u0131 olarak yaln\u0131zca istenen b\u00f6l\u00fcmlerin toplanmas\u0131n\u0131 sa\u011flayan bir komuttur. K\u0131saca; tek \u015farta ba\u011flanan bir toplama i\u015flemini ifade eder. <\/li>
                  • Form\u00fcl\u00fc ise; =etopla(aral\u0131k;\u00f6l\u00e7\u00fct;(toplam_aral\u0131\u011f\u0131))<\/strong> olarak bilinir. Hangi h\u00fccreler aras\u0131 toplama yapmak istiyorsan\u0131z bu aral\u0131kt\u0131r. \u00d6l\u00e7\u00fct ise h\u00fccreler aras\u0131nda arad\u0131\u011f\u0131m\u0131z \u015fartt\u0131r.Toplam de\u011fer elde etmek i\u00e7in ise toplam aral\u0131\u011f\u0131 kullan\u0131l\u0131r.<\/li><\/ul>\n\n\n\n

                    K\u0131rpma Form\u00fcl\u00fc<\/h3>\n\n\n\n
                    • Kelimelerin aras\u0131nda, sonunda ya da ba\u015f\u0131nda yer alan gereksiz bo\u015fluklar\u0131 silmek i\u00e7in kullan\u0131lan bir form\u00fcld\u00fcr. Burada da ilgili h\u00fccreye =KIRP(B1)<\/strong> yazarak buradaki bo\u015fluklar\u0131 kolay bir \u015fekilde silebiliriz.<\/li><\/ul>\n\n\n\n

                      Ka\u00e7\u0131nc\u0131 Form\u00fcl\u00fc<\/h3>\n\n\n\n
                      • Belirli bir ifadenin belirli aral\u0131kta ka\u00e7\u0131nc\u0131 s\u0131rada oldu\u011funu bulmaya ve e\u015fle\u015ftirmeye yarayan bir form\u00fcld\u00fcr. Genellikle uzun listelerde kullan\u0131l\u0131r.<\/li>
                      • \u0130lgili s\u00fctuna =ka\u00e7\u0131nc\u0131 yazd\u0131ktan sonra aramak istedi\u011fimiz kelimeyi yazman\u0131z gerekiyor. Bu kelimenin hosting oldu\u011funu kabul edelim. Bu durumda form\u00fcl =ka\u00e7\u0131nc\u0131(\u2018\u2018hosting\u2019\u2019;B1:B12;0)<\/strong> olarak belirlenir.<\/li><\/ul>\n\n\n\n

                        Yuvarla Form\u00fcl\u00fc<\/h3>\n\n\n\n
                        • Bir h\u00fccrede yer alan rakamlar\u0131n tam olmamas\u0131 halinde istenen basamaktan yukar\u0131 ya da a\u015fa\u011f\u0131 yuvarlamak i\u00e7in kullan\u0131l\u0131r.<\/li>
                        • Yuvarla, a\u015fa\u011f\u0131 yuvarla ya da yukar\u0131 yuvarla \u015feklinde kullan\u0131l\u0131r.<\/li>
                        • Bunun form\u00fcl\u00fc ise =yuvarla(B1;de\u011fi\u015fken)<\/strong> \u015feklindedir. Bu de\u011fi\u015fken, hangi basamakta yuvarlama yap\u0131laca\u011f\u0131n\u0131 belirler. <\/li>
                        • E\u011fer yukar\u0131 yuvarlanmas\u0131 isteniyorsa form\u00fclde yukar\u0131yuvarla, a\u015fa\u011f\u0131 yuvarlanmas\u0131 isteniyorsa a\u015fa\u011f\u0131yuvarla yaz\u0131lmas\u0131 gerekiyor.<\/li><\/ul>\n\n\n\n

                          Uzunluk Form\u00fcl\u00fc<\/h3>\n\n\n\n
                          • Bir h\u00fccredeki metnin ya da say\u0131n\u0131n ka\u00e7 karaktere sahip oldu\u011funu belirlemeye yarar.<\/li>
                          • Bunun form\u00fcl\u00fc ise =uzunluk(b1<\/strong>) \u015feklindedir.<\/li><\/ul>\n\n\n\n

                            B\u00fcy\u00fck Harf K\u00fc\u00e7\u00fck Harf Form\u00fcl\u00fc<\/h3>\n\n\n\n
                            • Bazen tablolarda ya da metinlerde b\u00fcy\u00fck harfleri k\u00fc\u00e7\u00fck harflere ya da k\u00fc\u00e7\u00fck harfleri b\u00fcy\u00fck harflere \u00e7evirmek isteyebiliriz. Bunun i\u00e7in de bir form\u00fcl bulunuyor.<\/li>
                            • =b\u00fcy\u00fckharf(B1)<\/strong> yazd\u0131\u011f\u0131n\u0131zda B1 h\u00fccresindeki t\u00fcm yaz\u0131lar b\u00fcy\u00fck harf olur.<\/li>
                            • =k\u00fc\u00e7\u00fckharf(B1) <\/strong>yazd\u0131\u011f\u0131n\u0131zda ise B1 h\u00fccresindeki t\u00fcm yaz\u0131lar\u0131 k\u00fc\u00e7\u00fck harflere \u00e7evirmi\u015f olursunuz.<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"

                              \u0130\u015f hayat\u0131nda, e\u011fitim hayat\u0131nda en \u00e7ok kulland\u0131\u011f\u0131m\u0131z programlardan biri Excel oluyor. Microsoft\u2019un geli\u015ftirdi\u011fi ve piyasaya sundu\u011fu Excel, temel tablolama i\u015flemlerine sahip bir yaz\u0131l\u0131md\u0131r. Y\u0131llard\u0131r yaln\u0131zca…<\/p>\n","protected":false},"author":22,"featured_media":7247,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51,44],"tags":[],"class_list":["post-7082","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-is","category-nedir-nasil-yapilir"],"yoast_head":"\nYeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri - Niobe Hosting<\/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:\/\/www.niobehosting.com\/blog\/excel-formulleri\/\" \/>\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 Excel Form\u00fclleri - Niobe Hosting\" \/>\n<meta property=\"og:description\" content=\"\u0130\u015f hayat\u0131nda, e\u011fitim hayat\u0131nda en \u00e7ok kulland\u0131\u011f\u0131m\u0131z programlardan biri Excel oluyor. Microsoft\u2019un geli\u015ftirdi\u011fi ve piyasaya sundu\u011fu Excel, temel tablolama i\u015flemlerine sahip bir yaz\u0131l\u0131md\u0131r. Y\u0131llard\u0131r yaln\u0131zca...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/\" \/>\n<meta property=\"og:site_name\" content=\"Niobe Hosting\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-17T14:13:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-04T12:49:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.niobehosting.com\/blog\/wp-content\/uploads\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"358\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u015eevval G\u00fclsuyu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u015eevval G\u00fclsuyu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/\"},\"author\":{\"name\":\"\u015eevval G\u00fclsuyu\",\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/47f1583dadf0ec3db72574888f1a3d11\"},\"headline\":\"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri\",\"datePublished\":\"2022-05-17T14:13:21+00:00\",\"dateModified\":\"2022-07-04T12:49:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/\"},\"wordCount\":1616,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg\",\"articleSection\":[\"\u0130\u015f\",\"Nedir & Nas\u0131l Yap\u0131l\u0131r?\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/\",\"url\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/\",\"name\":\"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri - Niobe Hosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg\",\"datePublished\":\"2022-05-17T14:13:21+00:00\",\"dateModified\":\"2022-07-04T12:49:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg\",\"contentUrl\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg\",\"width\":750,\"height\":358},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/excel-formulleri\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/\",\"name\":\"Niobe Hosting\",\"description\":\"Niobe Hosting\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/#organization\",\"name\":\"Niobe Hosting\",\"url\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/blog-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/blog-logo.png\",\"width\":332,\"height\":49,\"caption\":\"Niobe Hosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/47f1583dadf0ec3db72574888f1a3d11\",\"name\":\"\u015eevval G\u00fclsuyu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d7d6674c33bdc93252ee448a9a2bbfddd3bcf21fd2159ee19d3ac451155c452a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d7d6674c33bdc93252ee448a9a2bbfddd3bcf21fd2159ee19d3ac451155c452a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d7d6674c33bdc93252ee448a9a2bbfddd3bcf21fd2159ee19d3ac451155c452a?s=96&d=mm&r=g\",\"caption\":\"\u015eevval G\u00fclsuyu\"},\"url\":\"https:\\\/\\\/www.niobehosting.com\\\/blog\\\/author\\\/sevvalgulsuyu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri - Niobe Hosting","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.niobehosting.com\/blog\/excel-formulleri\/","og_locale":"tr_TR","og_type":"article","og_title":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri - Niobe Hosting","og_description":"\u0130\u015f hayat\u0131nda, e\u011fitim hayat\u0131nda en \u00e7ok kulland\u0131\u011f\u0131m\u0131z programlardan biri Excel oluyor. Microsoft\u2019un geli\u015ftirdi\u011fi ve piyasaya sundu\u011fu Excel, temel tablolama i\u015flemlerine sahip bir yaz\u0131l\u0131md\u0131r. Y\u0131llard\u0131r yaln\u0131zca...","og_url":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/","og_site_name":"Niobe Hosting","article_published_time":"2022-05-17T14:13:21+00:00","article_modified_time":"2022-07-04T12:49:17+00:00","og_image":[{"width":750,"height":358,"url":"https:\/\/www.niobehosting.com\/blog\/wp-content\/uploads\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg","type":"image\/jpeg"}],"author":"\u015eevval G\u00fclsuyu","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"\u015eevval G\u00fclsuyu","Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/#article","isPartOf":{"@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/"},"author":{"name":"\u015eevval G\u00fclsuyu","@id":"https:\/\/www.niobehosting.com\/blog\/#\/schema\/person\/47f1583dadf0ec3db72574888f1a3d11"},"headline":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri","datePublished":"2022-05-17T14:13:21+00:00","dateModified":"2022-07-04T12:49:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/"},"wordCount":1616,"commentCount":0,"publisher":{"@id":"https:\/\/www.niobehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/#primaryimage"},"thumbnailUrl":"https:\/\/www.niobehosting.com\/blog\/wp-content\/uploads\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg","articleSection":["\u0130\u015f","Nedir & Nas\u0131l Yap\u0131l\u0131r?"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/","url":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/","name":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri - Niobe Hosting","isPartOf":{"@id":"https:\/\/www.niobehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/#primaryimage"},"image":{"@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/#primaryimage"},"thumbnailUrl":"https:\/\/www.niobehosting.com\/blog\/wp-content\/uploads\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg","datePublished":"2022-05-17T14:13:21+00:00","dateModified":"2022-07-04T12:49:17+00:00","breadcrumb":{"@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/#primaryimage","url":"https:\/\/www.niobehosting.com\/blog\/wp-content\/uploads\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg","contentUrl":"https:\/\/www.niobehosting.com\/blog\/wp-content\/uploads\/yeni-baslayanlar-icin-excel-formu\u0308lleri.jpg","width":750,"height":358},{"@type":"BreadcrumbList","@id":"https:\/\/www.niobehosting.com\/blog\/excel-formulleri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/www.niobehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Yeni Ba\u015flayanlar \u0130\u00e7in Bilinmesi Gereken Excel Form\u00fclleri"}]},{"@type":"WebSite","@id":"https:\/\/www.niobehosting.com\/blog\/#website","url":"https:\/\/www.niobehosting.com\/blog\/","name":"Niobe Hosting","description":"Niobe Hosting","publisher":{"@id":"https:\/\/www.niobehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.niobehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/www.niobehosting.com\/blog\/#organization","name":"Niobe Hosting","url":"https:\/\/www.niobehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.niobehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.niobehosting.com\/blog\/wp-content\/uploads\/blog-logo.png","contentUrl":"https:\/\/www.niobehosting.com\/blog\/wp-content\/uploads\/blog-logo.png","width":332,"height":49,"caption":"Niobe Hosting"},"image":{"@id":"https:\/\/www.niobehosting.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.niobehosting.com\/blog\/#\/schema\/person\/47f1583dadf0ec3db72574888f1a3d11","name":"\u015eevval G\u00fclsuyu","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/secure.gravatar.com\/avatar\/d7d6674c33bdc93252ee448a9a2bbfddd3bcf21fd2159ee19d3ac451155c452a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d7d6674c33bdc93252ee448a9a2bbfddd3bcf21fd2159ee19d3ac451155c452a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d7d6674c33bdc93252ee448a9a2bbfddd3bcf21fd2159ee19d3ac451155c452a?s=96&d=mm&r=g","caption":"\u015eevval G\u00fclsuyu"},"url":"https:\/\/www.niobehosting.com\/blog\/author\/sevvalgulsuyu\/"}]}},"_links":{"self":[{"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/posts\/7082","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=7082"}],"version-history":[{"count":0,"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/posts\/7082\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/media\/7247"}],"wp:attachment":[{"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=7082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=7082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.niobehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=7082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}