{"id":1888,"date":"2023-10-30T01:52:26","date_gmt":"2023-10-30T01:52:26","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/"},"modified":"2023-12-10T05:58:52","modified_gmt":"2023-12-10T05:58:52","slug":"deger-formulu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/","title":{"rendered":"Bir form\u00fcl\u00fc excel&#39;deki bir de\u011fere nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1212104294\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>\u0130\u015fime ba\u015flad\u0131\u011f\u0131m ilk g\u00fcnlerden itibaren bir \u015feyi zor yoldan \u00f6\u011frendim:<\/p><p> Birine rapor (Excel&#8217;de) g\u00f6ndermeden \u00f6nce <span style=\"font-size: 1em;\">form\u00fcl\u00fc de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmemiz gerekir. Bu sadece bir form\u00fcl\u00fc sonu\u00e7 de\u011feriyle de\u011fi\u015ftirmek anlam\u0131na gelir.<\/span> \u015e\u00f6yle d\u00fc\u015f\u00fcn\u00fcn, birine rapor g\u00f6nderdi\u011finizde form\u00fcllerle de\u011fil de\u011ferlerle ilgilenir, bir form\u00fcl gelir.<\/p><p> Size bunu yapman\u0131n ilgin\u00e7 yollar\u0131ndan baz\u0131lar\u0131n\u0131 anlatay\u0131m ama ondan \u00f6nce.<\/p><h2 class=\"wp-block-heading\"> Neden bir form\u00fcl\u00fc de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmelisiniz?<\/h2><p> Bir form\u00fcl\u00fc sonu\u00e7 de\u011feriyle de\u011fi\u015ftirmenizin baz\u0131 nedenleri a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p><ol><li> Kaynak verileri olmayan birine rapor g\u00f6nderiyorsan\u0131z t\u00fcm form\u00fclleri statik de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrmek en iyisidir.<\/li><li> Baz\u0131 i\u015flevler ge\u00e7icidir ve e-tablonuzu g\u00fcncelledi\u011finizde de\u011ferleri yeniden hesaplan\u0131r.<\/li><li> Son kullan\u0131c\u0131n\u0131n hesaplamay\u0131 de\u011fi\u015ftirmesini \u00f6nleyin.<\/li><li> Statik de\u011ferler kolayca d\u00fczenlenebilir ve herkes bunlar\u0131 kolayca <a href=\"https:\/\/exceladvisor.org\/tr\/kopyala-yapistir\/\">kopyalay\u0131p yap\u0131\u015ft\u0131rabilir<\/a> .<\/li><li> Son kullan\u0131c\u0131n\u0131n kafas\u0131n\u0131 karma\u015f\u0131k form\u00fcllerle kar\u0131\u015ft\u0131rmak istemezsiniz.<\/li><li> Veya <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/formulu-gizle\/\" data-wpel-link=\"internal\">form\u00fclleri g\u00f6stermek istemezsiniz<\/a> .<\/li><\/ol><p class=\"qt-tip\"> <strong>K\u0131sa Not:<\/strong> Bu, <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\">temel Excel becerilerini<\/a> geli\u015ftirmeye yard\u0131mc\u0131 olabilecek <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/tavsiye\/\" data-wpil=\"url\">Excel ipu\u00e7lar\u0131ndan<\/a> biridir.<\/p><h2 class=\"wp-block-heading\"> 1. De\u011ferleri basit bir klavye k\u0131sayoluyla yap\u0131\u015ft\u0131r\u0131n<\/h2><p> H\u0131z ve kolayl\u0131k a\u00e7\u0131s\u0131ndan <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\">k\u0131sayol tu\u015flar\u0131<\/a> en iyisidir ve form\u00fclleri de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrmenin en kolay yolu k\u0131sayol tu\u015fu kullanmakt\u0131r.<\/p><p> Tek yapman\u0131z gereken:<\/p><ul><li> Form\u00fcllerinizin bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7in.<\/li><li> H\u00fccreleri kopyalamak i\u00e7in Ctrl + C tu\u015flar\u0131na bas\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-des-cellules-pour-convertir-des-formules-en-une-valeur-statique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Form\u00fclleri statik minimum de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in 1 kopya h\u00fccre\"><\/figure><\/div><ul><li> Ve sonra Alt + ES V. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-touche-de-raccourci-pour-convertir-la-formule-en-une-valeur-statique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Form\u00fcl\u00fc statik minimum de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in 2 k\u0131sayol tu\u015fu\"><\/figure><\/div><p> Bu k\u0131sayol tu\u015fu kullan\u0131ld\u0131\u011f\u0131nda t\u00fcm form\u00fcller statik sonu\u00e7 de\u011ferleriyle de\u011fi\u015ftirilecektir.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> Orijinal form\u00fclleri <a href=\"https:\/\/exceladvisor.org\/tr\/kaydedilmemis-dosyalari-kurtar\/\">kaybetmek istemiyorsan\u0131z<\/a> bir yedek dosya olu\u015fturman\u0131z gerekir.<\/p><h2 class=\"wp-block-heading\"> 2. De\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u00d6zel Yap\u0131\u015ft\u0131r&#8217;\u0131 kullanma<\/h2><p> K\u0131sayol tu\u015funu kullanmaktan ho\u015flanm\u0131yorsan\u0131z, onu de\u011fi\u015ftirmek i\u00e7in \u00f6zel yap\u0131\u015ft\u0131rma se\u00e7ene\u011fini kullanabilirsiniz.<\/p><ul><li> \u00d6ncelikle tarih aral\u0131\u011f\u0131n\u0131z\u0131 veya s\u00fctunun tamam\u0131n\u0131 se\u00e7in.<\/li><li> Daha sonra sa\u011f t\u0131klay\u0131p kopyalay\u0131n.<\/li><li> Ana Sayfa sekmesine gidin \u279c Pano \u279c Yap\u0131\u015ft\u0131r \u279c \u00d6zel Yap\u0131\u015ft\u0131r. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-allez-a-longlet-daccueil-pour-utiliser-le-collage-special-pour-convertir-une-formule-en-une-valeur-statique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"3 Bir form\u00fcl\u00fc statik minimum de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmek amac\u0131yla \u00f6zel yap\u0131\u015ft\u0131rmay\u0131 kullanmak i\u00e7in ana sayfa sekmesine gidin\"><\/figure><\/div><ul><li> Veya sa\u011f t\u0131klay\u0131p \u00d6zel Yap\u0131\u015ft\u0131r -&gt; De\u011ferler se\u00e7ene\u011fine de gidebilirsiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-clic-droit-pour-utiliser-le-collage-special-pour-convertir-la-formule-en-une-valeur-statique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"4 form\u00fcl\u00fc statik minimum de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmek amac\u0131yla \u00f6zel yap\u0131\u015ft\u0131rmay\u0131 kullanmak i\u00e7in sa\u011f t\u0131klay\u0131n\"><\/figure><\/div><p> Bu y\u00f6ntem, t\u00fcm form\u00fclleri statik sonu\u00e7 de\u011ferleriyle de\u011fi\u015ftirmek i\u00e7in k\u0131sayol tu\u015fu y\u00f6ntemi gibi \u00e7al\u0131\u015f\u0131r.<\/p><h2 class=\"wp-block-heading\"> 3. Ba\u011flam men\u00fcs\u00fcn\u00fc kullanma<\/h2><p> Ve e\u011fer \u00f6zel yap\u0131\u015ft\u0131rmay\u0131 kullanmak istemiyorsan\u0131z, bu d\u00f6n\u00fc\u015f\u00fcm i\u00e7in <a href=\"https:\/\/www.myexcelonline.com\/blog\/power-right-click-excel\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">sa\u011f t\u0131klay\u0131p s\u00fcr\u00fckle b\u0131rak<\/a> y\u00f6ntemini kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-convertir-la-formule-en-une-valeur-statique-en-utilisant-la-methode-du-clic-droit-1.gif\" sizes=\"\" srcset=\"\" alt=\"11 Sa\u011f t\u0131klama y\u00f6ntemini kullanarak form\u00fcl\u00fc statik bir de\u011fere d\u00f6n\u00fc\u015ft\u00fcr\u00fcn\"><\/figure><\/div><ol><li> \u00d6ncelikle form\u00fcllerinizin bulundu\u011fu h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7in.<\/li><li> \u015eimdi se\u00e7imin kenar\u0131na sa\u011f t\u0131klay\u0131n.<\/li><li> Ve sa\u011f t\u0131klamay\u0131 bas\u0131l\u0131 tutarak aral\u0131\u011f\u0131 sa\u011fa s\u00fcr\u00fckleyin ve an\u0131nda orijinal konumuna geri getirip b\u0131rak\u0131n.<\/li><li> Burada se\u00e7enekler men\u00fcs\u00fcn\u00fc g\u00f6receksiniz.<\/li><li> Bu se\u00e7enekler men\u00fcs\u00fcnden \u201cBuraya yaln\u0131zca de\u011ferler olarak kopyala\u201d se\u00e7ene\u011fini se\u00e7in.<\/li><\/ol><p> Bu, bu h\u00fccrelerdeki t\u00fcm form\u00fclleri an\u0131nda statik sonu\u00e7 de\u011ferlerine d\u00f6n\u00fc\u015ft\u00fcrecektir.<\/p><h2 class=\"wp-block-heading\"> 4. Form\u00fclleri VBA Koduyla De\u011ferlere D\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/h2><p> T\u00fcm form\u00fclleri otomatik olarak metin veya say\u0131sal de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrmek istiyorsan\u0131z bunun i\u00e7in VBA&#8217;y\u0131 kullanabilirsiniz. Burada sadece h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7ip bu makroyu \u00e7al\u0131\u015ft\u0131raca\u011f\u0131n\u0131z basit bir VBA kodundan bahsetmi\u015ftim.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub ConvertToValues() Dim MyRange As Range Dim MyCell As Range Select Case MsgBox(\"You Can't Undo This Action. \" &amp; _ \"Save Workbook First?\", _ vbYesNoCancel, \"Alert\") Case Is = vbYes ThisWorkbook.Save Case Is = vbCancel Exit Sub End Select Set MyRange = Selection For Each MyCell In MyRange If MyCell.HasFormula Then MyCell.Formula = MyCell.Value End If Next MyCell End Sub<\/code><\/pre><p> <strong>\u0130lgili:<\/strong> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/vba\/\" data-wpel-link=\"internal\">Excel VBA E\u011fitimi<\/a><\/p><h2 class=\"wp-block-heading\"> 5. Form\u00fcl\u00fcn i\u00e7indeki de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/h2><p> Farkl\u0131 d\u00fc\u015f\u00fcnelim. \u0130ki veya \u00fc\u00e7 i\u015flevin birle\u015fiminden olu\u015fan karma\u015f\u0131k bir form\u00fcl\u00fcn\u00fcz var. Burada bir metin de\u011ferini temizlemek ve ard\u0131ndan onu do\u011fru b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in uzun bir form\u00fcl\u00fcn\u00fcz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-modifier-la-formule-pour-convertir-une-formule-en-une-valeur-statique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Bir form\u00fcl\u00fc statik minimum de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in 5 form\u00fcl\u00fc d\u00fczenleyin\"><\/figure><\/div><p> \u015eimdi, iki ikame fonksiyonunun sonucunu statik metin de\u011ferlerine d\u00f6n\u00fc\u015ft\u00fcrmek istiyorsan\u0131z, ad\u0131mlar a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p><ol><li> F2&#8217;yi kullanarak form\u00fcl\u00fc <a href=\"https:\/\/exceladvisor.org\/tr\/hucreyi-duzenle\/\">d\u00fczenleyin<\/a> .<\/li><li> Form\u00fcl\u00fcn yaln\u0131zca statik de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmeniz gereken k\u0131sm\u0131n\u0131 se\u00e7in.<\/li><li> F9&#8217;a bas\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-appuyez-sur-f9-pour-convertir-une-formule-en-un-texte-de-valeur-statique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"6 bir form\u00fcl\u00fc minimum statik de\u011fer metnine d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in f9 tu\u015funa bas\u0131n\"><\/figure><\/div><p> Art\u0131k uygun metin durumuna d\u00f6n\u00fc\u015ft\u00fcrebilece\u011finiz tek bir metin de\u011feriniz var.<\/p><h2 class=\"wp-block-heading\"> 6. Power Query ile form\u00fcl sonu\u00e7 de\u011ferini al\u0131n<\/h2><p> Bazen bir form\u00fcl\u00fcn sonu\u00e7 de\u011ferini d\u00f6n\u00fc\u015ft\u00fcrmek yerine ayr\u0131 bir h\u00fccreye alman\u0131z gerekebilir. Ve bu durumda bir g\u00fc\u00e7 sorgusu kullanabilirsiniz.<\/p><p> M\u00fc\u015fterinize g\u00f6ndermeden \u00f6nce onu de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrmeniz gerekir. Ama olay \u015fu ki, t\u00fcm form\u00fclleri kaybetmek istemezsin. \u0130\u015fte g\u00fc\u00e7 sorgusu kullanarak form\u00fcllerden de\u011fer alman\u0131n basit ad\u0131mlar\u0131.<\/p><ul><li> Tabloyu se\u00e7in ve Veri sekmesine gidin \u279c Al ve D\u00f6n\u00fc\u015ft\u00fcr \u279c Tablodan. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-charger-des-donnees-dans-une-requete-de-puissance-pour-convertir-la-formule-en-une-valeur-min-1.png\" sizes=\"\" srcset=\"\" alt=\"7 form\u00fcl\u00fc minimum de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in verileri bir g\u00fc\u00e7 sorgusuna y\u00fckleyin\"><\/figure><\/div><ul><li> Bu, tablonuzu Power Query D\u00fczenleyicisi&#8217;nde a\u00e7acakt\u0131r. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-donnees-dans-lediteur-de-requete-de-puissance-pour-convertir-la-formule-en-une-valeur-statique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Form\u00fcl\u00fc statik bir minimum de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in g\u00fc\u00e7 sorgusu d\u00fczenleyicisindeki 8 veri\"><\/figure><\/div><ul><li> Oradan \u201cKapat ve Y\u00fckle\u201dye t\u0131klaman\u0131z yeterli. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-fermez-et-chargez-les-donnees-dans-une-feuille-Excel-pour-convertir-la-formule-en-une-valeur-statique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"9 form\u00fcl\u00fc statik bir minimum de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in verileri kapat\u0131n ve bir Excel sayfas\u0131na y\u00fckleyin\"><\/figure><\/div><ul><li> Art\u0131k g\u00fc\u00e7 sorgusu, form\u00fcller yerine fiyat de\u011ferlerinin bulundu\u011fu yeni bir sayfaya yeni bir tablo ekleyecektir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-obtenir-des-donnees-dans-une-feuille-separee-apres-avoir-converti-une-formule-en-une-valeur-min-1.png\" sizes=\"\" srcset=\"\" alt=\"10 form\u00fcl\u00fc minimum de\u011fere d\u00f6n\u00fc\u015ft\u00fcrd\u00fckten sonra verileri ayr\u0131 bir sayfada al\u0131n\"><\/figure><\/div><p> En iyi yan\u0131, form\u00fcl tablonuzda de\u011fi\u015fiklik yapt\u0131\u011f\u0131n\u0131zda g\u00fc\u00e7 sorgusu tablosunu yenilemenizdir. Bu y\u00f6ntemi kullanarak her seferinde verileri kopyalay\u0131p yap\u0131\u015ft\u0131rman\u0131za gerek kalmaz.<\/p><h2 class=\"wp-block-heading\"> \u200b\u200b\u200b\u200b\u200b\u200bSonu\u00e7<\/h2><p> Bazen karma\u015f\u0131k ve b\u00fcy\u00fck form\u00fcller kullanmak \u00e7al\u0131\u015fma kitab\u0131n\u0131z\u0131n boyutunu art\u0131r\u0131r. Bu y\u00fczden ba\u015fkalar\u0131yla payla\u015fmadan \u00f6nce bunlar\u0131 mutlak de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrmek daha iyidir.<\/p><p> Yukar\u0131da tart\u0131\u015ft\u0131\u011f\u0131m\u0131z t\u00fcm y\u00f6ntemler size farkl\u0131 durumlarda yard\u0131mc\u0131 olabilir. Bana sorarsan\u0131z favorim klavye k\u0131sayolu ama bazen PowerQuery kullanmay\u0131 da seviyorum.<\/p><p> Umar\u0131m bu ipucunu faydal\u0131 bulmu\u015fsundur, ama \u015fimdi bana bir \u015fey s\u00f6yle.<\/p><p> Senin favorin ne? Form\u00fclleri de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in kulland\u0131\u011f\u0131n\u0131z ba\u015fka bir y\u00f6ntem var m\u0131?<\/p><p> L\u00fctfen yorum b\u00f6l\u00fcm\u00fcnde benimle payla\u015f\u0131n, sizden haber almak isterim ve bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim onlar da bunu takdir edeceklerdir.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excelin-temelleri\/\">Microsoft Excel Temelleri (Bile\u015fenler, Par\u00e7alar ve Bilgi Notlar\u0131)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/\">Negatif bir say\u0131y\u0131 Excel&#8217;de pozitife d\u00f6n\u00fc\u015ft\u00fcrme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-damgasi\/\">Excel&#8217;e zaman damgas\u0131 ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pire\/\">Excel&#8217;e madde i\u015faretleri ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-ok-ekle\/\">Excel&#8217;de bir h\u00fccreye ok ekleme<\/a><\/li><li> Excel&#8217;de seri numaralar\u0131n\u0131 otomatik olarak ekleme <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1888","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de Form\u00fcl\u00fc De\u011fere D\u00f6n\u00fc\u015ft\u00fcrmenin 6 Yolu (2023)<\/title>\n<meta name=\"description\" content=\"\u0130\u015fe ba\u015flad\u0131\u011f\u0131m ilk g\u00fcnlerden itibaren zor bir \u015fey \u00f6\u011frendim. Buradaki fikir basit\u00e7e bir form\u00fcl\u00fc de\u011feriyle de\u011fi\u015ftirmektir.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Form\u00fcl\u00fc De\u011fere D\u00f6n\u00fc\u015ft\u00fcrmenin 6 Yolu (2023)\" \/>\n<meta property=\"og:description\" content=\"\u0130\u015fe ba\u015flad\u0131\u011f\u0131m ilk g\u00fcnlerden itibaren zor bir \u015fey \u00f6\u011frendim. Buradaki fikir basit\u00e7e bir form\u00fcl\u00fc de\u011feriyle de\u011fi\u015ftirmektir.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:58:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-des-cellules-pour-convertir-des-formules-en-une-valeur-statique-min-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/\",\"name\":\"Excel&#39;de Form\u00fcl\u00fc De\u011fere D\u00f6n\u00fc\u015ft\u00fcrmenin 6 Yolu (2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-des-cellules-pour-convertir-des-formules-en-une-valeur-statique-min-1.png\",\"datePublished\":\"2023-10-30T01:52:26+00:00\",\"dateModified\":\"2023-12-10T05:58:52+00:00\",\"description\":\"\u0130\u015fe ba\u015flad\u0131\u011f\u0131m ilk g\u00fcnlerden itibaren zor bir \u015fey \u00f6\u011frendim. Buradaki fikir basit\u00e7e bir form\u00fcl\u00fc de\u011feriyle de\u011fi\u015ftirmektir.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-des-cellules-pour-convertir-des-formules-en-une-valeur-statique-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-des-cellules-pour-convertir-des-formules-en-une-valeur-statique-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bir form\u00fcl\u00fc excel&#39;deki bir de\u011fere nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de Form\u00fcl\u00fc De\u011fere D\u00f6n\u00fc\u015ft\u00fcrmenin 6 Yolu (2023)","description":"\u0130\u015fe ba\u015flad\u0131\u011f\u0131m ilk g\u00fcnlerden itibaren zor bir \u015fey \u00f6\u011frendim. Buradaki fikir basit\u00e7e bir form\u00fcl\u00fc de\u011feriyle de\u011fi\u015ftirmektir.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Form\u00fcl\u00fc De\u011fere D\u00f6n\u00fc\u015ft\u00fcrmenin 6 Yolu (2023)","og_description":"\u0130\u015fe ba\u015flad\u0131\u011f\u0131m ilk g\u00fcnlerden itibaren zor bir \u015fey \u00f6\u011frendim. Buradaki fikir basit\u00e7e bir form\u00fcl\u00fc de\u011feriyle de\u011fi\u015ftirmektir.","og_url":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:58:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-des-cellules-pour-convertir-des-formules-en-une-valeur-statique-min-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/","url":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/","name":"Excel&#39;de Form\u00fcl\u00fc De\u011fere D\u00f6n\u00fc\u015ft\u00fcrmenin 6 Yolu (2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-des-cellules-pour-convertir-des-formules-en-une-valeur-statique-min-1.png","datePublished":"2023-10-30T01:52:26+00:00","dateModified":"2023-12-10T05:58:52+00:00","description":"\u0130\u015fe ba\u015flad\u0131\u011f\u0131m ilk g\u00fcnlerden itibaren zor bir \u015fey \u00f6\u011frendim. Buradaki fikir basit\u00e7e bir form\u00fcl\u00fc de\u011feriyle de\u011fi\u015ftirmektir.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/deger-formulu\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-des-cellules-pour-convertir-des-formules-en-une-valeur-statique-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-des-cellules-pour-convertir-des-formules-en-une-valeur-statique-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/deger-formulu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Bir form\u00fcl\u00fc excel&#39;deki bir de\u011fere nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrebilirim?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1888","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1888"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1888\/revisions"}],"predecessor-version":[{"id":2277,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1888\/revisions\/2277"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}