{"id":6673,"date":"2024-01-31T15:56:41","date_gmt":"2024-01-31T12:56:41","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=6673"},"modified":"2024-01-31T16:12:09","modified_gmt":"2024-01-31T13:12:09","slug":"excel-kullanim-rehberi-excel-puf-noktalar","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/","title":{"rendered":"Ayr\u0131nt\u0131l\u0131 Excel Kullan\u0131m Rehberi"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Makale \u0130\u00e7eri\u011fi<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u0130\u00e7indekiler Tablosunu A\u00e7\/Kapat\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#Excel_Nedir\" >Excel Nedir?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_2021_ozellikleri\" >excel 2021 \u00f6zellikleri<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_de_formul_nasil_yazilir\" >excel de form\u00fcl nas\u0131l yaz\u0131l\u0131r<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_de_formuller_hangi_isaretle_baslar\" >excel de form\u00fcller hangi i\u015faretle ba\u015flar<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_eger_formulu\" >excel e\u011fer form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_and_kullanimi\" >excel and kullan\u0131m\u0131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_ara_formulu\" >excel ara form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_ara_toplam_formulu\" >excel ara toplam form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_aradaki_farki_bulma\" >excel aradaki fark\u0131 bulma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_aranan_degeri_bulma\" >excel aranan de\u011feri bulma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_arasinda_formulu\" >excel aras\u0131nda form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_arayuzunde_calisma_alanini_tanima\" >excel aray\u00fcz\u00fcnde \u00e7al\u0131\u015fma alan\u0131n\u0131 tan\u0131ma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_asagi_yuvarla\" >excel a\u015fa\u011f\u0131 yuvarla<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_ay_formulu\" >excel ay form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_ayni_olanlari_sil\" >excel ayn\u0131 olanlar\u0131 sil<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_basarili_basarisiz\" >excel ba\u015far\u0131l\u0131 ba\u015far\u0131s\u0131z<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_baska_hucreden_veri_alma\" >excel ba\u015fka h\u00fccreden veri alma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_bol_formulu\" >excel b\u00f6l form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_bugun_tarih_formulu\" >excel bug\u00fcn tarih form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_bul_degistir_formulu\" >excel bul de\u011fi\u015ftir form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_buyuk_formulu\" >excel b\u00fcy\u00fck form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_en_kucuk_degeri_bulma\" >excel en k\u00fc\u00e7\u00fck de\u011feri bulma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_en_yakin_sayiyi_bulma\" >excel en yak\u0131n say\u0131y\u0131 bulma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_esit_degil_formulu\" >excel e\u015fit de\u011fil form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_etopla_formulu\" >excel etopla form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_count_formulu\" >excel count form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_calisma_tablosu_kac_sutundan_olusur\" >excel \u00e7al\u0131\u015fma tablosu ka\u00e7 s\u00fctundan olu\u015fur<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_carpma_formulu\" >excel \u00e7arpma form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_cikarma_islemi_formulu\" >excel \u00e7\u0131karma i\u015flemi form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_birlestir_formulu\" >excel birle\u015ftir form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_cift_tirnak_isareti\" >excel \u00e7ift t\u0131rnak i\u015fareti<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_de_buton_olusturma\" >excel de buton olu\u015fturma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_de_buyuk_kucuk_isareti_nasil_yapilir\" >excel de b\u00fcy\u00fck k\u00fc\u00e7\u00fck i\u015fareti nas\u0131l yap\u0131l\u0131r<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_de_en_buyuk_sayiyi_bulma_formulu\" >excel de en b\u00fcy\u00fck say\u0131y\u0131 bulma form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_de_indis_formulu\" >excel de indis form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_de_kalan_gun_hesaplama\" >excel de kalan g\u00fcn hesaplama<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_de_ortalama_formulu\" >excel de ortalama form\u00fcl\u00fc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_devresel_odeme_formulu\" >excel devresel \u00f6deme form\u00fcl\u00fc<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_bilinmesi_gerekenler\" >excel bilinmesi gerekenler<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_de_hucre_nedir\" >excel de h\u00fccre nedir<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_dosya_uzantisi_nedir\" >excel dosya uzant\u0131s\u0131 nedir<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_dugme_islevleri\" >excel d\u00fc\u011fme i\u015flevleri<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_formul_hatasi_bulma\" >excel form\u00fcl hatas\u0131 bulma<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"https:\/\/sunucucozumleri.com\/blog\/excel-kullanim-rehberi-excel-puf-noktalar\/#excel_formuller_listesi\" >excel form\u00fcller listesi<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Excel_Nedir\"><\/span>Excel Nedir?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Excel<\/strong>, Microsoft taraf\u0131ndan geli\u015ftirilen ve yayg\u0131n olarak kullan\u0131lan bir elektronik tablo program\u0131d\u0131r. Excel, verileri d\u00fczenlemek, hesaplamalar yapmak, grafikler olu\u015fturmak ve veri analizi yapmak i\u00e7in kullan\u0131l\u0131r. Bu program, ofis ve i\u015f ortamlar\u0131nda veri y\u00f6netimi ve analizi i\u00e7in temel bir ara\u00e7 olarak kabul edilir. Excel&#8217;in temel \u00f6zellikleri \u015funlard\u0131r:<\/p>\n<ol>\n<li><strong>H\u00fccre Tabanl\u0131 D\u00fczen<\/strong>: Excel, verilerin h\u00fccreler ad\u0131 verilen bireysel kutularda sakland\u0131\u011f\u0131 bir \u0131zgara format\u0131 kullan\u0131r. Her h\u00fccre, harflerle etiketlenen s\u00fctunlar ve say\u0131larla etiketlenen sat\u0131rlar taraf\u0131ndan tan\u0131mlan\u0131r (\u00f6rne\u011fin, A1, B2).<\/li>\n<li><strong>Form\u00fcller ve Fonksiyonlar<\/strong>: Excel, matematiksel hesaplamalar ve veri analizi i\u00e7in \u00e7e\u015fitli form\u00fcller ve fonksiyonlar sunar. Bu form\u00fcller, basit toplama i\u015flemlerinden karma\u015f\u0131k istatistiksel analizlere kadar \u00e7e\u015fitlilik g\u00f6sterir.<\/li>\n<li><strong>Veri Analizi ve G\u00f6rselle\u015ftirme<\/strong>: Excel, verileri analiz etmek ve \u00e7e\u015fitli grafik ve tablolar arac\u0131l\u0131\u011f\u0131yla g\u00f6rselle\u015ftirmek i\u00e7in geni\u015f imkanlar sunar. Bu, trendleri ve desenleri kolayca g\u00f6rmeyi ve sunmay\u0131 sa\u011flar.<\/li>\n<li><strong>Pivot Tablolar<\/strong>: Kullan\u0131c\u0131lar\u0131n veri setlerini \u00f6zetlemek ve farkl\u0131 a\u00e7\u0131lardan analiz etmek i\u00e7in kullanabilece\u011fi g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Pivot tablolar, b\u00fcy\u00fck veri setlerini h\u0131zl\u0131 ve kolay bir \u015fekilde s\u0131ralamak, gruplamak ve kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in kullan\u0131l\u0131r.<\/li>\n<li><strong>Makro ve Otomasyon<\/strong>: Excel, VBA (Visual Basic for Applications) ad\u0131 verilen bir programlama dili kullanarak makro yazma ve otomasyon i\u015flemlerini destekler. Bu, tekrar eden g\u00f6revleri otomatikle\u015ftirmek ve karma\u015f\u0131k hesaplamalar\u0131 kolayla\u015ft\u0131rmak i\u00e7in kullan\u0131l\u0131r.<\/li>\n<li><strong>Veri \u0130thalat\u0131 ve Entegrasyonu<\/strong>: Excel, \u00e7e\u015fitli veri kaynaklar\u0131ndan veri alabilme ve bu verileri entegre edebilme yetene\u011fine sahiptir. Bu, kullan\u0131c\u0131lar\u0131n farkl\u0131 formatlardaki verileri tek bir yerde toplay\u0131p i\u015flemesini sa\u011flar.<\/li>\n<\/ol>\n<p>\u0130\u015f d\u00fcnyas\u0131ndan e\u011fitime kadar bir\u00e7ok alanda kullan\u0131lan Excel, kullan\u0131c\u0131lar\u0131n veri ile etkile\u015fimini kolayla\u015ft\u0131ran g\u00fc\u00e7l\u00fc ve esnek bir ara\u00e7t\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_2021_ozellikleri\"><\/span>excel 2021 \u00f6zellikleri<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Excel 2021<\/strong>, bir\u00e7ok yeni \u00f6zellik ve iyile\u015ftirme ile geldi ve bu \u00f6zellikler veri analizi ve i\u015f birli\u011fi yeteneklerini art\u0131rd\u0131. \u0130\u015fte Excel 2021&#8217;in ana \u00f6zellikleri:<\/p>\n<ol>\n<li><strong>E\u015f Zamanl\u0131 D\u00fczenleme<\/strong>: Birden fazla kullan\u0131c\u0131n\u0131n ayn\u0131 Excel \u00e7al\u0131\u015fma kitab\u0131 \u00fczerinde ayn\u0131 anda \u00e7al\u0131\u015fmas\u0131na olanak tan\u0131r, b\u00f6ylece i\u015f birli\u011fini daha verimli hale getirir.<\/li>\n<li><strong>Modern Yorumlar ile Daha \u0130yi \u0130\u015f Birli\u011fi<\/strong>: Office uygulamalar\u0131nda daha tutarl\u0131 bir yorum yapma deneyimi sunar, b\u00f6ylece \u00e7al\u0131\u015fma kitaplar\u0131 i\u00e7inde daha etkili ileti\u015fim sa\u011flan\u0131r.<\/li>\n<li><strong>G\u00f6rsel Yenileme<\/strong>: Excel 2021, \u015ferit \u00fczerinde yenilenmi\u015f sekmelerle modernle\u015ftirilmi\u015f bir kullan\u0131c\u0131 aray\u00fcz\u00fcne sahiptir, daha temiz ve daha sezgisel bir deneyim sunar.<\/li>\n<li><strong>XLOOKUP Fonksiyonu<\/strong>: Tablolarda veya aral\u0131klarda veri arama yetene\u011fini \u00f6nemli \u00f6l\u00e7\u00fcde iyile\u015ftirir, \u00f6nceki VLOOKUP\/HLOOKUP fonksiyonlar\u0131na g\u00f6re daha etkili ve verimlidir.<\/li>\n<li><strong>LET Fonksiyonu<\/strong>: Hesaplama sonu\u00e7lar\u0131na isim verme imkan\u0131 tan\u0131r, b\u00f6ylece form\u00fcl i\u00e7inde ara hesaplamalar\u0131 veya isim tan\u0131mlar\u0131n\u0131 saklamay\u0131 kolayla\u015ft\u0131r\u0131r.<\/li>\n<li><strong>Dinamik Diziler<\/strong>: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE ve RANDARRAY gibi yeni fonksiyonlar i\u00e7erir; tek bir form\u00fclle dizi de\u011ferlerini \u00e7al\u0131\u015fmak i\u00e7in basit\u00e7e kullan\u0131l\u0131r.<\/li>\n<li><strong>XMATCH Fonksiyonu<\/strong>: Belirli bir \u00f6\u011feyi bir dizi veya h\u00fccre aral\u0131\u011f\u0131nda arar ve ard\u0131ndan \u00f6\u011fenin g\u00f6receli konumunu d\u00f6nd\u00fcr\u00fcr, veri aramalar\u0131n\u0131n i\u015flevselli\u011fini art\u0131r\u0131r.<\/li>\n<li><strong>Sayfa G\u00f6r\u00fcn\u00fcmleri<\/strong>: Excel \u00e7al\u0131\u015fma sayfas\u0131nda, ba\u015fkalar\u0131n\u0131 etkilemeden \u00f6zelle\u015ftirilmi\u015f g\u00f6r\u00fcn\u00fcmler olu\u015fturman\u0131z\u0131 sa\u011flar.<\/li>\n<li><strong>Eri\u015filebilirlik Ara\u00e7lar\u0131<\/strong>: Eri\u015filebilir i\u00e7erik olu\u015fturmay\u0131 kolayla\u015ft\u0131ran \u00f6zel bir Eri\u015filebilirlik Sekmesi ile gelir.<\/li>\n<li><strong>Performans \u0130yile\u015ftirmeleri<\/strong>: Excel 2021, \u00f6zellikle SUMIF, COUNTIF ve AVERAGEIF gibi fonksiyonlarla daha iyi performans, istikrar ve h\u0131z sunar.<\/li>\n<li><strong>Birden Fazla Sayfay\u0131 Ayn\u0131 Anda G\u00f6sterme<\/strong>: Birden fazla gizli sayfay\u0131 daha verimli bir \u015fekilde y\u00f6netmek i\u00e7in pratik bir g\u00fcncellemedir.<\/li>\n<li><strong>Yeni Stok Medya<\/strong>: \u0130\u00e7erik olu\u015fturmay\u0131 geli\u015ftiren stok g\u00f6rseller, ikonlar ve daha fazlas\u0131n\u0131n eklenmi\u015f bir k\u00fct\u00fcphanesi.<\/li>\n<li><strong>Microsoft Arama Entegrasyonu<\/strong>: Metin, komutlar, yard\u0131m ve daha fazlas\u0131n\u0131 bulmak i\u00e7in uygulaman\u0131n \u00fcst k\u0131sm\u0131nda g\u00fc\u00e7l\u00fc bir arama arac\u0131 i\u00e7erir.<\/li>\n<li><strong>OpenDocument Format (ODF) 1.3 Deste\u011fi<\/strong>: ODF spesifikasyonundaki daha fazla \u00f6zelli\u011fi destekler.<\/li>\n<li><strong>G\u00fcncellenmi\u015f \u00c7izim Sekmesi<\/strong>: \u00c7izim ara\u00e7lar\u0131na daha kolay eri\u015fim ve Point Eraser, Cetvel ve Lasso gibi yeni eklemeler sunar.<\/li>\n<li><strong>\u00c7al\u0131\u015fma Kitab\u0131 \u0130statistikleri<\/strong>: Kullan\u0131c\u0131lara \u00e7al\u0131\u015fma kitab\u0131n\u0131n boyutu ve karma\u015f\u0131kl\u0131\u011f\u0131 hakk\u0131nda bilgi veren istatistikler sunar.<\/li>\n<li><strong>Hex Renk De\u011ferleri<\/strong>: Kullan\u0131c\u0131lar art\u0131k Renkler ileti\u015fim kutusuna do\u011frudan Hex renk de\u011ferleri girebilir, belirli renkleri kullanmay\u0131 kolayla\u015ft\u0131r\u0131r.<\/li>\n<li><strong>\u00c7izilmi\u015f Stil \u00c7er\u00e7eve<\/strong>: \u00c7al\u0131\u015fma kitab\u0131ndaki \u015feklere daha rahat ve ki\u015fisel bir g\u00f6r\u00fcn\u00fcm kazand\u0131rmak i\u00e7in kullan\u0131labilir.<\/li>\n<\/ol>\n<p>Bu g\u00fcncellemeler, kullan\u0131c\u0131lar\u0131n veri y\u00f6netimi ve analizi ihtiya\u00e7lar\u0131na y\u00f6nelik daha g\u00fc\u00e7l\u00fc ve kullan\u0131c\u0131 dostu bir Excel deneyimi sunmaktad\u0131r<\/p>\n<h2><span class=\"ez-toc-section\" id=\"excel_de_formul_nasil_yazilir\"><\/span>excel de form\u00fcl nas\u0131l yaz\u0131l\u0131r<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel&#8217;de bir form\u00fcl yazmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz:<\/p>\n<ol>\n<li>Excel \u00e7al\u0131\u015fma tablosunu a\u00e7\u0131n ve bir h\u00fccreyi se\u00e7in. Bu h\u00fccreye form\u00fcl\u00fcn\u00fcz\u00fc yazacaks\u0131n\u0131z.<\/li>\n<li>Se\u00e7ti\u011finiz h\u00fccreye t\u0131klad\u0131ktan sonra, h\u00fccrenin \u00fcst k\u0131sm\u0131nda bulunan form\u00fcl \u00e7ubu\u011funa bak\u0131n. Bu \u00e7ubuk, se\u00e7ti\u011finiz h\u00fccreye form\u00fcl\u00fcn\u00fcz\u00fc girece\u011finiz yerdir.<\/li>\n<li>Form\u00fcl \u00e7ubu\u011funa form\u00fcl\u00fcn\u00fcz\u00fc yaz\u0131n. Excel form\u00fclleri genellikle bir e\u015fittir i\u015fareti &#8220;=&#8221; ile ba\u015flar. \u00d6rne\u011fin, toplama i\u015flemi i\u00e7in &#8220;A1 + B1&#8221; veya &#8220;SUM(A1, B1)&#8221; gibi bir form\u00fcl yazabilirsiniz.<\/li>\n<li>Form\u00fcl\u00fc yazd\u0131ktan sonra ENTER tu\u015funa bas\u0131n. Excel, form\u00fcl\u00fcn\u00fcz\u00fc hesaplar ve sonucunu se\u00e7ti\u011finiz h\u00fccreye yerle\u015ftirir.<\/li>\n<\/ol>\n<p>Form\u00fcl yazarken baz\u0131 \u00f6nemli noktalara dikkat etmelisiniz:<\/p>\n<ul>\n<li>Form\u00fcl \u00e7ubu\u011fu, form\u00fcl\u00fcn\u00fcz\u00fcn mevcut d\u00fczenini g\u00f6sterir. Form\u00fcl\u00fc burada d\u00fczenleyebilir veya kontrol edebilirsiniz.<\/li>\n<li>Excel&#8217;de kullanabilece\u011finiz bir\u00e7ok yerle\u015fik fonksiyon vard\u0131r. Bu fonksiyonlar\u0131 kullanarak daha karma\u015f\u0131k hesaplamalar yapabilirsiniz. \u00d6rne\u011fin, &#8220;SUM&#8221; fonksiyonu toplama i\u015flemi i\u00e7in kullan\u0131l\u0131r.<\/li>\n<li>H\u00fccre referanslar\u0131, bir h\u00fccrenin konumunu belirtmek i\u00e7in kullan\u0131l\u0131r. \u00d6rne\u011fin, &#8220;A1&#8221; h\u00fccresi birinci s\u0131ra, birinci s\u00fctundaki h\u00fccreyi temsil eder.<\/li>\n<li>Form\u00fcl i\u00e7inde matematiksel operat\u00f6rler (+, -, *, \/), i\u015flevler ve h\u00fccre referanslar\u0131 kullanabilirsiniz.<\/li>\n<li>Form\u00fcl yazarken b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131l\u0131\u011f\u0131na dikkat etmelisiniz.<\/li>\n<\/ul>\n<p>Excel&#8217;de form\u00fcl yazma becerileri, veri analizi ve hesaplamalar yaparken olduk\u00e7a \u00f6nemlidir. Form\u00fcller, verileri i\u015flemek ve sonu\u00e7lar\u0131 otomatik olarak hesaplamak i\u00e7in g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_de_formuller_hangi_isaretle_baslar\"><\/span>excel de form\u00fcller hangi i\u015faretle ba\u015flar<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de form\u00fcller genellikle e\u015fittir i\u015fareti &#8220;=&#8221; ile ba\u015flar. Bu e\u015fittir i\u015fareti, Excel&#8217;e bir h\u00fccre veya h\u00fccre aral\u0131\u011f\u0131na uygulanacak bir i\u015flem veya hesaplama yap\u0131laca\u011f\u0131n\u0131 belirtir. Form\u00fcl\u00fcn ba\u015f\u0131na &#8220;=&#8221; eklemek, Excel&#8217;in bu ifadenin bir form\u00fcl oldu\u011funu anlamas\u0131n\u0131 sa\u011flar.<\/p>\n<p>\u00d6rnek olarak, a\u015fa\u011f\u0131daki form\u00fcllerin her biri &#8220;=&#8221; i\u015fareti ile ba\u015flar:<\/p>\n<ul>\n<li><code>=A1+B1<\/code>: A1 h\u00fccresindeki de\u011fer ile B1 h\u00fccresindeki de\u011feri toplar.<\/li>\n<li><code>=FONKS\u0130YON(A2, B2)<\/code>: Belirli bir i\u015flevi (fonksiyonu) A2 ve B2 h\u00fccrelerine uygular.<\/li>\n<li><code>=SUM(A1:A10)<\/code>: A1 h\u00fccresinden A10 h\u00fccresine kadar olan aral\u0131ktaki say\u0131lar\u0131 toplar.<\/li>\n<\/ul>\n<p>Excel&#8217;de &#8220;=&#8221; i\u015fareti ile ba\u015flayan form\u00fcller, h\u00fccredeki sonucu otomatik olarak hesaplar ve g\u00fcnceller. Bu nedenle Excel form\u00fcllerini kullanarak \u00e7e\u015fitli hesaplamalar ve veri analizi i\u015flemleri yapabilirsiniz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_eger_formulu\"><\/span>excel e\u011fer form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_6675\" aria-describedby=\"caption-attachment-6675\" style=\"width: 1024px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-large wp-image-6675\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2024\/01\/excel-eger-formulu-1024x934.webp\" alt=\"excel e\u011fer form\u00fcl\u00fc\" width=\"1024\" height=\"934\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2024\/01\/excel-eger-formulu-1024x934.webp 1024w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2024\/01\/excel-eger-formulu-300x274.webp 300w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2024\/01\/excel-eger-formulu-768x700.webp 768w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2024\/01\/excel-eger-formulu.webp 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption id=\"caption-attachment-6675\" class=\"wp-caption-text\">excel e\u011fer form\u00fcl\u00fc<\/figcaption><\/figure>\n<p>Excel&#8217;de &#8220;E\u011eER&#8221; fonksiyonu (IF function), belirli bir ko\u015fulu de\u011ferlendirir ve belirli bir sonucu d\u00f6nd\u00fcr\u00fcr. &#8220;E\u011eER&#8221; fonksiyonu, bir ko\u015fulun do\u011fru veya yanl\u0131\u015f oldu\u011funu kontrol eder ve bu ko\u015fula ba\u011fl\u0131 olarak farkl\u0131 sonu\u00e7lar \u00fcretebilir. E\u011eER fonksiyonunun temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=E\u011eER(ko\u015ful, do\u011fruysa_de\u011fer, yanl\u0131\u015fsa_de\u011fer)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>ko\u015ful<\/code>: Bir mant\u0131ksal ifade veya ko\u015ful, de\u011ferlendirilmek istenen \u015fart.<\/li>\n<li><code>do\u011fruysa_de\u011fer<\/code>: E\u011fer ko\u015ful do\u011fruysa, d\u00f6nd\u00fcr\u00fclecek de\u011fer veya i\u015flem.<\/li>\n<li><code>yanl\u0131\u015fsa_de\u011fer<\/code>: E\u011fer ko\u015ful yanl\u0131\u015fsa, d\u00f6nd\u00fcr\u00fclecek de\u011fer veya i\u015flem (iste\u011fe ba\u011fl\u0131, e\u011fer belirtilmezse 0 olarak kabul edilir).<\/li>\n<\/ul>\n<p>\u00d6rnek olarak, bir \u00f6\u011frencinin notunun 60&#8217;\u0131n \u00fczerinde olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=E\u011eER(A1 &gt;= 60, \"Ge\u00e7ti\", \"Kald\u0131\")<\/code><br \/>\nBu form\u00fcl, A1 h\u00fccresindeki notun 60 veya daha fazla olup olmad\u0131\u011f\u0131n\u0131 kontrol eder. E\u011fer not 60 veya daha fazlaysa, &#8220;Ge\u00e7ti&#8221; metnini d\u00f6nd\u00fcr\u00fcr; aksi takdirde &#8220;Kald\u0131&#8221; metnini d\u00f6nd\u00fcr\u00fcr.<\/p>\n<p>E\u011eER fonksiyonu, \u00e7ok daha karma\u015f\u0131k ko\u015fullar\u0131n de\u011ferlendirilmesi i\u00e7in kullan\u0131labilir ve Excel \u00e7al\u0131\u015fma tablosunda veri analizi ve karar verme i\u015flemleri s\u0131ras\u0131nda olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_and_kullanimi\"><\/span>excel and kullan\u0131m\u0131<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_6676\" aria-describedby=\"caption-attachment-6676\" style=\"width: 520px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-6676\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2024\/01\/excel-and-kullanimi-min.png\" alt=\"excel and kullan\u0131m\u0131\" width=\"520\" height=\"205\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2024\/01\/excel-and-kullanimi-min.png 520w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2024\/01\/excel-and-kullanimi-min-300x118.png 300w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><figcaption id=\"caption-attachment-6676\" class=\"wp-caption-text\">excel and kullan\u0131m\u0131<\/figcaption><\/figure>\n<p>Excel&#8217;de &#8220;AND&#8221; fonksiyonu, birden fazla ko\u015fulun hepsinin do\u011fru olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, verilen t\u00fcm ko\u015fullar do\u011fruysa &#8220;TRUE&#8221; (DO\u011eRU), herhangi biri yanl\u0131\u015fsa &#8220;FALSE&#8221; (YANLI\u015e) de\u011ferini d\u00f6nd\u00fcr\u00fcr. \u00d6zellikle karma\u015f\u0131k karar verme i\u015flemlerinde ve ko\u015fullu formatlamada s\u0131kl\u0131kla kullan\u0131l\u0131r.<\/p>\n<p><strong>AND Fonksiyonunun Kullan\u0131m\u0131:<\/strong> AND fonksiyonunun genel yap\u0131s\u0131 \u015fu \u015fekildedir:<\/p>\n<p>=AND(ko\u015ful1, ko\u015ful2, &#8230;)<\/p>\n<p>Burada &#8220;ko\u015ful1&#8221;, &#8220;ko\u015ful2&#8221; vb. Excel&#8217;deki mant\u0131ksal testlerdir ve bunlar do\u011fru (TRUE) veya yanl\u0131\u015f (FALSE) de\u011ferler d\u00f6nd\u00fcr\u00fcr.<\/p>\n<p><strong>\u00d6rnek Kullan\u0131m:<\/strong> Diyelim ki, iki s\u00fctununuz var ve her iki s\u00fctundaki de\u011ferlerin de belirli bir kriteri kar\u015f\u0131lamas\u0131n\u0131 kontrol etmek istiyorsunuz. \u00d6rne\u011fin, A s\u00fctunundaki de\u011ferlerin 10&#8217;dan b\u00fcy\u00fck ve B s\u00fctunundaki de\u011ferlerin &#8220;Evet&#8221; olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/p>\n<p>=AND(A1&gt;10, B1=&#8221;Evet&#8221;)<\/p>\n<p>Bu form\u00fcl, A1 h\u00fccresindeki de\u011fer 10&#8217;dan b\u00fcy\u00fck ve ayn\u0131 zamanda B1 h\u00fccresindeki de\u011fer &#8220;Evet&#8221; ise TRUE de\u011ferini d\u00f6nd\u00fcrecektir.<\/p>\n<p><strong>AND Fonksiyonunun Kullan\u0131ld\u0131\u011f\u0131 Senaryolar:<\/strong><\/p>\n<ol>\n<li><strong>Ko\u015fullu Bi\u00e7imlendirme<\/strong>: Belirli ko\u015fullar kar\u015f\u0131land\u0131\u011f\u0131nda h\u00fccrelerin format\u0131n\u0131 de\u011fi\u015ftirmek i\u00e7in kullan\u0131labilir.<\/li>\n<li><strong>Karar Verme \u0130\u015flemleri<\/strong>: Birden fazla ko\u015fulun ayn\u0131 anda kar\u015f\u0131lan\u0131p kar\u015f\u0131lanmad\u0131\u011f\u0131n\u0131 kontrol ederek, daha karma\u015f\u0131k karar verme i\u015flemlerinde kullan\u0131l\u0131r.<\/li>\n<li><strong>Filtreleme ve S\u0131ralama<\/strong>: Veri analizinde, belirli kriterlere g\u00f6re verileri filtrelemek ve s\u0131ralamak i\u00e7in kullan\u0131l\u0131r.<\/li>\n<\/ol>\n<p>Excel&#8217;de AND fonksiyonunun kullan\u0131m\u0131 genellikle basit ve do\u011frudand\u0131r, ancak birden fazla ko\u015fulun kombinasyonunu de\u011ferlendirmeniz gerekti\u011finde olduk\u00e7a g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Bu fonksiyon, veri analizi ve raporlamada s\u0131kl\u0131kla kullan\u0131lan bir yap\u0131 ta\u015f\u0131d\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_ara_formulu\"><\/span>excel ara form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_6677\" aria-describedby=\"caption-attachment-6677\" style=\"width: 512px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-6677\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2024\/01\/excel-ara-formulu-min.png\" alt=\"excel ara form\u00fcl\u00fc\" width=\"512\" height=\"294\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2024\/01\/excel-ara-formulu-min.png 512w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2024\/01\/excel-ara-formulu-min-300x172.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><figcaption id=\"caption-attachment-6677\" class=\"wp-caption-text\">excel ara form\u00fcl\u00fc<\/figcaption><\/figure>\n<p>Excel&#8217;de &#8220;ARA&#8221; fonksiyonu, metin i\u00e7inde belirli bir karakter veya metin par\u00e7as\u0131n\u0131 aramak ve bu par\u00e7an\u0131n ba\u015flang\u0131\u00e7 pozisyonunu bulmak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, genellikle metin i\u015fleme, veri temizleme veya daha karma\u015f\u0131k metin bazl\u0131 i\u015flemler i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p><strong>ARA Fonksiyonunun Yap\u0131s\u0131:<\/strong> ARA fonksiyonunun temel yap\u0131s\u0131 \u015fu \u015fekildedir:<br \/>\n=ARA(aranan_metin, i\u00e7inde_aranacak_metin, [ba\u015flang\u0131\u00e7_numaras\u0131])<\/p>\n<ul>\n<li><code>aranan_metin<\/code>: Aramak istedi\u011finiz karakter veya metin par\u00e7as\u0131d\u0131r.<\/li>\n<li><code>i\u00e7inde_aranacak_metin<\/code>: Araman\u0131n yap\u0131laca\u011f\u0131 metindir.<\/li>\n<li><code>[ba\u015flang\u0131\u00e7_numaras\u0131]<\/code> (iste\u011fe ba\u011fl\u0131): Araman\u0131n ba\u015flayaca\u011f\u0131 pozisyonu belirtir. Bu parametre verilmezse, varsay\u0131lan olarak metnin ba\u015f\u0131ndan arama yap\u0131l\u0131r.<\/li>\n<\/ul>\n<p><strong>\u00d6rnek Kullan\u0131m:<\/strong> \u00d6rne\u011fin, bir h\u00fccredeki metnin i\u00e7inde &#8220;elma&#8221; kelimesinin ge\u00e7ti\u011fi yeri bulmak istiyorsunuz. Diyelim ki, &#8220;Bu c\u00fcmlede elma kelimesi ge\u00e7iyor.&#8221; metni A1 h\u00fccresinde yer al\u0131yor. Bu durumda kullanaca\u011f\u0131n\u0131z form\u00fcl \u015f\u00f6yle olur:<br \/>\n=ARA(&#8220;elma&#8221;, A1)<\/p>\n<p>Bu form\u00fcl, &#8220;elma&#8221; kelimesinin A1 h\u00fccresindeki metin i\u00e7indeki ba\u015flang\u0131\u00e7 konumunu d\u00f6nd\u00fcrecektir.<\/p>\n<p><strong>ARA Fonksiyonunun Kullan\u0131m Senaryolar\u0131:<\/strong><\/p>\n<ol>\n<li><strong>Metin \u0130\u00e7inde Belirli Bir Kelimenin Konumunu Bulma<\/strong>: Bir metin par\u00e7as\u0131 i\u00e7inde belirli bir kelimenin veya karakter dizisinin yerini tespit etmek i\u00e7in kullan\u0131l\u0131r.<\/li>\n<li><strong>Metinleri B\u00f6lme veya D\u00fczenleme<\/strong>: Belirli bir karaktere g\u00f6re metni b\u00f6lme veya d\u00fczenleme i\u015flemlerinde kullan\u0131l\u0131r.<\/li>\n<li><strong>Veri Temizleme<\/strong>: Metin i\u00e7inde istenmeyen k\u0131s\u0131mlar\u0131 tespit etmek ve temizlemek i\u00e7in kullan\u0131labilir.<\/li>\n<\/ol>\n<p>ARA fonksiyonu, b\u00fcy\u00fck ve karma\u015f\u0131k metin verileri \u00fczerinde \u00e7al\u0131\u015f\u0131rken \u00e7ok kullan\u0131\u015fl\u0131 olabilir. Metin tabanl\u0131 verilerle \u00e7al\u0131\u015f\u0131rken, metin i\u00e7inde arama yapma, konum tespiti ve metin manip\u00fclasyonu gibi i\u015flemleri kolayla\u015ft\u0131r\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_ara_toplam_formulu\"><\/span>excel ara toplam form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de &#8220;ARA TOPLAM&#8221; fonksiyonu, bir veri seti \u00fczerinde \u00e7e\u015fitli hesaplamalar yapmak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, \u00f6zellikle filtre uygulanm\u0131\u015f verilerle \u00e7al\u0131\u015f\u0131rken kullan\u0131\u015fl\u0131d\u0131r, \u00e7\u00fcnk\u00fc filtrelenmi\u015f veriler \u00fczerinde hesaplamalar yaparken gizlenmi\u015f sat\u0131rlar\u0131 g\u00f6z ard\u0131 eder.<\/p>\n<p><strong>ARA TOPLAM Fonksiyonunun Yap\u0131s\u0131:<\/strong> ARA TOPLAM fonksiyonunun genel yap\u0131s\u0131 \u015fu \u015fekildedir:<br \/>\n=ARA TOPLAM(fonksiyon_numaras\u0131, ref1, [ref2], &#8230;)<\/p>\n<ul>\n<li><code>fonksiyon_numaras\u0131<\/code>: Yapmak istedi\u011finiz hesaplama t\u00fcr\u00fcn\u00fc belirtir. \u00d6rne\u011fin, 9 toplam\u0131, 1 ortalama, 2 say\u0131y\u0131 vb. temsil eder.<\/li>\n<li><code>ref1, [ref2], ...<\/code>: Hesaplamalar\u0131n yap\u0131laca\u011f\u0131 h\u00fccre aral\u0131klar\u0131d\u0131r.<\/li>\n<\/ul>\n<p><strong>Fonksiyon Numaralar\u0131 ve Kar\u015f\u0131l\u0131klar\u0131:<\/strong><\/p>\n<ol>\n<li>Ortalama (AVERAGE)<\/li>\n<li>Say\u0131 (COUNT)<\/li>\n<li>Say\u01312 (COUNTA)<\/li>\n<li>Maksimum (MAX)<\/li>\n<li>Minimum (MIN)<\/li>\n<li>\u00c7arp\u0131m (PRODUCT)<\/li>\n<li>Standart Sapma (STDEV)<\/li>\n<li>Standart Sapma (STDEVP)<\/li>\n<li>Toplam (SUM)<\/li>\n<li>Varyans (VAR)<\/li>\n<li>Varyans (VARP)<\/li>\n<\/ol>\n<p>Ve bu numaralar\u0131n 101 ile 111 aras\u0131ndaki versiyonlar\u0131, gizlenmi\u015f sat\u0131rlar\u0131 da dahil ederek hesaplama yapar.<\/p>\n<p><strong>\u00d6rnek Kullan\u0131m:<\/strong> \u00d6rne\u011fin, A1:A10 aral\u0131\u011f\u0131ndaki say\u0131lar\u0131n toplam\u0131n\u0131 almak i\u00e7in, ve e\u011fer bu aral\u0131kta filtre uygulanm\u0131\u015fsa gizlenmi\u015f sat\u0131rlar\u0131 hesaba katmamak i\u00e7in, a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n=ARA TOPLAM(9, A1:A10)<\/p>\n<p>Bu form\u00fcl, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerdeki say\u0131lar\u0131n toplam\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p>\n<p><strong>ARA TOPLAM Fonksiyonunun Kullan\u0131m Senaryolar\u0131:<\/strong><\/p>\n<ol>\n<li><strong>Filtrelenmi\u015f Veriler \u00dczerinde Hesaplama<\/strong>: Filtre uygulanm\u0131\u015f bir veri seti \u00fczerinde toplam, ortalama gibi hesaplamalar yapmak i\u00e7in kullan\u0131l\u0131r.<\/li>\n<li><strong>Gizlenmi\u015f Sat\u0131rlar\u0131 Hari\u00e7 Tutma<\/strong>: Veri analizi s\u0131ras\u0131nda belirli sat\u0131rlar\u0131 gizleyip, gizlenmi\u015f sat\u0131rlar\u0131 hesaba katmadan hesaplamalar yapmak i\u00e7in kullan\u0131l\u0131r.<\/li>\n<li><strong>Esnek Veri Analizi<\/strong>: Farkl\u0131 hesaplama t\u00fcrleri i\u00e7in tek bir fonksiyon ile \u00e7e\u015fitli analizler yapma imkan\u0131 sunar.<\/li>\n<\/ol>\n<p>ARA TOPLAM fonksiyonu, Excel&#8217;de dinamik ve esnek veri analizleri yapmak i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131 bir ara\u00e7t\u0131r, \u00f6zellikle b\u00fcy\u00fck veri setleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken ve filtreleme i\u015flemleri s\u0131ras\u0131nda.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_aradaki_farki_bulma\"><\/span>excel aradaki fark\u0131 bulma<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de iki say\u0131 aras\u0131ndaki fark\u0131 bulmak i\u00e7in genellikle basit bir \u00e7\u0131karma i\u015flemi kullan\u0131l\u0131r. Bu i\u015flem, iki h\u00fccre aras\u0131ndaki de\u011ferleri \u00e7\u0131kararak yap\u0131labilir. \u00d6rne\u011fin, A2 ve B2 h\u00fccrelerindeki say\u0131lar\u0131n fark\u0131n\u0131 bulmak i\u00e7in <code>=A2-B2<\/code> form\u00fcl\u00fc kullan\u0131l\u0131r. Bu form\u00fcl, A2 h\u00fccresindeki de\u011ferden B2 h\u00fccresindeki de\u011feri \u00e7\u0131kararak sonucu verir.<\/p>\n<p>E\u011fer iki say\u0131 aras\u0131ndaki mutlak fark\u0131 bulmak istiyorsan\u0131z, <code>ABS()<\/code> fonksiyonunu kullanabilirsiniz. Bu fonksiyon, iki say\u0131n\u0131n fark\u0131n\u0131n mutlak de\u011ferini al\u0131r. \u00d6rne\u011fin, <code>=ABS(A2-B2)<\/code> form\u00fcl\u00fc, A2 ve B2 h\u00fccrelerindeki de\u011ferler aras\u0131ndaki fark\u0131n mutlak de\u011ferini hesaplar.<\/p>\n<p>Ayr\u0131ca, Excel&#8217;de iki say\u0131 aras\u0131ndaki y\u00fczde fark\u0131n\u0131 hesaplamak i\u00e7in bir form\u00fcl de kullanabilirsiniz. Bu hesaplama genellikle <code>=2*ABS(A2-B2)\/(A2+B2)<\/code> form\u00fcl\u00fc ile yap\u0131l\u0131r. Bu form\u00fcl, iki say\u0131 aras\u0131ndaki mutlak fark\u0131 al\u0131r, bunu iki say\u0131n\u0131n toplam\u0131na b\u00f6ler ve sonucu 2 ile \u00e7arpar.<\/p>\n<p>Bu form\u00fcller, Excel&#8217;de s\u0131k\u00e7a kar\u015f\u0131la\u015f\u0131lan hesaplamalar i\u00e7in kullan\u0131\u015fl\u0131d\u0131r ve veri analizlerinizde size yard\u0131mc\u0131 olabilir. \u00d6zellikle finansal analiz, m\u00fchendislik hesaplamalar\u0131 veya genel veri kar\u015f\u0131la\u015ft\u0131rmalar\u0131nda bu t\u00fcr form\u00fcller olduk\u00e7a yararl\u0131d\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_aranan_degeri_bulma\"><\/span>excel aranan de\u011feri bulma<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de aranan bir de\u011feri bulmak i\u00e7in genellikle &#8220;D\u00dc\u015eEYARA&#8221; (VLOOKUP) fonksiyonu kullan\u0131l\u0131r. Bu fonksiyon, belirli bir de\u011feri aray\u0131p, e\u015fle\u015fen de\u011ferin bulundu\u011fu sat\u0131rdan ba\u015fka bir de\u011feri getirmenizi sa\u011flar. D\u00dc\u015eEYARA fonksiyonunun kullan\u0131m\u0131 i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz:<\/p>\n<ol>\n<li><strong>Aranacak De\u011fer<\/strong>: \u0130lk olarak, aramak istedi\u011finiz de\u011feri belirlemeniz gerekiyor. Bu de\u011fer, genellikle bir h\u00fccre referans\u0131 veya do\u011frudan bir say\u0131, metin gibi olabilir.<\/li>\n<li><strong>Tablo Dizisi<\/strong>: Araman\u0131n yap\u0131laca\u011f\u0131 h\u00fccre aral\u0131\u011f\u0131n\u0131 belirtmelisiniz. Bu aral\u0131k, aranan de\u011feri i\u00e7eren ilk s\u00fctunu ve istedi\u011finiz d\u00f6n\u00fc\u015f de\u011ferini i\u00e7eren s\u00fctunu kapsamal\u0131d\u0131r.<\/li>\n<li><strong>S\u00fctun \u0130ndis Say\u0131s\u0131<\/strong>: D\u00f6n\u00fc\u015f de\u011ferinin bulundu\u011fu s\u00fctunun, tablo dizisindeki s\u0131ra numaras\u0131n\u0131 belirtmelisiniz. \u00d6rne\u011fin, aral\u0131\u011f\u0131n\u0131z B2:D11 ise ve d\u00f6n\u00fc\u015f de\u011feri C s\u00fctunundaysa, s\u00fctun indis say\u0131s\u0131 2 olacakt\u0131r.<\/li>\n<li><strong>Aral\u0131k Bak<\/strong>: \u0130ste\u011fe ba\u011fl\u0131 olarak, &#8220;DO\u011eRU&#8221; veya &#8220;YANLI\u015e&#8221; de\u011ferlerinden birini kullanarak, yakla\u015f\u0131k veya tam e\u015fle\u015fme arayabilirsiniz. &#8220;DO\u011eRU&#8221; (veya 1) yakla\u015f\u0131k e\u015fle\u015fme, &#8220;YANLI\u015e&#8221; (veya 0) ise tam e\u015fle\u015fme i\u00e7in kullan\u0131l\u0131r.<\/li>\n<\/ol>\n<p>\u00d6rnek olarak, A s\u00fctununda yer alan bir de\u011feri aramak ve bu de\u011fere kar\u015f\u0131l\u0131k gelen B s\u00fctunundaki de\u011feri almak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl kullan\u0131labilir:<br \/>\n=D\u00dc\u015eEYARA(aranan_de\u011fer, A:B, 2, YANLI\u015e)<\/p>\n<p>Ayr\u0131ca, D\u00dc\u015eEYARA fonksiyonunun baz\u0131 s\u0131n\u0131rlamalar\u0131 vard\u0131r. \u00d6rne\u011fin, bu fonksiyon sadece soldan sa\u011fa do\u011fru arama yapar. E\u011fer arad\u0131\u011f\u0131n\u0131z de\u011fer, d\u00f6n\u00fc\u015f de\u011ferinin solunda yer al\u0131yorsa, &#8220;\u0130ND\u0130S&#8221; ve &#8220;KA\u00c7INCI&#8221; fonksiyonlar\u0131n\u0131 birlikte kullanarak bu s\u0131n\u0131rlamay\u0131 a\u015fabilirsiniz\u200b\u200b\u200b\u200b\u200b\u200b.<\/p>\n<p>Bu fonksiyonlar, \u00f6zellikle b\u00fcy\u00fck veri tablolar\u0131nda \u00e7al\u0131\u015f\u0131rken olduk\u00e7a yararl\u0131d\u0131r ve \u00e7e\u015fitli veri kar\u015f\u0131la\u015ft\u0131rma ve arama ihtiya\u00e7lar\u0131n\u0131za \u00e7\u00f6z\u00fcm sunabilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_arasinda_formulu\"><\/span>excel aras\u0131nda form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de bir h\u00fccre de\u011ferinin belirli iki de\u011fer aras\u0131nda olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in, &#8220;E\u011eER&#8221; ve &#8220;VE&#8221; i\u015flevlerinin bir kombinasyonunu kullanabilirsiniz. \u00d6rne\u011fin, B2 h\u00fccresindeki de\u011ferin A2 ve A3 h\u00fccrelerindeki de\u011ferler aras\u0131nda olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n=E\u011eER(VE(B2&gt;A2,B2&lt;A3),&#8221;Evet&#8221;,&#8221;Hay\u0131r&#8221;)<\/p>\n<p>Bu form\u00fcl, B2 h\u00fccresindeki de\u011fer A2 ve A3 h\u00fccrelerindeki de\u011ferler aras\u0131ndaysa &#8220;Evet&#8221; sonucunu, de\u011filse &#8220;Hay\u0131r&#8221; sonucunu d\u00f6nd\u00fcrecektir.<\/p>\n<p>Ayr\u0131ca, belirli bir say\u0131 aral\u0131\u011f\u0131na dayal\u0131 olarak bir h\u00fccreye de\u011fer veya kategori atamak i\u00e7in &#8220;E\u011eER&#8221; ve &#8220;VE&#8221; i\u015flevlerini birle\u015ftirebilirsiniz. \u00d6rne\u011fin, B2 h\u00fccresindeki bir de\u011ferin 0 ile 100 aras\u0131nda, 101 ile 500 aras\u0131nda, 501 ile 1000 aras\u0131nda veya 1000&#8217;in \u00fczerinde olmas\u0131na ba\u011fl\u0131 olarak farkl\u0131 kategoriler atamak istiyorsan\u0131z, a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/p>\n<p>=E\u011eER(VE(B2&gt;=0,B2&lt;=100),&#8221;D\u00fc\u015f\u00fck&#8221;,E\u011eER(VE(B2&gt;100,B2&lt;=500),&#8221;Orta&#8221;,E\u011eER(VE(B2&gt;500,B2&lt;=1000),&#8221;\u0130yi&#8221;,E\u011eER(VE(B2&gt;1000),&#8221;M\u00fckemmel&#8221;,&#8221;&#8221;))))<\/p>\n<p>Bu form\u00fcl, B2 h\u00fccresindeki de\u011ferin belirli say\u0131 aral\u0131klar\u0131na g\u00f6re &#8220;D\u00fc\u015f\u00fck&#8221;, &#8220;Orta&#8221;, &#8220;\u0130yi&#8221; veya &#8220;M\u00fckemmel&#8221; gibi kategorileri d\u00f6nd\u00fcr\u00fcr.Bu t\u00fcr form\u00fcller, veri analizi ve ko\u015fullu i\u015flemlerde olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r ve Excel&#8217;deki \u00e7e\u015fitli senaryolarda uygulanabilir\u200b<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_arayuzunde_calisma_alanini_tanima\"><\/span>excel aray\u00fcz\u00fcnde \u00e7al\u0131\u015fma alan\u0131n\u0131 tan\u0131ma<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;deki \u00e7al\u0131\u015fma alan\u0131n\u0131 tan\u0131mak, program\u0131n etkili bir \u015fekilde kullan\u0131lmas\u0131nda \u00f6nemli bir ad\u0131md\u0131r. Excel aray\u00fcz\u00fc, verilerinizi organize etmek ve analiz etmek i\u00e7in \u00e7e\u015fitli ara\u00e7lar ve se\u00e7enekler sunar. \u0130\u015fte Excel \u00e7al\u0131\u015fma alan\u0131n\u0131n temel bile\u015fenleri:<\/p>\n<ol>\n<li><strong>\u015eerit (Ribbon)<\/strong>: Excel&#8217;in en \u00fcst k\u0131sm\u0131nda bulunan ve sekme ba\u015fl\u0131klar\u0131 i\u00e7eren b\u00f6l\u00fcmd\u00fcr. Bu sekme ba\u015fl\u0131klar\u0131 alt\u0131nda, farkl\u0131 i\u015flevlere ve \u00f6zelliklere h\u0131zl\u0131 eri\u015fim sa\u011flayan ara\u00e7lar bulunur.<\/li>\n<li><strong>Form\u00fcl \u00c7ubu\u011fu (Formula Bar)<\/strong>: Aktif h\u00fccredeki veriyi g\u00f6sterir ve burada form\u00fcller yaz\u0131labilir. H\u00fccre i\u00e7eri\u011fini d\u00fczenlemek i\u00e7in de kullan\u0131l\u0131r.<\/li>\n<li><strong>\u00c7al\u0131\u015fma Sayfalar\u0131 (Worksheets)<\/strong>: Bir Excel dosyas\u0131, birden fazla \u00e7al\u0131\u015fma sayfas\u0131 i\u00e7erebilir. Bu sayfalar\u0131n sekmeleri, ekran\u0131n alt k\u0131sm\u0131nda g\u00f6r\u00fcnt\u00fclenir. Yeni bir sayfa eklemek, mevcut sayfalar aras\u0131nda ge\u00e7i\u015f yapmak veya sayfalar\u0131 yeniden adland\u0131rmak bu alandan yap\u0131l\u0131r.<\/li>\n<li><strong>H\u00fccreler ve S\u00fctunlar<\/strong>: Ana \u00e7al\u0131\u015fma alan\u0131, h\u00fccrelerin bir \u0131zgaras\u0131ndan olu\u015fur. Her h\u00fccre, bir sat\u0131r numaras\u0131 ve bir s\u00fctun harfi ile tan\u0131mlan\u0131r (\u00f6rne\u011fin, A1, B1 vb.).<\/li>\n<li><strong>Durum \u00c7ubu\u011fu (Status Bar)<\/strong>: Excel penceresinin en alt\u0131nda yer al\u0131r ve \u00e7al\u0131\u015fma kitab\u0131n\u0131zla ilgili bilgileri ve baz\u0131 h\u0131zl\u0131 ara\u00e7lar\u0131 g\u00f6sterir.<\/li>\n<li><strong>H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011fu (Quick Access Toolbar)<\/strong>: Excel penceresinin en \u00fcst\u00fcnde, \u015feridin \u00fczerinde bulunur ve s\u0131k kullan\u0131lan komutlara h\u0131zl\u0131 eri\u015fim sa\u011flar. Bu ara\u00e7 \u00e7ubu\u011funu \u00f6zelle\u015ftirebilirsiniz.<\/li>\n<li><strong>Dosya Sekmesi (File Tab)<\/strong>: Bu sekme, &#8220;Dosya&#8221; men\u00fcs\u00fcn\u00fc a\u00e7ar ve buradan yeni bir dosya olu\u015fturabilir, mevcut bir dosyay\u0131 a\u00e7abilir, kaydedebilir, yazd\u0131rabilir ve di\u011fer dosya y\u00f6netimi i\u015flemlerini ger\u00e7ekle\u015ftirebilirsiniz.<\/li>\n<\/ol>\n<p>Bu bile\u015fenlerin her biri, Excel&#8217;de veri i\u015fleme ve analiz i\u015flemlerini daha verimli ve etkili bir \u015fekilde ger\u00e7ekle\u015ftirmenizi sa\u011flar. Her birinin i\u015flevselli\u011fini anlamak, Excel&#8217;de daha h\u0131zl\u0131 ve etkili \u00e7al\u0131\u015fman\u0131za yard\u0131mc\u0131 olacakt\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_asagi_yuvarla\"><\/span>excel a\u015fa\u011f\u0131 yuvarla<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de &#8220;A\u015eA\u011eIYUVARLA&#8221; fonksiyonu, belirli bir say\u0131y\u0131 belirtilen basamak say\u0131s\u0131na kadar a\u015fa\u011f\u0131 do\u011fru yuvarlamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyonun genel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=A\u015eA\u011eIYUVARLA(say\u0131, basamak_say\u0131s\u0131)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>say\u0131<\/code>: Yuvarlamak istedi\u011finiz say\u0131d\u0131r.<\/li>\n<li><code>basamak_say\u0131s\u0131<\/code>: Yuvarlaman\u0131n yap\u0131laca\u011f\u0131 basamak say\u0131s\u0131d\u0131r. \u00d6rne\u011fin, 0 ise say\u0131 en yak\u0131n tam say\u0131ya, 2 ise ondal\u0131k k\u0131sm\u0131n iki basama\u011f\u0131na kadar yuvarlan\u0131r.<\/li>\n<\/ul>\n<p><strong>\u00d6rnek Kullan\u0131mlar:<\/strong><\/p>\n<ol>\n<li><code>=A\u015eA\u011eIYUVARLA(3.14159, 2)<\/code>: Bu form\u00fcl, 3.14159 say\u0131s\u0131n\u0131 ondal\u0131k k\u0131sm\u0131n iki basama\u011f\u0131na kadar a\u015fa\u011f\u0131 do\u011fru yuvarlar ve sonu\u00e7 <code>3.14<\/code> olur.<\/li>\n<li><code>=A\u015eA\u011eIYUVARLA(150.678, 0)<\/code>: Bu form\u00fcl, 150.678 say\u0131s\u0131n\u0131 en yak\u0131n tam say\u0131ya a\u015fa\u011f\u0131 do\u011fru yuvarlar ve sonu\u00e7 <code>150<\/code> olur.<\/li>\n<\/ol>\n<p>Bu fonksiyon, finansal hesaplamalar, veri analizi ve raporlama gibi durumlarda kullan\u0131\u015fl\u0131d\u0131r, \u00f6zellikle de belirli bir say\u0131sal hassasiyete ihtiya\u00e7 duyuldu\u011funda.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_ay_formulu\"><\/span>excel ay form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de &#8220;AY&#8221; fonksiyonu, belirtilen bir tarihten ay bilgisini almak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, bir tarih i\u00e7eren h\u00fccreden veya tarih ifadesinden ay numaras\u0131n\u0131 (1&#8217;den 12&#8217;ye kadar) d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, Ocak i\u00e7in 1, \u015eubat i\u00e7in 2 ve Aral\u0131k i\u00e7in 12 de\u011ferlerini d\u00f6nd\u00fcr\u00fcr.<\/p>\n<p><strong>AY Fonksiyonunun S\u00f6zdizimi:<\/strong><br \/>\n<code>=AY(seri_no)<\/code><\/p>\n<ul>\n<li><code>seri_no<\/code>: Ay bilgisini elde etmek istedi\u011finiz tarih.<\/li>\n<\/ul>\n<p><strong>\u00d6rnek Kullan\u0131mlar:<\/strong><\/p>\n<ol>\n<li><code>=AY(\"2023-03-15\")<\/code>: Bu form\u00fcl, belirtilen tarih olan &#8220;15 Mart 2023&#8221; i\u00e7in ay numaras\u0131 olarak <code>3<\/code> d\u00f6nd\u00fcrecektir.<\/li>\n<li><code>=AY(B5)<\/code>: E\u011fer B5 h\u00fccresi bir tarih i\u00e7eriyorsa, bu form\u00fcl o tarihin ay\u0131n\u0131 d\u00f6nd\u00fcrecektir. \u00d6rne\u011fin, B5 h\u00fccresi &#8220;2023-10-05&#8221; tarihini i\u00e7eriyorsa, sonu\u00e7 <code>10<\/code> olacakt\u0131r.<\/li>\n<\/ol>\n<p>AY fonksiyonu, tarihleri aylara g\u00f6re s\u0131n\u0131fland\u0131rma, ayl\u0131k raporlama veya tarihlerle ilgili di\u011fer hesaplamalar yaparken olduk\u00e7a faydal\u0131d\u0131r. Bu fonksiyonu, di\u011fer Excel tarih ve saat fonksiyonlar\u0131yla birlikte kullanarak daha karma\u015f\u0131k tarih i\u015flemleri ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_ayni_olanlari_sil\"><\/span>excel ayn\u0131 olanlar\u0131 sil<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de ayn\u0131 olan verileri silmek i\u00e7in \u00e7e\u015fitli y\u00f6ntemler bulunmaktad\u0131r. \u0130\u015fte en yayg\u0131n kullan\u0131lan baz\u0131 y\u00f6ntemler:<\/p>\n<ol>\n<li><strong>Yinelenenleri Kald\u0131rma \u00d6zelli\u011fi<\/strong>:\n<ul>\n<li>Veri sekmesine gidin.<\/li>\n<li>&#8220;Veri Ara\u00e7lar\u0131&#8221; b\u00f6l\u00fcm\u00fcnde, &#8220;Yinelenenleri Kald\u0131r&#8221; se\u00e7ene\u011fine t\u0131klay\u0131n.<\/li>\n<li>Silmek istedi\u011finiz s\u00fctunlar\u0131 se\u00e7in ve ard\u0131ndan &#8220;Tamam&#8221;\u0131 t\u0131klay\u0131n.<\/li>\n<li>Excel, yinelenen kay\u0131tlar\u0131 otomatik olarak siler ve yaln\u0131zca benzersiz kay\u0131tlar\u0131 b\u0131rak\u0131r.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Ko\u015fullu Bi\u00e7imlendirme<\/strong>:\n<ul>\n<li>Tekrarlayan verileri bulmak i\u00e7in, \u00f6ncelikle kontrol etmek istedi\u011finiz h\u00fccreleri se\u00e7in.<\/li>\n<li>&#8220;Giri\u015f&#8221; sekmesinin &#8220;Stil&#8221; grubunda &#8220;Ko\u015fullu Bi\u00e7imlendirme&#8221;ye gidin.<\/li>\n<li>&#8220;H\u00fccre Vurgulama Kurallar\u0131&#8221; alt\u0131nda &#8220;Yinelenen De\u011ferler&#8221; se\u00e7ene\u011fini se\u00e7in.<\/li>\n<li>Ard\u0131ndan, yinelenen verileri manuel olarak silmek i\u00e7in bu vurgulamay\u0131 kullanabilirsiniz.<\/li>\n<\/ul>\n<\/li>\n<li><strong>VBA Makrolar\u0131<\/strong>:\n<ul>\n<li>Daha karma\u015f\u0131k veri setleri i\u00e7in, VBA makrolar\u0131 kullan\u0131larak ayn\u0131 olan veriler silinebilir.<\/li>\n<li>Bu y\u00f6ntem, \u00f6zellikle b\u00fcy\u00fck veri setlerinde ve \u00f6zel silme kriterlerinde kullan\u0131\u015fl\u0131d\u0131r.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Filtreleme Y\u00f6ntemi<\/strong>:\n<ul>\n<li>Verilerinizi filtreleyerek yinelenen kay\u0131tlar\u0131 belirleyebilir ve silmek istediklerinizi se\u00e7ebilirsiniz.<\/li>\n<li>Bu y\u00f6ntem, manuel olarak belirli verileri incelemek ve silmek istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Bu y\u00f6ntemler, Excel&#8217;deki yinelenen veya tekrar eden verileri temizlemek ve veri setinizi daha d\u00fczenli hale getirmek i\u00e7in kullan\u0131labilir. Hangi y\u00f6ntemin kullan\u0131laca\u011f\u0131, veri setinizin boyutu ve karma\u015f\u0131kl\u0131\u011f\u0131na ba\u011fl\u0131 olarak de\u011fi\u015febilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_basarili_basarisiz\"><\/span>excel ba\u015far\u0131l\u0131 ba\u015far\u0131s\u0131z<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de \u00f6\u011frencilerin ba\u015far\u0131 durumunu hesaplamak i\u00e7in &#8220;E\u011eER&#8221; ve &#8220;YADA&#8221; fonksiyonlar\u0131n\u0131 kullanabilirsiniz. \u00d6rne\u011fin, \u00f6\u011frencinin final notu veya ortalamas\u0131 50&#8217;den y\u00fcksekse ba\u015far\u0131l\u0131, aksi halde ba\u015far\u0131s\u0131z olarak belirtmek i\u00e7in \u015fu form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=E\u011eER(YADA(H3&lt;50;G3&lt;50);\"BA\u015eARISIZ\";\"BA\u015eARILI\")<br \/>\n<\/code><br \/>\nBu form\u00fclde, <code>H3<\/code> h\u00fccresi ortalamay\u0131 ve <code>G3<\/code> h\u00fccresi final notunu temsil eder. E\u011fer \u00f6\u011frencinin ortalamas\u0131 veya final notu 50&#8217;den d\u00fc\u015f\u00fckse &#8220;BA\u015eARISIZ&#8221;, herhangi biri 50 veya \u00fczeriyse &#8220;BA\u015eARILI&#8221; sonucu d\u00f6nd\u00fcr\u00fcl\u00fcr. Bu form\u00fcl, \u00f6\u011frencilerin ba\u015far\u0131 durumlar\u0131n\u0131 etkin bir \u015fekilde de\u011ferlendirmek i\u00e7in kullan\u0131\u015fl\u0131 bir y\u00f6ntem sunar.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_baska_hucreden_veri_alma\"><\/span>excel ba\u015fka h\u00fccreden veri alma<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de ba\u015fka bir h\u00fccreden veri almak i\u00e7in \u00e7e\u015fitli y\u00f6ntemler kullan\u0131labilir. En basit y\u00f6ntem, do\u011frudan h\u00fccre referans\u0131 kullanmakt\u0131r. \u00d6rne\u011fin, <code>A1<\/code> h\u00fccresindeki veriyi <code>B1<\/code> h\u00fccresine almak i\u00e7in, <code>B1<\/code> h\u00fccresine <code>=A1<\/code> form\u00fcl\u00fcn\u00fc yazabilirsiniz. Bu, <code>A1<\/code> h\u00fccresindeki veriyi <code>B1<\/code> h\u00fccresinde g\u00f6sterir.<\/p>\n<p>Di\u011fer bir y\u00f6ntem ise &#8220;D\u00dc\u015eEYARA&#8221; veya &#8220;\u0130ND\u0130S&#8221; ve &#8220;KA\u00c7INCI&#8221; fonksiyonlar\u0131n\u0131n kullan\u0131m\u0131d\u0131r. Bu fonksiyonlar, daha karma\u015f\u0131k veri al\u0131\u015fveri\u015flerinde ve belirli ko\u015fullara g\u00f6re veri \u00e7ekmek istedi\u011finiz durumlarda kullan\u0131l\u0131r. \u00d6rne\u011fin, bir listeye dayal\u0131 olarak belirli bir de\u011feri getirmek i\u00e7in bu fonksiyonlar tercih edilebilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_bol_formulu\"><\/span>excel b\u00f6l form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de b\u00f6lme i\u015flemi i\u00e7in basit bir form\u00fcl kullan\u0131l\u0131r. B\u00f6lme i\u015flemini ger\u00e7ekle\u015ftirmek istedi\u011finiz iki say\u0131y\u0131 veya h\u00fccre referans\u0131n\u0131 &#8220;\/&#8221; i\u015faretiyle ay\u0131rarak bu i\u015flemi yapabilirsiniz. \u00d6rne\u011fin, <code>A1<\/code> h\u00fccresindeki say\u0131y\u0131 <code>B1<\/code> h\u00fccresindeki say\u0131ya b\u00f6lmek i\u00e7in <code>=A1\/B1<\/code> \u015feklinde bir form\u00fcl kullanabilirsiniz. Bu form\u00fcl, <code>A1<\/code> h\u00fccresindeki de\u011feri <code>B1<\/code> h\u00fccresindeki de\u011fere b\u00f6ler ve sonucu d\u00f6nd\u00fcr\u00fcr. Bu t\u00fcr basit aritmetik i\u015flemler, Excel&#8217;de veri i\u015fleme ve analizi i\u00e7in temel yetenekler aras\u0131ndad\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_bugun_tarih_formulu\"><\/span>excel bug\u00fcn tarih form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de mevcut tarihi (bug\u00fcn\u00fcn tarihini) almak i\u00e7in &#8220;BUG\u00dcN&#8221; fonksiyonunu kullanabilirsiniz. Bu fonksiyon, bilgisayar\u0131n\u0131z\u0131n sistem tarihini kullanarak o anki tarihi d\u00f6nd\u00fcr\u00fcr.<\/p>\n<p>Fonksiyonun kullan\u0131m\u0131 olduk\u00e7a basittir ve herhangi bir arg\u00fcman almaz:<br \/>\n<code>=BUG\u00dcN()<\/code><br \/>\nBu form\u00fcl\u00fc bir h\u00fccreye yazd\u0131\u011f\u0131n\u0131zda, o h\u00fccre otomatik olarak o g\u00fcn\u00fcn tarihini g\u00f6sterecektir. Bu fonksiyon, tarihle ilgili hesaplamalarda, \u00f6zellikle de g\u00fcncel tarihe ba\u011fl\u0131 olarak de\u011fi\u015fen verileri y\u00f6netirken olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. \u00d6rne\u011fin, belirli bir tarihe kadar ge\u00e7en g\u00fcn say\u0131s\u0131n\u0131 hesaplamak i\u00e7in &#8220;BUG\u00dcN&#8221; fonksiyonunu kullanabilirsiniz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_bul_degistir_formulu\"><\/span>excel bul de\u011fi\u015ftir form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de metinleri bulma ve de\u011fi\u015ftirme i\u015flemleri i\u00e7in &#8220;BUL&#8221; ve &#8220;DE\u011e\u0130\u015eT\u0130R&#8221; fonksiyonlar\u0131n\u0131 kullanabilirsiniz. &#8220;BUL&#8221; fonksiyonu belirli bir metin i\u00e7inde bir kelime veya ifadeyi bulur ve &#8220;DE\u011e\u0130\u015eT\u0130R&#8221; fonksiyonu bu bulunan metni yeni bir metinle de\u011fi\u015ftirir.<\/p>\n<p>\u0130\u015fte bu i\u015flemleri ger\u00e7ekle\u015ftirmek i\u00e7in kullanabilece\u011finiz temel form\u00fcller:<\/p>\n<ol>\n<li><strong>Metni Bulma (BUL Fonksiyonu)<\/strong>:<br \/>\n<code>=BUL(arama_metni, metin)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>arama_metni<\/code>: Arad\u0131\u011f\u0131n\u0131z kelime veya ifade.<\/li>\n<li><code>metin<\/code>: Arama yapmak istedi\u011finiz metin.<\/li>\n<\/ul>\n<p>\u00d6rne\u011fin, A1 h\u00fccresindeki metinde &#8220;Excel&#8221; kelimesini bulmak i\u00e7in:<br \/>\n<code>=BUL(\"Excel\", A1)<br \/>\n<\/code><\/li>\n<li><strong>Metni De\u011fi\u015ftirme (DE\u011e\u0130\u015eT\u0130R Fonksiyonu)<\/strong>:<br \/>\n<code>=DE\u011e\u0130\u015eT\u0130R(metin, ba\u015flang\u0131\u00e7_noktas\u0131, uzunluk, yeni_metin)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>metin<\/code>: De\u011fi\u015ftirmek istedi\u011finiz metin.<\/li>\n<li><code>ba\u015flang\u0131\u00e7_noktas\u0131<\/code>: De\u011fi\u015ftirmeye ba\u015flamak istedi\u011finiz metindeki karakterin konumu.<\/li>\n<li><code>uzunluk<\/code>: De\u011fi\u015ftirmek istedi\u011finiz metindeki karakter say\u0131s\u0131.<\/li>\n<li><code>yeni_metin<\/code>: Eski metni yerine koymak istedi\u011finiz yeni metin.<\/li>\n<\/ul>\n<p>\u00d6rne\u011fin, A1 h\u00fccresindeki metindeki &#8220;Excel&#8221; kelimesini &#8220;Microsoft Excel&#8221; ile de\u011fi\u015ftirmek i\u00e7in:<br \/>\n<code>=DE\u011e\u0130\u015eT\u0130R(A1, BUL(\"Excel\", A1), UZUN(\"Excel\"), \"Microsoft Excel\")<\/code><\/li>\n<\/ol>\n<p>Bu form\u00fcller, belirli metinleri h\u0131zl\u0131ca bulma ve de\u011fi\u015ftirme i\u015flemleri i\u00e7in kullan\u0131l\u0131r. Excel&#8217;de daha fazla metin i\u015fleme i\u015flemi i\u00e7in bu fonksiyonlar\u0131 kullanabilirsiniz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_buyuk_formulu\"><\/span>excel b\u00fcy\u00fck form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de metinleri b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in &#8220;B\u00dcY\u00dcK&#8221; fonksiyonunu kullanabilirsiniz. Bu fonksiyon, bir metin dizisini b\u00fcy\u00fck harfle yazd\u0131r\u0131r.<\/p>\n<p>Fonksiyonun kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=B\u00dcY\u00dcK(metin)<\/code><\/p>\n<ul>\n<li><code>metin<\/code>: B\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek istedi\u011finiz metin veya h\u00fccre referans\u0131.<\/li>\n<\/ul>\n<p>\u00d6rnek olarak, A1 h\u00fccresindeki metni b\u00fcy\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=B\u00dcY\u00dcK(A1)<\/code><br \/>\nBu form\u00fcl, A1 h\u00fccresindeki metni tamamen b\u00fcy\u00fck harfle d\u00f6nd\u00fcrecektir. Bu fonksiyon, verileri d\u00fczenlemek veya belirli bir formata getirmek istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_en_kucuk_degeri_bulma\"><\/span>excel en k\u00fc\u00e7\u00fck de\u011feri bulma<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de bir veri aral\u0131\u011f\u0131ndaki en k\u00fc\u00e7\u00fck de\u011feri bulmak i\u00e7in &#8220;ENK\u00dc\u00c7\u00dcK&#8221; fonksiyonunu kullanabilirsiniz. Bu fonksiyon, belirli bir veri aral\u0131\u011f\u0131ndaki en k\u00fc\u00e7\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr. ENK\u00dc\u00c7\u00dcK fonksiyonunun temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=ENK\u00dc\u00c7\u00dcK(aral\u0131k)<\/code><\/p>\n<ul>\n<li><code>aral\u0131k<\/code>: En k\u00fc\u00e7\u00fck de\u011feri bulmak istedi\u011finiz veri aral\u0131\u011f\u0131 veya h\u00fccre referans\u0131.<\/li>\n<\/ul>\n<p>\u00d6rne\u011fin, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerdeki en k\u00fc\u00e7\u00fck de\u011feri bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=ENK\u00dc\u00c7\u00dcK(A1:A10)<\/code><br \/>\nBu form\u00fcl, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerdeki en k\u00fc\u00e7\u00fck de\u011feri bulacakt\u0131r. ENK\u00dc\u00c7\u00dcK fonksiyonu, veri analizi ve s\u0131ralama i\u015flemleri s\u0131ras\u0131nda s\u0131k\u00e7a kullan\u0131l\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_en_yakin_sayiyi_bulma\"><\/span>excel en yak\u0131n say\u0131y\u0131 bulma<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de bir veri aral\u0131\u011f\u0131 i\u00e7indeki en yak\u0131n say\u0131y\u0131 bulmak i\u00e7in &#8220;YAKIN&#8221; veya &#8220;YAKIN.DAHA.B\u00dcY\u00dcK&#8221; fonksiyonlar\u0131n\u0131 kullanabilirsiniz. Bu fonksiyonlar, belirli bir say\u0131ya en yak\u0131n de\u011feri d\u00f6nd\u00fcrmenize yard\u0131mc\u0131 olur.<\/p>\n<ol>\n<li><strong>YAKIN Fonksiyonu:<\/strong>\n<ul>\n<li>Bu fonksiyon, belirli bir say\u0131ya en yak\u0131n de\u011feri d\u00f6nd\u00fcr\u00fcr. Yani, veri aral\u0131\u011f\u0131 i\u00e7indeki say\u0131lar aras\u0131ndan belirledi\u011finiz say\u0131ya en yak\u0131n olan\u0131n\u0131 se\u00e7er.<\/li>\n<li>Temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=YAKIN(hedef_say\u0131, aral\u0131k, s\u0131ralama)<br \/>\n<\/code><\/li>\n<li><code>hedef_say\u0131<\/code>: En yak\u0131n de\u011feri bulmak istedi\u011finiz hedef say\u0131.<\/li>\n<li><code>aral\u0131k<\/code>: En yak\u0131n de\u011feri aramak istedi\u011finiz veri aral\u0131\u011f\u0131 veya h\u00fccre referans\u0131.<\/li>\n<li><code>s\u0131ralama<\/code> (iste\u011fe ba\u011fl\u0131): -1, 0 veya 1 de\u011ferlerinden birini al\u0131r. -1, en yak\u0131n de\u011ferin daha k\u00fc\u00e7\u00fck olan\u0131n\u0131 se\u00e7er. 0, kesirli say\u0131lar\u0131 da dikkate al\u0131r. 1, en yak\u0131n de\u011ferin daha b\u00fcy\u00fck olan\u0131n\u0131 se\u00e7er.<\/li>\n<\/ul>\n<\/li>\n<li><strong>YAKIN.DAHA.B\u00dcY\u00dcK Fonksiyonu:<\/strong>\n<ul>\n<li>Bu fonksiyon, belirli bir say\u0131ya e\u015fit veya daha b\u00fcy\u00fck olan ilk de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/li>\n<li>Temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=YAKIN.DAHA.B\u00dcY\u00dcK(hedef_say\u0131, aral\u0131k)<br \/>\n<\/code><\/li>\n<li><code>hedef_say\u0131<\/code>: E\u015fit veya daha b\u00fcy\u00fck olan ilk de\u011feri bulmak istedi\u011finiz hedef say\u0131.<\/li>\n<li><code>aral\u0131k<\/code>: De\u011ferleri aramak istedi\u011finiz veri aral\u0131\u011f\u0131 veya h\u00fccre referans\u0131.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>\u00d6rnek olarak, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerdeki say\u0131lar aras\u0131ndan 7&#8217;ye en yak\u0131n say\u0131y\u0131 veya 7&#8217;den b\u00fcy\u00fck veya e\u015fit olan ilk say\u0131y\u0131 bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fclleri kullanabilirsiniz:<br \/>\n<code>=YAKIN(7, A1:A10, 1)  \/\/ 7'ye en yak\u0131n b\u00fcy\u00fck say\u0131y\u0131 bulur.<br \/>\n<\/code><br \/>\nveya<br \/>\n<code>=YAKIN.DAHA.B\u00dcY\u00dcK(7, A1:A10)  \/\/ 7'ye e\u015fit veya daha b\u00fcy\u00fck ilk say\u0131y\u0131 bulur.<br \/>\n<\/code><br \/>\nBu fonksiyonlar, belirli bir de\u011fere en yak\u0131n olan veya belirli bir de\u011feri a\u015fan ilk de\u011feri bulman\u0131za yard\u0131mc\u0131 olur.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_esit_degil_formulu\"><\/span>excel e\u015fit de\u011fil form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de iki de\u011ferin e\u015fit olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in &#8220;E\u015e\u0130T DE\u011e\u0130L&#8221; fonksiyonunu veya operat\u00f6r\u00fcn\u00fc kullanabilirsiniz. \u0130\u015fte bu i\u015flemi ger\u00e7ekle\u015ftirmek i\u00e7in iki farkl\u0131 yol:<\/p>\n<ol>\n<li><strong>E\u015e\u0130T DE\u011e\u0130L Fonksiyonu:<\/strong>\n<ul>\n<li>&#8220;E\u015e\u0130T DE\u011e\u0130L&#8221; fonksiyonu, iki de\u011ferin e\u015fit olup olmad\u0131\u011f\u0131n\u0131 kontrol eder ve sonu\u00e7 olarak &#8220;DO\u011eRU&#8221; veya &#8220;YANLI\u015e&#8221; d\u00f6nd\u00fcr\u00fcr.<\/li>\n<li>Temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=E\u015e\u0130TDE\u011e\u0130L(de\u011fer1, de\u011fer2)<br \/>\n<\/code><\/li>\n<li><code>de\u011fer1<\/code>: Kar\u015f\u0131la\u015ft\u0131r\u0131lacak ilk de\u011fer.<\/li>\n<li><code>de\u011fer2<\/code>: Kar\u015f\u0131la\u015ft\u0131r\u0131lacak ikinci de\u011fer.<\/li>\n<li>E\u011fer <code>de\u011fer1<\/code> ve <code>de\u011fer2<\/code> e\u015fitse, fonksiyon &#8220;YANLI\u015e&#8221; d\u00f6nd\u00fcr\u00fcr; aksi takdirde &#8220;DO\u011eRU&#8221; d\u00f6nd\u00fcr\u00fcr.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>\u00d6rnek olarak, A1 h\u00fccresindeki de\u011fer ile B1 h\u00fccresindeki de\u011ferin e\u015fit olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=E\u015e\u0130TDE\u011e\u0130L(A1, B1)<br \/>\n<\/code><\/p>\n<ol start=\"2\">\n<li><strong>E\u015fit De\u011fil Operat\u00f6r\u00fc:<\/strong>\n<ul>\n<li>Excel&#8217;de &#8220;E\u015fit De\u011fil&#8221; operat\u00f6r\u00fc &#8220;&lt;&gt;&#8221; i\u015fareti ile temsil edilir.<\/li>\n<li>Bu operat\u00f6r\u00fc kullanarak iki de\u011ferin e\u015fit olup olmad\u0131\u011f\u0131n\u0131 do\u011frudan kontrol edebilirsiniz.<\/li>\n<li>\u00d6rne\u011fin, A1 ve B1 h\u00fccrelerindeki de\u011ferlerin e\u015fit olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in \u015fu form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=A1 &lt;&gt; B1<br \/>\n<\/code><\/li>\n<li>Bu form\u00fcl, A1 ve B1 h\u00fccrelerindeki de\u011ferler farkl\u0131 ise &#8220;DO\u011eRU&#8221; d\u00f6nd\u00fcrecektir; aksi takdirde &#8220;YANLI\u015e&#8221; d\u00f6nd\u00fcrecektir.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Her iki y\u00f6ntem de iki de\u011ferin e\u015fit olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in kullan\u0131\u015fl\u0131d\u0131r, ve tercihinize ba\u011fl\u0131 olarak hangi y\u00f6ntemi kullanaca\u011f\u0131n\u0131z\u0131 se\u00e7ebilirsiniz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_etopla_formulu\"><\/span>excel etopla form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de toplama i\u015flemi yapmak i\u00e7in &#8220;TOPLA&#8221; fonksiyonunu kullanabilirsiniz. TOPLA fonksiyonu, belirli bir h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131lar\u0131 toplar. Temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=TOPLA(h\u00fccre_aral\u0131\u011f\u01311, [h\u00fccre_aral\u0131\u011f\u01312], ...)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>h\u00fccre_aral\u0131\u011f\u01311<\/code>: Toplamak istedi\u011finiz ilk h\u00fccre aral\u0131\u011f\u0131 veya h\u00fccre referans\u0131.<\/li>\n<li><code>[h\u00fccre_aral\u0131\u011f\u01312], ...<\/code> (iste\u011fe ba\u011fl\u0131): Ek h\u00fccre aral\u0131klar\u0131 ekleyebilirsiniz. Birden fazla h\u00fccre aral\u0131\u011f\u0131 toplanabilir.<\/li>\n<\/ul>\n<p>\u00d6rnek olarak, A1&#8217;den A5&#8217;e kadar olan h\u00fccrelerdeki say\u0131lar\u0131 toplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=TOPLA(A1:A5)<br \/>\n<\/code><br \/>\nBu form\u00fcl, A1, A2, A3, A4 ve A5 h\u00fccrelerindeki say\u0131lar\u0131 toplar ve sonucu verir.<\/p>\n<p>Ayr\u0131ca, virg\u00fclle ayr\u0131lm\u0131\u015f birden fazla h\u00fccre aral\u0131\u011f\u0131n\u0131 da ayn\u0131 form\u00fcl i\u00e7inde kullanabilirsiniz. \u00d6rne\u011fin, A1&#8217;den A5&#8217;e kadar olan h\u00fccrelerle B1&#8217;den B5&#8217;e kadar olan h\u00fccrelerdeki say\u0131lar\u0131 toplamak i\u00e7in \u015fu form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=TOPLA(A1:A5, B1:B5)<br \/>\n<\/code><br \/>\nTOPLA fonksiyonu, Excel&#8217;de say\u0131lar\u0131 toplamak i\u00e7in yayg\u0131n olarak kullan\u0131lan bir fonksiyondur.<\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_count_formulu\"><\/span>excel count form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de &#8220;COUNT&#8221; fonksiyonu, belirli bir aral\u0131ktaki veya h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131sal de\u011ferlerin say\u0131s\u0131n\u0131 saymak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, veri analizi ve say\u0131sal verilerle \u00e7al\u0131\u015f\u0131rken olduk\u00e7a faydal\u0131d\u0131r.<\/p>\n<p>COUNT fonksiyonunun temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=COUNT(aral\u0131k)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>aral\u0131k<\/code>: Saymak istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131 veya de\u011ferlerin bulundu\u011fu aral\u0131k.<\/li>\n<\/ul>\n<p>\u00d6rnek olarak, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerde ka\u00e7 tane say\u0131sal de\u011fer oldu\u011funu saymak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=COUNT(A1:A10)<\/code><br \/>\nBu form\u00fcl, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerde ka\u00e7 tane say\u0131sal de\u011fer oldu\u011funu sayar.<\/p>\n<p>COUNT fonksiyonu, verilerin analizi s\u0131ras\u0131nda bo\u015f olmayan h\u00fccrelerin say\u0131lmas\u0131, toplam de\u011ferlerin say\u0131lmas\u0131 veya belirli bir ko\u015fulu kar\u015f\u0131layan h\u00fccrelerin say\u0131lmas\u0131 gibi bir\u00e7ok farkl\u0131 senaryoda kullan\u0131labilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_calisma_tablosu_kac_sutundan_olusur\"><\/span>excel \u00e7al\u0131\u015fma tablosu ka\u00e7 s\u00fctundan olu\u015fur<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel \u00e7al\u0131\u015fma tablosu (workbook) varsay\u0131lan olarak 256 s\u00fctundan olu\u015fur. Ancak bu s\u00fctun say\u0131s\u0131 kullan\u0131lan Excel s\u00fcr\u00fcm\u00fcne ve ayarlamalara ba\u011fl\u0131 olarak de\u011fi\u015febilir. Daha eski Excel s\u00fcr\u00fcmleri 2003 \u00f6ncesinde 256 s\u00fctunla s\u0131n\u0131rl\u0131yd\u0131, ancak daha yeni s\u00fcr\u00fcmler daha fazla s\u00fctun desteklemektedir. Excel 2016 ve sonraki s\u00fcr\u00fcmler, 16.384 s\u00fctuna kadar destekleyebilir.<\/p>\n<p>S\u00fctun say\u0131s\u0131n\u0131 art\u0131rmak veya azaltmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz:<\/p>\n<ol>\n<li>Excel&#8217;de bir \u00e7al\u0131\u015fma tablosu a\u00e7\u0131n veya yeni bir \u00e7al\u0131\u015fma tablosu olu\u015fturun.<\/li>\n<li>&#8220;Dosya&#8221; men\u00fcs\u00fcnden &#8220;Se\u00e7enekler&#8221; veya &#8220;Excel Se\u00e7enekleri&#8221; se\u00e7ene\u011fine gidin.<\/li>\n<li>&#8220;Form\u00fcl&#8221; veya &#8220;Form\u00fcller&#8221; sekmesini se\u00e7in.<\/li>\n<li>&#8220;\u00c7al\u0131\u015fma Kitab\u0131&#8221; veya &#8220;Workbooks&#8221; b\u00f6l\u00fcm\u00fcnde &#8220;D\u00fczenleme Se\u00e7enekleri&#8221; veya &#8220;Editing Options&#8221; gibi bir se\u00e7enek bulunur.<\/li>\n<li>Bu se\u00e7enekleri kullanarak s\u00fctun say\u0131s\u0131n\u0131 art\u0131rabilir veya azaltabilirsiniz.<\/li>\n<\/ol>\n<p>Excel&#8217;de s\u00fctun say\u0131s\u0131n\u0131 art\u0131r\u0131rken, kullan\u0131labilir fiziksel belle\u011fi ve bilgisayar\u0131n\u0131z\u0131n i\u015flem kapasitesini dikkate almal\u0131s\u0131n\u0131z, \u00e7\u00fcnk\u00fc daha fazla s\u00fctun daha fazla kaynak gerektirebilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_carpma_formulu\"><\/span>excel \u00e7arpma form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de \u00e7arpma i\u015flemi i\u00e7in basit bir form\u00fcl kullanabilirsiniz. \u00c7arpma i\u015flemini ger\u00e7ekle\u015ftirmek istedi\u011finiz iki say\u0131y\u0131 veya h\u00fccre referans\u0131n\u0131 &#8220;*&#8221; i\u015faretiyle ay\u0131rarak bu i\u015flemi yapabilirsiniz. \u0130\u015fte temel \u00e7arpma form\u00fcl\u00fc:<br \/>\n<code>=Say\u01311 * Say\u01312<br \/>\n<\/code><\/p>\n<ul>\n<li><code>Say\u01311<\/code> ve <code>Say\u01312<\/code>: \u00c7arpmak istedi\u011finiz say\u0131lar veya h\u00fccre referanslar\u0131.<\/li>\n<\/ul>\n<p>\u00d6rnek olarak, A1 h\u00fccresindeki say\u0131y\u0131 B1 h\u00fccresindeki say\u0131yla \u00e7arpmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=A1 * B1<br \/>\n<\/code><br \/>\nBu form\u00fcl, A1 h\u00fccresindeki de\u011feri B1 h\u00fccresindeki de\u011ferle \u00e7arpar ve sonucu d\u00f6nd\u00fcr\u00fcr. Excel&#8217;de \u00e7arpma i\u015flemi, matematiksel hesaplamalar veya veri analizi s\u0131ras\u0131nda s\u0131k\u00e7a kullan\u0131l\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_cikarma_islemi_formulu\"><\/span>excel \u00e7\u0131karma i\u015flemi form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de \u00e7\u0131karma i\u015flemi i\u00e7in basit bir form\u00fcl kullanabilirsiniz. \u00c7\u0131karma i\u015flemini ger\u00e7ekle\u015ftirmek istedi\u011finiz iki say\u0131y\u0131 veya h\u00fccre referans\u0131n\u0131 &#8220;-&#8221; i\u015faretiyle ay\u0131rarak bu i\u015flemi yapabilirsiniz. \u0130\u015fte temel \u00e7\u0131karma form\u00fcl\u00fc:<br \/>\n<code>=Say\u01311 - Say\u01312<br \/>\n<\/code><\/p>\n<ul>\n<li><code>Say\u01311<\/code>: \u00c7\u0131karmak istedi\u011finiz ilk say\u0131 veya h\u00fccre referans\u0131.<\/li>\n<li><code>Say\u01312<\/code>: \u00c7\u0131kart\u0131lacak ikinci say\u0131 veya h\u00fccre referans\u0131.<\/li>\n<\/ul>\n<p>\u00d6rnek olarak, A1 h\u00fccresindeki say\u0131dan B1 h\u00fccresindeki say\u0131y\u0131 \u00e7\u0131karmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=A1 - B1<\/code><br \/>\nBu form\u00fcl, A1 h\u00fccresindeki de\u011ferden B1 h\u00fccresindeki de\u011feri \u00e7\u0131kar\u0131r ve sonucu d\u00f6nd\u00fcr\u00fcr. Excel&#8217;de \u00e7\u0131karma i\u015flemi, matematiksel hesaplamalar veya veri analizi s\u0131ras\u0131nda s\u0131k\u00e7a kullan\u0131l\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_birlestir_formulu\"><\/span>excel birle\u015ftir form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de h\u00fccreleri birle\u015ftirmek i\u00e7in &#8220;B\u0130RLE\u015eT\u0130R&#8221; fonksiyonunu veya &#8220;&amp;&#8221; operat\u00f6r\u00fcn\u00fc kullanabilirsiniz. Bu, metin veya de\u011ferleri bir araya getirmek i\u00e7in kullan\u0131\u015fl\u0131d\u0131r. \u0130\u015fte her iki y\u00f6ntemin kullan\u0131m\u0131:<\/p>\n<ol>\n<li><strong>B\u0130RLE\u015eT\u0130R Fonksiyonu Kullanarak<\/strong>: B\u0130RLE\u015eT\u0130R fonksiyonu, belirtilen metin veya h\u00fccreleri birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r. \u0130\u015fte temel kullan\u0131m\u0131:<br \/>\n<code>=B\u0130RLE\u015eT\u0130R(metin1, metin2, ...)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>metin1<\/code>, <code>metin2<\/code>, &#8230;: Birle\u015ftirmek istedi\u011finiz metin veya h\u00fccre referanslar\u0131.<\/li>\n<\/ul>\n<p>\u00d6rne\u011fin, A1 h\u00fccresindeki metni B1 h\u00fccresindeki metinle birle\u015ftirmek i\u00e7in:<br \/>\n<code>=B\u0130RLE\u015eT\u0130R(A1, \" \", B1)<br \/>\n<\/code><br \/>\nBu form\u00fcl, A1 h\u00fccresindeki metni ve B1 h\u00fccresindeki metni birle\u015ftirir ve aralar\u0131na bo\u015fluk ekler.<\/li>\n<li><strong>&amp; Operat\u00f6r\u00fcn\u00fc Kullanarak<\/strong>: &amp; operat\u00f6r\u00fc, metin veya h\u00fccreleri birle\u015ftirmek i\u00e7in kullanabilece\u011finiz bir operat\u00f6rd\u00fcr. \u0130\u015fte temel kullan\u0131m\u0131:<br \/>\n<code>=metin1 &amp; metin2<br \/>\n<\/code><\/p>\n<ul>\n<li><code>metin1<\/code> ve <code>metin2<\/code>: Birle\u015ftirmek istedi\u011finiz metin veya h\u00fccre referanslar\u0131.<\/li>\n<\/ul>\n<p>\u00d6rne\u011fin, A1 h\u00fccresindeki metni B1 h\u00fccresindeki metinle birle\u015ftirmek i\u00e7in:<br \/>\n<code>=A1 &amp; \" \" &amp; B1<br \/>\n<\/code><br \/>\nBu form\u00fcl, A1 h\u00fccresindeki metni ve B1 h\u00fccresindeki metni birle\u015ftirir ve aralar\u0131na bo\u015fluk ekler.<\/li>\n<\/ol>\n<p>Her iki y\u00f6ntem de metinleri veya de\u011ferleri istedi\u011finiz \u015fekilde birle\u015ftirmenize olanak tan\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_cift_tirnak_isareti\"><\/span>excel \u00e7ift t\u0131rnak i\u015fareti<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de \u00e7ift t\u0131rnak i\u015faretini metin veya form\u00fcller i\u00e7inde kullanmak i\u00e7in iki farkl\u0131 kullan\u0131m vard\u0131r:<\/p>\n<ol>\n<li><strong>Metin \u0130\u00e7inde \u00c7ift T\u0131rnak<\/strong>: \u00c7ift t\u0131rnak i\u015fareti ile \u00e7evrilen metin, metin olarak kabul edilir ve h\u00fccreye bu metin olarak yaz\u0131l\u0131r. \u00d6rne\u011fin, h\u00fccreye <code>A1<\/code> yazmak yerine <code>\"A1\"<\/code> yazarsan\u0131z, h\u00fccreye &#8220;A1&#8221; metni yaz\u0131l\u0131r.<\/li>\n<li><strong>Form\u00fcl \u0130\u00e7inde \u00c7ift T\u0131rnak<\/strong>: Form\u00fcller i\u00e7inde \u00e7ift t\u0131rnak i\u015fareti, metinleri tan\u0131mlamak i\u00e7in kullan\u0131l\u0131r. \u00d6zellikle metin i\u00e7eren form\u00fcllerde \u00e7ift t\u0131rnak i\u015fareti kullanabilirsiniz. \u00d6rne\u011fin, bir h\u00fccredeki metni di\u011fer bir h\u00fccrede kullanmak i\u00e7in a\u015fa\u011f\u0131daki gibi bir form\u00fcl kullanabilirsiniz:<br \/>\n<code>=A1 &amp; \" metni\"<br \/>\n<\/code><br \/>\nBu form\u00fcl, A1 h\u00fccresindeki metni al\u0131r ve sonuna &#8221; metni&#8221; ekler.<\/li>\n<\/ol>\n<p>\u00c7ift t\u0131rnak i\u015fareti Excel&#8217;de metin veya form\u00fcller i\u00e7inde kullan\u0131labilecek basit bir metin i\u015fareti olarak kullan\u0131l\u0131r ve metin i\u00e7inde t\u0131rnak i\u015fareti kullanman\u0131z\u0131 sa\u011flar.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_de_buton_olusturma\"><\/span>excel de buton olu\u015fturma<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de bir buton olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz. Bu ad\u0131mlar, Excel&#8217;in Windows s\u00fcr\u00fcm\u00fcne dayal\u0131d\u0131r ve farkl\u0131 s\u00fcr\u00fcmlerde veya i\u015fletim sistemlerinde hafif de\u011fi\u015fiklikler g\u00f6sterebilir:<\/p>\n<ol>\n<li>Excel \u00e7al\u0131\u015fma tablonuzu a\u00e7\u0131n.<\/li>\n<li>&#8220;Geli\u015ftirici&#8221; sekmesini g\u00f6r\u00fcnt\u00fclemek i\u00e7in Excel men\u00fcs\u00fcnde &#8220;Dosya&#8221; &gt; &#8220;Se\u00e7enekler&#8221; &gt; &#8220;\u00d6zelle\u015ftirme Sekmesi&#8221; yolunu izleyin. &#8220;Geli\u015ftirici&#8221; kutusunu i\u015faretleyin ve &#8220;Tamam&#8221; d\u00fc\u011fmesine t\u0131klay\u0131n.<\/li>\n<li>&#8220;Geli\u015ftirici&#8221; sekmesi g\u00f6r\u00fcn\u00fcr hale geldi\u011finde, bu sekme \u00fczerinde &#8220;Ekle&#8221; b\u00f6l\u00fcm\u00fcn\u00fc bulun.<\/li>\n<li>&#8220;Ekle&#8221; b\u00f6l\u00fcm\u00fcnde, &#8220;D\u00fc\u011fme (ActiveX Kontrol\u00fc)&#8221; veya &#8220;D\u00fc\u011fme (Form Kontrol\u00fc)&#8221; se\u00e7eneklerinden birini se\u00e7ebilirsiniz. Her ikisi de buton eklemenize izin verir, ancak kullan\u0131m ama\u00e7lar\u0131n\u0131za ba\u011fl\u0131 olarak farkl\u0131l\u0131klar g\u00f6sterebilir.\n<ul>\n<li>&#8220;D\u00fc\u011fme (ActiveX Kontrol\u00fc)&#8221;: Bu se\u00e7enek, daha geli\u015fmi\u015f interaktif formlar ve butonlar olu\u015fturman\u0131za olanak tan\u0131r.<\/li>\n<li>&#8220;D\u00fc\u011fme (Form Kontrol\u00fc)&#8221;: Bu se\u00e7enek daha temel butonlar olu\u015fturman\u0131za olanak tan\u0131r.<\/li>\n<\/ul>\n<\/li>\n<li>\u0130lgili se\u00e7ene\u011fi se\u00e7tikten sonra, \u00e7al\u0131\u015fma tablonuz \u00fczerinde butonunuzu \u00e7izmek i\u00e7in fareyi kullanabilirsiniz. Butonun boyutunu ve konumunu belirleyebilirsiniz.<\/li>\n<li>Butonun sa\u011f t\u0131klanabilir \u00f6zelliklerini ayarlamak i\u00e7in sa\u011f t\u0131klay\u0131n ve &#8220;\u00d6zellikler&#8221; veya benzeri bir se\u00e7enek se\u00e7in. Burada butonun ad\u0131n\u0131, metnini ve t\u0131klanabilir i\u015flevini ayarlayabilirsiniz.<\/li>\n<li>Butona \u00e7ift t\u0131klad\u0131\u011f\u0131n\u0131zda veya t\u0131klad\u0131\u011f\u0131n\u0131zda ger\u00e7ekle\u015fmesini istedi\u011finiz eylemi belirlemek i\u00e7in bir &#8220;Makro&#8221; atayabilirsiniz. Makro olu\u015fturmak ve atamak i\u00e7in &#8220;Geli\u015ftirici&#8221; sekmesi alt\u0131nda &#8220;Visual Basic&#8221; d\u00fc\u011fmesini kullanabilirsiniz.<\/li>\n<li>Butonunuz art\u0131k \u00e7al\u0131\u015fma tablonuzda bulunuyor ve t\u0131klanabilir durumda. \u0130stedi\u011finiz i\u015flemi ger\u00e7ekle\u015ftirmek i\u00e7in butona t\u0131klayabilirsiniz.<\/li>\n<\/ol>\n<p>Unutmay\u0131n ki butonlar\u0131n kullan\u0131m\u0131 ve \u00f6zellikleri, se\u00e7ti\u011finiz buton t\u00fcr\u00fcne ve Excel s\u00fcr\u00fcm\u00fcne ba\u011fl\u0131 olarak de\u011fi\u015febilir. Bu ad\u0131mlar, temel bir buton olu\u015fturma s\u00fcrecini a\u00e7\u0131klar ve daha fazla \u00f6zelle\u015ftirme se\u00e7ene\u011fi vard\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_de_buyuk_kucuk_isareti_nasil_yapilir\"><\/span>excel de b\u00fcy\u00fck k\u00fc\u00e7\u00fck i\u015fareti nas\u0131l yap\u0131l\u0131r<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de b\u00fcy\u00fck veya k\u00fc\u00e7\u00fck i\u015faretleri olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/p>\n<p><strong>B\u00fcy\u00fck \u0130\u015fareti (&gt;) Olu\u015fturmak:<\/strong><\/p>\n<ol>\n<li>Excel \u00e7al\u0131\u015fma tablonuzda bir h\u00fccreye b\u00fcy\u00fck i\u015fareti (&gt;) yazmak i\u00e7in do\u011frudan bu h\u00fccreye t\u0131klay\u0131n veya istedi\u011finiz h\u00fccreyi se\u00e7in.<\/li>\n<li>H\u00fccreye &#8220;&gt;&#8221; i\u015faretini yaz\u0131n ve ENTER tu\u015funa bas\u0131n. \u00d6rne\u011fin, &#8220;A1&#8221; h\u00fccresine &#8220;&gt;5&#8221; yazarak bu h\u00fccrede b\u00fcy\u00fck i\u015fareti olu\u015fturabilirsiniz. Bu, &#8220;5&#8217;ten b\u00fcy\u00fck&#8221; anlam\u0131na gelir.<\/li>\n<\/ol>\n<p><strong>K\u00fc\u00e7\u00fck \u0130\u015fareti (&lt;) Olu\u015fturmak:<\/strong><\/p>\n<ol>\n<li>Excel \u00e7al\u0131\u015fma tablonuzda bir h\u00fccreye k\u00fc\u00e7\u00fck i\u015fareti (&lt;) yazmak i\u00e7in do\u011frudan bu h\u00fccreye t\u0131klay\u0131n veya istedi\u011finiz h\u00fccreyi se\u00e7in.<\/li>\n<li>H\u00fccreye &#8220;&lt;&#8221; i\u015faretini yaz\u0131n ve ENTER tu\u015funa bas\u0131n. \u00d6rne\u011fin, &#8220;B1&#8221; h\u00fccresine &#8220;&lt;10&#8221; yazarak bu h\u00fccrede k\u00fc\u00e7\u00fck i\u015fareti olu\u015fturabilirsiniz. Bu, &#8220;10&#8217;dan k\u00fc\u00e7\u00fck&#8221; anlam\u0131na gelir.<\/li>\n<\/ol>\n<p>Bu ad\u0131mlar, belirli bir h\u00fccreye b\u00fcy\u00fck veya k\u00fc\u00e7\u00fck i\u015fareti eklemek i\u00e7in kullanabilece\u011finiz basit bir yol sa\u011flar. Bu i\u015faretler, \u00f6zellikle veri filtrelemesi veya ko\u015fullu bi\u00e7imlendirme gibi veri analizi i\u015flemlerinde s\u0131k\u00e7a kullan\u0131l\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_de_en_buyuk_sayiyi_bulma_formulu\"><\/span>excel de en b\u00fcy\u00fck say\u0131y\u0131 bulma form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de bir veri aral\u0131\u011f\u0131ndaki en b\u00fcy\u00fck say\u0131y\u0131 bulmak i\u00e7in &#8220;MAKS&#8221; fonksiyonunu kullanabilirsiniz. Bu fonksiyon, belirtilen bir aral\u0131ktaki en b\u00fcy\u00fck say\u0131y\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p>\n<p>MAKS fonksiyonunun temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=MAKS(aral\u0131k)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>aral\u0131k<\/code>: En b\u00fcy\u00fck say\u0131y\u0131 bulmak istedi\u011finiz veri aral\u0131\u011f\u0131 veya h\u00fccre referans\u0131.<\/li>\n<\/ul>\n<p>\u00d6rne\u011fin, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerdeki en b\u00fcy\u00fck say\u0131y\u0131 bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=MAKS(A1:A10)<br \/>\n<\/code><br \/>\nBu form\u00fcl, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerdeki en b\u00fcy\u00fck say\u0131y\u0131 bulacakt\u0131r. Veri aral\u0131\u011f\u0131ndaki en b\u00fcy\u00fck say\u0131y\u0131 bulmak i\u00e7in bu fonksiyonu kullanabilirsiniz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_de_indis_formulu\"><\/span>excel de indis form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de &#8220;\u0130ND\u0130S&#8221; fonksiyonu, belirli bir h\u00fccre aral\u0131\u011f\u0131ndan veya bir dizi de\u011ferden belirli bir s\u0131radaki veya belirli bir sat\u0131rdaki de\u011feri d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. \u0130ND\u0130S fonksiyonunun temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=\u0130ND\u0130S(dizi, sat\u0131r_numaras\u0131, s\u00fctun_numaras\u0131)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>dizi<\/code>: De\u011ferleri i\u00e7eren h\u00fccre aral\u0131\u011f\u0131 veya dizi.<\/li>\n<li><code>sat\u0131r_numaras\u0131<\/code>: Diziden d\u00f6nd\u00fcrmek istedi\u011finiz de\u011ferin bulundu\u011fu sat\u0131r\u0131n numaras\u0131.<\/li>\n<li><code>s\u00fctun_numaras\u0131<\/code> (iste\u011fe ba\u011fl\u0131): Diziden d\u00f6nd\u00fcrmek istedi\u011finiz de\u011ferin bulundu\u011fu s\u00fctunun numaras\u0131. E\u011fer sadece sat\u0131r numaras\u0131 belirtiyorsan\u0131z, bu parametreyi bo\u015f b\u0131rakabilirsiniz.<\/li>\n<\/ul>\n<p>\u00d6rnek olarak, A1&#8217;den B3&#8217;e kadar olan h\u00fccre aral\u0131\u011f\u0131ndan 2. sat\u0131r\u0131n 2. s\u00fctunundaki de\u011feri almak i\u00e7in \u015fu form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=\u0130ND\u0130S(A1:B3, 2, 2)<br \/>\n<\/code><br \/>\nBu form\u00fcl, A1&#8217;den B3&#8217;e kadar olan h\u00fccre aral\u0131\u011f\u0131ndaki 2. sat\u0131r\u0131n 2. s\u00fctunundaki de\u011feri d\u00f6nd\u00fcrecektir.<\/p>\n<p>\u0130ND\u0130S fonksiyonu, veri analizi ve belirli h\u00fccrelerden veri alma i\u015flemleri s\u0131ras\u0131nda kullan\u0131\u015fl\u0131d\u0131r. Ayr\u0131ca, dinamik form\u00fcller olu\u015fturmak i\u00e7in kullan\u0131labilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_de_kalan_gun_hesaplama\"><\/span>excel de kalan g\u00fcn hesaplama<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de bir tarihin bug\u00fcnden sonraki kalan g\u00fcn say\u0131s\u0131n\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz:<\/p>\n<ol>\n<li>\u0130lk olarak, Excel&#8217;de bir h\u00fccreye hedef tarihi girmeniz gerekmektedir. \u00d6rne\u011fin, hedef tarihi A1 h\u00fccresine girelim ve bu h\u00fccreye &#8220;31.12.2024&#8221; gibi bir tarih yazal\u0131m.<\/li>\n<li>Ard\u0131ndan, kalan g\u00fcnleri hesaplamak istedi\u011finiz ba\u015fka bir h\u00fccreyi se\u00e7in. \u00d6rne\u011fin, bu h\u00fccreyi B1 olarak se\u00e7elim.<\/li>\n<li>B1 h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yaz\u0131n ve ENTER tu\u015funa bas\u0131n:<\/li>\n<\/ol>\n<p><code>=A1-G\u00dcN(BUG\u00dcN())<br \/>\n<\/code><br \/>\nBu form\u00fcl, A1 h\u00fccresindeki hedef tarihi bug\u00fcnk\u00fc tarihten \u00e7\u0131kar\u0131r ve kalan g\u00fcn say\u0131s\u0131n\u0131 hesaplar.<\/p>\n<ol start=\"4\">\n<li>B1 h\u00fccresindeki form\u00fcl\u00fc girdikten sonra, B1 h\u00fccresinde hedef tarihe ka\u00e7 g\u00fcn kald\u0131\u011f\u0131n\u0131 g\u00f6receksiniz. Bu, hedef tarihe olan kalan g\u00fcn say\u0131s\u0131n\u0131 g\u00f6sterir.<\/li>\n<\/ol>\n<p>\u00d6rne\u011fin, e\u011fer hedef tarih &#8220;31.12.2024&#8221; olarak belirlediyseniz ve bug\u00fcn &#8220;15.11.2024&#8221; ise, B1 h\u00fccresindeki form\u00fcl &#8220;46&#8221; sonucunu verecektir, \u00e7\u00fcnk\u00fc 31 Aral\u0131k&#8217;a kadar 46 g\u00fcn kalm\u0131\u015ft\u0131r.<\/p>\n<p>Bu \u015fekilde Excel&#8217;de bir tarihin bug\u00fcnden sonraki kalan g\u00fcn say\u0131s\u0131n\u0131 kolayca hesaplayabilirsiniz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_de_ortalama_formulu\"><\/span>excel de ortalama form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de bir veri aral\u0131\u011f\u0131ndaki say\u0131lar\u0131n ortalamas\u0131n\u0131 hesaplamak i\u00e7in &#8220;ORTALAMA&#8221; fonksiyonunu kullanabilirsiniz. Bu fonksiyon, belirli bir veri aral\u0131\u011f\u0131ndaki say\u0131lar\u0131n ortalamas\u0131n\u0131 al\u0131r.<\/p>\n<p>ORTALAMA fonksiyonunun temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=ORTALAMA(aral\u0131k)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>aral\u0131k<\/code>: Ortalamas\u0131n\u0131 almak istedi\u011finiz veri aral\u0131\u011f\u0131 veya h\u00fccre referans\u0131.<\/li>\n<\/ul>\n<p>\u00d6rne\u011fin, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerdeki say\u0131lar\u0131n ortalamas\u0131n\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=ORTALAMA(A1:A10)<br \/>\n<\/code><br \/>\nBu form\u00fcl, A1&#8217;den A10&#8217;a kadar olan h\u00fccrelerdeki say\u0131lar\u0131n ortalamas\u0131n\u0131 hesaplar.<\/p>\n<p>ORTALAMA fonksiyonu, veri analizi s\u0131ras\u0131nda say\u0131lar\u0131n ortalamas\u0131n\u0131 h\u0131zl\u0131 bir \u015fekilde hesaplamak i\u00e7in kullan\u0131\u015fl\u0131d\u0131r. Excel&#8217;de bu t\u00fcr temel istatistiksel hesaplamalar\u0131 kolayca yapabilirsiniz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_devresel_odeme_formulu\"><\/span>excel devresel \u00f6deme form\u00fcl\u00fc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de dairesel \u00f6deme (annuity) hesaplamalar\u0131 i\u00e7in kullanabilece\u011finiz bir form\u00fcl vard\u0131r. Dairesel \u00f6deme, belirli bir s\u00fcre boyunca sabit aral\u0131klarla \u00f6denen miktarlard\u0131r. Bu t\u00fcr hesaplamalar i\u00e7in &#8220;\u00d6DEME&#8221; veya &#8220;PMT&#8221; fonksiyonunu kullanabilirsiniz. \u00d6zellikle kredi taksitleri veya yat\u0131r\u0131m getirileri hesaplamalar\u0131nda bu fonksiyonu kullanabilirsiniz.<\/p>\n<p>\u00d6DEME fonksiyonunun temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<br \/>\n<code>=\u00d6DEME(faiz_oran\u0131, periyot_say\u0131s\u0131, ana_para)<br \/>\n<\/code><\/p>\n<ul>\n<li><code>faiz_oran\u0131<\/code>: D\u00f6nemsel faiz oran\u0131. Y\u0131ll\u0131k faiz oran\u0131n\u0131 d\u00f6nemsel olarak b\u00f6lmelisiniz. \u00d6rne\u011fin, y\u0131ll\u0131k %5 faiz oran\u0131 i\u00e7in ayl\u0131k taksit hesapl\u0131yorsan\u0131z, 0.05\/12 \u015feklinde bir de\u011fer kullanabilirsiniz.<\/li>\n<li><code>periyot_say\u0131s\u0131<\/code>: Toplam \u00f6deme d\u00f6nemi say\u0131s\u0131. \u00d6rne\u011fin, 5 y\u0131l boyunca her ay \u00f6deme yap\u0131l\u0131yorsa, 5*12 = 60 olarak belirtilebilir.<\/li>\n<li><code>ana_para<\/code>: Kredi veya yat\u0131r\u0131m\u0131n ba\u015flang\u0131\u00e7 ana paras\u0131.<\/li>\n<\/ul>\n<p>\u00d6rnek olarak, ayl\u0131k %1 faiz oran\u0131yla 3 y\u0131l boyunca 10.000 TL&#8217;lik bir kredinin ayl\u0131k taksitini hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<br \/>\n<code>=\u00d6DEME(0.01\/12, 3*12, -10000)<br \/>\n<\/code><br \/>\nBu form\u00fcl, ayl\u0131k taksitin ne kadar olmas\u0131 gerekti\u011fini hesaplar. Sonucu negatif i\u015faretlememizin nedeni, \u00f6demelerin para \u00e7\u0131k\u0131\u015flar\u0131n\u0131 temsil etmesidir.<\/p>\n<p>\u00d6DEME fonksiyonu, dairesel \u00f6deme hesaplamalar\u0131 i\u00e7in olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r. Bu hesaplamalar, kredi, yat\u0131r\u0131m veya emeklilik planlamas\u0131 gibi finansal kararlar al\u0131rken s\u0131k\u00e7a kullan\u0131l\u0131r.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"excel_bilinmesi_gerekenler\"><\/span>excel bilinmesi gerekenler<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel&#8217;de bilinmesi gereken baz\u0131 temel konular \u015funlard\u0131r:<\/p>\n<ol>\n<li><strong>Temel Form\u00fcller ve Fonksiyonlar<\/strong>: Toplama, \u00e7\u0131karma, \u00e7arpma, b\u00f6lme gibi temel matematiksel i\u015flemler ve SUM, AVERAGE, MIN, MAX gibi temel fonksiyonlar.<\/li>\n<li><strong>H\u00fccre Referanslar\u0131<\/strong>: Mutlak, g\u00f6receli ve kar\u0131\u015f\u0131k h\u00fccre referanslar\u0131n\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 anlamak.<\/li>\n<li><strong>Tablo Olu\u015fturma ve Bi\u00e7imlendirme<\/strong>: Verilerinizi d\u00fczenli bir \u015fekilde saklamak ve g\u00f6rselle\u015ftirmek i\u00e7in tablolar olu\u015fturmak ve bi\u00e7imlendirmek.<\/li>\n<li><strong>Grafikler ve G\u00f6rselle\u015ftirme<\/strong>: Verileri anlamak ve sunmak i\u00e7in grafikler ve di\u011fer g\u00f6rsel ara\u00e7lar\u0131 kullanma.<\/li>\n<li><strong>Pivot Tablolar\u0131<\/strong>: Verileri \u00f6zetlemek ve analiz etmek i\u00e7in pivot tablolar\u0131 kullanma.<\/li>\n<li><strong>Veri Filtreleme ve S\u0131ralama<\/strong>: B\u00fcy\u00fck veri setlerini y\u00f6netmek i\u00e7in filtreleme ve s\u0131ralama \u00f6zelliklerini kullanma.<\/li>\n<li><strong>Ko\u015fullu Bi\u00e7imlendirme<\/strong>: Verilerinizi belirli ko\u015fullara g\u00f6re otomatik olarak bi\u00e7imlendirmek.<\/li>\n<li><strong>Veri Do\u011frulama<\/strong>: H\u00fccrelere girilen verileri kontrol etmek i\u00e7in veri do\u011frulama ara\u00e7lar\u0131n\u0131 kullanma.<\/li>\n<li><strong>Makrolar ve VBA<\/strong>: Tekrar eden g\u00f6revleri otomatikle\u015ftirmek i\u00e7in basit makrolar yazma ve Visual Basic for Applications (VBA) kullan\u0131m\u0131.<\/li>\n<\/ol>\n<p>Excel, \u00e7ok y\u00f6nl\u00fc ve g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r ve bu temel beceriler, \u00e7o\u011fu temel ve orta d\u00fczey Excel ihtiyac\u0131n\u0131 kar\u015f\u0131lamak i\u00e7in yeterlidir. Daha ileri d\u00fczey kullan\u0131m i\u00e7in ise belirli i\u015flevler ve geli\u015fmi\u015f \u00f6zelliklerin detayl\u0131 incelenmesi gerekebilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_de_hucre_nedir\"><\/span>excel de h\u00fccre nedir<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de &#8220;h\u00fccre,&#8221; elektronik \u00e7al\u0131\u015fma tablosunun temel yap\u0131 ta\u015f\u0131d\u0131r. Bir h\u00fccre, belirli bir sat\u0131r ve s\u00fctun kesi\u015fiminde bulunan k\u00fc\u00e7\u00fck bir kare veya dikd\u00f6rtgen alan\u0131 temsil eder. Excel \u00e7al\u0131\u015fma tablosu, bir\u00e7ok h\u00fccreden olu\u015fur ve her h\u00fccre, belirli bir veriyi, metni, say\u0131y\u0131 veya form\u00fcl\u00fc i\u00e7erebilir.<\/p>\n<p>\u0130\u015fte Excel h\u00fccrelerinin temel \u00f6zellikleri:<\/p>\n<ol>\n<li><strong>Adresleme<\/strong>: Her h\u00fccre, bir adresle (\u00f6rne\u011fin, &#8220;A1&#8221; veya &#8220;C3&#8221;) belirtilir. Bu adres, h\u00fccrenin s\u0131ra ve s\u00fctun konumunu g\u00f6sterir. &#8220;A1&#8221; adresi birinci s\u0131ra ve birinci s\u00fctunda bulunan h\u00fccreyi ifade eder.<\/li>\n<li><strong>Veri Depolama<\/strong>: H\u00fccreler, verileri depolamak i\u00e7in kullan\u0131l\u0131r. Metin, say\u0131, tarih, form\u00fcl veya herhangi bir veri t\u00fcr\u00fcn\u00fc i\u00e7erebilirler.<\/li>\n<li><strong>Form\u00fcller<\/strong>: H\u00fccreler, Excel form\u00fclleri i\u00e7erebilir. Form\u00fcller, h\u00fccrelerdeki verileri i\u015flemek ve hesaplamak i\u00e7in kullan\u0131l\u0131r. \u00d6rne\u011fin, toplama, \u00e7\u0131karma veya ortalama hesaplamalar\u0131 yapmak i\u00e7in form\u00fcller kullan\u0131labilir.<\/li>\n<li><strong>Bi\u00e7imlendirme<\/strong>: H\u00fccrelerin g\u00f6r\u00fcn\u00fcm\u00fc ve bi\u00e7imi \u00f6zelle\u015ftirilebilir. Yaz\u0131 tipi, renk, h\u00fccre kenarl\u0131klar\u0131 ve h\u00fccrenin hizalamas\u0131 gibi bi\u00e7imsel \u00f6zellikler ayarlanabilir.<\/li>\n<li><strong>Ba\u011flant\u0131lar<\/strong>: H\u00fccreler aras\u0131nda ba\u011flant\u0131lar kurabilirsiniz. Bir h\u00fccredeki de\u011feri ba\u015fka bir h\u00fccreye aktarmak veya ba\u011flamak i\u00e7in form\u00fcller veya i\u015flevler kullan\u0131labilir.<\/li>\n<li><strong>Veri Analizi<\/strong>: H\u00fccreler, veri analizi i\u015flemleri i\u00e7in temel birimlerdir. B\u00fcy\u00fck veri setlerini i\u015flemek, grafikler olu\u015fturmak veya verileri filtrelemek i\u00e7in kullan\u0131labilirler.<\/li>\n<\/ol>\n<p>Excel&#8217;de h\u00fccrelerin kullan\u0131m\u0131, veri y\u00f6netimi, hesaplamalar, raporlar olu\u015fturma ve daha pek \u00e7ok g\u00f6revde \u00f6nemlidir. Her bir h\u00fccre, belirli bir veriyi veya hesaplamay\u0131 temsil eder ve bu nedenle \u00e7al\u0131\u015fma tablosunun temel yap\u0131 ta\u015f\u0131d\u0131r.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_dosya_uzantisi_nedir\"><\/span>excel dosya uzant\u0131s\u0131 nedir<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel dosyalar\u0131n\u0131n uzant\u0131s\u0131 &#8220;.xlsx&#8221; veya &#8220;.xls&#8221; \u015feklindedir, bu uzant\u0131lar dosyan\u0131n Excel format\u0131nda oldu\u011funu belirtir. \u0130\u015fte her iki uzant\u0131n\u0131n anlamlar\u0131:<\/p>\n<ol>\n<li><strong>.xlsx Uzant\u0131s\u0131<\/strong>: Bu uzant\u0131, Excel 2007 ve sonraki s\u00fcr\u00fcmler i\u00e7in kullan\u0131lan dosya bi\u00e7imidir. &#8220;.xlsx&#8221; dosyalar\u0131, Excel&#8217;in modern s\u00fcr\u00fcmleri taraf\u0131ndan desteklenir ve daha fazla \u00f6zellik ve g\u00fcvenlik i\u00e7erir. Bu dosya bi\u00e7imi, Office Open XML (OOXML) standard\u0131na dayan\u0131r.<\/li>\n<li><strong>.xls Uzant\u0131s\u0131<\/strong>: Bu uzant\u0131, eski Excel s\u00fcr\u00fcmleri i\u00e7in kullan\u0131lan dosya bi\u00e7imidir. \u00d6zellikle Excel 2003 ve \u00f6nceki s\u00fcr\u00fcmler bu uzant\u0131y\u0131 kullan\u0131r. &#8220;.xls&#8221; dosyalar\u0131, daha yeni s\u00fcr\u00fcmlerde de a\u00e7\u0131labilir, ancak baz\u0131 \u00f6zellikler kaybolabilir veya uyumsuzluklar olabilir.<\/li>\n<\/ol>\n<p>Excel&#8217;de \u00e7al\u0131\u015f\u0131rken, dosyalar\u0131n\u0131z\u0131n hangi s\u00fcr\u00fcmle uyumlu oldu\u011funa dikkat etmelisiniz. Genellikle &#8220;.xlsx&#8221; uzant\u0131l\u0131 dosyalar daha modern ve \u00f6nerilen bir formatt\u0131r, ancak eski s\u00fcr\u00fcmlerle payla\u015fman\u0131z gereken dosyalar i\u00e7in &#8220;.xls&#8221; uzant\u0131s\u0131n\u0131 kullanabilirsiniz. Excel, bu iki dosya bi\u00e7imini destekler ve her ikisini de a\u00e7abilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_dugme_islevleri\"><\/span>excel d\u00fc\u011fme i\u015flevleri<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de d\u00fc\u011fmeler (butonlar) olu\u015fturabilir ve bu d\u00fc\u011fmelere \u00e7e\u015fitli i\u015flevler atayabilirsiniz. \u0130\u015fte Excel&#8217;de d\u00fc\u011fme i\u015flevlerini atamak i\u00e7in izleyebilece\u011finiz ad\u0131mlar:<\/p>\n<ol>\n<li><strong>D\u00fc\u011fme Ekleme:<\/strong>\n<ul>\n<li>Excel&#8217;in &#8220;Geli\u015ftirici&#8221; sekmesini g\u00f6r\u00fcnt\u00fclemek i\u00e7in &#8220;Dosya&#8221; &gt; &#8220;Se\u00e7enekler&#8221; &gt; &#8220;\u00d6zelle\u015ftirme Sekmesi&#8221; yolunu izleyin. &#8220;Geli\u015ftirici&#8221; kutusunu i\u015faretleyin ve &#8220;Tamam&#8221; d\u00fc\u011fmesine t\u0131klay\u0131n.<\/li>\n<li>&#8220;Geli\u015ftirici&#8221; sekmesi g\u00f6r\u00fcn\u00fcr hale geldi\u011finde, &#8220;Ekle&#8221; b\u00f6l\u00fcm\u00fcnde &#8220;D\u00fc\u011fme (ActiveX Kontrol\u00fc)&#8221; veya &#8220;D\u00fc\u011fme (Form Kontrol\u00fc)&#8221; se\u00e7eneklerinden birini se\u00e7erek \u00e7al\u0131\u015fma tablonuza bir d\u00fc\u011fme ekleyebilirsiniz.<\/li>\n<\/ul>\n<\/li>\n<li><strong>D\u00fc\u011fmeye \u0130\u015flev Atama:<\/strong>\n<ul>\n<li>D\u00fc\u011fmeyi ekledikten sonra, d\u00fc\u011fmeyi sa\u011f t\u0131klayarak d\u00fc\u011fme \u00f6zelliklerine eri\u015fin.<\/li>\n<li>&#8220;D\u00fczenle&#8221; veya &#8220;D\u00fc\u011fme \u00d6zellikleri&#8221; se\u00e7ene\u011fini se\u00e7erek, d\u00fc\u011fmeye bir i\u015flev (VBA makrosu veya mevcut bir form\u00fcl) atayabilirsiniz.<\/li>\n<\/ul>\n<\/li>\n<li><strong>VBA Makrosu Atama:<\/strong>\n<ul>\n<li>D\u00fc\u011fmeye bir VBA makrosu atamak i\u00e7in &#8220;D\u00fc\u011fme \u00d6zellikleri&#8221; penceresinde &#8220;Olu\u015ftur&#8221; d\u00fc\u011fmesine t\u0131klay\u0131n.<\/li>\n<li>VBA edit\u00f6r\u00fc a\u00e7\u0131lacak ve yeni bir makro olu\u015fturabileceksiniz. Bu makroyu d\u00fc\u011fmenize atayabilirsiniz. \u00d6rne\u011fin, d\u00fc\u011fme t\u0131kland\u0131\u011f\u0131nda belirli bir i\u015flemi ger\u00e7ekle\u015ftiren bir VBA makrosu olu\u015fturabilirsiniz.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Form\u00fcl Atama:<\/strong>\n<ul>\n<li>D\u00fc\u011fmeye bir form\u00fcl atamak isterseniz, &#8220;D\u00fc\u011fme \u00d6zellikleri&#8221; penceresinde &#8220;Ba\u011fla&#8221; se\u00e7ene\u011fini kullanabilirsiniz.<\/li>\n<li>Bir h\u00fccreye form\u00fcl yazabilir veya h\u00fccre aral\u0131klar\u0131 aras\u0131nda bir form\u00fcl kullanabilirsiniz. D\u00fc\u011fme t\u0131kland\u0131\u011f\u0131nda bu form\u00fcl \u00e7al\u0131\u015facakt\u0131r.<\/li>\n<\/ul>\n<\/li>\n<li><strong>D\u00fc\u011fme G\u00f6r\u00fcnt\u00fcs\u00fc ve Metni D\u00fczenleme:<\/strong>\n<ul>\n<li>D\u00fc\u011fmeye t\u0131klanabilir bir g\u00f6r\u00fcnt\u00fc veya metin eklemek i\u00e7in &#8220;D\u00fc\u011fme \u00d6zellikleri&#8221; penceresini kullanabilirsiniz. Bu, d\u00fc\u011fmenin ne yapaca\u011f\u0131n\u0131 ve nas\u0131l g\u00f6r\u00fcnece\u011fini \u00f6zelle\u015ftirmenize olanak tan\u0131r.<\/li>\n<\/ul>\n<\/li>\n<li><strong>D\u00fc\u011fme \u0130\u015flevini Test Etme:<\/strong>\n<ul>\n<li>D\u00fc\u011fme i\u015flevini test etmek i\u00e7in d\u00fc\u011fmeye t\u0131klayabilirsiniz. E\u011fer bir VBA makrosu atad\u0131ysan\u0131z, makro \u00e7al\u0131\u015facakt\u0131r.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Excel&#8217;de d\u00fc\u011fme i\u015flevleri, \u00e7al\u0131\u015fma tablosunun daha etkile\u015fimli olmas\u0131n\u0131 sa\u011flar. D\u00fc\u011fmeleri kullanarak \u00f6zel i\u015flemler, hesaplamalar veya veri giri\u015fi kolayca yap\u0131labilir.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_formul_hatasi_bulma\"><\/span>excel form\u00fcl hatas\u0131 bulma<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de form\u00fcl hatalar\u0131n\u0131 bulmak ve d\u00fczeltmek i\u00e7in birka\u00e7 y\u00f6ntem ve ara\u00e7 bulunmaktad\u0131r. \u0130\u015fte bu hatalar\u0131 tespit etmek ve d\u00fczeltmek i\u00e7in kullanabilece\u011finiz baz\u0131 y\u00f6ntemler:<\/p>\n<ol>\n<li><strong>Hata Mesajlar\u0131n\u0131 Kullanma:<\/strong>\n<ul>\n<li>Excel, hata tespiti ve d\u00fczeltme konusunda yard\u0131mc\u0131 olmak i\u00e7in hata mesajlar\u0131 sa\u011flar. Bir h\u00fccreye hatal\u0131 bir form\u00fcl girdi\u011finizde, h\u00fccrenin yan\u0131nda bir \u00fcnlem i\u015fareti i\u00e7eren bir \u00fc\u00e7gen simgesi g\u00f6r\u00fcnecektir. Bu simgeye t\u0131klad\u0131\u011f\u0131n\u0131zda, hatan\u0131n nedenini a\u00e7\u0131klayan bir ileti al\u0131rs\u0131n\u0131z. \u0130letiyi okuyarak hatan\u0131n t\u00fcr\u00fcn\u00fc ve nedenini anlayabilirsiniz.<\/li>\n<\/ul>\n<\/li>\n<li><strong>H\u00fccre Kontrol\u00fc:<\/strong>\n<ul>\n<li>H\u00fccrelerdeki form\u00fclleri g\u00f6zden ge\u00e7irerek hatalar\u0131 manuel olarak tespit edebilirsiniz. Form\u00fcllerinizi dikkatli bir \u015fekilde kontrol edin ve matematiksel d\u00fczg\u00fcn oldu\u011fundan, h\u00fccre referanslar\u0131n\u0131n do\u011fru oldu\u011fundan ve i\u015flevlerin do\u011fru bi\u00e7imde yaz\u0131ld\u0131\u011f\u0131ndan emin olun.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Form\u00fcl \u0130zleme Arac\u0131:<\/strong>\n<ul>\n<li>Excel&#8217;in &#8220;Form\u00fcl \u0130zleme&#8221; arac\u0131n\u0131 kullanarak, bir h\u00fccredeki form\u00fcl\u00fcn nas\u0131l hesapland\u0131\u011f\u0131n\u0131 g\u00f6rsel olarak takip edebilirsiniz. &#8220;Form\u00fcl \u0130zleme&#8221; arac\u0131n\u0131 kullanmak i\u00e7in &#8220;Form\u00fcller&#8221; sekmesini a\u00e7\u0131n ve &#8220;Form\u00fcl \u0130zleme Ba\u015flat&#8221; se\u00e7ene\u011fini kullanarak h\u00fccreye t\u0131klad\u0131\u011f\u0131n\u0131zda form\u00fcl\u00fcn hesaplanma ad\u0131mlar\u0131n\u0131 g\u00f6rsel olarak takip edebilirsiniz.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Form\u00fcl Hata \u0130\u015flevleri:<\/strong>\n<ul>\n<li>Excel, form\u00fcl hatalar\u0131n\u0131 tespit etmek ve d\u00fczeltmek i\u00e7in \u00f6zel i\u015flevler sunar. \u00d6rne\u011fin, &#8220;HATA.T\u00dcR\u00dc&#8221; i\u015flevi, bir h\u00fccredeki hatan\u0131n t\u00fcr\u00fcn\u00fc belirtir ve &#8220;HATA.D\u00dcZELT&#8221; i\u015flevi, bir hatay\u0131 d\u00fczeltmeye yard\u0131mc\u0131 olur. Bu i\u015flevleri kullanarak hatalar\u0131 tespit edebilir ve gerekli d\u00fczeltmeleri yapabilirsiniz.<\/li>\n<\/ul>\n<\/li>\n<li><strong>H\u00fccre Denetimi:<\/strong>\n<ul>\n<li>Excel, h\u00fccrelerdeki form\u00fclleri denetlemek i\u00e7in &#8220;H\u00fccre Denetimi&#8221; \u00f6zelli\u011fini sunar. Bir h\u00fccreyi se\u00e7tikten sonra &#8220;Veri&#8221; sekmesini a\u00e7\u0131n ve &#8220;H\u00fccre Denetimi&#8221; se\u00e7ene\u011fini kullanarak h\u00fccredeki form\u00fcl hatalar\u0131n\u0131 tespit edebilirsiniz.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Hata Kontrollerini Etkinle\u015ftirme:<\/strong>\n<ul>\n<li>Excel&#8217;de &#8220;Dosya&#8221; &gt; &#8220;Se\u00e7enekler&#8221; &gt; &#8220;Form\u00fcl&#8221; yolunu izleyerek, &#8220;Hata Kontrolleri&#8221; b\u00f6l\u00fcm\u00fcnde hata tespiti se\u00e7eneklerini etkinle\u015ftirebilirsiniz. Bu, form\u00fcl hatalar\u0131n\u0131 daha iyi tespit etmenize yard\u0131mc\u0131 olabilir.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Bu y\u00f6ntemler, Excel&#8217;de form\u00fcl hatalar\u0131n\u0131 tespit etmek ve d\u00fczeltmek i\u00e7in kullanabilece\u011finiz ara\u00e7lar ve stratejilerdir. Hatalar\u0131 tespit edip d\u00fczeltmek i\u00e7in bu y\u00f6ntemleri kullanarak veri analizi ve raporlama i\u015flemlerinizi daha g\u00fcvenilir hale getirebilirsiniz.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"excel_formuller_listesi\"><\/span>excel form\u00fcller listesi<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel&#8217;de kullanabilece\u011finiz bir\u00e7ok form\u00fcl bulunmaktad\u0131r. \u0130\u015fte yayg\u0131n olarak kullan\u0131lan baz\u0131 Excel form\u00fclleri ve k\u0131sa a\u00e7\u0131klamalar\u0131:<\/p>\n<ol>\n<li><strong>TOPLA<\/strong>: Bir h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131lar\u0131n toplam\u0131n\u0131 hesaplar.<\/li>\n<li><strong>\u00c7IKAR<\/strong>: \u0130ki say\u0131n\u0131n fark\u0131n\u0131 hesaplar.<\/li>\n<li><strong>\u00c7ARP<\/strong>: \u0130ki say\u0131n\u0131n \u00e7arp\u0131m\u0131n\u0131 hesaplar.<\/li>\n<li><strong>B\u00d6L<\/strong>: \u0130ki say\u0131n\u0131n b\u00f6l\u00fcm\u00fcn\u00fc hesaplar.<\/li>\n<li><strong>MOD<\/strong>: Bir say\u0131n\u0131n di\u011fer say\u0131ya b\u00f6l\u00fcnmesinden kalan\u0131 hesaplar.<\/li>\n<li><strong>\u00dcSALMA<\/strong>: Bir say\u0131n\u0131n \u00fcss\u00fcn\u00fc hesaplar.<\/li>\n<li><strong>KAREK\u00d6K<\/strong>: Bir say\u0131n\u0131n karek\u00f6k\u00fcn\u00fc hesaplar.<\/li>\n<li><strong>M\u0130N<\/strong>: Bir h\u00fccre aral\u0131\u011f\u0131ndaki en k\u00fc\u00e7\u00fck say\u0131y\u0131 bulur.<\/li>\n<li><strong>MAKS<\/strong>: Bir h\u00fccre aral\u0131\u011f\u0131ndaki en b\u00fcy\u00fck say\u0131y\u0131 bulur.<\/li>\n<li><strong>ORTALAMA<\/strong>: Bir h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131lar\u0131n ortalamas\u0131n\u0131 hesaplar.<\/li>\n<li><strong>MEDYAN<\/strong>: Bir h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131lar\u0131n medyan\u0131n\u0131 hesaplar.<\/li>\n<li><strong>MODALITE<\/strong>: Bir h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131lar\u0131n modunu hesaplar (en s\u0131k tekrar eden de\u011fer).<\/li>\n<li><strong>STANDARTSAPMA<\/strong>: Bir h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131lar\u0131n standart sapmas\u0131n\u0131 hesaplar.<\/li>\n<li><strong>VARYANS<\/strong>: Bir h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131lar\u0131n varyans\u0131n\u0131 hesaplar.<\/li>\n<li><strong>Y\u00dcZDE<\/strong>: Bir say\u0131n\u0131n y\u00fczdesini hesaplar.<\/li>\n<li><strong>Y\u00dcZDEYAP<\/strong>: Bir say\u0131n\u0131n y\u00fczde de\u011fi\u015fimini hesaplar.<\/li>\n<li><strong>YUVARLA<\/strong>: Bir say\u0131y\u0131 belirli bir ondal\u0131k basama\u011fa yuvarlar.<\/li>\n<li><strong>B\u00dcY\u00dcK HARF<\/strong>: Metni b\u00fcy\u00fck harflere d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/li>\n<li><strong>K\u00dc\u00c7\u00dcK HARF<\/strong>: Metni k\u00fc\u00e7\u00fck harflere d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/li>\n<li><strong>METN\u0130B\u0130RLE\u015eT\u0130R<\/strong>: Metinleri birle\u015ftirir.<\/li>\n<li><strong>SAYIYIBUL<\/strong>: Metin i\u00e7indeki say\u0131y\u0131 bulur.<\/li>\n<li><strong>E\u011eER<\/strong>: Bir ko\u015fulu de\u011ferlendirir ve sonu\u00e7 d\u00f6nd\u00fcr\u00fcr.<\/li>\n<li><strong>\u015eARTLIFORMAT<\/strong>: Bir h\u00fccreyi belirli bir ko\u015fula g\u00f6re bi\u00e7imlendirir.<\/li>\n<li><strong>VER\u0130TABANI<\/strong>: Veritaban\u0131nda belirli bir ko\u015fulu kar\u015f\u0131layan kay\u0131tlar\u0131 se\u00e7er.<\/li>\n<li><strong>H\u00dcCRE<\/strong>: Belirli bir h\u00fccredeki de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/li>\n<\/ol>\n<p>Bu, sadece Excel form\u00fcllerinin bir k\u0131sm\u0131d\u0131r. Excel&#8217;de daha fazla form\u00fcl bulunmaktad\u0131r ve her biri farkl\u0131 i\u015flevlere sahiptir. \u0130htiyac\u0131n\u0131za g\u00f6re bu form\u00fclleri kullanarak \u00e7e\u015fitli hesaplamalar, veri analizi ve raporlar olu\u015fturabilirsiniz. Excel&#8217;de form\u00fcllerle \u00e7al\u0131\u015fmak, verilerinizi i\u015flemek ve analiz etmek i\u00e7in g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Nedir? Excel, Microsoft taraf\u0131ndan geli\u015ftirilen ve yayg\u0131n olarak kullan\u0131lan bir elektronik tablo program\u0131d\u0131r. Excel, verileri d\u00fczenlemek, hesaplamalar yapmak, grafikler olu\u015fturmak ve veri analizi yapmak i\u00e7in kullan\u0131l\u0131r. Bu program, ofis ve i\u015f ortamlar\u0131nda veri y\u00f6netimi ve analizi i\u00e7in temel bir ara\u00e7 olarak kabul edilir. Excel&#8217;in temel \u00f6zellikleri \u015funlard\u0131r: H\u00fccre Tabanl\u0131 D\u00fczen: Excel, verilerin h\u00fccreler ad\u0131 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":6674,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[232],"tags":[],"class_list":["post-6673","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/6673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=6673"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/6673\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/6674"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=6673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=6673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=6673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}