{"id":45307,"date":"2022-06-19T22:00:04","date_gmt":"2022-06-19T19:00:04","guid":{"rendered":"https:\/\/kutaybilen.com.tr\/?p=45307"},"modified":"2022-06-19T22:00:04","modified_gmt":"2022-06-19T19:00:04","slug":"is-ve-okulda-ziyadesiyle-isinize-yarayacak-9-excel-formulu","status":"publish","type":"post","link":"https:\/\/kutaybilen.com.tr\/?p=45307","title":{"rendered":"\u0130\u015f ve Okulda Ziyadesiyle \u0130\u015finize Yarayacak 9 Excel Form\u00fcl\u00fc"},"content":{"rendered":"<p><strong>450\u2019den fazla<\/strong> fonksiyonu bulunan <strong>Microsoft Excel<\/strong>; d\u00fcnyada ve \u00fclkemizde en yayg\u0131n olarak kullan\u0131lan elektronik tablo uygulamas\u0131 olmay\u0131 ba\u015farm\u0131\u015ft\u0131r. Lakin kullan\u0131m\u0131 hala daha bir\u00e7ok insan taraf\u0131ndan anla\u015f\u0131lmaz yahut ba\u015f kar\u0131\u015ft\u0131r\u0131c\u0131 olarak g\u00f6r\u00fclmekte. Hatta bu say\u0131 o kadar fazla ki Excel\u2019in kullan\u0131m\u0131n\u0131 \u00f6\u011frenmek isteyenler i\u00e7in bir s\u00fcr\u00fc kurslar var. <\/p>\n<p>Hesaplama, pivot tablolar ve grafik olu\u015fturma ara\u00e7lar\u0131 sayesinde hem g\u00fcnl\u00fck hem de i\u015f hayat\u0131nda k\u0131ymetli bir yere sahip olan Excel\u2019in kullan\u0131m\u0131n\u0131 <strong>epeyce kolayla\u015ft\u0131ran <\/strong>9 form\u00fcl\u00fc bulduk ve sizler i\u00e7in s\u0131ralad\u0131k. <\/p>\n<p><b>Microsoft Excel Form\u00fclleri: <\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/075f52b31fd222a9c99063762db5be57beca74f6.jpeg\"\/><\/p>\n<ul>\n<li>Metinleri S\u00fctunlara D\u00f6n\u00fc\u015ft\u00fcrme<\/li>\n<li>S\u00fctunlar\u0131 Birle\u015ftirme<\/li>\n<li>H\u00fccre \u0130\u00e7indeki Harfleri K\u00fc\u00e7\u00fck ve B\u00fcy\u00fck Harf Olarak Yazma<\/li>\n<li>Say\u0131sal Bedelleri Sayma<\/li>\n<li>Mant\u0131ksal Toplama ve Sonu\u00e7 Yazd\u0131rma<\/li>\n<li>Ko\u015fula Nazaran Sayma<\/li>\n<li>Ko\u015fullu Bi\u00e7imlendirme<\/li>\n<li>Ortalama Alma<\/li>\n<li>Excel Kullan\u0131rken \u0130\u015finize Yarayacak K\u0131sayollar<\/li>\n<\/ul>\n<p><b>Metinleri s\u00fctunlara d\u00f6n\u00fc\u015ft\u00fcrme<\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/643601412f74ba333ec69a3c80773fc1b110dbc3.png\"\/><\/p>\n<ul>\n<li><strong>Ad\u0131m #1:<\/strong> Bilgilerin yahut k\u0131ymetlerin bulundu\u011fu s\u00fctunu se\u00e7iniz.<\/li>\n<li><strong>Ad\u0131m #2:<\/strong> Daha sonras\u0131nda ise Data sekmesinden Bilgi Ara\u00e7lar\u0131 k\u00fcmesine t\u0131klay\u0131n\u0131z.<\/li>\n<li><strong>Ad\u0131m #3:<\/strong> En son olarak Metni S\u00fctunlara D\u00f6n\u00fc\u015ft\u00fcr se\u00e7ene\u011fine t\u0131kland\u0131\u011f\u0131nda s\u00fcre\u00e7 tamamlanacakt\u0131r. <\/li>\n<\/ul>\n<p>Excel program\u0131nda <strong>metinler sola yasl\u0131<\/strong>,<strong> say\u0131sal de\u011ferler<\/strong> ise <strong>sa\u011fa yasl\u0131<\/strong> yaz\u0131l\u0131rlar. Datalar her vakit ba\u015fka farkl\u0131 kar\u015f\u0131n\u0131za \u00e7\u0131kmayabilir ve bu da hepsinin metin olarak alg\u0131lanmas\u0131na neden olabilir. Hem bunu \u00f6nlemek hem de datalar\u0131 d\u00fczg\u00fcn bir bi\u00e7imde g\u00f6rmek i\u00e7in metinleri s\u00fctunlara <strong>pratik ve hayli kolay<\/strong> bir halde d\u00f6n\u00fc\u015ft\u00fcrebilirsiniz. <\/p>\n<p><b>S\u00fctunlar\u0131 birle\u015ftirme <\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/72fda4a22626efd34660113ecc0d1818eb79fc8a.png\"\/><\/p>\n<ul>\n<li><strong>Ad\u0131m #1:<\/strong> Birinci evvel birle\u015ftirmek istedi\u011finiz bilgilerin yan\u0131na bir s\u00fctun ekleyin.<\/li>\n<li><strong>Ad\u0131m #2:<\/strong> Daha sonras\u0131nda = yaz\u0131n ve birle\u015ftirmek istedi\u011finiz birinci h\u00fccreyi se\u00e7in. <\/li>\n<li><strong>Ad\u0131m #3:<\/strong> Son olarak birle\u015ftirmek istedi\u011finiz \u00f6b\u00fcr h\u00fccreyi de se\u00e7in ve enter tu\u015funa bas\u0131n. Bunun i\u00e7in =A2&#038;&#8221; &#8220;&#038;B2 form\u00fcl\u00fc \u00f6rnek olarak verilebilir. <\/li>\n<\/ul>\n<p>Excel\u2019in kolay fonksiyonlar\u0131ndan birisi ise istedi\u011finiz h\u00fccreleri s\u00fctunlarda birle\u015ftirebilmenizdir. Bu birle\u015ftirme form\u00fcl\u00fcn\u00fc kullanarak<strong> iki yahut daha fazla<\/strong> s\u00fctunu bir ortaya bilgi kayb\u0131 olmadan getirebilirsiniz. <\/p>\n<p><b>H\u00fccre i\u00e7indeki harfleri k\u00fc\u00e7\u00fck yahut b\u00fcy\u00fck olarak yazma<\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/c4b32caa4f133e53e928c93c090c6830e36a81fd.png\"\/><\/p>\n<ul>\n<li><strong>Ad\u0131m #1:<\/strong> =K\u00dc\u00c7\u00dcKHARF() form\u00fcl\u00fc ile k\u00fc\u00e7\u00fck harfle yazmak istedi\u011finiz h\u00fccreyi se\u00e7ip parantez i\u00e7inde belirtti\u011finizde hepsi k\u00fc\u00e7\u00fck harflerle yaz\u0131lm\u0131\u015f olacakt\u0131r.  <\/li>\n<li><strong>Ad\u0131m #2:<\/strong> \u015eayet h\u00fccre i\u00e7indeki harfleri b\u00fcy\u00fck yazmak istiyorsan\u0131z da =B\u00dcY\u00dcKHARF() form\u00fcl\u00fcn\u00fc kullanman\u0131z k\u00e2fi olacakt\u0131r. <\/li>\n<\/ul>\n<p>Bazen Excel program\u0131nda bilgilerimizi ya<strong> k\u00fc\u00e7\u00fck <\/strong>ya da<strong> b\u00fcy\u00fck harfle<\/strong> yazmam\u0131z gerekebilir. Excel\u2019in \u00f6zelli\u011fi sayesinde her bir h\u00fccre i\u00e7in <strong>tek tek u\u011fra\u015fmadan<\/strong> 1-2 ad\u0131mda bu s\u00fcreci kolay bir bi\u00e7imde halledebilirsiniz.<\/p>\n<p><b>Say\u0131sal bedelleri sayma <\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/89a78710e083dc33a5b3bc9f578bf8b371969c51.png\"\/><\/p>\n<ul>\n<li><strong>Ad\u0131m #1:<\/strong> Giri\u015f simgesine bast\u0131ktan sonra \u00fcstteki foto\u011frafta form\u00fclleri yaz\u0131ca\u011f\u0131n\u0131z yer k\u0131rm\u0131z\u0131 ile g\u00f6sterildi.<\/li>\n<li><strong>Ad\u0131m #2:<\/strong> O k\u0131sma =BA\u011e_DE\u011e_SAY() form\u00fcl\u00fcn\u00fc yazd\u0131\u011f\u0131zda ve hangi h\u00fccrelerdeki say\u0131sal bedelleri \u00f6\u011frenmek istiyorsan\u0131z onlar\u0131 da parantez i\u00e7inde belirtti\u011finizde s\u00fcreciniz tamamlanacakt\u0131r. <\/li>\n<\/ul>\n<p>Mant\u0131ksal, yan\u0131lg\u0131 k\u0131ymetlerini ve metinleri saymak i\u00e7in <strong>=BA\u011e_DE\u011e_SAY() <\/strong>form\u00fcl\u00fcn\u00fc kullanabilirsiniz. T\u0131pk\u0131 vakitte say\u0131 i\u00e7eren <strong>h\u00fccre say\u0131s\u0131n\u0131 <\/strong>ve birtak\u0131m de\u011fi\u015fkenler listesindeki say\u0131lar\u0131 sayman\u0131zda yard\u0131mc\u0131 olur. <\/p>\n<p><b>Mant\u0131ksal toplama ve sonu\u00e7 yazd\u0131rma<\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/2298795caa37f4b804e4e816d3358499ea38d49a.png\"\/><\/p>\n<ul>\n<li><strong>Ad\u0131m #1:<\/strong> Toplanacak b\u00fct\u00fcn h\u00fccreleri se\u00e7in ve =TOPLA() i\u015flevini yaz\u0131n. <\/li>\n<li><strong>Ad\u0131m #2:<\/strong> Mant\u0131ksal sonu\u00e7 yazd\u0131rmak i\u00e7in =E\u011eER i\u015flevi kullan\u0131l\u0131r. <\/li>\n<\/ul>\n<p><strong>Microsoft Excel <\/strong>program\u0131nda h\u00fccrelerin otomatik toplama yapmas\u0131 \u00fcstteki yazd\u0131\u011f\u0131m\u0131z form\u00fcl ile m\u00fcmk\u00fcn. <strong>T\u00fcm matematik s\u00fcre\u00e7lerini <\/strong>kolayl\u0131kla yapabilen bir sistemi oldu\u011fun i\u00e7in de ziyadesiyle tercih edilen bir program. Bu sayede hem i\u015finizi<strong> k\u0131sa s\u00fcrede<\/strong> halletmi\u015f oluyorsunuz hem de vakitten tasarruf ediyorsunuz. <\/p>\n<p><strong>E\u011fer fonksiyonu <\/strong>olarak bilinen mant\u0131ksal sonu\u00e7 yazd\u0131rma, Excel\u2019in en yayg\u0131n \u00f6zelliklerinden birisidir. \u015eayet i\u015flevi; iki k\u0131ymet ortas\u0131nda <strong>mant\u0131ksal kar\u015f\u0131la\u015ft\u0131rmalar <\/strong>yapman\u0131za imkan sa\u011flar. <\/p>\n<p><b>Ko\u015fula nazaran sayma  <\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/03addc4e2d21de3b01c0a585bf2a5ae3316f510a.jpeg\"\/><\/p>\n<ul>\n<li><strong>Ad\u0131m #1:<\/strong> Giri\u015f sekmesine t\u0131klay\u0131n\u0131z.<\/li>\n<li><strong>Ad\u0131m #2:<\/strong> \u0130\u015flevlerin yaz\u0131ld\u0131\u011f\u0131 bo\u015flu\u011fa =E\u011eERSAY form\u00fcl\u00fcn\u00fc yaz\u0131p Enter tu\u015funa bas\u0131n\u0131z.<\/li>\n<\/ul>\n<p>Bu form\u00fcl\u00fc yazd\u0131\u011f\u0131n\u0131zda; size, <strong>\u015farta uygun<\/strong> olan t\u00fcm h\u00fccrelerin say\u0131s\u0131n\u0131 verecektir. \u00d6rnek verecek olursak; \u015fayet bir s\u0131n\u0131fta kimin ge\u00e7ip kimin kald\u0131\u011f\u0131n\u0131 \u00f6\u011frenmek istiyorsan\u0131z parantez i\u00e7ine hem <strong>h\u00fccre aral\u0131\u011f\u0131n\u0131<\/strong> yaz\u0131p hem de <strong>ge\u00e7ti<\/strong> s\u00f6z\u00fcn\u00fc yazd\u0131\u011f\u0131n\u0131zda <strong>ge\u00e7en \u00f6\u011frencilerin say\u0131s\u0131n\u0131<\/strong> \u00f6\u011frenmenizde yard\u0131mc\u0131 olacakt\u0131r. Bu \u00e7e\u015fit hesaplamalar Excel sayesinde birka\u00e7 dakikan\u0131z\u0131 alacakt\u0131r. <\/p>\n<p><b>Ko\u015fullu bi\u00e7imlendirme<\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/307b16e42f179cf073cdcefe92d5787df3c065d2.png\"\/><\/p>\n<ul>\n<li><strong>Ad\u0131m #1:<\/strong> Giri\u015f sekmesine t\u0131klay\u0131n\u0131z. <\/li>\n<li><strong>Ad\u0131m #2:<\/strong> Tarzlar k\u00fcmesinin i\u00e7erisinden \u015fartl\u0131 bi\u00e7imlendirme fonksiyonuna t\u0131klay\u0131n\u0131z. <\/li>\n<\/ul>\n<p>Excel\u2019in en \u00e7ok kullan\u0131lan \u00f6zelliklerinden biri olan <strong>ko\u015fullu bi\u00e7imlendirme<\/strong> sayesinde elektronik tablolar\u0131n\u0131z\u0131 tekrardan d\u00fczenleyip, renklendirme ile <strong>u\u011fra\u015fmak zorunda <\/strong>de\u011filsiniz zira bu misyonu \u015fartl\u0131 bi\u00e7imlendirmenin kendisi yap\u0131yor. <\/p>\n<p><strong>Renk \u00f6l\u00e7ekleri ve data \u00e7ubuklar\u0131 kurallar\u0131na<\/strong> nazaran haz\u0131rlanm\u0131\u015f olan bu bilhassa h\u00fccrelerin art planlar\u0131n\u0131 renklendirerek vurgular\u0131n\u0131z\u0131 belirginle\u015ftirebilirsiniz. <\/p>\n<p><b>Ortalama alma <\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/32ab0589819bff73078c6afbf3e91f6ad5dd16c7.jpeg\"\/><\/p>\n<ul>\n<li><strong>Ad\u0131m #1:<\/strong> Giri\u015f men\u00fcs\u00fcne t\u0131klay\u0131n\u0131z. <\/li>\n<li><strong>Ad\u0131m #2: <\/strong>Fonksiyonlar\u0131 yazd\u0131\u011f\u0131m\u0131z bo\u015flu\u011fa =ORTALAMA() form\u00fcl\u00fcn\u00fc yaz\u0131p enter tu\u015funa bas\u0131n\u0131z. <\/li>\n<\/ul>\n<p>Excelde yapt\u0131\u011f\u0131n\u0131z hesaplamalardan biri de <strong>ortalama almak <\/strong>olabilir. Bunun i\u00e7in de hayli kolay bir yol olan; ortalama alma<strong> form\u00fcl\u00fcn\u00fc <\/strong>kullan\u0131rsan\u0131z Excel sizin yerinize istedi\u011finiz ortalamay\u0131 birka\u00e7 saniye i\u00e7erisinde sunacakt\u0131r.  <\/p>\n<p>Ayr\u0131ca ortalama fonksiyonu ile birlikte merkezi e\u011filimin <strong>\u00fc\u00e7 farkl\u0131 \u00f6l\u00e7\u00fcs\u00fcn\u00fc <\/strong>\u00f6l\u00e7er. Bunlar ise; <strong>ortalama, orta bedel ve mod\u2019dur.<\/strong> <\/p>\n<p><b>Excel kullan\u0131rken i\u015finize yarayacak k\u0131sayollar <\/b><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.webtekno.com\/images\/editor\/default\/0003\/24\/01bd42993f55f8100496a8b9ba668c796790178f.jpeg\"\/><\/p>\n<ul>\n<li><strong>F4<\/strong> tu\u015fu ile son d\u00fczenlemeyi tekrarlayabilirsiniz. \u015eayet bir \u015feyi tekrarlamak isterseniz bu k\u0131sayol size vakit kazand\u0131racakt\u0131r. <\/li>\n<li><strong>ALT + Enter <\/strong>k\u0131sayolu sayesinde birebir h\u00fccrede yeni bir sat\u0131r ba\u015flatabilirsiniz. Bir h\u00fccreye \u00e7ok fazla data koyman\u0131z gerekiyorsa bu k\u0131sayol sayesinde i\u015finiz daha kolay olacakt\u0131r. <\/li>\n<li><strong>CTRL + `<\/strong> tu\u015flar\u0131 form\u00fclleri g\u00f6r\u00fcnt\u00fclemenize yard\u0131mc\u0131 olur. Bir h\u00fccrenin form\u00fcl\u00fcne ve k\u0131ymetlerine bakmak i\u00e7in bu k\u0131sayolu kullanabilirsiniz. <\/li>\n<li><strong>CTRL + I <\/strong>k\u0131sayolu ile metninizi s\u00fcratli ve pratik bir bi\u00e7imde hem italik olarak hem de italik olmaktan \u00e7\u0131kartmak i\u00e7in kullanabilirsiniz. <\/li>\n<li><strong>CTRL + Shift + ;<\/strong> tu\u015flar\u0131 sayesinde tablonuza girdi\u011finiz datalar\u0131n saatini i\u015fleyebilirsiniz. \u015eayet bilgileri ne vakit i\u015fledi\u011finizi hat\u0131rlamakta zorlan\u0131yorsan\u0131z bu k\u0131sayol tam sizin i\u00e7in!<\/li>\n<\/ul>\n<p><strong>Excel program\u0131n\u0131n<\/strong> hayat\u0131m\u0131zdaki yeri belirli. Birden fazla i\u015f al\u0131mlar\u0131nda da dikkat edilen bir \u00f6ge oldu\u011fu i\u00e7in nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131 \u00f6\u011frenmemiz epeyce de\u011ferli. <\/p>\n<p>Biz de bu y\u00fczden sizler i\u00e7in Excel\u2019in kullan\u0131m\u0131n\u0131 <strong>fazlas\u0131yla kolayla\u015ft\u0131ran 9 form\u00fcl\u00fc<\/strong> bir ortaya getirdik ve listeledik. Umar\u0131z ki keyifli ve yararl\u0131 bir okuma olmu\u015ftur. \u015eayet bu ve bunun \u00fczere i\u00e7erikleri seviyorsan\u0131z yapman\u0131z gereken tek \u015fey Webtekno\u2019yu takip etmek.<\/p>\n<div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>450\u2019den fazla fonksiyonu bulunan Microsoft Excel; d\u00fcnyada ve \u00fclkemizde en yayg\u0131n olarak kullan\u0131lan elektronik tablo uygulamas\u0131 olmay\u0131 ba\u015farm\u0131\u015ft\u0131r &#8230;<\/p>\n","protected":false},"author":1,"featured_media":45308,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[854],"tags":[4148,6329,6328,908,1032],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/45307"}],"collection":[{"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=45307"}],"version-history":[{"count":1,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/45307\/revisions"}],"predecessor-version":[{"id":45309,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/45307\/revisions\/45309"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=\/wp\/v2\/media\/45308"}],"wp:attachment":[{"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=45307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=45307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kutaybilen.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=45307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}