{"id":5220,"date":"2023-06-09T08:55:10","date_gmt":"2023-06-09T08:55:10","guid":{"rendered":"https:\/\/www.turkticaret.net\/blog\/?p=5220"},"modified":"2023-06-09T08:55:10","modified_gmt":"2023-06-09T08:55:10","slug":"verimliligi-arttiracak-excel-formulleri","status":"publish","type":"post","link":"https:\/\/www.turkticaret.net\/blog\/verimliligi-arttiracak-excel-formulleri\/","title":{"rendered":"Verimlili\u011fi Artt\u0131racak Excel Form\u00fclleri 2023"},"content":{"rendered":"<p><a href=\"https:\/\/www.microsoft.com\/tr-tr\/microsoft-365\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a> en s\u0131k kullan\u0131lan <a href=\"https:\/\/www.microsoft.com\/tr-tr\/microsoft-365?rtc=1\" target=\"_blank\" rel=\"noopener\">Microsoft<\/a> ara\u00e7lar\u0131ndan bir tanesidir. \u0130\u015f hayat\u0131nda da s\u0131k\u00e7a kullanabilece\u011finiz ve yeni ba\u015flayanlar i\u00e7in verimlili\u011fi artt\u0131racak excel form\u00fclleri i\u00e7in yaz\u0131m\u0131z\u0131 okumaya devam edin.<\/p>\n<p>Microsoft\u2019un Excel yaz\u0131l\u0131m\u0131 hem ki\u015fisel hem de profesyonel olarak kullanmak i\u00e7in 1987\u2019de piyasaya s\u00fcr\u00fclm\u00fc\u015ft\u00fcr. Fakat yayg\u0131n olarak kullan\u0131lmaya ba\u015flanmas\u0131 1993 y\u0131l\u0131n\u0131 buldu. 1993 y\u0131l\u0131ndan itibaren her t\u00fcrl\u00fc i\u015flevsellik ve \u00f6zellik ekleyerek elektronik tablolar i\u00e7in bir standart haline gelmi\u015ftir.<\/p>\n<h2>Bilmeniz Gereken Baz\u0131 Excel Form\u00fclleri<\/h2>\n<p>Giri\u015fte excelin olduk\u00e7a yayg\u0131n kullan\u0131ld\u0131\u011f\u0131ndan ve bize kolayl\u0131klar sa\u011flad\u0131\u011f\u0131ndan bahsetmi\u015ftik. Bu nedenle her t\u00fcrl\u00fc kullan\u0131c\u0131ya kolayl\u0131k sa\u011flayabilecek Excel form\u00fclleri vard\u0131r. Bu form\u00fcller Excel \u00e7al\u0131\u015fmalar\u0131nda i\u015finizi kolayla\u015ft\u0131rmaya olanak sa\u011flamaktad\u0131r. Bu form\u00fcllere birlikte bakal\u0131m.<\/p>\n<ol>\n<li>\n<h3>K\u0131sayollar<\/h3>\n<\/li>\n<\/ol>\n<p>Klavye k\u0131sayollar\u0131 ile ba\u015flayal\u0131m. K\u0131sayollar\u0131 kullanmak i\u00e7in fare kullanmay\u0131 b\u0131rak\u0131p klavye \u00fczerinden elektronik tablolarda \u00e7al\u0131\u015fmaya ba\u015flayabilirsiniz. Bunun i\u00e7in baz\u0131 k\u0131sayollar\u0131 da a\u015fa\u011f\u0131ya maddeleyelim.<\/p>\n<p>Yeni ba\u015flayan kullan\u0131c\u0131lar i\u00e7in baz\u0131 k\u0131sayollar;<\/p>\n<ul>\n<li>Ctrl tu\u015funu ve y\u00f6n tu\u015flar\u0131n\u0131 kullanarak veri aral\u0131klar\u0131n\u0131z aras\u0131nda h\u0131zl\u0131ca gezinebilirsiniz.<\/li>\n<li>Ctrl tu\u015fu ve Page up veya Page Down\u2019\u0131 kullanarak \u00e7al\u0131\u015fma sayfalar\u0131n\u0131z aras\u0131nda ge\u00e7i\u015f yapabilirsiniz.<\/li>\n<li>F4\u2019\u00fc kullanarak mutlak ve g\u00f6reli h\u00fccreler aras\u0131nda ge\u00e7i\u015f yapabilirsiniz.<\/li>\n<li>F2 tu\u015funu kullanarak i\u00e7eri\u011fini d\u00fczenlemek i\u00e7in h\u0131zl\u0131 bir \u015fekilde h\u00fccreye atlayabilirsiniz.<\/li>\n<\/ul>\n<ol start=\"2\">\n<li>\n<h3>TOPLA<\/h3>\n<\/li>\n<\/ol>\n<p>Kavramas\u0131 ve uygulamas\u0131 kolay bir form\u00fcl olarak bilinir. \u00d6zellikle sonu\u00e7 odakl\u0131 olup say\u0131lar\u0131 \u00e7e\u015fitli \u015fekillerde \u00f6ne \u00e7\u0131karman\u0131za izin vermektedir. Bununla birlikte alan birimleri, bilgi eklemek i\u00e7in ek bilgi sunan =Toplam\u2019a y\u00f6nelik bir\u00e7ok k\u0131sa yolu birle\u015ftirir. =Topla, t\u00fcm say\u0131 sat\u0131rlar\u0131n\u0131 ve yaln\u0131zca bir sat\u0131r\u0131n i\u00e7indeki h\u00fccreleri toplar. Ayr\u0131ca toplama, ortalama, en b\u00fcy\u00fck de\u011fer gibi basit fonksiyonlar\u0131 excelde form\u00fcller tab\u0131ndan se\u00e7erek i\u015fleminizi yapabilirsiniz.<\/p>\n<p>\u00d6rne\u011fin;<\/p>\n<p>Excelde form\u00fcller kategorisini se\u00e7ip otomatik toplam ba\u015fl\u0131\u011f\u0131 alt\u0131ndan ortalamay\u0131 se\u00e7ti\u011finizde ilgili h\u00fccre aral\u0131\u011f\u0131ndaki verilerin ortalamas\u0131n\u0131 verir. <strong>Say\u0131lar\u0131 say<\/strong> dedi\u011finizde h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131 adedini, <strong>en b\u00fcy\u00fck<\/strong> ve <strong>en k\u00fc\u00e7\u00fck<\/strong> se\u00e7enekleri de o aral\u0131ktaki b\u00fcy\u00fck ve k\u00fc\u00e7\u00fck olan de\u011ferleri verir.<\/p>\n<ol start=\"3\">\n<li>\n<h3>MAX \u2013 M\u0130N<\/h3>\n<\/li>\n<\/ol>\n<p>\u00c7ok say\u0131 i\u00e7eren bir bilgisayar program\u0131 kullan\u0131yorsan\u0131z bu form\u00fcl i\u015finizi kolayla\u015ft\u0131rabilir. =MAX ile veriler i\u00e7indeki en b\u00fcy\u00fck say\u0131y\u0131 g\u00f6rebilecek ve =M\u0130N ile birlikte de en k\u00fc\u00e7\u00fck say\u0131y\u0131 g\u00f6rebilirsiniz. Bu da \u00e7oklu verilerde i\u015finizi olduk\u00e7a kolayla\u015ft\u0131racak form\u00fcller aras\u0131ndad\u0131r.<\/p>\n<ol start=\"4\">\n<li>\n<h3>E\u011eER<\/h3>\n<\/li>\n<\/ol>\n<p>Bu form\u00fclle birlikte kesin bir ko\u015fulun kar\u015f\u0131lan\u0131p kar\u015f\u0131lanmad\u0131\u011f\u0131n\u0131 anlayabilirsiniz. Bir \u00f6rnekle ilerleyecek olursak B s\u00fctunundaki de\u011ferlerin ikiden b\u00fcy\u00fck olup olmad\u0131\u011f\u0131n\u0131 anlayabilirsiniz. =E\u011eER form\u00fcl\u00fcn\u00fc kullanarak ikiden b\u00fcy\u00fck her s\u00fct\u00fcn i\u00e7in evet se\u00e7ene\u011fini ikiden k\u00fc\u00e7\u00fck her s\u00fctun i\u00e7in de hay\u0131r se\u00e7ene\u011fini otomatik olarak doldurarak ilerleyebilirsiniz.<\/p>\n<p>=E\u011eER(B4&gt;2;\u201dEvet\u201d;\u201dHay\u0131r) \u015feklinde bir form\u00fcl yazarak B4 h\u00fccresindeki de\u011fer 2\u2019den b\u00fcy\u00fck ise \u201cEvet\u201d k\u00fc\u00e7\u00fck ise \u201cHay\u0131r\u201d \u015feklinde sonu\u00e7 verecek ve teker teker bakmak zorunda kalmayacaks\u0131n\u0131z.<\/p>\n<ol start=\"5\">\n<li>\n<h3>KIRP<\/h3>\n<\/li>\n<\/ol>\n<p>Bu form\u00fcl ile d\u00fczensiz ve \u00e7ok bo\u015fluklu metni tek bo\u015fluklu hale getirebilirsiniz. Her kelime aras\u0131na bir bo\u015fluk b\u0131rak\u0131r.<\/p>\n<p><img loading=\"lazy\" class=\"size-full wp-image-5234 aligncenter\" src=\"https:\/\/www.turkticaret.net\/blog\/wp-content\/uploads\/2023\/06\/Verimliligi-Arttiracak-Excel-Formulleri-2023-1.jpg\" alt=\"Verimlili\u011fi Artt\u0131racak Excel Form\u00fclleri 2023\" width=\"810\" height=\"440\" srcset=\"https:\/\/www.turkticaret.net\/blog\/wp-content\/uploads\/2023\/06\/Verimliligi-Arttiracak-Excel-Formulleri-2023-1.jpg 810w, https:\/\/www.turkticaret.net\/blog\/wp-content\/uploads\/2023\/06\/Verimliligi-Arttiracak-Excel-Formulleri-2023-1-300x163.jpg 300w, https:\/\/www.turkticaret.net\/blog\/wp-content\/uploads\/2023\/06\/Verimliligi-Arttiracak-Excel-Formulleri-2023-1-768x417.jpg 768w\" sizes=\"(max-width: 810px) 100vw, 810px\" \/><\/p>\n<ol start=\"6\">\n<li>\n<h3>B\u0130RLE\u015eT\u0130R<\/h3>\n<\/li>\n<\/ol>\n<p>Birden fazla h\u00fccreden de\u011fer alan ve benzer h\u00fccrelerle birle\u015ftirmeyi sa\u011flayan bir form\u00fcld\u00fcr. Bu form\u00fcl birden fazla h\u00fccredeki verileri tek bir h\u00fccrede kar\u015f\u0131la\u015ft\u0131rman\u0131z\u0131 sa\u011flar ve zamandan tasarruf etmenizi kolayla\u015ft\u0131r\u0131r. E\u011fer birle\u015ftirece\u011finiz h\u00fccrelerin aras\u0131na bo\u015fluk eklemek istiyorsan\u0131z ; i\u015faretinden sonra &#8221; &#8221; eklemeniz gerekir.<\/p>\n<ol start=\"7\">\n<li>\n<h3>BUG\u00dcN<\/h3>\n<\/li>\n<\/ol>\n<p>=BUG\u00dcN form\u00fcl\u00fc ile bug\u00fcn\u00fcn tarihini g\u00f6rebilirsiniz.<\/p>\n<ol start=\"8\">\n<li>\n<h3>YAZIM.D\u00dcZEN\u0130<\/h3>\n<\/li>\n<\/ol>\n<p>Excel\u2019i sadece bilgi analizi yapmak i\u00e7in de\u011fil verileri d\u00fczenlemek i\u00e7in de kullanabilirsiniz. =YAZIM.D\u00dcZEN\u0130 sayesinde bir h\u00fccrede bulunan kelimelerin ilk harflerini b\u00fcy\u00fck hale getirebiliriz. Kalan harfler k\u00fc\u00e7\u00fck olacakt\u0131r.<\/p>\n<ol start=\"9\">\n<li>\n<h3>\u00c7\u0130FTM\u0130<\/h3>\n<\/li>\n<\/ol>\n<p>\u00c7ok say\u0131da ondal\u0131k basamak i\u00e7eren verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z, =\u00c7\u0130FTM\u0130 form\u00fcl\u00fc sayesinde say\u0131lar \u00e7iftse DO\u011eRU tekse YANLI\u015e \u015feklinde uyar\u0131 verir. B\u00f6ylelikle say\u0131 k\u00fcmelerini de \u00e7ift tek \u015feklinde ay\u0131rabilirsiniz.<\/p>\n<ol start=\"10\">\n<li>\n<h3>KA\u00c7INCI<\/h3>\n<\/li>\n<\/ol>\n<p>=KA\u00c7INCI form\u00fcl\u00fc ile aranan ifadenin ka\u00e7\u0131nc\u0131 h\u00fccrede oldu\u011funu bulabilirsiniz. Yap\u0131s\u0131 =KA\u00c7INCI(aranan de\u011fer; aranan dizin; 0) \u015feklindedir. Aranan de\u011feri yaz\u0131p, arad\u0131\u011f\u0131n\u0131z dizin aral\u0131\u011f\u0131n\u0131 se\u00e7erek aranan de\u011ferin ka\u00e7\u0131nc\u0131 s\u0131rada oldu\u011funu bulabilirsiniz.<\/p>\n<ol start=\"11\">\n<li>\n<h3>SIRALAMA<\/h3>\n<\/li>\n<\/ol>\n<p>S\u0131ralama i\u015flevi, bir veriyi saatler, metin ve tarihler aras\u0131nda s\u0131ralaman\u0131za yard\u0131mc\u0131 olmaktad\u0131r. S\u0131ralamak i\u00e7in s\u00fctunda bir h\u00fccre se\u00e7in veri sekmesinde s\u0131rala ve filtreye t\u0131klayarak A\u2019dan Z\u2019ye veya Z\u2019den A\u2019ya olarak s\u0131ralama i\u015flemi yapabilirsiniz form\u00fcl olarak SIRALAMA (A2:C11,3) \u015feklinde kullanabilirsiniz.<\/p>\n<p>Form\u00fcller zamandan tasarruf etmenize ve e-tablolar\u0131n\u0131z\u0131n do\u011frulu\u011fundan emin olmak i\u00e7in size yard\u0131mc\u0131 olmaktad\u0131r. Farkl\u0131 ihtiya\u00e7lar\u0131n\u0131z\u0131 kar\u015f\u0131lamak i\u00e7in birden fazla form\u00fcl vard\u0131r fakat temel olarak bu form\u00fcller i\u015finizi kolayla\u015ft\u0131racakt\u0131r. Ancak ara\u00e7 tak\u0131m\u0131n\u0131za bu i\u015flevleri ekledikten sonra tablolama i\u015flemlerinize g\u00fcvenle ba\u015flayabilirsiniz.<\/p>\n<p>&nbsp;<\/p>\n<p>Excel g\u00fcnl\u00fck i\u015flerimizde bize kolayl\u0131k sa\u011flayacak, b\u00fcy\u00fck veri k\u00fcmelerini k\u0131sa birka\u00e7 form\u00fcl ile s\u0131n\u0131flayabilece\u011fimiz bir ara\u00e7t\u0131r.\u00a0 Yukar\u0131da yeni ba\u015flayanlar i\u00e7in kullan\u0131labilecek birka\u00e7 form\u00fcl hakk\u0131nda bilgiler verdik. Excel form\u00fclleri konusunda daha detayl\u0131 bir anlat\u0131m ve en s\u0131k kullan\u0131lan form\u00fcller i\u00e7in <a href=\"https:\/\/www.turkticaret.net\/blog\/yeni-baslayanlar-icin-excel-formulleri\/\">Yeni Ba\u015flayanlar \u0130\u00e7in Excel Form\u00fclleri<\/a> blog yaz\u0131m\u0131z\u0131 okuyabilir ve i\u00e7erisindeki g\u00f6rsel anlat\u0131mlar sayesinde kolayl\u0131kla uygulayabilirsiniz.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel en s\u0131k kullan\u0131lan Microsoft ara\u00e7lar\u0131ndan bir tanesidir. \u0130\u015f hayat\u0131nda da s\u0131k\u00e7a kullanabilece\u011finiz ve yeni ba\u015flayanlar i\u00e7in verimlili\u011fi artt\u0131racak excel form\u00fclleri i\u00e7in yaz\u0131m\u0131z\u0131 okumaya devam edin. Microsoft\u2019un Excel yaz\u0131l\u0131m\u0131 hem ki\u015fisel hem de profesyonel olarak kullanmak i\u00e7in 1987\u2019de piyasaya s\u00fcr\u00fclm\u00fc\u015ft\u00fcr. Fakat yayg\u0131n olarak kullan\u0131lmaya ba\u015flanmas\u0131 1993 y\u0131l\u0131n\u0131 buldu. 1993 y\u0131l\u0131ndan itibaren her t\u00fcrl\u00fc i\u015flevsellik ve [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":5233,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[51],"tags":[],"_links":{"self":[{"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/posts\/5220"}],"collection":[{"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/comments?post=5220"}],"version-history":[{"count":3,"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/posts\/5220\/revisions"}],"predecessor-version":[{"id":5235,"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/posts\/5220\/revisions\/5235"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/media\/5233"}],"wp:attachment":[{"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/media?parent=5220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/categories?post=5220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.turkticaret.net\/blog\/wp-json\/wp\/v2\/tags?post=5220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}