{"id":7463,"date":"2020-12-18T11:43:50","date_gmt":"2020-12-18T08:43:50","guid":{"rendered":"https:\/\/www.karadere.com\/blog\/?p=7463"},"modified":"2021-09-10T14:29:19","modified_gmt":"2021-09-10T11:29:19","slug":"ms-microsoft-excel-formul-notlarim","status":"publish","type":"post","link":"https:\/\/www.karadere.com\/blog\/ms-microsoft-excel-formul-notlarim.html","title":{"rendered":"MS &#8211; Microsoft Excel Form\u00fcl Notlar\u0131m"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-style-default\"><img decoding=\"async\" src=\"https:\/\/www.mobil13.com\/wp-content\/uploads\/2020\/01\/excel.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>H\u00fccre formatlama :<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CRTL + 1 = H\u00fccre formatlama penceresini a\u00e7ar<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CTRL + SHIFT + 5 = Y\u00fczde format\u0131<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CTRL + SHIFT + 1 = Numara format\u0131<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SUM = Toplama<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CTRL + SHIFT + L = Filtreleme koymak<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/tr-tr\/microsoft-365\/blog\/wp-content\/uploads\/sites\/60\/2019\/02\/Excel-with-Microsoft-Excel-in-Office-365-1b-1.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">;;;     ile custom form\u00fcl gizleme yap\u0131labilir  o h\u00fccredeki veriler g\u00f6r\u00fcnmez olur asl\u0131nda h\u00fccre de vard\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6zel bir custom format      <strong> [&gt;0.50]%0;;<\/strong>   bu form\u00fcl ile belirledi\u011finiz ko\u015fula g\u00f6re veriler g\u00f6r\u00fcn\u00fcr okunmas\u0131 kolayla\u015f\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Format painter&#8217;a iki kere basarak yap\u0131\u015fkan tu\u015f \u00f6zelli\u011fi kazand\u0131rabilirsiniz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">F4  =  En son yap\u0131lan i\u015flemi excel de tekrar yapman\u0131z\u0131 sa\u011flar<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Form\u00fcller : Trim() bo\u015fluklar\u0131 temizleme i\u015flemi yapar<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6zel Format \u00f6rnek cep telefonu;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Custom formattan 000 000 00 00 format\u0131 kullan\u0131labilir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bir\u00e7ok yaz\u0131l\u0131m dilinde text yani metin format\u0131n\u0131 &#8221; &#8221; \u00e7ift t\u0131rnak i\u00e7inde tan\u0131mlamal\u0131s\u0131n\u0131z.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sheet kopyalamada; CTRL + mause sol clik bas\u0131l\u0131 tutup kopyalama yapabilirsiniz. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CTRL + D  : bir \u00fcst h\u00fccreyi a\u015fa\u011f\u0131ya direkt kopyalar <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u015eifre koyma i\u015flemi :  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">F5 : Goto \/ git k\u0131sa yol tu\u015fudur se\u00e7ili alanlarda kullan\u0131l\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6zel yap\u0131\u015ft\u0131r\u0131n \u00f6zel yap\u0131\u015ft\u0131r metodunu kullanmak. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kar\u0131\u015f\u0131k tarih formatlar\u0131n\u0131 <strong>Text to Columns<\/strong> dan toplu formatlama yapabilirsiniz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B\u00fct\u00fcn excel&#8217;i <strong>&#8220;format as table&#8221;<\/strong> ile \u00e7al\u0131\u015fmak her zaman avantajd\u0131r. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Rastgele Veri \/ Random data \u00fcretme :           <strong> =ROUNDUP(RAND()*100;0)<\/strong>  Formula by Burhan_07  \ud83d\ude42<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=CHAR(RANDBETWEEN(65;90))&amp;CHAR(RANDBETWEEN(65;90))&amp;RANDBETWEEN(10;99)  Alfabe ile rasgele veri \u00fcretmek i\u00e7in faydal\u0131 bir form\u00fcl<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Yararl\u0131 Kaynaklar :<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-excel-tutorials-functions-and-formulas-for-beginners-and-advanced-users-ablebits-com-blog wp-block-embed-excel-tutorials-functions-and-formulas-for-beginners-and-advanced-users-ablebits-com-blog\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"post-embed\"><blockquote class=\"wp-embedded-content\" data-secret=\"uk2bFd9tWb\"><a href=\"https:\/\/www.ablebits.com\/office-addins-blog\/2018\/01\/24\/excel-randomize-list-random-sort\/\">Random sort in Excel: shuffle cells, rows and columns<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Random sort in Excel: shuffle cells, rows and columns&#8221; &#8212; Excel tutorials, functions and formulas for beginners and advanced users - Ablebits.com Blog\" src=\"https:\/\/www.ablebits.com\/office-addins-blog\/2018\/01\/24\/excel-randomize-list-random-sort\/embed\/#?secret=uk2bFd9tWb\" data-secret=\"uk2bFd9tWb\" width=\"600\" height=\"338\"  marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/div>\n<\/div><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">=VLOOKUP(G10;A5:E504;2;0)         En \u00e7ok kullan\u0131lan fom\u00fcl.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">D\u00fc\u015fey ara ile ID e\u015fle\u015ftirmesini yapmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sparkline nedir ?  bir h\u00fccerece  k\u00fc\u00e7\u00fck grafikler \u00fcretebilirsiniz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00d6zel yap\u0131\u015ft\u0131r yap\u0131\u015ft\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">0123 bir format\u0131n ba\u015f\u0131ndaki s\u0131f\u0131rlar\u0131 1 ile \u00f6zel yap\u0131\u015ft\u0131r \u00f6zel yap\u0131\u015ft\u0131r  ile d\u00fczeltebilirseniz. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">TRIM   birden fazla bo\u015fluklar\u0131 al\u0131r<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=VLOOKUP(&#8220;KAD&#8221;;A3:D57;3;0)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">=VLOOKUP(&#8220;KAD*&#8221;;A3:D57;3;0)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dizi form\u00fclleri      <strong>CRTL + SHIFT + ENTER <\/strong>ile \u00e7al\u0131\u015f\u0131r <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sparkline  : H\u00fccrelere mini grafikler ekleyebilir siniz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Geli\u015fmi\u015f listelere herhangi bir st\u00fcn bilgilerini nas\u0131l ekleri? <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">File -> Options -> Advanced   General daki Edit Custom Lists<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pivot Table grafik ekleme  ALT + F1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> NAL ile ba\u015flayan  =VLOOKUP(&#8220;NAL*&#8221;;B:D;3;0)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sonu NAL ile biten =VLOOKUP(&#8220;*NAL&#8221;;B:D;3;0)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5 haneli numaray\u0131 bulma  =VLOOKUP(&#8220;?????&#8221;;C:D;2;0)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kaynakar : <\/strong>https:\/\/chandoo.org\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00fccre formatlama : CRTL + 1 = H\u00fccre formatlama penceresini a\u00e7ar CTRL + SHIFT + 5 = Y\u00fczde format\u0131 CTRL + SHIFT + 1 = Numara format\u0131 SUM = Toplama CTRL + SHIFT + L = Filtreleme koymak ;;; ile custom form\u00fcl gizleme yap\u0131labilir o h\u00fccredeki veriler g\u00f6r\u00fcnmez olur asl\u0131nda h\u00fccre de vard\u0131r. \u00d6zel bir [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[3232,3231,1581],"class_list":["post-7463","post","type-post","status-publish","format-standard","hentry","category-genel","tag-formul","tag-ms-microsoft-excel","tag-notlarim","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"aioseo_notices":[],"views":740,"_links":{"self":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/7463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/comments?post=7463"}],"version-history":[{"count":39,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/7463\/revisions"}],"predecessor-version":[{"id":7507,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/7463\/revisions\/7507"}],"wp:attachment":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/media?parent=7463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/categories?post=7463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/tags?post=7463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}