{"id":1487,"date":"2023-11-22T02:51:17","date_gmt":"2023-11-22T02:51:17","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/tavsiye\/"},"modified":"2023-12-10T06:04:18","modified_gmt":"2023-12-10T06:04:18","slug":"tavsiye","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/tavsiye\/","title":{"rendered":"Profesyonel olmak i\u0307\u00e7in 100 gizli excel i\u0307pucu\/p\u00fcf noktas\u0131"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-867921348\"><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> <div class=\"gb-container gb-container-897a20e8\"><div class=\"adthrive-video-player in-post\" data-video-id=\"Bqgp3l1Q\" data-player-type=\"default\"> <a href=\"https:\/\/exceladvisor.org\/tr\/excelin-temelleri\/\"><strong>Excel \u00f6\u011frenmenin<\/strong><\/a> EN HIZLI yollar\u0131ndan biri, baz\u0131 Excel \u0130PU\u00c7LARI ve P\u00fcf Noktalar\u0131n\u0131 \u00f6\u011frenmektir ve g\u00fcnde yaln\u0131zca bir Excel ipucu \u00f6\u011frenirseniz, bir ayda 30 yeni \u015fey \u00f6\u011frenebilirsiniz.<\/div><\/div><p> Ancak orada burada aramak yerine her g\u00fcn ba\u015fvurabilece\u011finiz bir listenizin olmas\u0131 gerekiyor. Bunun, \u0130NTERNET&#8217;te bulabilece\u011finiz <strong>t\u00fcm temel ve ileri d\u00fczey ipu\u00e7lar\u0131n\u0131 i\u00e7eren en kapsaml\u0131 liste<\/strong> oldu\u011funu s\u00f6ylemekten b\u00fcy\u00fck gurur duyuyorum.<\/p><p> Bu L\u0130STE&#8217;de, <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\"><strong>Excel becerilerinizi<\/strong><\/a> geli\u015ftirmek i\u00e7in \u00f6\u011frenebilece\u011finiz <strong>100&#8217;den fazla Excel \u0130PUCU ve P\u00fcf Noktas\u0131n\u0131<\/strong> ele ald\u0131m.<\/p><h2> En \u0130yi Excel P\u00fcf Noktalar\u0131 (Temelden \u0130leri D\u00fczey&#8217;e) <\/h2><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-1-add-serial-numbers\" class=\"wp-block-heading\"> 1. Seri numaralar\u0131n\u0131 ekleyin<\/h3><p> B\u00fcy\u00fck verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z buna bir seri numaras\u0131 s\u00fctunu eklemek en iyisidir. Bana g\u00f6re bunu yapman\u0131n en iyi yolu diziyi (Control + T) verilere uygulamak ve ard\u0131ndan yukar\u0131daki seri numaras\u0131na a\u015fa\u011f\u0131daki gibi 1 eklemek. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-astuces-Excel-pour-ajouter-des-numeros-de-serie-1.png\" sizes=\"\" srcset=\"\" alt=\"Seri Numaralar\u0131 Eklemek i\u00e7in Excel \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\"><\/figure><\/div><p> Bunu yapmak i\u00e7in s\u00fctundaki ilk h\u00fccreye 1 ekleyin ve ard\u0131ndan yukar\u0131daki h\u00fccrenin de\u011ferine 1 ekleyecek bir form\u00fcl olu\u015fturun.<\/p><p> Tablo kulland\u0131\u011f\u0131n\u0131z i\u00e7in, tabloda yeni bir giri\u015f olu\u015fturdu\u011funuzda Excel otomatik olarak form\u00fcl\u00fc a\u00e7acakt\u0131r ve seri numaras\u0131n\u0131 alacaks\u0131n\u0131z. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-2-insert-current-date-and-time\" class=\"wp-block-heading\"> 2. Ge\u00e7erli tarih ve saati girin<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/bugunun-tarihi-simdiki-saat\/\">Ge\u00e7erli tarih ve saati<\/a> eklemenin en iyi yolu, sistem tarih ve saatini al\u0131p d\u00f6nd\u00fcren \u015e\u0130MD\u0130 i\u015flevini kullanmakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19320\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-astuces-Excel-astuces-inserer-la-date-et-lheure-actuelles-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 ge\u00e7erli tarih ve saati ekleme\" width=\"361\" height=\"107\"><\/figure><\/div><p> Bu fonksiyonla ilgili tek sorun de\u011fi\u015fken olmas\u0131d\u0131r ve bir \u015feyi her yeniden hesaplad\u0131\u011f\u0131n\u0131zda de\u011ferini g\u00fcnceller. Ve e\u011fer bunu yapmak istemiyorsan\u0131z, en iyi yol <a href=\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/\" data-wpil=\"url\">onu somut de\u011fere d\u00f6n\u00fc\u015ft\u00fcrmektir<\/a> . A\u015fa\u011f\u0131daki VBA kodunu da kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub timestamp() Dim ts As Date With Selection .Value = Now .NumberFormat = \"m\/d\/yyyy h:mm:ss AM\/PM\" End With End Sub<\/code><\/pre><p> Veya <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-damgasi\/\">h\u00fccreye zaman damgas\u0131 eklemeye<\/a> y\u00f6nelik bu y\u00f6ntemler. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-3-select-non-continues-cells\" class=\"wp-block-heading\"> 3. S\u00fcrekli olmayan h\u00fccreleri se\u00e7in<\/h3><p> Normalde hepimiz bu \u015fekilde yap\u0131yoruz, kontrol tu\u015funa bas\u0131l\u0131 tutarak h\u00fccreleri tek tek se\u00e7iyoruz. Ancak bunun i\u00e7in \u00e7ok daha iyi bir yol oldu\u011funu buldum. Tek yapman\u0131z gereken ilk h\u00fccreyi se\u00e7ip SHIFT+F8 tu\u015flar\u0131na basmak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23094\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/astuces-excel-astuces-selectionner-des-cellules-non-adjacentes-sans-maintenir-la-touche-ctrl-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 ipu\u00e7lar\u0131 ctrl tu\u015funu bas\u0131l\u0131 tutmadan biti\u015fik olmayan h\u00fccreleri se\u00e7me\" width=\"211\" height=\"213\"><\/figure><\/div><p> Bu, h\u00fccreleri yaln\u0131zca se\u00e7erek se\u00e7ebilece\u011finiz bir se\u00e7im modu eklemenizi veya kald\u0131rman\u0131z\u0131 sa\u011flar. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-4-sort-buttons\" class=\"wp-block-heading\"> 4. S\u0131ralama d\u00fc\u011fmeleri<\/h3><p> S\u0131k s\u0131k s\u0131ralanmas\u0131 gereken verilerle \u00e7al\u0131\u015f\u0131yorsan\u0131z, <a href=\"https:\/\/exceladvisor.org\/tr\/hizli-erisim-cubugu\/\">H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011fu&#8217;na<\/a> bir d\u00fc\u011fme eklemek en iyisidir (zaten orada de\u011filse). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19324\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-astuces-excel-astuces-trier-les-boutons-qat-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 qat d\u00fc\u011fmelerini s\u0131ralama\" width=\"335\" height=\"66\"><\/figure><\/div><p> Tek yapman\u0131z gereken, H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011fundaki a\u015fa\u011f\u0131 oka t\u0131klamak, ard\u0131ndan \u201cArtan D\u00fczende S\u0131rala\u201d ve \u201cAzalan D\u00fczende S\u0131rala\u201d se\u00e7ene\u011fini se\u00e7mektir. QAT&#8217;a iki d\u00fc\u011fme ekler. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-5-move-data\" class=\"wp-block-heading\"> 5. Verileri ta\u015f\u0131y\u0131n<\/h3><p> Eminim kopyalay\u0131p yap\u0131\u015ft\u0131rmay\u0131 d\u00fc\u015f\u00fcn\u00fcyorsunuzdur ancak bunun i\u00e7in s\u00fcr\u00fckle b\u0131rak y\u00f6ntemini de kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19326\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-astuces-Excel-pour-deplacer-des-donnees-par-glisser-deposer-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"Excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 verileri s\u00fcr\u00fckleyip b\u0131rakarak ta\u015f\u0131ma\" width=\"396\" height=\"200\"><\/figure><\/div><p> Verilerinizin bulundu\u011fu aral\u0131\u011f\u0131 se\u00e7in ve ard\u0131ndan se\u00e7imin kenarl\u0131\u011f\u0131n\u0131 t\u0131klay\u0131n. Onu tutarak, koyman\u0131z gereken yere gidin. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-6-status-bar\" class=\"wp-block-heading\"> 6. Durum \u00e7ubu\u011fu<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/durum-cubugu\/\">Durum \u00e7ubu\u011fu<\/a> hala orada ancak onu neredeyse sonuna kadar kullanm\u0131yoruz. \u00dczerine sa\u011f t\u0131klarsan\u0131z ekleyebilece\u011finiz bir\u00e7ok se\u00e7ene\u011fin oldu\u011funu g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19328\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-astuces-Excel-astuces-barre-detat-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel ipu\u00e7lar\u0131 durum \u00e7ubu\u011fu ipu\u00e7lar\u0131\" width=\"514\" height=\"49\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-7-clipboard\" class=\"wp-block-heading\"> 7. Pano<\/h3><p> Normal <a href=\"https:\/\/exceladvisor.org\/tr\/kopyala-yapistir\/\">kopyalama ve yap\u0131\u015ft\u0131rmada<\/a> , ayn\u0131 anda yaln\u0131zca tek bir de\u011fer kullanabilece\u011finiz bir sorun vard\u0131r.<\/p><p> <strong>Ancak i\u015fin ilgin\u00e7 taraf\u0131 \u015fu:<\/strong> Bir de\u011feri kopyalad\u0131\u011f\u0131n\u0131zda panoya gider ve panoyu a\u00e7t\u0131\u011f\u0131n\u0131zda kopyalad\u0131\u011f\u0131n\u0131z t\u00fcm de\u011ferleri yap\u0131\u015ft\u0131rabilirsiniz. Bir panoyu a\u00e7mak i\u00e7in Ana Sayfa sekmesine git \u279c D\u00fczenleme&#8217;yi ve ard\u0131ndan a\u015fa\u011f\u0131 oku t\u0131klay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19330\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-trucs-et-astuces-excel-cliquez-sur-le-tableau-ouvert-a-partir-de-longlet-daccueil.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 ana sekmeden a\u00e7\u0131lan tabloya t\u0131klay\u0131n\" width=\"449\" height=\"293\"><\/figure><\/div><p> Bu, sol taraftaki panoyu a\u00e7acakt\u0131r ve de\u011ferleri oraya yap\u0131\u015ft\u0131rabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19331\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-astuces-excel-trucs-presse-papiers-copier-coller-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 panoya kopyala yap\u0131\u015ft\u0131r\" width=\"190\" height=\"187\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-8-bullet-points\" class=\"wp-block-heading\"> 8. Mermiler<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/pire\/\">Excel&#8217;de madde i\u015faretleri eklemenin<\/a> en kolay yolu \u00f6zel bi\u00e7imlendirme kullanmakt\u0131r ve izlenecek ad\u0131mlar a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p><ol><li> <a href=\"https:\/\/exceladvisor.org\/tr\/acik-formatli-hucre-secenekleri\/\">Ctrl + 1<\/a> tu\u015flar\u0131na bast\u0131\u011f\u0131n\u0131zda \u201cH\u00fccreyi Bi\u00e7imlendir\u201d ileti\u015fim kutusunu g\u00f6receksiniz.<\/li><li> Say\u0131 sekmesi alt\u0131nda \u00d6zel&#8217;i se\u00e7in.<\/li><li> Giri\u015f \u00e7ubu\u011funa a\u015fa\u011f\u0131daki format\u0131 girin.<ol><li><mark class=\"has-inline-color\" style=\"background-color: #fdde6c;\"> \u25cf Genel;\u25cf Genel;\u25cf Genel;\u25cf Genel<\/mark><\/li><\/ol><\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-astuces-Excel-pour-la-mise-en-forme-personnalisee-des-puces-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 ipu\u00e7lar\u0131 madde i\u015faretleri i\u00e7in \u00f6zel bi\u00e7imlendirme\" width=\"503\" height=\"442\"><\/figure><\/div><p> Art\u0131k h\u00fccreye her de\u011fer girdi\u011finizde Excel bunun \u00f6n\u00fcne bir madde i\u015fareti ekler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-trucs-Excel-astuces-inserer-des-puces-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 madde i\u015faretleri ekleme\" width=\"172\" height=\"123\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-9-worksheet-copy\" class=\"wp-block-heading\"> 9. Elektronik tablonun kopyas\u0131<\/h3><p> Ayn\u0131 \u00e7al\u0131\u015fma kitab\u0131nda bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n kopyas\u0131n\u0131 olu\u015fturmak i\u00e7in en iyi yol s\u00fcr\u00fckleyip b\u0131rakmakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19337\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-astuces-Excel-pour-creer-une-copie-de-feuille-de-calcul-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 bir e-tablonun kopyas\u0131n\u0131 olu\u015fturma\" width=\"400\" height=\"68\"><\/figure><\/div><p> Sayfa ad\u0131 sekmesine t\u0131klay\u0131p bas\u0131l\u0131 tutun, ard\u0131ndan kopyay\u0131 olu\u015fturmak istedi\u011finiz yere sola veya sa\u011fa s\u00fcr\u00fckleyip b\u0131rak\u0131n. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-10-undo-redo\" class=\"wp-block-heading\"> 10. Geri Al-Yinele<\/h3><p> S\u0131ralama d\u00fc\u011fmeleri gibi, QAT&#8217;a Geri Al ve Yinele d\u00fc\u011fmelerini de ekleyebilirsiniz. Bu d\u00fc\u011fmelerin en iyi yan\u0131, bunlar\u0131, <a href=\"https:\/\/exceladvisor.org\/tr\/yinelemeyi-geri-al\/\">k\u0131sayol tu\u015funa<\/a> tekrar tekrar basman\u0131za gerek kalmadan belirli bir etkinli\u011fi iptal etmek i\u00e7in kullanabilmenizdir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19340\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-astuces-excel-astuces-annuler-les-boutons-de-retablissement-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 yineleme d\u00fc\u011fmelerini geri alma\" width=\"334\" height=\"67\"><\/figure><h3 class=\"aligncenter\"> 11. Otomatik format <\/h3><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><p><a href=\"https:\/\/exceladvisor.org\/tr\/muhasebeciler-icin-excel\/\">Finansal verilerle ilgileniyorsan\u0131z<\/a> , otomatik format en iyi ara\u00e7lar\u0131n\u0131zdan biri olabilir. Format\u0131 k\u00fc\u00e7\u00fck ve b\u00fcy\u00fck veri k\u00fcmelerine uygular (\u00f6zellikle veriler tablo bi\u00e7iminde oldu\u011funda). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19342\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-astuces-Excel-pour-utiliser-le-format-automatique-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131 Otomatik Format\u0131 Kullan\" width=\"447\" height=\"413\"><\/figure><\/div><ol><li> \u00d6ncelikle onu H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011funa eklemeniz gerekir ( <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-format\/\">ad\u0131mlar a\u015fa\u011f\u0131dad\u0131r<\/a> ).<\/li><li> Bundan sonra, format\u0131 uygulaman\u0131z gerekti\u011finde, uygulamak istedi\u011finiz verileri se\u00e7in ve h\u0131zl\u0131 eri\u015fim ara\u00e7 \u00e7ubu\u011fundaki OTOMAT\u0130K FORMAT d\u00fc\u011fmesini t\u0131klay\u0131n.<\/li><li> Bi\u00e7imlendirme t\u00fcr\u00fcn\u00fc se\u00e7meniz i\u00e7in size bir pencere g\u00f6sterecektir ve bunu se\u00e7tikten sonra Tamam&#8217;a t\u0131klay\u0131n.<\/li><\/ol><p> AUTOFORMAT alt\u0131 farkl\u0131 format\u0131n birle\u015fimidir ve uygularken bunlardan herhangi birini kapatma se\u00e7ene\u011finiz vard\u0131r. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-12-format-painter\" class=\"wp-block-heading\"> 12. Format Boyac\u0131s\u0131<\/h3><p> Format Painter&#8217;\u0131n basit fikri <strong>, format\u0131 bir b\u00f6l\u00fcmden di\u011ferine kopyalay\u0131p yap\u0131\u015ft\u0131rmakt\u0131r<\/strong> . Diyelim ki B2:D7 aral\u0131\u011f\u0131nda belirli bir bi\u00e7imlendirmeniz (yaz\u0131 tipi stili ve rengi, <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-rengi\/\">h\u00fccredeki arka plan rengi<\/a> , kal\u0131n, kenarl\u0131k vb.) var ve <a href=\"https:\/\/exceladvisor.org\/tr\/ressam-formati\/\">bi\u00e7im boyac\u0131s\u0131<\/a> ile B9:D14 aral\u0131\u011f\u0131ndaki bu bi\u00e7imlendirmeyi bir taneyle kopyalayabilirsiniz. t\u0131klamak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19344\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-trucs-et-astuces-exce-utiliser-format-peintre.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 format ressam\u0131n\u0131 kullanma\" width=\"272\" height=\"504\"><\/figure><\/div><ol><li> \u0130lk \u00f6nce B2:D7 aral\u0131\u011f\u0131n\u0131 se\u00e7in.<\/li><li> Bundan sonra Ana Sayfa sekmesi \u279c Pano&#8217;ya gidin ve ard\u0131ndan \u201cBi\u00e7im Boyac\u0131s\u0131\u201dna t\u0131klay\u0131n.<\/li><li> \u015eimdi C1 h\u00fccresini se\u00e7ti\u011finizde bi\u00e7imlendirme B9:D14&#8217;e otomatik olarak uygulanacakt\u0131r.<\/li><\/ol><p> Format Painter h\u0131zl\u0131d\u0131r ve format\u0131n bir b\u00f6l\u00fcmden di\u011ferine uygulanmas\u0131n\u0131 kolayla\u015ft\u0131r\u0131r.<\/p><p> <em>\u0130lgili: <a href=\"https:\/\/exceladvisor.org\/tr\/ressam-formati-1\/\">Bi\u00e7im Boyac\u0131s\u0131 K\u0131sayolu<\/a><\/em> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-13-cell-message\" class=\"wp-block-heading\"> 13. H\u00fccresel mesaj<\/h3><p> Diyelim ki bir h\u00fccreye &#8220;De\u011feri silmeyin&#8221;, &#8220;Ad\u0131n\u0131z\u0131 girin&#8221; veya bunun gibi belirli bir mesaj eklemeniz gerekiyor.<\/p><p> Bu durumda, s\u00f6z konusu h\u00fccre i\u00e7in bir h\u00fccre mesaj\u0131 ekleyebilirsiniz. Kullan\u0131c\u0131 bu h\u00fccreyi se\u00e7ti\u011finde belirtti\u011finiz mesaj\u0131 g\u00f6r\u00fcnt\u00fcleyecektir. \u0130zlenecek ad\u0131mlar \u015funlard\u0131r: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22339\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-creer-un-affichage-de-message-de-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 h\u00fccre mesaj\u0131 ekran\u0131 olu\u015fturma\" width=\"230\" height=\"164\"><\/figure><\/div><ol><li> \u00d6ncelikle mesaj eklemek istedi\u011finiz h\u00fccreyi se\u00e7in.<\/li><li> Bundan sonra Veri sekmesine gidin \u279c Veri Ara\u00e7lar\u0131 \u279c Veri Do\u011frulama \u279c Veri Do\u011frulama.<\/li><li> Veri Do\u011frulama penceresinde Giri\u015f Mesaj\u0131 sekmesine gidin.<\/li><li> Ba\u015fl\u0131\u011f\u0131 ve mesaj\u0131 girin ve &#8220;H\u00fccre se\u00e7ildi\u011finde giri\u015f mesaj\u0131n\u0131 g\u00f6ster&#8221; se\u00e7ene\u011finin i\u015faretlendi\u011finden emin olun.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22338\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-creer-un-message-cellulaire.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 h\u00fccre mesaj\u0131 olu\u015fturma\" width=\"396\" height=\"321\"><\/figure><\/div><p> Mesaj g\u00f6r\u00fcnt\u00fclendi\u011finde konumunu de\u011fi\u015ftirmek i\u00e7in s\u00fcr\u00fckleyip b\u0131rakabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-14-strikethrough\" class=\"wp-block-heading\"> 14. \u00dczeri \u00e7izildi<\/h3><p> Word&#8217;den farkl\u0131 olarak Excel&#8217;de \u015feritte <a href=\"https:\/\/exceladvisor.org\/tr\/cubuk-1\/\">\u00fcst\u00fc \u00e7izili uygulama<\/a> se\u00e7ene\u011fi yoktur. Ancak bunu yapman\u0131n 5 yolu oldu\u011funu ve en basitinin klavye k\u0131sayolu oldu\u011funu anlad\u0131m.<\/p><p> Tek yapman\u0131z gereken, \u00fczerini \u00e7izmek istedi\u011finiz h\u00fccreyi se\u00e7ip a\u015fa\u011f\u0131daki klavye k\u0131sayolunu kullanmak.<\/p><p> <kbd>Ctrl<\/kbd> + <kbd>5<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22336\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/barre-excel-conseils-astuces.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 ipu\u00e7lar\u0131n\u0131 g\u00f6zden ge\u00e7irin\" width=\"178\" height=\"194\"><\/figure><\/div><p> Ve MAC kullan\u0131yorsan\u0131z o zaman:<\/p><p> <kbd>\u2318<\/kbd> + <kbd>\u21e7<\/kbd> <kbd>+<\/kbd><\/p><p class=\"qt-tip\"> <strong>K\u0131sa not:<\/strong> K\u0131smi metin i\u00e7in bunu yapman\u0131z gerekiyorsa ayn\u0131 k\u0131sayol tu\u015flar\u0131n\u0131 kullanabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-15-add-barcode\" class=\"wp-block-heading\"> 15. Barkod ekleyin<\/h3><p> Bu, \u00e7o\u011fu Excel kullan\u0131c\u0131s\u0131n\u0131n g\u00f6rmezden geldi\u011fi gizli ipu\u00e7lar\u0131ndan biridir. Excel&#8217;de barkod olu\u015fturmak i\u00e7in ID-AUTOMATIC&#8217;ten <a href=\"http:\/\/www.idautomation.com\/free-barcode-products\/code39-font\/#Download_Free_Barcode_Font\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">bu barkod yaz\u0131 tipini y\u00fcklemeniz<\/a> yeterlidir.<\/p><p> Bu yaz\u0131 tipi y\u00fcklendikten sonra barkod olu\u015fturmak istedi\u011finiz h\u00fccreye numaray\u0131 yazman\u0131z ve ard\u0131ndan yaz\u0131 tipi stilini uygulaman\u0131z gerekecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20515\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-astuces-Excel-pour-installer-la-police-de-codes-a-barres-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Barkod Yaz\u0131 Tipini Y\u00fcklemek \u0130\u00e7in 15 Excel \u0130pucu\" width=\"396\" height=\"114\"><\/figure><\/div><p> \u25b7 <a href=\"https:\/\/exceladvisor.org\/tr\/barkod-ekle\/\" data-wpil=\"url\">bu ipucu hakk\u0131nda daha fazla bilgi edinin<\/a> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-16-month-name\" class=\"wp-block-heading\"> 16. Ay\u0131n ad\u0131<\/h3><p> Pekala, diyelim ki bir h\u00fccrenizde bir tarih var ve bu tarihin <a href=\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/\">ay veya y\u0131l olarak g\u00f6r\u00fcnt\u00fclenmesini<\/a> istiyorsunuz. Bunu yapmak i\u00e7in \u00f6zel bi\u00e7imlendirme uygulayabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-20517\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-astuces-Excel-montrent-la-date-sous-forme-de-mois-annee-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"16 Excel \u0130pucu Tarihi Ay Y\u0131l Olarak G\u00f6ster\" width=\"516\" height=\"454\"><\/figure><\/div><ul><li> \u0130lk \u00f6nce tarihin bulundu\u011fu h\u00fccreyi se\u00e7in ve bi\u00e7imlendirme se\u00e7eneklerini a\u00e7\u0131n (Ctrl + 1 tu\u015flar\u0131n\u0131 kullan\u0131n).<\/li><li> &#8220;\u00d6zel&#8221; se\u00e7ene\u011fini se\u00e7in ve ay i\u00e7in &#8220;MMM&#8221; veya &#8220;MMMMMM&#8221; veya y\u0131l format\u0131 i\u00e7in &#8220;YYYY&#8221; ekleyin.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> \u00d6zel bi\u00e7imlendirme, h\u00fccre bi\u00e7imlendirmesini tarihten y\u0131la\/aya de\u011fi\u015ftirir ancak de\u011fer ayn\u0131 kal\u0131r. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-17-highlight-blank-cells\" class=\"wp-block-heading\"> 17. Bo\u015f h\u00fccreleri vurgulay\u0131n<\/h3><p> B\u00fcy\u00fck veri sayfalar\u0131yla \u00e7al\u0131\u015f\u0131rken bo\u015f h\u00fccreleri tan\u0131mlamak zordur. Bu nedenle en iyi yol, h\u00fccre rengini uygulayarak bunlar\u0131 vurgulamakt\u0131r.<\/p><ul><li> \u00d6ncelikle Ctrl + A k\u0131sayol tu\u015funu kullanarak \u00e7al\u0131\u015fma sayfas\u0131ndaki t\u00fcm verileri se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21448\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-mettre-en-evidence-les-cellules-vides-selectionner-des-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"Bo\u015f H\u00fccreleri Vurgulamak i\u00e7in Excel \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131 Veri Se\u00e7in\" width=\"478\" height=\"263\"><\/figure><\/div><ul><li> Bundan sonra Ana Sayfa sekmesine gidin \u279c D\u00fczenle \u279c Bul ve Se\u00e7 \u279c \u00d6zel&#8217;e Git. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21447\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-mettre-en-surbrillance-les-cellules-vides-cliquez-sur-goto-special.png\" sizes=\"auto, \" srcset=\"\" alt=\"Bo\u015f h\u00fccreleri vurgulamak i\u00e7in Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 \u00f6zel git'e t\u0131klay\u0131n\" width=\"184\" height=\"346\"><\/figure><\/div><ul><li> \u00d6zele Git ileti\u015fim kutusunda Bo\u015f&#8217;u se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21446\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-mettre-en-surbrillance-les-cellules-vides-cliquez-sur-loption-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"Bo\u015f h\u00fccreleri vurgulamak i\u00e7in Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 bo\u015f se\u00e7ene\u011fe t\u0131klay\u0131n\" width=\"316\" height=\"332\"><\/figure><\/div><ul><li> Bu noktada t\u00fcm bo\u015f h\u00fccreleri se\u00e7tiniz ve \u015fimdi yaz\u0131 tipi ayarlar\u0131n\u0131 kullanarak h\u00fccre rengini uyguluyorsunuz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" class=\"wp-image-21445\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-mettre-en-evidence-les-cellules-vides-appliquer-la-couleur.png\" sizes=\"\" srcset=\"\" alt=\"Bo\u015f h\u00fccreleri vurgulamak ve renk uygulamak i\u00e7in Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131\"><\/figure><\/div><p> &#8230;ancak bunun i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/bos-hucreleri-vurgula\/\">ko\u015fullu bi\u00e7imlendirmeyi de kullanabilirsiniz<\/a> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-18-font-color-with-custom-formatting\" class=\"wp-block-heading\"> 18. \u00d6zel Bi\u00e7imlendirmeli Yaz\u0131 Tipi Rengi<\/h3><p> Excel&#8217;de \u00f6zel bi\u00e7imlendirme uygulayabiliriz ve \u00f6zel bi\u00e7imlendirmede yaz\u0131 tipi renklerini kullanma se\u00e7ene\u011fi vard\u0131r (s\u0131n\u0131rl\u0131d\u0131r ancak kullan\u0131\u015fl\u0131d\u0131r).<\/p><p> \u00d6rne\u011fin pozitif say\u0131lar i\u00e7in ye\u015fil, negatif say\u0131lar i\u00e7in k\u0131rm\u0131z\u0131 renk kullanmak istiyorsan\u0131z \u00f6zel format\u0131 kullanman\u0131z gerekir. <\/p><pre> [Green]#,###;[Red]-#,###;0; <\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21453\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-les-nombres-positifs-negatifs-rouges-verts-ajouter-une-mise-en-forme-personnalisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"K\u0131rm\u0131z\u0131 Ye\u015fil Pozitif Negatif Say\u0131lar i\u00e7in Excel \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131 \u00d6zel Bi\u00e7imlendirme Ekleme\" width=\"527\" height=\"465\"><\/figure><\/div><ol><li> \u00d6ncelikle bu format\u0131 uygulamak istedi\u011finiz h\u00fccreleri se\u00e7in.<\/li><li> Bundan sonra, Ctrl + 1 klavye k\u0131sayolunu kullanarak format se\u00e7ene\u011fini a\u00e7\u0131n ve giri\u015f ileti\u015fim kutusunda \u201c\u00d6zel\u201d kategorisine ve \u00d6zel Format&#8217;a gidin.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-19-theme-color\" class=\"wp-block-heading\"> 19. Tema rengi<\/h3><p> Hepimizin Excel&#8217;de kulland\u0131\u011f\u0131m\u0131z favori yaz\u0131 tipleri ve renkleri vard\u0131r. Diyelim ki i\u015f arkada\u015f\u0131n\u0131zdan bir dosya ald\u0131n\u0131z ve \u015fimdi bu dosyadan \u00e7al\u0131\u015fma sayfas\u0131n\u0131n yaz\u0131 tipini ve renklerini de\u011fi\u015ftirmek istiyorsunuz. Ger\u00e7ek \u015fu ki, bunu her \u00e7al\u0131\u015fma sayfas\u0131 i\u00e7in tek tek yapman\u0131z gerekiyor ve zaman al\u0131yor.<\/p><p> Ancak favori renk ve yaz\u0131 tiplerinizle \u00f6zel bir tema olu\u015fturursan\u0131z e-tablonun stilini tek t\u0131klamayla de\u011fi\u015ftirebilirsiniz. Bunun i\u00e7in tek yapman\u0131z gereken favori tasar\u0131mlar\u0131n\u0131z\u0131 tablolara, renkleri \u015fekil ve grafiklere ve yaz\u0131 tipi stiline uygulay\u0131p \u00f6zel bir tema olarak kaydetmek. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-enregistrer-le-theme-de-formatage.png\" sizes=\"\" srcset=\"\" alt=\"K\u0131rm\u0131z\u0131 Ye\u015fil Pozitif Negatif Say\u0131lar i\u00e7in Excel \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131 \u00d6zel Bi\u00e7imlendirme Ekleme\"><\/figure><\/div><ol><li> D\u00fczen sekmesine gidin \u279c Temalar \u279c Ge\u00e7erli temay\u0131 kaydedin. \u201c <a href=\"https:\/\/exceladvisor.org\/tr\/farkli-kaydet\/\">Farkl\u0131 Kaydet<\/a> \u201d ileti\u015fim kutusunu a\u00e7ar, teman\u0131z\u0131 adland\u0131r\u0131r ve kaydeder.<\/li><li> Ve art\u0131k her seferinde, herhangi bir \u00e7al\u0131\u015fma sayfas\u0131 stilini kendi \u00f6zel stilinizle de\u011fi\u015ftirmek i\u00e7in yaln\u0131zca tek bir t\u0131klamaya ihtiyac\u0131n\u0131z var. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-20-clear-formatting\" class=\"wp-block-heading\"> 20. Bi\u00e7imlendirmeyi Temizle<\/h3><p> Bu, bir h\u00fccrenin veya h\u00fccre aral\u0131\u011f\u0131n\u0131n bi\u00e7imlendirmesini temizlemek i\u00e7in kullanabilece\u011finiz basit bir klavye k\u0131sayoludur.<\/p><p> <kbd>Alt<\/kbd> \u279c <kbd>H<\/kbd> \u279c <kbd>E<\/kbd> \u279c <kbd>F<\/kbd><\/p><p> Aksi takdirde, Giri\u015f sekmesindeki formatlamay\u0131 temizle se\u00e7ene\u011fini de kullanabilirsiniz (Giri\u015f Sekmesi \u279c D\u00fczenle \u279c Temizle \u279c Formatlar). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-19359\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-astuces-Excel-pour-une-mise-en-forme-claire-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 ipu\u00e7lar\u0131 net bi\u00e7imlendirme\" width=\"221\" height=\"240\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-21-sentence-case\" class=\"wp-block-heading\"> 21. Ceza davalar\u0131<\/h3><p> Excel&#8217;de metni farkl\u0131 b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harflere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u00fc\u00e7 farkl\u0131 i\u015flevimiz (LOWER, UPPER ve PROPER) bulunmaktad\u0131r. Ancak metni c\u00fcmle durumuna d\u00f6n\u00fc\u015ft\u00fcrme se\u00e7ene\u011fi yoktur. \u0130\u015fte kullanabilece\u011finiz form\u00fcl:<\/p><p class=\"formula\"> =\u00dcST(SOL(A1,1))&amp;ALT(SA\u011e(A1,LEN(A1)-1)) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21500\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-convertir-en-cas-de-phrase.png\" sizes=\"auto, \" srcset=\"\" alt=\"C\u00fcmle Durumuna D\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in Excel \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131\" width=\"246\" height=\"225\"><\/figure><\/div><p> Bu form\u00fcl, bir c\u00fcmlenin ilk harfini b\u00fcy\u00fck harfe, geri kalan\u0131n\u0131 k\u00fc\u00e7\u00fck harfe d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ( <a href=\"https:\/\/exceladvisor.org\/tr\/cumle-durumu\/\"><em>bu form\u00fcl\u00fcn nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 \u00f6\u011frenin<\/em><\/a> ). <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-22-random-numbers\" class=\"wp-block-heading\"> 22. Rastgele say\u0131lar<\/h3><p> Excel&#8217;de rastgele say\u0131lar olu\u015fturmak i\u00e7in kullanabilece\u011finiz iki \u00f6zel i\u015flev vard\u0131r. Bunlardan ilki, 0 ile 1 aras\u0131nda rastgele say\u0131lar \u00fcreten RAND&#8217;d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22341\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-rand.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 ipu\u00e7lar\u0131 rand\" width=\"304\" height=\"227\"><\/figure><\/div><p> \u0130kincisi ise iki belirli say\u0131 aral\u0131\u011f\u0131nda rastgele say\u0131lar \u00fcreten RANDBETWEEN&#8217;dir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22342\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-randbetween.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 ipu\u00e7lar\u0131 rand aras\u0131nda\" width=\"421\" height=\"217\"><\/figure><\/div><p class=\"qt-tip\"> <strong>UYARI:<\/strong> Bu i\u015flevler ge\u00e7icidir, bu nedenle e-tablonuzu her yeniden hesaplad\u0131\u011f\u0131n\u0131zda veya Enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda de\u011ferlerini g\u00fcncellerler; bu nedenle bunlar\u0131 dikkatli kulland\u0131\u011f\u0131n\u0131zdan emin olun. <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-harfler-olustur\/\">Rastgele harfler<\/a> ve <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-tarih-olusturucu\/\">rastgele tarihler<\/a> olu\u015fturmak i\u00e7in RANDBETWEEN&#8217;i de kullanabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-23-count-words\" class=\"wp-block-heading\"> 23. Kelimeleri say\u0131n<\/h3><p> Excel&#8217;de kelimeleri saymak i\u00e7in \u00f6zel bir i\u015flev yoktur. LEN ile karakterleri sayabilirsiniz ancak kelimeleri sayamazs\u0131n\u0131z. Ancak <a href=\"https:\/\/exceladvisor.org\/tr\/kelimeleri-say\/\">h\u00fccredeki kelimeleri sayman\u0131za<\/a> yard\u0131mc\u0131 olabilecek a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz.<\/p><p id=\"formula\" class=\"formula\"> =UZUNLUK(A1)-UZUNLUK(YEDEK(A1,\u201d \u201c,\u201d))+1 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21503\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-compter-les-mots.png\" sizes=\"auto, \" srcset=\"\" alt=\"Kelime saymaya y\u00f6nelik Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131\" width=\"460\" height=\"113\"><\/figure><\/div><p> Bu form\u00fcl, h\u00fccredeki bo\u015fluk say\u0131s\u0131n\u0131 sayar ve ard\u0131ndan h\u00fccredeki toplam s\u00f6zc\u00fck say\u0131s\u0131na e\u015fit olan 1&#8217;i ekler. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-24-calculate-the-age\" class=\"wp-block-heading\"> 24. Ya\u015f\u0131 hesaplay\u0131n<\/h3><p> Bir ki\u015finin ya\u015f\u0131n\u0131 hesaplaman\u0131n en iyi yolu <a href=\"https:\/\/exceladvisor.org\/tr\/eger-tarih\/\">DATEDIF<\/a> kullanmakt\u0131r. Bu gizemli i\u015flev, <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-araligi\/\">tarih aral\u0131\u011f\u0131<\/a> aras\u0131ndaki fark\u0131 elde etmek i\u00e7in \u00f6zel olarak tasarlanm\u0131\u015ft\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21506\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-calculer-lage.gif\" sizes=\"auto, \" srcset=\"\" alt=\"Ya\u015f\u0131 Hesaplamak \u0130\u00e7in Excel \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131\" width=\"426\" height=\"102\"><\/figure><\/div><p> Ve form\u00fcl \u015f\u00f6yle olacak:<\/p><p class=\"formula\"> =\u201dYa\u015f\u0131n\u0131z \u201c&amp; ETAR\u0130HL\u0130(Do\u011fum Tarihi, Bug\u00fcn(),\u201dy\u201d) &amp;\u201d Y\u0131l(lar), \u201c&amp; ETAR\u0130HL\u0130(Do\u011fum Tarihi, BUG\u00dcN(),\u201dym\u201d)&amp; \u201d AY(lar) &amp; \u201c&amp; TAR\u0130HL\u0130(Do\u011fum Tarihi,BUG\u00dcN(),\u201dmd\u201d)&amp; \u201cG\u00fcn(ler).\u201d <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-25-calculate-the-ratio\" class=\"wp-block-heading\"> 25. Oran\u0131 hesaplay\u0131n<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/rapor\/\">Excel&#8217;de oran hesaplaman\u0131n d\u00f6rt farkl\u0131 yolu<\/a> oldu\u011funu anlad\u0131m ancak basit b\u00f6lme y\u00f6ntemini kullanmak en kolay\u0131d\u0131r. Tek yapman\u0131z gereken b\u00fcy\u00fck say\u0131y\u0131 k\u00fc\u00e7\u00fck say\u0131lara b\u00f6l\u00fcp onu iki nokta \u00fcst \u00fcste ve bir ile birle\u015ftirmek; i\u015fte kullanman\u0131z gereken form\u00fcl:<\/p><p class=\"formula\"> =B\u00fcy\u00fck-Say\u0131\/K\u00fc\u00e7\u00fck-Say\u0131&amp;\u201d:\u201d&amp;\u201d1\u2033 <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21842\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/astuces-excel-astuces-pour-utiliser-une-division-simple-pour-calculer-le-rapport-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 excel'de oran\u0131 hesaplamak i\u00e7in basit b\u00f6lmeyi kullanman\u0131n p\u00fcf noktalar\u0131\" width=\"324\" height=\"185\"><\/figure><\/div><p> Bu form\u00fcl b\u00fcy\u00fck say\u0131y\u0131 k\u00fc\u00e7\u00fc\u011fe b\u00f6ler, b\u00f6ylece k\u00fc\u00e7\u00fck say\u0131y\u0131 taban (1) olarak alabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-26-root-of-number\" class=\"wp-block-heading\"> 26. Say\u0131n\u0131n k\u00f6k\u00fc<\/h3><p> Bir say\u0131n\u0131n karek\u00f6k\u00fcn\u00fc, k\u00fcpk\u00f6k\u00fcn\u00fc veya herhangi bir k\u00f6k\u00fcn\u00fc hesaplaman\u0131n en iyi yolu \u00fcs form\u00fcl\u00fcn\u00fc kullanmakt\u0131r. \u00dcsl\u00fc form\u00fclde, k\u00f6k\u00fcn\u00fc hesaplamak istedi\u011finiz N&#8217;inci say\u0131y\u0131 belirtebilirsiniz.<\/p><p class=\"formula\"> =say\u0131^(1\/n)<\/p><p> \u00d6rne\u011fin, 625&#8217;in <a href=\"https:\/\/exceladvisor.org\/tr\/kare-kok\/\">karek\u00f6k\u00fcn\u00fc<\/a> hesaplamak istiyorsan\u0131z form\u00fcl \u015f\u00f6yle olacakt\u0131r:<\/p><p class=\"formula\"> =625^(1\/2) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-astuces-astuces-en-utilisant-une-formule-doperateur-exposant-pour-obtenir-la-racine-carree.png\" sizes=\"\" srcset=\"\" alt=\"Karek\u00f6k almak i\u00e7in \u00fcsl\u00fc operat\u00f6r form\u00fcl\u00fcn\u00fc kullanan excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-27-days-in-a-month\" class=\"wp-block-heading\">27. Bir aydaki g\u00fcnler<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/ayin-gunleri\/\">Bir aydaki toplam g\u00fcn say\u0131s\u0131n\u0131<\/a> dinamik olarak elde etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/p><p class=\"formula\"> =G\u00dcN(EOAY(BUG\u00dcN(),0)) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21839\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-obtenir-le-nombre-total-de-jours-dans-un-mois-en-utilisant-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 form\u00fcl\u00fc kullanarak bir aydaki toplam g\u00fcn say\u0131s\u0131n\u0131 al\u0131r\" width=\"496\" height=\"106\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-28-month-s-last-date\" class=\"wp-block-heading\"> 28. Ay\u0131n son toplant\u0131s\u0131<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/ayin-sonu\/\">Bir ay\u0131n son tarihini<\/a> almak i\u00e7in a\u015fa\u011f\u0131daki dinamik form\u00fcl\u00fc kullanabilirsiniz.<\/p><p class=\"formula\"> =TAR\u0130H(YIL(BUG\u00dcN()),AY(BUG\u00dcN())+1,0) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21511\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-la-date-de-fin-de-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"Ay Biti\u015f Tarihi i\u00e7in Excel \u0130pu\u00e7lar\u0131 ve P\u00fcf Noktalar\u0131\" width=\"505\" height=\"156\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-29-reverse-vlookup\" class=\"wp-block-heading\">29. <a href=\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/\">D\u00dc\u015eEYARA&#8217;y\u0131 Ters \u00c7evir<\/a><\/h3><p> Hepimizin bildi\u011fi gibi D\u00dc\u015eEYARA&#8217;y\u0131 kullanarak bir de\u011fer araman\u0131n yolu yoktur. Ancak INDEX MATCH&#8217;e ge\u00e7erseniz istedi\u011finiz y\u00f6ne bakabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-18408\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/index-match-exemple-de-formule-entrer-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"dizin e\u015fle\u015fme form\u00fcl\u00fc \u00f6rne\u011fi girin\" width=\"470\" height=\"410\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-30-sumproduct-if\" class=\"wp-block-heading\"> 30. E\u011eER \u00d6ZET<\/h3><p> Ko\u015ful kullanarak ko\u015fullu SUMproduct ve \u00e7arp\u0131m de\u011ferleri olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz.<\/p><p class=\"formula\"> = <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-urun-2\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u00d6ZET \u00c7ARPIM<\/a> (\u2013(C7:C19=C2),E7:E19,F7:F19) <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-31-smooth-line\" class=\"wp-block-heading\"> 31. D\u00fczg\u00fcn \u00e7izgi<\/h3><p> \u00c7izgi grafi\u011fi kullanmay\u0131 seviyorsan\u0131z harikas\u0131n\u0131z, ancak grafikte d\u00fcz bir \u00e7izgi kullansayd\u0131n\u0131z daha da harika olurdu. Bu, grafi\u011finize ak\u0131ll\u0131 bir g\u00f6r\u00fcn\u00fcm verecektir.<\/p><ol><li> Grafi\u011finizdeki veri sat\u0131r\u0131n\u0131 se\u00e7in ve \u00fczerine sa\u011f t\u0131klay\u0131n.<\/li><li> \u201cVeri Serisini Bi\u00e7imlendir\u201d se\u00e7ene\u011fini se\u00e7in.<\/li><li> Doldur ve \u00c7izgi&#8217;ye gidin \u279c \u00c7izgi \u279c \u201cD\u00fczg\u00fcn \u00c7izgi\u201d se\u00e7ene\u011fini i\u015faretleyin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21850\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/conseils-excel-astuces-conseils-de-creation-de-graphiques-graphique-a-courbes-lisses.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 ipu\u00e7lar\u0131 grafik ipu\u00e7lar\u0131 d\u00fczg\u00fcn \u00e7izgi grafi\u011fi\" width=\"411\" height=\"231\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-32-chart-formatting\" class=\"wp-block-heading\"> 32. Grafikleri Bi\u00e7imlendirme <\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" class=\"wp-image-21857\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/astuces-excel-astuces-copier-la-mise-en-forme-du-graphique-dun-graphique-a-lautre-en-utilisant-le-collage-special.gif\" sizes=\"\" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 ipu\u00e7lar\u0131 \u00f6zel yap\u0131\u015ft\u0131rmay\u0131 kullanarak grafik bi\u00e7imlendirmesini bir grafikten di\u011ferine kopyalama\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/grafik-formatini-kopyala\/\">Grafik format\u0131n\u0131 Excel&#8217;e kopyala<\/a> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-33-hide-axis-labels\" class=\"wp-block-heading\"> 33. Eksen etiketlerini gizle<\/h3><p> Bu grafik ipucu basit ama yine de olduk\u00e7a i\u015flevseldir. Eksen etiketi de\u011ferlerinin grafi\u011finizde g\u00f6r\u00fcnt\u00fclenmesini istemiyorsan\u0131z bunlar\u0131 kald\u0131rabilirsiniz. Ancak bunlar\u0131 silmek yerine gizlemek en iyisidir. \u0130\u015fte ad\u0131mlar:<\/p><ol><li> Grafikte Yatay\/Dikey ekseni se\u00e7in.<\/li><li> \u201cEkseni Bi\u00e7imlendir\u201d etiketlerine gidin.<\/li><li> Etiket konumunda &#8220;Yok&#8221;u se\u00e7in. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21860\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-pour-masquer-letiquette-de-laxe.png\" sizes=\"auto, \" srcset=\"\" alt=\"Eksen Etiketini Gizlemek i\u00e7in Excel \u0130pu\u00e7lar\u0131 P\u00fcf Noktalar\u0131\" width=\"278\" height=\"193\"><\/figure><\/div><p> Ve yine, g\u00f6stermek istiyorsan\u0131z &#8220;Eksenin Yan\u0131nda&#8221; se\u00e7ene\u011fini se\u00e7meniz yeterlidir. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-34-display-units\" class=\"wp-block-heading\"> 34. Te\u015fhir \u00fcniteleri<\/h3><p> Grafi\u011finizde b\u00fcy\u00fck say\u0131larla u\u011fra\u015f\u0131yorsan\u0131z eksen de\u011ferlerinin birimlerini de\u011fi\u015ftirebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" class=\"wp-image-21862\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-pour-masquer-letiquette-de-laxe-avant-apres.png\" sizes=\"\" srcset=\"\" alt=\"Eksen Etiketini \u00d6nce Sonra Gizlemeye Y\u00f6nelik Excel \u0130pu\u00e7lar\u0131\"><\/figure><\/div><ol><li> Grafi\u011finizin grafik eksenini se\u00e7in ve \u201cEkseni Bi\u00e7imlendir\u201d format se\u00e7eneklerini a\u00e7\u0131n.<\/li><li> Eksen Se\u00e7enekleri&#8217;nde eksen de\u011ferleriniz i\u00e7in bir birim se\u00e7ebilece\u011finiz &#8220;Birimleri G\u00f6ster&#8221; se\u00e7ene\u011fine gidin. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-35-round-corner\" class=\"wp-block-heading\"> 35. Yuvarlak k\u00f6\u015fe<\/h3><p> S\u0131k s\u0131k k\u00f6\u015feleri yuvarlat\u0131lm\u0131\u015f Excel grafikleri kullan\u0131yorum ve siz de yuvarlat\u0131lm\u0131\u015f k\u00f6\u015feleri kullanmay\u0131 seviyorsan\u0131z, basit ad\u0131mlar\u0131 burada bulabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21865\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-coin-rond-reglage-du-graphique-coche.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 yuvarlak k\u00f6\u015fe grafi\u011fi ayarlama onay i\u015fareti\" width=\"141\" height=\"34\"><\/figure><\/div><ol><li> Grafi\u011finizi se\u00e7in ve bi\u00e7imlendirme se\u00e7eneklerini a\u00e7\u0131n.<\/li><li> Doldur ve \u00c7izgile \u279c Kenarl\u0131klar&#8217;a gidin.<\/li><li> Kenarl\u0131k b\u00f6l\u00fcmlerinde yuvarlat\u0131lm\u0131\u015f k\u00f6\u015feleri kontrol edin. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-36-hide-gap\" class=\"wp-block-heading\"> 36. Bo\u015flu\u011fu Gizleyin<\/h3><p> Diyelim ki, Haziran ay\u0131nda hi\u00e7bir tutar\u0131n bulunmad\u0131\u011f\u0131 ve h\u00fccrenin bo\u015f oldu\u011fu, ayl\u0131k sat\u0131\u015flar\u0131 i\u00e7eren bir grafi\u011finiz var. Bu bo\u015f h\u00fccre i\u00e7in a\u015fa\u011f\u0131daki se\u00e7enekleri kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" class=\"wp-image-21870\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-pour-combler-lecart-pour-les-valeurs-vides.png\" sizes=\"\" srcset=\"\" alt=\"Bo\u015f de\u011ferlerdeki bo\u015flu\u011fu doldurmak i\u00e7in Excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131\"><\/figure><\/div><ul><li> Bo\u015f h\u00fccre i\u00e7in yer g\u00f6ster.<\/li><li> S\u0131f\u0131r kullan\u0131n.<\/li><li> Veri noktalar\u0131n\u0131 \u00e7izgiye ba\u011flay\u0131n.<\/li><\/ul><p> \u0130\u015fte bu se\u00e7enekleri kullanma ad\u0131mlar\u0131.<\/p><ol><li> Grafi\u011finize sa\u011f t\u0131klay\u0131n ve &#8220;Veri Se\u00e7&#8221;i se\u00e7in.<\/li><li> Veri se\u00e7im penceresinde \u201cGizli ve Bo\u015f H\u00fccre\u201dye t\u0131klay\u0131n.<\/li><li> \u201cBo\u015f h\u00fccreyi farkl\u0131 g\u00f6ster\u201d alan\u0131nda istedi\u011finiz se\u00e7ene\u011fi se\u00e7in. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9319\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/conseils-de-graphique-Excel-pour-supprimer-lecart-du-graphique-selectionnez-connecter-les-donnees-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Grafik se\u00e7imi ba\u011flant\u0131 verisindeki bo\u015flu\u011fu kald\u0131rmak i\u00e7in Excel grafik ipu\u00e7lar\u0131\" width=\"305\" height=\"140\"><\/figure><\/div><p> \u201cVeri noktalar\u0131n\u0131 hatla ba\u011fla\u201d se\u00e7ene\u011fini kulland\u0131\u011f\u0131n\u0131zdan emin olun (\u00f6nerilir). <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-37-pictograph-in-excel\" class=\"wp-block-heading\"> 37. Excel&#8217;de Piktogram<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/piktogram\/\">Excel&#8217;de bir piktogram nas\u0131l olu\u015fturulur<\/a> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-38-chart-template\" class=\"wp-block-heading\"> 38. Grafik \u015eablonu<\/h3><p> Her yeni grafik olu\u015fturdu\u011funuzda uygulamak istedi\u011finiz favori bir grafik format\u0131n\u0131z oldu\u011funu varsayal\u0131m. Gelecekte istedi\u011finiz zaman kullanmak \u00fczere bir grafik \u015fablonu olu\u015fturabilirsiniz ve ad\u0131mlar a\u015fa\u011f\u0131daki gibidir.<\/p><ul><li> Tercih etti\u011finiz bi\u00e7imlendirmeyi tamamlad\u0131ktan sonra sa\u011f t\u0131klay\u0131n ve &#8220;\u015eablon Olarak Kaydet&#8221;i se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9322\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/conseils-de-creation-de-graphiques-excel-enregistrer-en-tant-que-modele-clic-droit-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel grafik ipu\u00e7lar\u0131 \u015fablon olarak kaydet sa\u011f t\u0131klay\u0131n\" width=\"167\" height=\"276\"><\/figure><\/div><ul><li> Farkl\u0131 Kaydet ileti\u015fim kutusunu kullanarak bunu \u015fablon klas\u00f6r\u00fcne kaydedin.<\/li><li> Favori \u015fablonunuza yeni bir \u015fablon eklemek i\u00e7in Grafik Ekle ileti\u015fim kutusundaki \u015fablonlardan se\u00e7in. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9323\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/conseils-de-creation-de-graphiques-excel-enregistrer-en-tant-que-modele-appliquer-le-graphique-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel grafik ipu\u00e7lar\u0131 \u015fablon olarak kaydet grafi\u011fi uygula\" width=\"120\" height=\"304\"><\/figure><h3 class=\"aligncenter\"> 39. Varsay\u0131lan Grafik<\/h3><\/div><\/div><\/div><p> Grafik eklemek i\u00e7in bir k\u0131sayol tu\u015fu kullanabilirsiniz, ancak sorun yaln\u0131zca varsay\u0131lan grafi\u011fi ekleyebilmesidir ve Excel&#8217;de varsay\u0131lan grafik t\u00fcr\u00fc &#8220;S\u00fctun Grafi\u011fi&#8221;dir. Yani favori grafi\u011finiz \u00e7izgi grafikse k\u0131sayol sizin i\u00e7in hi\u00e7bir i\u015fe yaramaz. Ama gelin bu sorunu a\u015fal\u0131m. Bu sorunu \u00e7\u00f6zmeye y\u00f6nelik ad\u0131mlar \u015funlard\u0131r:<\/p><ul><li> Ekle sekmesi \u279c Grafikler&#8217;e gidin.<\/li><li> Sa\u011f alt k\u00f6\u015fedeki oka t\u0131klay\u0131n.<\/li><li> Daha sonra, grafik ekleme pencerenizde \u201cT\u00fcm Grafikler\u201de gidin ve grafik kategorisini se\u00e7in.<\/li><li> Varsay\u0131lan olarak ayarlamak istedi\u011finiz grafik stiline sa\u011f t\u0131klay\u0131n. \u201cVarsay\u0131lan grafik olarak ayarla\u201dy\u0131 se\u00e7in.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9324\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/conseils-de-creation-de-graphiques-Excel-modifier-le-graphique-par-defaut-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel grafik ipu\u00e7lar\u0131 varsay\u0131lan grafi\u011fi de\u011fi\u015ftirir\" width=\"490\" height=\"74\"><\/figure><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\">\n<h3 id=\"h-40-hidden-cells\" class=\"wp-block-heading\">40. Gizli H\u00fccreler<\/h3><p> Bir grafi\u011fin veri aral\u0131\u011f\u0131ndaki bir h\u00fccreyi gizledi\u011finizde, bu veri noktas\u0131 da grafikten gizlenir. Bu sorunu \u00e7\u00f6zmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 uygulaman\u0131z yeterlidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9325\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/les-conseils-de-creation-de-graphiques-Excel-affichent-la-valeur-cachee-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel grafik ipu\u00e7lar\u0131 gizli de\u011feri g\u00f6sterir\" width=\"569\" height=\"282\"><\/figure><\/div><ol><li> Grafi\u011finizi se\u00e7in ve sa\u011f t\u0131klay\u0131n.<\/li><li> \u279c Veri Se\u00e7 \u279c Gizli ve Bo\u015f H\u00fccreler&#8217;e gidin.<\/li><li> A\u00e7\u0131lan pencerede &#8220;Verileri gizli sat\u0131r ve s\u00fctunlarda g\u00f6ster&#8221; kutusunu i\u015faretleyin. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-41-print-titles\" class=\"wp-block-heading\"> 41. Bas\u0131l\u0131 ba\u015fl\u0131klar<\/h3><p> Diyelim ki masan\u0131zda ba\u015fl\u0131klar var ve bu ba\u015fl\u0131klar\u0131 yazd\u0131rd\u0131\u011f\u0131n\u0131z her sayfaya yazd\u0131rmak istiyorsunuz. Bu durumda, bu ba\u015fl\u0131klar\u0131 her sayfaya yazd\u0131rmak i\u00e7in \u201cBa\u015fl\u0131klar\u0131 Yazd\u0131r\u201d se\u00e7ene\u011fini d\u00fczeltebilirsiniz.<\/p><ul><li> \u201cYerle\u015fim Sekmesi\u201dne gidin \u279c Sayfa Yap\u0131s\u0131 \u279c Ba\u015fl\u0131klar\u0131 Yazd\u0131r&#8217;a t\u0131klay\u0131n.<\/li><li> \u015eimdi sayfa d\u00fczeni penceresinde sayfa sekmesine gidin ve a\u015fa\u011f\u0131dakileri belirtin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21885\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-impression-titre-goto.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 ba\u015fl\u0131k bas\u0131m\u0131na git\" width=\"158\" height=\"92\"><\/figure><\/div><ol><li> <strong><a href=\"https:\/\/exceladvisor.org\/tr\/yazdirma-alanini-ayarla\/\">Yazd\u0131rma alan\u0131<\/a> :<\/strong> Yazd\u0131rmak istedi\u011finiz t\u00fcm verileri se\u00e7in.<\/li><li> <strong>\u00dcstte tekrarlanacak sat\u0131rlar:<\/strong> Her sayfada tekrarlamak istedi\u011finiz ba\u015fl\u0131k sat\u0131rlar\u0131.<\/li><li> <strong>Solda tekrarlanacak s\u00fctunlar:<\/strong> Her sayfan\u0131n solunda tekrarlamak istedi\u011finiz s\u00fctunlar (varsa). <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-21886\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-imprimer-titre-selectionner.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 bas ba\u015fl\u0131\u011f\u0131 se\u00e7\" width=\"438\" height=\"163\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-42-page-order\" class=\"wp-block-heading\"> 42. Sayfa s\u0131ras\u0131<\/h3><p> B\u00fcy\u00fck verileri yazd\u0131rmak istedi\u011finizde sayfalar\u0131n s\u0131ras\u0131n\u0131 belirlemek \u00e7ok kullan\u0131\u015fl\u0131d\u0131r.<\/p><ul><li> Dosya Sekmesi \u279c Yazd\u0131r \u279c Yazd\u0131rma Kurulumu \u279c Sayfalar Sekmesi&#8217;ne gidin.<\/li><li> \u015eimdi burada iki se\u00e7ene\u011finiz var:<ul><li> <strong>\u0130lk se\u00e7enek:<\/strong> <em>Sayfalar\u0131n\u0131z\u0131 dikey s\u0131rada yazd\u0131rmak.<\/em><\/li><li> <strong>\u0130kinci se\u00e7enek:<\/strong> <em>Sayfalar\u0131n\u0131z\u0131 yatay s\u0131rada yazd\u0131rmak.<\/em> <\/li><\/ul><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-definir-le-sens-dimpression.png\" sizes=\"\" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 yazd\u0131rma y\u00f6n\u00fcn\u00fc tan\u0131mlar\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-43-print-comments\" class=\"wp-block-heading\"> 43. Yorumlar\u0131 yazd\u0131r<\/h3><p> Raporlar\u0131n\u0131za <a href=\"https:\/\/exceladvisor.org\/tr\/yorum-ekle\/\">yorum eklerseniz<\/a> bunlar\u0131 da yazd\u0131rabilirsiniz. Bas\u0131l\u0131 t\u00fcm sayfalar\u0131n sonunda t\u00fcm yorumlar\u0131n bir listesini alabilirsiniz.<\/p><ul><li> Dosya Sekmesi \u279c Yazd\u0131r \u279c Yazd\u0131rma Kurulumu \u279c Sayfalar Sekmesi&#8217;ne gidin.<\/li><li> Yazd\u0131r b\u00f6l\u00fcm\u00fcnde, Yorumlar a\u00e7\u0131l\u0131r listesini kullanarak &#8220;Sayfan\u0131n sonunda&#8221; se\u00e7ene\u011fini se\u00e7in.<\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-44-scale-to-fit\" class=\"wp-block-heading\"> 44. S\u0131\u011facak \u015eekilde \u00d6l\u00e7eklendirin<\/h3><p> Bazen t\u00fcm verileri tek bir sayfaya yazd\u0131rmak zor oluyor. Bu durumda t\u00fcm verileri tek bir sayfaya s\u0131\u011fd\u0131rmak i\u00e7in \u201cS\u0131\u011fd\u0131racak \u015eekilde \u00d6l\u00e7ekle\u201d se\u00e7ene\u011fini kullanabilirsiniz.<\/p><ol><li> Dosya Sekmesi \u279c Yazd\u0131r \u279c Yazd\u0131rma Ayar\u0131 \u279c Sayfa Sekmesi&#8217;ne gidin.<\/li><li> Daha sonra iki se\u00e7ene\u011fi ayarlaman\u0131z gerekir:<ol><li> Normal boyutun y\u00fczdesini ayarlay\u0131n.<\/li><li> Geni\u015flik ve uzunlu\u011fu kullanarak t\u00fcm verilerinizi s\u0131\u011fd\u0131rmak istedi\u011finiz sayfa say\u0131s\u0131n\u0131 belirtin. <\/li><\/ol><\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26985\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-echelle-pour-sadapter-a-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-ayarlama i\u00e7in-\u00f6l\u00e7ek\" width=\"438\" height=\"453\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-45-custom-header-footer\" class=\"wp-block-heading\"> 45. \u00d6zel \u00dcstbilgi Altbilgisi<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/altbilgi-basligi-ekle\/\">\u00dcstbilgi ve altbilgide<\/a> sayfa numaras\u0131n\u0131 kullanmak yerine \u00f6zel bir \u00fcstbilgi ve altbilgi de kullanabilirsiniz.<\/p><ul><li> Dosya sekmesine gidin \u279c Yazd\u0131r \u279c Yazd\u0131rma Kurulumu \u279c \u00dcstbilgi\/Altbilgi.<\/li><li> \u00d6zel \u00fcstbilgi veya altbilgi d\u00fc\u011fmesini t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26988\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-echelle-pour-sadapter-a-2-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-ayarlama i\u00e7in-\u00f6l\u00e7ek\" width=\"438\" height=\"453\"><\/figure><\/div><ul><li> Burada \u00fcstbilgi\/altbilgi hizalamas\u0131n\u0131 se\u00e7ebilirsiniz. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26991\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-echelle-pour-sadapter-a-3-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-ayarlama i\u00e7in-\u00f6l\u00e7ek\" width=\"659\" height=\"351\"><\/figure><\/div><ul><li> Ve a\u015fa\u011f\u0131daki se\u00e7enekler kullan\u0131labilir:<ol><li> Sayfa numaras\u0131<\/li><li> Toplam sayfa say\u0131s\u0131n\u0131 i\u00e7eren sayfa numaras\u0131.<\/li><li> Tarih<\/li><li> Zaman<\/li><li> Dosya yolu<\/li><li> Dosya ad\u0131<\/li><li> Sayfa ad\u0131<\/li><li> Resim <\/li><\/ol><\/li><\/ul><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-46-center-on-page\" class=\"wp-block-heading\"> 46. Sayfan\u0131n ortas\u0131nda<\/h3><p> Bir sayfaya yazd\u0131r\u0131lacak daha az veriye sahip oldu\u011funuzu d\u00fc\u015f\u00fcn\u00fcn. Bu durumda yazd\u0131r\u0131rken sayfan\u0131n ortas\u0131na hizalayabilirsiniz.<\/p><ol><li> Dosya sekmesine gidin \u279c Yazd\u0131r \u279c Yazd\u0131rma Kurulumu \u279c Kenar Bo\u015fluklar\u0131.<\/li><li> \u201cSayfay\u0131 ortala\u201d b\u00f6l\u00fcm\u00fcnde se\u00e7ebilece\u011finiz iki se\u00e7ene\u011finiz vard\u0131r.<ul><li> <strong>Yatay:<\/strong> verileri sayfan\u0131n ortas\u0131na hizalar.<\/li><li> <strong>Dikey:<\/strong> Verileri sayfan\u0131n ortas\u0131na hizalar. <\/li><\/ul><\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26998\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-aligner-imprimer-page-centre-milieu.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-hizalama-bask\u0131-sayfa-orta-orta\" width=\"388\" height=\"368\"><\/figure><\/div><p> Bir sayfay\u0131 yazd\u0131rmadan \u00f6nce <a href=\"https:\/\/exceladvisor.org\/tr\/baski-onizleme-1\/\">bask\u0131 \u00f6nizlemesinde<\/a> de\u011fi\u015fiklikleri g\u00f6rd\u00fc\u011f\u00fcn\u00fczden emin olun. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-47-print-area\" class=\"wp-block-heading\"> 47. Yazd\u0131rma alan\u0131<\/h3><p> Bir aral\u0131\u011f\u0131 yazd\u0131rman\u0131n en kolay yolu, o aral\u0131\u011f\u0131 se\u00e7ip \u201cse\u00e7imi yazd\u0131r\u201d se\u00e7ene\u011fini kullanmakt\u0131r. Peki ya bu aral\u0131\u011f\u0131 s\u0131k s\u0131k yazd\u0131rman\u0131z gerekiyorsa, o zaman her seferinde se\u00e7meden yazd\u0131rma alan\u0131n\u0131 belirleyip yazd\u0131rabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-10563\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-zone-dimpression-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"minimum yazd\u0131rma alan\u0131na t\u0131klay\u0131n\" width=\"305\" height=\"157\"><\/figure><\/div><p> D\u00fczen sekmesine gidin, Yazd\u0131rma Alan\u0131 a\u00e7\u0131l\u0131r men\u00fcs\u00fcne t\u0131klay\u0131n ve ard\u0131ndan Yazd\u0131rma Alan\u0131n\u0131 Ayarla se\u00e7ene\u011fine t\u0131klay\u0131n. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-48-custom-margin\" class=\"wp-block-heading\"> 48. \u00d6zel kenar bo\u015flu\u011fu<\/h3><ul><li> Dosya sekmesine gidin \u279c Yazd\u0131r.<\/li><li> Yazd\u0131r&#8217;a t\u0131klad\u0131\u011f\u0131n\u0131zda \u00e7\u0131kt\u0131n\u0131n an\u0131nda \u00f6nizlemesini g\u00f6receksiniz.<\/li><li> \u015eimdi pencerenin sa\u011f alt k\u0131sm\u0131ndaki \u201cKenar Bo\u015fluklar\u0131n\u0131 G\u00f6ster\u201d d\u00fc\u011fmesine t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27001\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-montrent-des-marges-personnalisees.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-\u00f6zel-kenar bo\u015fluklar\u0131n\u0131 g\u00f6ster\" width=\"105\" height=\"68\"><\/figure><\/div><p> Uygulanan t\u00fcm kenar bo\u015fluklar\u0131n\u0131 g\u00f6sterecektir ve bunlar\u0131 yaln\u0131zca s\u00fcr\u00fckleyip b\u0131rakarak de\u011fi\u015ftirebilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-49-error-values\" class=\"wp-block-heading\"> 49. Hata de\u011ferleri<\/h3><p> Yazd\u0131rma s\u0131ras\u0131nda t\u00fcm hata de\u011ferlerini belirli bir de\u011ferle de\u011fi\u015ftirebilirsiniz (de\u011fi\u015ftirme olarak kullan\u0131lacak di\u011fer \u00fc\u00e7 de\u011fer).<\/p><ul><li> Dosya sekmesine gidin \u279c Yazd\u0131r \u279c Yazd\u0131rma Kurulumu \u279c Sayfa.<\/li><li> &#8220;H\u00fccre hatas\u0131 olarak&#8221; a\u00e7\u0131l\u0131r listesinden de\u011fi\u015ftirme de\u011ferini se\u00e7in.<\/li><li> Yedek olarak kullanabilece\u011finiz \u00fc\u00e7 se\u00e7ene\u011finiz var.<ol><li> Beyaz<\/li><li> \u00c7ift eksi i\u015fareti.<\/li><li> T\u00fcm hatalar i\u00e7in &#8220;#N\/A&#8221; hatas\u0131. <\/li><\/ol><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27004\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/astuces-excel-astuces-remplacer-les-erreurs-lors-de-limpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-yazd\u0131rma s\u0131ras\u0131nda-hatalar\u0131 de\u011fi\u015ftirme\" width=\"438\" height=\"453\"><\/figure><\/div><ul><li> De\u011fi\u015ftirme de\u011ferini se\u00e7tikten sonra Tamam&#8217;a t\u0131klay\u0131n.<\/li><\/ul><p> Bir raporu sayfaya yazd\u0131r\u0131rken hatalar\u0131 sunman\u0131n en iyi yolunun &#8220;\u00e7ift eksi i\u015fareti&#8221; kullanmak oldu\u011funu d\u00fc\u015f\u00fcn\u00fcyorum. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-50-custom-start-page-number\" class=\"wp-block-heading\"> 50. \u00d6zel Ba\u015flang\u0131\u00e7 Sayfas\u0131 Numaras\u0131<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfa-numarasi-ekle\/\">Sayfa numaras\u0131n\u0131<\/a> \u00f6zel bir numaradan ba\u015flatmak istiyorsan\u0131z 5 deyin. Bu numaray\u0131 belirtebilirsiniz, geri kalan sayfalar bu s\u0131ray\u0131 takip edecektir.<\/p><ul><li> Dosya sekmesine gidin \u279c Yazd\u0131r \u279c Yazd\u0131rma Kurulumu \u279c Sayfa.<\/li><li> &#8220;\u0130lk sayfa numaras\u0131&#8221; giri\u015f alan\u0131na sayfa numaras\u0131n\u0131 ba\u015flatmak istedi\u011finiz numaray\u0131 girin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27004\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/astuces-excel-astuces-remplacer-les-erreurs-lors-de-limpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-yazd\u0131rma s\u0131ras\u0131nda-hatalar\u0131 de\u011fi\u015ftirme\" width=\"438\" height=\"453\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p class=\"has-medium-font-size\"> Bu se\u00e7enek yaln\u0131zca e-tablonuzda \u00fcst bilgi\/alt bilgi uygulad\u0131ysan\u0131z \u00e7al\u0131\u015f\u0131r. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-51-tracking-important-cells\" class=\"wp-block-heading\"> 51. \u00d6nemli H\u00fccrelerin Takibi<\/h3><p> Bazen bir \u00e7al\u0131\u015fma kitab\u0131ndaki <a href=\"https:\/\/exceladvisor.org\/tr\/pencereyi-izle\/\">baz\u0131 \u00f6nemli h\u00fccreleri izlememiz<\/a> gerekir ve bunun i\u00e7in en iyi yol Watch Window&#8217;u kullanmakt\u0131r. \u0130zleme penceresinde, bu \u00f6nemli h\u00fccreleri ekler ve ard\u0131ndan bunlar hakk\u0131ndaki belirli bilgileri tek bir yerden al\u0131rs\u0131n\u0131z (her h\u00fccreye gitmeden).<\/p><ul><li> \u00d6ncelikle Form\u00fcl Sekmesi \u279c Form\u00fcl Denetimi \u279c \u0130zleme Penceresi&#8217;ne gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27009\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-utiliser-la-fenetre-de-surveillance.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-kullan\u0131m-izleme-penceresi\" width=\"315\" height=\"95\"><\/figure><\/div><ul><li> \u015eimdi \u201c\u0130zleme Penceresi\u201d ileti\u015fim kutusunda \u201c\u0130zleme Ekle\u201dye t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27011\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/astuces-excel-astuce-ajouter-une-cellule-a-la-fenetre-de-surveillance.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u0130zleme penceresine h\u00fccre ekleme hilesi ile ilgili Excel ipu\u00e7lar\u0131\" width=\"504\" height=\"171\"><\/figure><\/div><ul><li> Bundan sonra eklemek istedi\u011finiz h\u00fccreyi veya h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7in ve Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Tamam&#8217;a t\u0131klad\u0131\u011f\u0131n\u0131zda, izleme penceresinde h\u00fccre(ler) hakk\u0131nda \u00f6zel bilgiler alacaks\u0131n\u0131z. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-52-flash-fill\" class=\"wp-block-heading\"> 52. An\u0131nda Doldurma<\/h3><p> Flash dolgusu, Excel&#8217;de kullanmay\u0131 en sevdi\u011fim se\u00e7eneklerden biridir. Taklit\u00e7i gibi, yapt\u0131\u011f\u0131n\u0131z g\u00f6revi yap\u0131n. Sana bir \u00f6rnek vereyim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27018\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/astuces-excel-astuces-pour-utiliser-flashfill.gif\" sizes=\"auto, \" srcset=\"\" alt=\"flashfill'i-kullanmak i\u00e7in excel-tavsiyeleri-p\u00fcf noktalar\u0131\" width=\"236\" height=\"188\"><\/figure><\/div><p> Bunu kullanma ad\u0131mlar\u0131 \u015funlard\u0131r: A1:A10 aral\u0131\u011f\u0131nda tarihleriniz var ve \u015fimdi B s\u00fctunundaki tarihlerden ay\u0131 almak istiyorsunuz.<\/p><p> Tek yapman\u0131z gereken, B1 h\u00fccresine ilk tarihin ay\u0131n\u0131 yazmak, ard\u0131ndan B2 h\u00fccresine gidip CTRL + E k\u0131sayol tu\u015funa basmakt\u0131r. \u0130\u015finiz bitti\u011finde, ay, a\u015fa\u011f\u0131daki gibi, geri kalan tarihlerin i\u00e7inden \u00e7\u0131kar\u0131lacakt\u0131r. . <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-53-combine-worksheets\" class=\"wp-block-heading\"> 53. Elektronik Tablolar\u0131 Birle\u015ftirin<\/h3><p> Eminim ge\u00e7mi\u015fte bir yerlerde meslekta\u015f\u0131n\u0131zdan 12 ayl\u0131k veriler i\u00e7in 12 farkl\u0131 e-tablonun bulundu\u011fu bir dosya alm\u0131\u015fs\u0131n\u0131zd\u0131r. Bu durumda en iyi \u00e7\u00f6z\u00fcm, <a href=\"https:\/\/exceladvisor.org\/tr\/pekistirmek\/\" data-wpil=\"url\">t\u00fcm bu \u00e7al\u0131\u015fma sayfalar\u0131n\u0131 \u201cBirle\u015ftir\u201d se\u00e7ene\u011fini kullanarak birle\u015ftirmektir<\/a> ve izlenecek ad\u0131mlar a\u015fa\u011f\u0131da verilmi\u015ftir.<\/p><ul><li> Yeni bir \u00e7al\u0131\u015fma sayfas\u0131 ekleyerek ba\u015flay\u0131n, ard\u0131ndan Veri sekmesi \u279c Veri Ara\u00e7lar\u0131 \u279c Birle\u015ftir&#8217;e gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27022\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-utiliser-la-fenetre-de-surveillance.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-kullan\u0131m-izleme-penceresi\" width=\"327\" height=\"91\"><\/figure><\/div><ul><li> \u015eimdi \u201cBirle\u015ftir\u201d penceresinde, ilk \u00e7al\u0131\u015fma sayfas\u0131ndaki aral\u0131\u011f\u0131 eklemek i\u00e7in \u00fcst oka t\u0131klay\u0131n ve ard\u0131ndan \u201cEkle\u201d d\u00fc\u011fmesine t\u0131klay\u0131n.<\/li><li> Daha sonra yukar\u0131daki ad\u0131m\u0131 kullanarak t\u00fcm \u00e7al\u0131\u015fma sayfalar\u0131n\u0131n referanslar\u0131n\u0131 eklemeniz gerekir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27023\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-ajouter-une-reference-combiner-des-feuilles-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-referans-ekleme-\u00e7al\u0131\u015fma sayfalar\u0131n\u0131 birle\u015ftirme\" width=\"430\" height=\"300\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-54-protect-a-workbook\" class=\"wp-block-heading\"> 54. Bir ciltleyiciyi koruyun<\/h3><p> \u00c7al\u0131\u015fma kitab\u0131na parola eklemek olduk\u00e7a basittir; ad\u0131mlar\u0131 burada bulabilirsiniz.<\/p><ul><li> &#8220;Farkl\u0131 Kaydet&#8221; ileti\u015fim kutusunu a\u00e7t\u0131\u011f\u0131n\u0131zda bir dosyay\u0131 kaydederken Ara\u00e7lar Genel Se\u00e7enekler&#8217;e gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27026\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-cliquez-sur-options-generales-mot-de-passe.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-t\u0131klama-genel-se\u00e7enekler-\u015fifre\" width=\"304\" height=\"144\"><\/figure><\/div><ul><li> \u201cA\u00e7\u0131lacak \u015fifre\u201dye bir \u015fifre ekleyin ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27028\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-entrer-le-mot-de-passe.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-\u015fifreyi-girin\" width=\"284\" height=\"178\"><\/figure><\/div><ul><li> \u015eifreyi tekrar girin ve tekrar Tamam&#8217;a t\u0131klay\u0131n.<\/li><li> Sonunda dosyay\u0131 kaydedin.<\/li><\/ul><p> Art\u0131k bu dosyay\u0131 her yeniden a\u00e7\u0131\u015f\u0131n\u0131zda, dosyay\u0131 a\u00e7mak i\u00e7in \u015fifreyi girmeniz istenecektir. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-55-live-image\" class=\"wp-block-heading\"> 55. Canl\u0131 G\u00f6r\u00fcnt\u00fc<\/h3><p> Excel&#8217;de bir tablonun canl\u0131 g\u00f6r\u00fcnt\u00fcs\u00fcn\u00fc kullanmak tabloyu alana g\u00f6re yeniden boyutland\u0131rman\u0131za yard\u0131mc\u0131 olabilir ve canl\u0131 bir g\u00f6r\u00fcnt\u00fc olu\u015fturmak i\u00e7in tabloyu iki farkl\u0131 \u015fekilde kullanabilirsiniz.<\/p><p> Biri kamera ara\u00e7lar\u0131, ikincisi ise \u00f6zel kolaj se\u00e7ene\u011fi. <a href=\"https:\/\/exceladvisor.org\/tr\/kamera-araci\/\">Kamera arac\u0131n\u0131 kullanma ad\u0131mlar\u0131<\/a> a\u015fa\u011f\u0131da verilmi\u015ftir ve \u00f6zel kolaj i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullan\u0131n.<\/p><ol><li> Resim olarak yap\u0131\u015ft\u0131rmak istedi\u011finiz aral\u0131\u011f\u0131 se\u00e7in ve kopyalay\u0131n.<\/li><li> H\u00fccreye gidin ve yap\u0131\u015ft\u0131rmak istedi\u011finiz yere sa\u011f t\u0131klay\u0131n.<\/li><li> \u00d6zel Kolaj \u279c Di\u011fer Kolaj \u279c Ba\u011flant\u0131l\u0131 G\u00f6r\u00fcnt\u00fc Se\u00e7enekleri&#8217;ne gidin. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27035\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-creer-une-image-en-direct-avec-collage-special-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-\u00f6zel-yap\u0131\u015ft\u0131r ile-canl\u0131-g\u00f6r\u00fcnt\u00fc olu\u015fturma\" width=\"344\" height=\"276\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-56-userform\" class=\"wp-block-heading\"> 56. Kullan\u0131c\u0131 formu<\/h3><p> Birka\u00e7 Excel kullan\u0131c\u0131s\u0131, kullanabilece\u011fimiz varsay\u0131lan bir <a href=\"https:\/\/exceladvisor.org\/tr\/veri-giris-formu-3\/\">veri giri\u015f formunun<\/a> oldu\u011funu biliyor. Ve en g\u00fczel taraf\u0131 da bunun i\u00e7in tek sat\u0131r kod yazman\u0131za gerek yok. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27038\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-formulaire-de-saisie-de-donnees-par-defaut-2-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-varsay\u0131lan-veri-giri\u015f-formu\" width=\"335\" height=\"357\"><\/figure><\/div><p> \u0130\u015fte nas\u0131l kullan\u0131laca\u011f\u0131:<\/p><ol><li> \u00d6ncelikle, verileri girmek istedi\u011finiz ba\u015fl\u0131klara sahip bir tablonuz oldu\u011fundan emin olun.<\/li><li> Daha sonra bu tablodaki h\u00fccrelerden birini se\u00e7in ve <kbd>Alt<\/kbd> + <kbd>D<\/kbd> + <kbd>O<\/kbd> + <kbd>O<\/kbd> k\u0131sayol tu\u015funu kullanarak kullan\u0131c\u0131 formunu a\u00e7\u0131n. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-57-custom-tab\" class=\"wp-block-heading\"> 57. \u00d6zel Sekme<\/h3><p> Hepimizin favori se\u00e7enekleri veya s\u0131kl\u0131kla kulland\u0131\u011f\u0131m\u0131z se\u00e7enekleri vard\u0131r. T\u00fcm bu se\u00e7eneklere tek bir yerden eri\u015fmek i\u00e7in bir sekme olu\u015fturup ekleyin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27041\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-nouvel-onglet-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-yeni-sekme\" width=\"302\" height=\"567\"><\/figure><\/div><ol><li> \u00d6ncelikle Dosya sekmesi \u279c Se\u00e7enekler \u279c \u015eeridi \u00d6zelle\u015ftir&#8217;e gidin.<\/li><li> \u015eimdi \u201cYeni Sekme\u201dye t\u0131klay\u0131n (bu yeni bir sekme ekleyecektir).<\/li><li> Bundan sonra, \u00fczerine sa\u011f t\u0131klay\u0131n ve adland\u0131r\u0131n, ard\u0131ndan gruba bir ad verin.<\/li><li> Son olarak sekmeye se\u00e7enekler eklememiz gerekiyor ve bunun i\u00e7in \u201cKomutlar\u0131 se\u00e7\u201d se\u00e7ene\u011fine gidip bunlar\u0131 tek tek sekmeye eklememiz gerekiyor.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-58-goal-seek\" class=\"wp-block-heading\"> 58. Ama\u00e7 aramak<\/h3><p> Basit\u00e7e s\u00f6ylemek gerekirse, Hedef Arama bir problem \u00e7\u00f6zme arac\u0131d\u0131r. Sonu\u00e7ta istenen de\u011feri kan\u0131tlayarak giri\u015f de\u011ferini bulman\u0131za yard\u0131mc\u0131 olur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27044\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-objectif-chercher.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-hedefler i\u00e7in arama\" width=\"214\" height=\"148\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/\">\u2026 daha fazlas\u0131n\u0131 \u00f6\u011frenmek i\u00e7in k\u0131lavuzun tamam\u0131 burada<\/a> . <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-59-text-to-speech\" class=\"wp-block-heading\"> 59. Metinden Konu\u015fmaya<\/h3><p> Bu, Excel&#8217;in bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na yazd\u0131\u011f\u0131n\u0131z metni seslendirmesi i\u00e7in bir se\u00e7enektir. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-60-named-range\" class=\"wp-block-heading\"> 60. Adland\u0131r\u0131lm\u0131\u015f plaj<\/h3><p> Adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k olu\u015fturman\u0131n en kolay yolu, aral\u0131\u011f\u0131 se\u00e7ip &#8220;Se\u00e7imden Olu\u015ftur&#8221; se\u00e7ene\u011fini kullanarak olu\u015fturmakt\u0131r. \u0130zlenecek ad\u0131mlar \u015funlard\u0131r:<\/p><ul><li> Adland\u0131r\u0131lm\u0131\u015f aral\u0131k olu\u015fturmak istedi\u011finiz s\u00fctunu\/sat\u0131r\u0131 se\u00e7in.<\/li><li> Sa\u011f t\u0131klay\u0131n ve \u201cAd Ayarla\u2026\u201d se\u00e7ene\u011fini t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27049\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-clic-droit-selectionner-definir-le-nom.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-sa\u011f-t\u0131klama-se\u00e7im-ad\u0131-ad\u0131\" width=\"208\" height=\"127\"><\/figure><\/div><ul><li> Adland\u0131r\u0131lm\u0131\u015f aral\u0131k ad\u0131n\u0131 ekleme se\u00e7ene\u011fini se\u00e7in ve Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27050\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-entrez-le-nom-et-cliquez-sur-ok.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-ad\u0131n\u0131 girin ve-tamam'a t\u0131klay\u0131n\" width=\"302\" height=\"232\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-61-trim\" class=\"wp-block-heading\"> 61. Garnit\u00fcr<\/h3><p> TRIM, bir metin dizesindeki <a href=\"https:\/\/exceladvisor.org\/tr\/fazladan-bosluklari-kaldir\/\">fazladan bo\u015fluklar\u0131 kald\u0131rman\u0131za<\/a> yard\u0131mc\u0131 olabilir. Bo\u015fluklar\u0131 kald\u0131rmak istedi\u011finiz h\u00fccreye ba\u015fvurman\u0131z yeterlidir; sonu\u00e7ta k\u0131rp\u0131lm\u0131\u015f de\u011feri d\u00f6nd\u00fcrecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27053\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-supprimer-les-espaces-supplementaires-avec-garniture.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-k\u0131rpmal\u0131-fazla-bo\u015fluklar\u0131-kald\u0131r\" width=\"573\" height=\"220\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-62-remove-duplicates\" class=\"wp-block-heading\"> 62. Kopyalar\u0131 kald\u0131r\u0131n<\/h3><p> B\u00fcy\u00fck verilerle \u00e7al\u0131\u015f\u0131rken en s\u0131k kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z \u015feylerden biri &#8220;yinelenen de\u011ferler&#8221;dir. Excel&#8217;de bu yinelenen de\u011ferleri kald\u0131rmak olduk\u00e7a basittir. \u0130\u015fte bunu nas\u0131l yapaca\u011f\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27056\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-supprimer-les-doublons.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-kopyalar\u0131-sil\" width=\"325\" height=\"95\"><\/figure><\/div><ol><li> \u00d6ncelikle verilerdeki h\u00fccrelerden birini se\u00e7in veya verilerin tamam\u0131n\u0131 se\u00e7in.<\/li><li> Bundan sonra Veri \u279c Veri Ara\u00e7lar\u0131 \u279c Yinelenenleri Kald\u0131r&#8217;a gidin.<\/li><li> Bu noktada kar\u015f\u0131n\u0131za \u201cKopyalar\u0131 Kald\u0131r\u201d penceresi \u00e7\u0131k\u0131yor ve bu pencereden yinelenen de\u011ferleri kald\u0131r\u0131rken dikkate almak\/dikkate almamak istedi\u011finiz s\u00fctunlar\u0131 se\u00e7in\/se\u00e7imini kald\u0131r\u0131n.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Tamam&#8217;\u0131 t\u0131klatt\u0131\u011f\u0131n\u0131zda, Excel se\u00e7ilen verilerde de\u011ferlerin kopya oldu\u011fu t\u00fcm sat\u0131rlar\u0131 silecek ve silinen de\u011ferlerin say\u0131s\u0131n\u0131 ve kalan <a href=\"https:\/\/exceladvisor.org\/tr\/benzersiz-degerleri-sayma-1\/\">benzersiz de\u011ferleri<\/a> i\u00e7eren bir mesaj g\u00f6r\u00fcnt\u00fcleyecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27057\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-supprimer-les-doublons.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-sil-kopyalar-pencere\" width=\"438\" height=\"279\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-63-combine-text-fill-justify\" class=\"wp-block-heading\"> 63. Metni Birle\u015ftir (Yaslanm\u0131\u015f Doldur)<\/h3><p> Diyelim ki A1:A5 aral\u0131\u011f\u0131nda kelimeleriniz var ve <a href=\"https:\/\/exceladvisor.org\/tr\/bir-dizi-hucreyi-birlestirmek\/\">hepsini tek bir h\u00fccrede birle\u015ftirmek<\/a> istiyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27060\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-combiner-texte-avec-remplissage-justifier.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-metni-doldurma-hakl\u0131l\u0131kla-birle\u015ftirme\" width=\"357\" height=\"140\"><\/figure><\/div><ol><li> \u0130lk olarak, A s\u00fctununu t\u00fcm metnin tek bir h\u00fccrede birle\u015ftirilebilmesi i\u00e7in yeterince geni\u015f yap\u0131n.<\/li><li> Bundan sonra t\u00fcm aral\u0131\u011f\u0131 se\u00e7in.<\/li><li> \u015eimdi Ana Sayfa sekmesine gidin \u279c D\u00fczenle \u279c Doldur \u279c <a href=\"https:\/\/exceladvisor.org\/tr\/tamamen-hakli-cikarmak\/\">Yasla<\/a> . <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-64-remove-specific-character\" class=\"wp-block-heading\"> 64. Belirli bir karakteri silin<\/h3><p> A1:A5 aral\u0131\u011f\u0131nda ve hepsini tek bir h\u00fccrede birle\u015ftirmek istiyorsunuz. Bunu dolgu gerek\u00e7esi ile nas\u0131l yapaca\u011f\u0131n\u0131z a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27063\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-trouver-et-remplacer-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-bul ve de\u011fi\u015ftir\" width=\"445\" height=\"196\"><\/figure><\/div><ol><li> Tek yapman\u0131z gereken bu s\u00fctunu se\u00e7ip Bul ve De\u011fi\u015ftir ileti\u015fim kutusunu a\u00e7makt\u0131r.<\/li><li> Bundan sonra \u201cDe\u011fi\u015ftir\u201d sekmesine t\u0131klay\u0131n.<\/li><li> \u015eimdi burada \u201cNeyi bul\u201d k\u0131sm\u0131na de\u011fi\u015ftirmek istedi\u011finiz karakteri girin ve \u201c\u015eununla de\u011fi\u015ftir\u201d se\u00e7ene\u011fini bo\u015f b\u0131rakt\u0131\u011f\u0131n\u0131zdan emin olun.<\/li><li> \u015eimdi \u201cT\u00fcm\u00fcn\u00fc De\u011fi\u015ftir\u201de t\u0131klay\u0131n.<\/li><\/ol><p> \u201cT\u00fcm\u00fcn\u00fc De\u011fi\u015ftir\u201d se\u00e7ene\u011fine t\u0131klad\u0131\u011f\u0131n\u0131zda Excel s\u00f6z konusu karakteri t\u00fcm s\u00fctundan kald\u0131racakt\u0131r.<\/p><p> <em>\u0130lgili: Excel&#8217;deki Bir H\u00fccreden \u0130lk Karakteri Kald\u0131rma<\/em> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-65-combine-text\" class=\"wp-block-heading\"> 65. Metni birle\u015ftir<\/h3><p> Yani birden fazla h\u00fccrede metniniz var ve t\u00fcm metni tek bir h\u00fccrede birle\u015ftirmek istiyorsunuz. Hay\u0131r, bu sefer doldurma gerek\u00e7esi ile de\u011fil. Bunu TEXT JOIN ile yap\u0131yoruz. Office 365 kullan\u0131yorsan\u0131z metin birle\u015ftirme konusunda ezber bozan yeni bir TEXTJOIN i\u015flevi var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27064\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-texte-joindre.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-metin-birle\u015ftirme\" width=\"348\" height=\"186\"><\/figure><\/div><p> \u0130\u015fte s\u00f6zdizimi:<\/p><p> TEXTJOIN(s\u0131n\u0131rlay\u0131c\u0131, g\u00f6rmezden_bo\u015f, metin1, [metin2], \u2026)<\/p><p> Bo\u015f h\u00fccreleri yoksaymak istiyorsan\u0131z tek yapman\u0131z gereken bir s\u0131n\u0131rlay\u0131c\u0131 (varsa) ve TRUE eklemek ve sonunda aral\u0131\u011fa ba\u015fvurmak. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-66-unpivot-data\" class=\"wp-block-heading\"> 66. D\u00f6nd\u00fcr\u00fclmemi\u015f veriler<\/h3><p> A\u015fa\u011f\u0131daki tabloya bak\u0131n, rapor olarak kullanabilirsiniz ancak ham veri olarak kullanamazs\u0131n\u0131z. Hay\u0131r yapamazs\u0131n. Ancak bu tabloyu a\u015fa\u011f\u0131daki gibi bir \u015feye d\u00f6n\u00fc\u015ft\u00fcr\u00fcrseniz her yerde rahatl\u0131kla kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27065\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/astuces-excel-astuces-donnees-non-pivotees-avec-une-requete-de-puissance-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-ipu\u00e7lar\u0131-g\u00fc\u00e7 sorgusu ile-verilerin \u00f6zetini a\u00e7ma\" width=\"692\" height=\"662\"><\/figure><\/div><p> Ancak bu tabloyu a\u015fa\u011f\u0131daki gibi bir \u015feye d\u00f6n\u00fc\u015ft\u00fcr\u00fcrseniz her yerde rahatl\u0131kla kullanabilirsiniz. Peki bunu nas\u0131l yap\u0131yorsunuz?<\/p><p> <a href=\"https:\/\/exceladvisor.org\/tr\/dondurulmemis-veriler\/\" data-wpil=\"url\">\u0130\u015fte izlemeniz gereken basit ad\u0131mlar<\/a> . <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-67-delete-error-cells\" class=\"wp-block-heading\"> 67. Hata h\u00fccrelerini silin<\/h3><p> \u00c7o\u011fu zaman b\u00fcy\u00fck veriyle \u00e7al\u0131\u015f\u0131rken hata de\u011ferlerinin oldu\u011fu a\u015fikard\u0131r ancak bunlar\u0131 saklamak iyi de\u011fildir. Bu hata de\u011ferlerini i\u015flemenin en kolay yolu bunlar\u0131 se\u00e7ip kald\u0131rmakt\u0131r. \u0130\u015fte basit ad\u0131mlar.<\/p><ul><li> \u00d6ncelikle Ana Sayfa sekmesine gidin \u279c D\u00fczenle \u279c <a href=\"https:\/\/exceladvisor.org\/tr\/bul-degistir-1\/\">Bul ve De\u011fi\u015ftir<\/a> \u279c \u00d6zel&#8217;e gidin.<\/li><li> Git ileti\u015fim kutusunda form\u00fcl\u00fc se\u00e7in ve hatalar\u0131 kontrol edin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27072\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-selectionner-les-erreurs-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-se\u00e7im-hatalar\u0131\" width=\"316\" height=\"332\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Tamam&#8217;a t\u0131klad\u0131\u011f\u0131n\u0131zda t\u00fcm hatalar se\u00e7ilecektir ve ard\u0131ndan &#8220;Sil&#8221; d\u00fc\u011fmesini kullanarak her \u015feyi silebilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-68-arrange-columns\" class=\"wp-block-heading\">68. S\u00fctunlar\u0131 d\u00fczenleyin<\/h3><p> \u00d6zel bir s\u0131ralama kullanarak verilerdeki s\u00fctunlar\u0131 d\u00fczenlemek istedi\u011finizi varsayal\u0131m. Normal y\u00f6ntem <a href=\"https:\/\/exceladvisor.org\/tr\/kes-ve-yapistir\/\">bunlar\u0131 tek tek kesip yap\u0131\u015ft\u0131rmakt\u0131r<\/a> .<\/p><p> Ama ayn\u0131 zamanda kullan\u0131ma haz\u0131r bir y\u00f6ntemimiz de var. Excel&#8217;de, sat\u0131rlar\u0131 s\u0131ralad\u0131\u011f\u0131n\u0131z gibi <a href=\"https:\/\/exceladvisor.org\/tr\/yatay-olarak-sirala\/\">s\u00fctunlar\u0131 da s\u0131ralayabilir<\/a> ve ayn\u0131 y\u00f6ntemleri kullanarak bunlar\u0131 \u00f6zel bir s\u0131raya g\u00f6re d\u00fczenleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27075\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-trier-les-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-\u00fc\u00e7 s\u00fctun\" width=\"330\" height=\"245\"><\/figure><\/div><p> \u21e2 <a href=\"https:\/\/exceladvisor.org\/tr\/yatay-olarak-sirala\/\"><strong>Tam tavsiye<\/strong><\/a> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-69-convert-to-date\" class=\"wp-block-heading\">69. Tarihe d\u00f6n\u00fc\u015ft\u00fcr<\/h3><p> Bazen metin olarak saklanan tarihleriniz olur ve bunlar\u0131 daha ileri hesaplama ve analizlerde kullanabilirsiniz. Bunlar\u0131 basit\u00e7e tekrar ge\u00e7erli tarihlere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in TARIH DE\u011eER\u0130 i\u015flevini kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27076\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-convertir-du-texte-a-ce-jour.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-metni-tarihe-d\u00f6n\u00fc\u015ft\u00fcrme\" width=\"517\" height=\"159\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/bugune-kadarki-metin\/\">Metni tarihe d\u00f6n\u00fc\u015ft\u00fcrmenin di\u011fer yollar\u0131<\/a> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-70-negative-to-positive\" class=\"wp-block-heading\"> 70. Olumsuzdan Olumluya<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/negatif-sayiyi-pozitife-cevir\/\">Negatif bir say\u0131y\u0131 pozitife d\u00f6n\u00fc\u015ft\u00fcrmenin<\/a> en kolay yolu, kullanmakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27079\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-convertir-un-nombre-negatif-en-positif-avec-abs.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-negatif-say\u0131y\u0131-pozitif-withabs'a d\u00f6n\u00fc\u015ft\u00fcrme\" width=\"252\" height=\"260\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-71-format-painter\" class=\"wp-block-heading\"> 71. Format ressam\u0131<\/h3><p> H\u00fccre bi\u00e7imlendirmesini uygulamak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/ressam-formati\/\">Bi\u00e7im Boyac\u0131s\u0131&#8217;n\u0131<\/a> kullanmaya ba\u015flamadan \u00f6nce k\u0131sayol tu\u015fuyla \u00d6zel Yap\u0131\u015ft\u0131r&#8217;\u0131 kullan\u0131yordum. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27082\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Appliquer-le-formatage-des-cellules-avec-des-astuces-de-souris-a-double-clic.gif\" sizes=\"auto, \" srcset=\"\" alt=\"\u00c7ift t\u0131klama fare hileleriyle h\u00fccre bi\u00e7imlendirmesini uygulay\u0131n\" width=\"324\" height=\"282\"><\/figure><\/div><ol><li> H\u00fccre bi\u00e7imlendirmesini kopyalamak istedi\u011finiz h\u00fccreyi veya aral\u0131\u011f\u0131 se\u00e7in.<\/li><li> \u279c Ana Sayfa sekmesi \u279c Pano&#8217;ya gidin.<\/li><li> \u201cBi\u00e7im Boyac\u0131s\u0131\u201d d\u00fc\u011fmesine \u00e7ift t\u0131klay\u0131n.<\/li><li> Bunu yapt\u0131\u011f\u0131n\u0131z anda imleciniz bir f\u0131r\u00e7aya d\u00f6n\u00fc\u015f\u00fcr.<\/li><li> Bu bi\u00e7imlendirmeyi \u00e7al\u0131\u015fma sayfan\u0131z\u0131n herhangi bir yerine, ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131na ve hatta ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131na uygulayabilirsiniz. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-72-rename-a-worksheet\" class=\"wp-block-heading\"> 72. Bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131 yeniden adland\u0131r\u0131n<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-yeniden-adlandir\/\">Bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131n\u0131 de\u011fi\u015ftirmek<\/a> i\u00e7in k\u0131sayol tu\u015funu kullanmaktan her zaman daha h\u0131zl\u0131 oldu\u011funu g\u00f6rd\u00fcm. Tek yapman\u0131z gereken sayfa sekmesine \u00e7ift t\u0131klay\u0131p yeni bir ad girmek. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27085\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Renommer-le-nom-de-la-feuille-de-calcul-avec-des-astuces-de-souris-a-double-clic.gif\" sizes=\"auto, \" srcset=\"\" alt=\"Fareyle \u00e7ift t\u0131klama hileleriyle e-tablo ad\u0131n\u0131 yeniden adland\u0131r\u0131n\" width=\"280\" height=\"36\"><\/figure><\/div><p> Size <strong>bu y\u00f6ntemin neden k\u0131sayol kullanmaktan daha h\u0131zl\u0131 oldu\u011funu<\/strong> anlatay\u0131m. Bir k\u0131sayol tu\u015funu kullanarak <a href=\"https:\/\/exceladvisor.org\/tr\/yeniden-isimlendirmek\/\" data-wpil=\"url\">birden \u00e7ok \u00e7al\u0131\u015fma sayfas\u0131n\u0131 yeniden adland\u0131rmak<\/a> istedi\u011finizi varsayal\u0131m.<\/p><p> Bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131n\u0131 de\u011fi\u015ftirmeden \u00f6nce onu etkinle\u015ftirmeniz gerekir. Ancak fareyi kullan\u0131rsan\u0131z, bu \u00e7al\u0131\u015fma sayfas\u0131 otomatik olarak etkinle\u015ftirilecek ve yaln\u0131zca iki t\u0131klamayla ad\u0131 de\u011fi\u015ftirilecektir. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-73-fill-handle\" class=\"wp-block-heading\"> 73. Doldurma kolu<\/h3><p> Eminim ki k\u0131sayol ba\u011f\u0131ml\u0131lar\u0131 <a href=\"https:\/\/exceladvisor.org\/tr\/kayip-dusmek\/\">h\u00fccrelerdeki form\u00fclleri ve de\u011ferleri a\u015fa\u011f\u0131 s\u00fcr\u00fcklemek i\u00e7in her zaman bir k\u0131sayol tu\u015fu<\/a> kullan\u0131rlar. Ancak doldurma tutamac\u0131n\u0131 kullanmak, k\u0131sayol tu\u015funu kullanmaktan daha etkileyicidir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27086\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/astuces-excel-astuces-pour-utiliser-la-poignee-de-remplissage-avec-la-souris.gif\" sizes=\"auto, \" srcset=\"\" alt=\"Fareyle-doldurma-tutamac\u0131n\u0131-kullanmak i\u00e7in Excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131\" width=\"236\" height=\"140\"><\/figure><\/div><ol><li> S\u00fcr\u00fcklemek istedi\u011finiz form\u00fcl veya de\u011ferin bulundu\u011fu h\u00fccreyi se\u00e7in.<\/li><li> H\u00fccre s\u0131n\u0131rlay\u0131c\u0131 kutunun sa\u011f alt k\u0131sm\u0131ndaki k\u00fc\u00e7\u00fck kare kutuya \u00e7ift t\u0131klay\u0131n.<\/li><\/ol><p> Bu y\u00f6ntem yaln\u0131zca ilgili s\u00fctunda de\u011ferleriniz varsa ve yaln\u0131zca dikey y\u00f6nde \u00e7al\u0131\u015f\u0131rsa \u00e7al\u0131\u015f\u0131r. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-74-hide-ribbon\" class=\"wp-block-heading\"> 74. \u015eeridi Gizle<\/h3>\n<p>Dikkatiniz da\u011f\u0131lmadan \u00e7al\u0131\u015fmak istiyorsan\u0131z Excel \u015feridinizi k\u00fc\u00e7\u00fclterek bunu yapabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27089\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-pour-reduire-developper-le-ruban.gif\" sizes=\"auto, \" srcset=\"\" alt=\"\u015eeridi daraltmak i\u00e7in Excel ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131\" width=\"236\" height=\"188\"><\/figure><\/div><p> \u015eeridinizdeki etkin sekmeye \u00e7ift t\u0131klaman\u0131z yeterlidir; \u015ferit k\u00fc\u00e7\u00fclt\u00fclecektir. Ve e\u011fer geni\u015fletmek istiyorsan\u0131z, \u00fczerine tekrar \u00e7ift t\u0131klay\u0131n. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-75-edit-a-shape\" class=\"wp-block-heading\"> 75. Bir \u015fekli d\u00fczenleyin<\/h3><p> \u00c7al\u0131\u015fma sayfalar\u0131m\u0131zda belirli mesajlar\u0131 sunmak i\u00e7in s\u0131kl\u0131kla \u015fekiller kullan\u0131rs\u0131n\u0131z ve bu \u015fekillerin i\u00e7ine metin eklemeniz gerekir. Tipik y\u00f6ntemin yan\u0131 s\u0131ra, bir \u015fekli d\u00fczenlemek ve i\u00e7ine metin eklemek i\u00e7in \u00e7ift t\u0131klamay\u0131 kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27092\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-modifier-une-forme.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-bir-\u015fekli-d\u00fczenleme\" width=\"168\" height=\"116\"><\/figure><\/div><p> Bu y\u00f6ntemi, bir <a href=\"https:\/\/exceladvisor.org\/tr\/metin-bolgesi\/\">metin kutusu<\/a> veya <a href=\"https:\/\/exceladvisor.org\/tr\/dinamik-grafik-basligi\/\">grafik ba\u015fl\u0131\u011f\u0131ndaki<\/a> metni d\u00fczenlemek ve girmek i\u00e7in de kullanabilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-76-column-width\" class=\"wp-block-heading\"> 76. S\u00fctun geni\u015fli\u011fi<\/h3><p> S\u00fctun geni\u015fli\u011fini ayarlaman\u0131z gerekti\u011finde s\u00fctun ba\u015fl\u0131\u011f\u0131n\u0131n sa\u011f kenar\u0131na \u00e7ift t\u0131klayabilirsiniz. S\u00fctun geni\u015fli\u011fini s\u00fctun verilerine g\u00f6re otomatik olarak ayarlar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27095\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-ajuster-la-largeur-de-la-colonne.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-s\u00fctun geni\u015fli\u011fini ayarlama\" width=\"244\" height=\"148\"><\/figure><\/div><p> Ayn\u0131 y\u00f6ntem \u00e7izgi geni\u015fliklerini otomatik olarak ayarlamak i\u00e7in de kullan\u0131labilir. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-77-go-to-the-last-cell\" class=\"wp-block-heading\"> 77. Son h\u00fccreye git<\/h3><p> B\u00fcy\u00fck bir veri k\u00fcmesiyle \u00e7al\u0131\u015f\u0131yorsan\u0131z bu ipucu yararl\u0131 olabilir. \u00c7ift t\u0131klamay\u0131 kullanarak aral\u0131ktaki veri i\u00e7eren son h\u00fccreye gidebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27098\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-aller-a-la-derniere-cellule.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-son h\u00fccreye-git\" width=\"424\" height=\"228\"><\/figure><\/div><p> Sa\u011fa gitmek i\u00e7in aktif h\u00fccrenin sa\u011f kenar\u0131na, sola gitmek istiyorsan\u0131z sol kenar\u0131na t\u0131klaman\u0131z gerekir. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-78-chart-formatting\" class=\"wp-block-heading\"> 78. Grafikleri Bi\u00e7imlendirmek<\/h3><p> Grafi\u011fi bi\u00e7imlendirmek amac\u0131yla bi\u00e7imlendirme se\u00e7eneklerini a\u00e7mak i\u00e7in Control + 1 tu\u015flar\u0131n\u0131 kullan\u0131rsan\u0131z, bahse girerim bu ipucunu seveceksiniz. Bi\u00e7imlendirme se\u00e7ene\u011fini a\u00e7mak i\u00e7in tek yapman\u0131z gereken grafik kenarl\u0131\u011f\u0131na \u00e7ift t\u0131klamakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27101\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-ouvrir-les-options-de-formatage-des-graphiques.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-a\u00e7\u0131k-grafik-bi\u00e7imlendirme-se\u00e7enekleri\" width=\"584\" height=\"228\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-79-pivot-table-double-click\" class=\"wp-block-heading\"> 79. Pivot tabloya \u00e7ift t\u0131klay\u0131n<\/h3><p> Birisinin size <a href=\"https:\/\/exceladvisor.org\/tr\/veri-kaynagini-degistir\/\">kaynak veriler<\/a> olmadan bir pivot tablo g\u00f6nderdi\u011fini varsayal\u0131m. Bildi\u011finiz gibi Excel, pivot tablo olu\u015fturmadan \u00f6nce verileri pivot \u00f6nbelle\u011finde saklar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27104\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-obtenir-le-tableau-croise-dynamique-des-donnees-source.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-ipu\u00e7lar\u0131-kaynak-veri-pivot-tablosu\" width=\"244\" height=\"156\"><\/figure><\/div><p> Veri de\u011ferlerine \u00e7ift t\u0131klayarak bir pivot tablodan veri \u00e7\u0131karabilirsiniz. Bunu yapt\u0131\u011f\u0131n\u0131z anda Excel, pivot tabloda kullan\u0131lan verileri i\u00e7eren yeni bir \u00e7al\u0131\u015fma sayfas\u0131 ekler. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-80-drag-drop-menu\" class=\"wp-block-heading\"> 80. S\u00fcr\u00fckle ve b\u0131rak men\u00fcs\u00fc<\/h3><p> Excel&#8217;de \u00e7ok az kullan\u0131c\u0131n\u0131n bildi\u011fi bir sa\u011f t\u0131klama a\u00e7\u0131l\u0131r men\u00fcs\u00fc vard\u0131r. Bu men\u00fcy\u00fc kullanmak i\u00e7in bir h\u00fccreyi veya h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7in, ard\u0131ndan sa\u011f t\u0131klay\u0131n ve bas\u0131l\u0131 tutarken se\u00e7imi ba\u015fka bir yere b\u0131rak\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27107\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-menu-clic-droit.gif\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-men\u00fc-sa\u011f t\u0131klama\" width=\"464\" height=\"380\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-81-default-file-saving-location\" class=\"wp-block-heading\"> 81. Varsay\u0131lan Dosya Kaydetme Konumu<\/h3><p> Normalde Excel \u00fczerinde \u00e7al\u0131\u015f\u0131rken her g\u00fcn 15&#8217;ten fazla Excel dosyas\u0131 olu\u015fturuyorum. Ve e\u011fer bu dosyalar\u0131n her birini masa\u00fcst\u00fcme kaydedersem, k\u00f6t\u00fc g\u00f6r\u00fcn\u00fcyor. Bunu d\u00fczeltmek i\u00e7in varsay\u0131lan klas\u00f6r\u00fcm\u00fc bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydedecek \u015fekilde de\u011fi\u015ftirdim ve burada bunu yapabilirsiniz.<\/p><ol><li> \u00d6ncelikle Dosya sekmesine gidin ve Excel se\u00e7eneklerini a\u00e7\u0131n.<\/li><li> Excel se\u00e7eneklerinde \u201cKaydet\u201d kategorisine gidin.<\/li><li> Art\u0131k varsay\u0131lan yerel dosya konumunu de\u011fi\u015ftirebilece\u011finiz bir giri\u015f \u00e7ubu\u011fu var.<\/li><li> Bu giri\u015f \u00e7ubu\u011fundan konum adresini d\u00fczenleyin ve sonunda Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ol><figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27113\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-changer-ladresse-de-changement-demplacement-par-defaut-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"varsay\u0131lan-konum-adresini-de\u011fi\u015ftirmek i\u00e7in-excel-ipu\u00e7lar\u0131-ve-p\u00fcf noktalar\u0131\" width=\"820\" height=\"371\"><\/figure><p> Art\u0131k \u201cFarkl\u0131 Kaydet\u201d ileti\u015fim kutusunu a\u00e7t\u0131\u011f\u0131n\u0131zda Excel size belirtti\u011finiz konumu g\u00f6sterecektir. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-82-disable-start-screen\" class=\"wp-block-heading\"> 82. A\u00e7\u0131l\u0131\u015f Ekran\u0131n\u0131 Devre D\u0131\u015f\u0131 B\u0131rak<\/h3><p> Eminim siz de benim gibi Microsoft Excel&#8217;i (veya ba\u015fka bir Office uygulamas\u0131n\u0131) a\u00e7\u0131p a\u00e7\u0131l\u0131\u015f ekran\u0131n\u0131 g\u00f6rmekten nefret ediyorsunuz. Bu, sisteminizin h\u0131z\u0131na ve y\u00fckledi\u011finiz eklentilere ba\u011fl\u0131 olarak zaman al\u0131r. Microsoft Office&#8217;te Ba\u015flang\u0131\u00e7 ekran\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rakma ad\u0131mlar\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27116\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-desactiver-lecran-de-demarrage-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Ba\u015flang\u0131\u00e7 ekran\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rakmak i\u00e7in Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131\" width=\"619\" height=\"374\"><\/figure><\/div><ol><li> \u00d6ncelikle Dosya sekmesine gidin ve Excel se\u00e7eneklerini a\u00e7\u0131n.<\/li><li> Excel se\u00e7eneklerinde \u201cGenel\u201d kategorisine gidin.<\/li><li> Se\u00e7eneklerden \u201cBa\u015flang\u0131\u00e7\u201d se\u00e7eneklerine gidin ve \u201cBu uygulama ba\u015flad\u0131\u011f\u0131nda a\u00e7\u0131l\u0131\u015f ekran\u0131n\u0131 g\u00f6ster\u201d se\u00e7ene\u011finin i\u015faretini kald\u0131r\u0131n.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Art\u0131k Excel&#8217;i her ba\u015flatt\u0131\u011f\u0131n\u0131zda, a\u00e7\u0131l\u0131\u015f ekran\u0131n\u0131 g\u00f6stermeden do\u011frudan \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7\u0131yor. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-83-developer-tab\" class=\"wp-block-heading\"> 83. Geli\u015ftirici Sekmesi<\/h3><p> VBA kodlar\u0131 yazmaya ba\u015flamadan \u00f6nce yapman\u0131z gereken ilk \u015fey <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\">\u201cGeli\u015ftirici\u201d sekmesini aktif hale getirmektir<\/a> . Microsoft Excel&#8217;i ilk y\u00fckledi\u011finizde bir geli\u015ftirici orada olmayacakt\u0131r. Bu y\u00fczden ayarlardan etkinle\u015ftirmeniz gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27119\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/trucs-et-astuces-excel-pour-activer-longlet-developpeur-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"geli\u015ftirici sekmesini-etkinle\u015ftirmek i\u00e7in excel-ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131\" width=\"578\" height=\"433\"><\/figure><\/div><ol><li> \u00d6ncelikle Dosya sekmesine gidin ve \u201c\u015eeridi \u00d6zelle\u015ftir\u201d kategorisine t\u0131klay\u0131n.<\/li><li> \u015eimdi sekme listesinde geli\u015ftirici sekmesini kontrol edin ve Tamam&#8217;a t\u0131klay\u0131n.<\/li><\/ol><p> Art\u0131k Excel pencerenize d\u00f6nd\u00fc\u011f\u00fcn\u00fczde \u015feritte bir geli\u015ftirici sekmesi g\u00f6receksiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-84-enable-macros\" class=\"wp-block-heading\"> 84. Makrolar\u0131 etkinle\u015ftirin<\/h3><p> Makro \u00f6zellikli bir dosyay\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda VBA kodlar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmak i\u00e7in makro se\u00e7eneklerini etkinle\u015ftirmeniz gerekir. \u015eu basit ad\u0131mlar\u0131 izleyin: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27120\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-creer-activer-les-macros-cliquez-sur-centre-de-confiance.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-olu\u015fturma-etkinle\u015ftirme-makrolar-t\u0131klama-g\u00fcven-merkezi\" width=\"318\" height=\"86\"><\/figure><\/div><ol><li> \u00d6ncelikle Dosya sekmesine gidin ve \u201cG\u00fcven Merkezi\u201d kategorisine t\u0131klay\u0131n.<\/li><li> Oradan \u201cG\u00fcven Merkezi Ayarlar\u0131\u201dna t\u0131klay\u0131n.<\/li><li> \u015eimdi \u201cG\u00fcven Merkezi Ayarlar\u0131\u201dnda makro ayarlar\u0131na t\u0131klay\u0131n.<\/li><li> Bundan sonra \u201cT\u00fcm makrolar\u0131 bildirimlerle etkinle\u015ftir\u201d se\u00e7ene\u011fine t\u0131klay\u0131n.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-85-autocorrect-option\" class=\"wp-block-heading\"> 85. Otomatik d\u00fczeltme se\u00e7ene\u011fi<\/h3><p> Excel&#8217;e \u00e7ok fazla veri giriyorsan\u0131z bu se\u00e7enek sizin i\u00e7in oyunun kurallar\u0131n\u0131 de\u011fi\u015ftirebilir. Otomatik D\u00fczelt se\u00e7ene\u011fiyle Excel&#8217;e, siz yazarken bir metin dizesini di\u011ferine de\u011fi\u015ftirmesini s\u00f6yleyebilirsiniz.<\/p><p> <strong>Sana bir \u00f6rnek vereyim:<\/strong><\/p><p> Benim ad\u0131m \u201cPuneet\u201d ama bazen insanlar bunu \u201cPunit\u201d olarak yaz\u0131yorlar ama do\u011fru yaz\u0131l\u0131\u015f\u0131 \u00f6nce geliyor. Yani yapabilece\u011fim \u015fey otomatik d\u00fczeltmeyi kullanmak ve Excel&#8217;e &#8220;Punit&#8221;i &#8220;Puneet&#8221; olarak de\u011fi\u015ftirmesini s\u00f6ylemek. \u015eu basit ad\u0131mlar\u0131 izleyin: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27132\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-correction-automatique-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-otomatik d\u00fczeltme\" width=\"410\" height=\"406\"><\/figure><\/div><ol><li> \u00d6ncelikle Dosya sekmesine giderek se\u00e7eneklere gelin ve <strong>\u201cProva\u201d kategorisine t\u0131klay\u0131n<\/strong> .<\/li><li> Bundan sonra, \u201cOtomatik D\u00fczelt Se\u00e7ene\u011fi\u201dne t\u0131klay\u0131n; <strong>Otomatik D\u00fczelt penceresi<\/strong> a\u00e7\u0131lacakt\u0131r.<\/li><li> Bu pencerede, hangi metnin de\u011fi\u015ftirilece\u011fini ve hangi metnin de\u011fi\u015ftirilece\u011fini belirtmek i\u00e7in iki giri\u015f \u00e7ubu\u011funuz vard\u0131r.<\/li><li> Her iki de\u011feri de girin ve ard\u0131ndan Tamam&#8217;\u0131 t\u0131klay\u0131n. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-86-custom-list\" class=\"wp-block-heading\"> 86. \u00d6zel Liste<\/h3><p> \u015e\u00f6yle d\u00fc\u015f\u00fcn\u00fcn, satt\u0131\u011f\u0131n\u0131z 10 \u00fcr\u00fcnden olu\u015fan bir listeniz var. Bu \u00fcr\u00fcn adlar\u0131n\u0131 eklemeniz gerekti\u011finde \u00f6zel bir liste kullanarak ekleyebilirsiniz. Bunu nas\u0131l yapaca\u011f\u0131n\u0131z\u0131 size anlatay\u0131m:<\/p><ol><li> \u00d6ncelikle Dosya sekmesine gidin ve se\u00e7eneklere gidin ve \u201cGeli\u015fmi\u015f\u201d kategorisine t\u0131klay\u0131n.<\/li><li> \u015eimdi ke\u015ffedin ve \u201cGenel\u201d b\u00f6l\u00fcm\u00fcne gidin ve \u201c\u00d6zel Listeyi D\u00fczenle\u2026\u201d se\u00e7ene\u011fine t\u0131klay\u0131n.<\/li><li> Art\u0131k bu pencerede listeye girebilir veya listeyi bir dizi h\u00fccreden de i\u00e7e aktarabilirsiniz.<br> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> \u015eimdi, yeni olu\u015fturdu\u011funuz \u00f6zel listeye girmek i\u00e7in listedeki ilk giri\u015fi h\u00fccreye girin, ard\u0131ndan doldurma tutamac\u0131n\u0131 kullanarak o h\u00fccrenin detay\u0131na gidin. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-87-apply-table\" class=\"wp-block-heading\"> 87. Tabloyu uygulay\u0131n<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo\/\">\u00c7ok say\u0131da pivot tablo kullan\u0131yorsan\u0131z<\/a> tabloyu ham verilere uygulamak \u00f6nemlidir. Tablo s\u00f6z konusu oldu\u011funda <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-guncelleme-araligi\/\">pivot tablo veri kayna\u011f\u0131n\u0131 g\u00fcncellemeye<\/a> gerek yoktur ve yeni bir giri\u015f ekledi\u011finizde form\u00fcller otomatik olarak s\u00fcr\u00fcklenir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27135\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-creer-appliquer-tableau.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-olu\u015fturma-uygulama-tablosu\" width=\"264\" height=\"275\"><\/figure><\/div><p> Tabloyu verilere uygulamak i\u00e7in <strong>Ctrl + T<\/strong> klavye k\u0131sayol tu\u015funu kullanman\u0131z ve Tamam&#8217;a t\u0131klaman\u0131z yeterlidir. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-88-gridline-color\" class=\"wp-block-heading\"> 88. Izgara rengi<\/h3><p> Varsay\u0131lan h\u00fccre \u0131zgaras\u0131 renginden memnun de\u011filseniz, birka\u00e7 t\u0131klamayla bunu de\u011fi\u015ftirebilir ve bunun i\u00e7in \u015fu basit ad\u0131mlar\u0131 uygulayabilirsiniz:<\/p><ul><li> \u00d6ncelikle Dosya sekmesine gidin ve \u201cGeli\u015fmi\u015f\u201d kategorisine t\u0131klay\u0131n.<\/li><li> \u015eimdi \u201cBu \u00e7al\u0131\u015fma kitab\u0131n\u0131n g\u00f6r\u00fcnt\u00fcleme se\u00e7enekleri\u201d b\u00f6l\u00fcm\u00fcne gidin ve uygulamak <strong>istedi\u011finiz rengi se\u00e7in<\/strong> . <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27138\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-pour-changer-la-couleur-du-quadrillage-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"k\u0131lavuz \u00e7izgisi rengini de\u011fi\u015ftirmek i\u00e7in excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131\" width=\"461\" height=\"423\"><\/figure><\/div><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> <strong>\u0130lgili \u2013 <a href=\"https:\/\/exceladvisor.org\/tr\/izgara\/\">K\u0131lavuz \u00c7izgilerini Yazd\u0131rma<\/a><\/strong> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-89-pin-to-taskbar\" class=\"wp-block-heading\"> 89. G\u00f6rev \u00e7ubu\u011funa sabitle<\/h3><p> Bu, uzun vadede zamandan tasarruf etmek i\u00e7in en sevdi\u011fim benzersiz kurulumlardan biridir. Sorun \u015fu ki, Microsoft Excel&#8217;i a\u00e7mak i\u00e7in Ba\u015flat men\u00fcs\u00fcne gitmek yerine onu g\u00f6rev \u00e7ubu\u011funa i\u015faret etmek en iyi yoldur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27143\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-trucs-et-astuces-epingler-lapplication-a-la-barre-des-taches-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-ve-p\u00fcf noktalar\u0131-uygulamay\u0131-g\u00f6rev \u00e7ubu\u011funa-pinleme\" width=\"260\" height=\"148\"><\/figure><\/div><p> Bu \u015fekilde g\u00f6rev \u00e7ubu\u011fu simgesine t\u0131klayarak a\u00e7abilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-90-macro-to-qat\" class=\"wp-block-heading\"> 90. Makrodan QAT&#8217;a<\/h3><p> S\u0131k kullanman\u0131z gereken makro kodunuz varsa. Bir makro kodunu \u00e7al\u0131\u015ft\u0131rman\u0131n en kolay yolu, onu H\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011fu&#8217;na eklemektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27126\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-ajouter-une-macro-a-qat.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 qat'a makro ekleme\" width=\"826\" height=\"648\"><\/figure><\/div><ol><li> \u00d6ncelikle Dosya sekmesine gidin ve \u201cH\u0131zl\u0131 Eri\u015fim Ara\u00e7 \u00c7ubu\u011fu\u201d kategorisine t\u0131klay\u0131n.<\/li><li> Bundan sonra, \u201cKomutu se\u00e7\u201d b\u00f6l\u00fcm\u00fcnde Makrolar&#8217;\u0131 se\u00e7in.<\/li><li> \u015eimdi makroyu se\u00e7in (QAT&#8217;a eklemek istedi\u011finiz) ve ekle&#8217;ye t\u0131klay\u0131n.<\/li><li> Oradan \u201cD\u00fczenle\u201dye t\u0131klay\u0131n ve makro d\u00fc\u011fmesi i\u00e7in bir simge se\u00e7in.<\/li><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Art\u0131k QAT \u00fczerinde az \u00f6nce belirtti\u011finiz <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">makro kodunu \u00e7al\u0131\u015ft\u0131rmak<\/a> i\u00e7in kullanabilece\u011finiz bir d\u00fc\u011fmeniz var. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-91-select-formula-cells\" class=\"wp-block-heading\"> 91. Form\u00fcl H\u00fccrelerini Se\u00e7in<\/h3><p> Diyelim ki <a href=\"https:\/\/exceladvisor.org\/tr\/deger-formulu\/\" data-wpil=\"url\">t\u00fcm form\u00fclleri de\u011ferlere d\u00f6n\u00fc\u015ft\u00fcrmek<\/a> istiyorsunuz ve form\u00fcllerinizin bulundu\u011fu h\u00fccreler <a href=\"https:\/\/exceladvisor.org\/tr\/bitisik-olmayan-hucreleri-sec\/\">biti\u015fik de\u011fil<\/a> . B\u00f6ylece her h\u00fccreyi tek tek se\u00e7mek yerine form\u00fcl\u00fcn\u00fcz\u00fcn bulundu\u011fu t\u00fcm h\u00fccreleri se\u00e7ebilirsiniz. \u0130\u015fte ad\u0131mlar:<\/p><ol><li> \u00d6ncelikle Ana Sayfa sekmesine gidin \u279c D\u00fczenle \u279c Bul ve Se\u00e7 \u279c \u00d6zel&#8217;e Git.<\/li><li> &#8220;\u00d6zel&#8217;e Git&#8221; ileti\u015fim kutusunda form\u00fclleri se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27148\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-selectionner-des-cellules-de-formule-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-form\u00fcl-h\u00fccrelerini se\u00e7in\" width=\"314\" height=\"330\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-92-multiply-using-paste-special\" class=\"wp-block-heading\"> 92. \u00d6zel Yap\u0131\u015ft\u0131r&#8217;\u0131 kullanarak \u00e7arp\u0131n<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/ozel-carpim-yapistir\/\">Tek seferlik hesaplamalar<\/a> yapmak i\u00e7in \u00f6zel yap\u0131\u015ft\u0131r se\u00e7ene\u011fini kullanarak kendinizi form\u00fcl yazmaktan kurtarabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27151\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-multiplier-coller-special-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-\u00e7arpma-yap\u0131\u015ft\u0131r-\u00f6zel\" width=\"404\" height=\"340\"><\/figure><\/div><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-93-highlight-duplicate-values\" class=\"wp-block-heading\"> 93. Yinelenen de\u011ferleri vurgulay\u0131n<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/yinelenen-degerleri-vurgula\/\">De\u011ferleri vurgulamak i\u00e7in VBA kodunu<\/a> kullanabilirsiniz, ancak en kolay yol ko\u015fullu bi\u00e7imlendirmeyi kullanmakt\u0131r. \u0130zlemeniz gereken ad\u0131mlar \u015funlard\u0131r: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27154\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-mettre-en-evidence-les-valeurs-en-double-formatage-conditionnel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-vurgulama-yinelenen-de\u011ferler-ko\u015fullu bi\u00e7imlendirme\" width=\"369\" height=\"343\"><\/figure><\/div><ol><li> \u00d6ncelikle yinelenen de\u011ferleri vurgulamak istedi\u011finiz aral\u0131\u011f\u0131 se\u00e7in.<\/li><li> Bundan sonra, Ana Sayfa sekmesine gidin \u279c Stiller \u279c H\u00fccre Kural\u0131n\u0131 Vurgula \u279c \u00c7o\u011falt\u0131lm\u0131\u015f De\u011ferler.<\/li><li> \u015eimdi ileti\u015fim kutusunda kullan\u0131lacak rengi se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n.<\/li><\/ol><p> Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131zda, yinelenen de\u011ferler vurgulanacakt\u0131r. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-94-quick-analysis-tool\" class=\"wp-block-heading\"> 94. H\u0131zl\u0131 Tarama Arac\u0131<\/h3><p> Excel&#8217;de bir h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7ti\u011finizde se\u00e7imin alt\u0131nda k\u00fc\u00e7\u00fck bir simgenin g\u00f6r\u00fcnd\u00fc\u011f\u00fcn\u00fc hi\u00e7 fark ettiniz mi? Bu simgeye <strong>\u201c<\/strong> <a href=\"https:\/\/exceladvisor.org\/tr\/hizli-analiz-araci\/\">H\u0131zl\u0131 Tarama Arac\u0131<\/a> <strong>\u201d<\/strong> denir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27157\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-analyse-rapide-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-ipu\u00e7lar\u0131-h\u0131zl\u0131-analiz\" width=\"418\" height=\"211\"><\/figure><\/div><p> Bu simgeye t\u0131klad\u0131\u011f\u0131n\u0131zda, \u015ferit \u00fczerinde mevcut se\u00e7eneklerden baz\u0131lar\u0131n\u0131 g\u00f6rebilir ve bunlar\u0131 do\u011frudan buradan kullanarak zamandan tasarruf edebilirsiniz. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-95-run-command\" class=\"wp-block-heading\"> 95. \u00c7ALI\u015eTIR komutu<\/h3><p> Evet, Excel uygulaman\u0131z\u0131 RUN komutunu kullanarak da a\u00e7abilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27160\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-ouvertes-avec-la-commande-run-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-y\u00fcr\u00fctme-komutuyla-a\u00e7\" width=\"399\" height=\"206\"><\/figure><\/div><ul><li> Bunun i\u00e7in yapman\u0131z gereken tek \u015fey RUN&#8217;u (Pencere Tu\u015fu + R) a\u00e7\u0131p i\u00e7ine &#8220;excel&#8221; yazman\u0131z.<\/li><li> Sonunda Enter tu\u015funa bas\u0131n. <\/li><\/ul><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-96-open-specific-file\" class=\"wp-block-heading\"> 96. Belirli bir dosyay\u0131 a\u00e7\u0131n<\/h3><p> Eminim benim gibi sizin de <strong>her g\u00fcn Excel \u00fczerinde \u00e7al\u0131\u015fmaya ba\u015flad\u0131\u011f\u0131n\u0131zda a\u00e7t\u0131\u011f\u0131n\u0131z<\/strong> bu t\u00fcr \u00e7al\u0131\u015fma kitaplar\u0131ndan birka\u00e7\u0131 veya belki biri vard\u0131r. Excel&#8217;de, sisteminizde Excel&#8217;i her ba\u015flatt\u0131\u011f\u0131n\u0131zda belirli bir dosyay\u0131 veya dosyalar\u0131 a\u00e7mak i\u00e7in kullanabilece\u011finiz bir se\u00e7enek vard\u0131r. \u0130\u015fte ad\u0131mlar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27163\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-astuces-astuces-ouvrir-des-fichiers-lors-de-louverture-dexcel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-dosyalar\u0131-a\u00e7ma-excel-ne zaman-a\u00e7\u0131l\u0131r\" width=\"704\" height=\"312\"><\/figure><\/div><ol><li> Dosya \u279c Se\u00e7enekler \u279c Geli\u015fmi\u015f \u279c Genel&#8217;e gidin.<\/li><li> Tipik olarak, bu dosyalar\u0131n bulundu\u011fu klas\u00f6r\u00fcn konumunu (evet, yazman\u0131z gerekir) &#8220;Ba\u015flang\u0131\u00e7ta t\u00fcm dosyalar\u0131 \u015furada a\u00e7&#8221; alan\u0131na girin. <\/li><\/ol><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-97-open-excel-automatically\" class=\"wp-block-heading\"> 97. Excel&#8217;i otomatik olarak a\u00e7\u0131n<\/h3><p> Diz\u00fcst\u00fc bilgisayar\u0131m\u0131 her a\u00e7t\u0131\u011f\u0131mda ilk yapt\u0131\u011f\u0131m \u015fey Excel&#8217;i a\u00e7mak oluyor ve eminim siz de ayn\u0131 \u015feyi yap\u0131yorsunuzdur. Burada daha iyi bir fikrim var; Excel&#8217;i sistem ba\u015flang\u0131\u00e7 klas\u00f6r\u00fcn\u00fcze ekleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27166\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-ajouter-excel-demarrage-forlder-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-ipu\u00e7lar\u0131-p\u00fcf noktalar\u0131-ekleme-Excel-ba\u015flang\u0131\u00e7-form\u00fcl\u00fc\" width=\"690\" height=\"122\"><\/figure><\/div><ol><li> \u00d6ncelikle Windows tu\u015fu + E&#8217;yi kullanarak \u201cDosya Gezgini\u201dni a\u00e7\u0131n.<\/li><li> \u015eimdi klas\u00f6r\u00fc a\u00e7mak i\u00e7in adres \u00e7ubu\u011funa a\u015fa\u011f\u0131daki adresi girin (kullan\u0131c\u0131 ad\u0131n\u0131 ger\u00e7ek kullan\u0131c\u0131 ad\u0131n\u0131zla de\u011fi\u015ftirin).<ul><li> C:Kullan\u0131c\u0131larKullan\u0131c\u0131AppDataRoamingMicrosoftWindowsBa\u015flat Men\u00fcs\u00fcProgramlarBa\u015flang\u0131\u00e7<\/li><\/ul><\/li><li> Daha sonra Ba\u015flang\u0131\u00e7 ekran\u0131n\u0131 a\u00e7\u0131n, Excel uygulamas\u0131na sa\u011f t\u0131klay\u0131n ve Dosya konumunu a\u00e7 se\u00e7ene\u011fine t\u0131klay\u0131n.<\/li><li> Konumdan (Excel Uygulama klas\u00f6r\u00fc), Excel Uygulama simgesini kopyalay\u0131n ve \u201cBa\u015flang\u0131\u00e7\u201d klas\u00f6r\u00fcne yap\u0131\u015ft\u0131r\u0131n.<\/li><\/ol><p> Art\u0131k sisteminizi her a\u00e7t\u0131\u011f\u0131n\u0131zda Excel otomatik olarak ba\u015flayacakt\u0131r. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-98-smart-look-up\" class=\"wp-block-heading\"> 98. Ak\u0131ll\u0131 Arama<\/h3><p> Excel&#8217;de \u201cAk\u0131ll\u0131 Arama\u201d diye bir se\u00e7enek bulunmaktad\u0131r ve bu se\u00e7enekle internette bir metni arayabilirsiniz. Tek yapman\u0131z gereken bir h\u00fccreyi veya h\u00fccre i\u00e7indeki metni se\u00e7ip \u0130nceleme \u279c Analizler \u279c Ak\u0131ll\u0131 Arama&#8217;ya gitmek. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22982\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-recherche-intelligente-appuyez-sur-le-bouton-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 ak\u0131ll\u0131 arama d\u00fc\u011fmeye bas\u0131n\" width=\"345\" height=\"289\"><\/figure><\/div><p> \u00dczerine t\u0131klad\u0131\u011f\u0131n\u0131zda, se\u00e7ti\u011finiz metin hakk\u0131nda bilgi sahibi olaca\u011f\u0131n\u0131z bir yan b\u00f6lme a\u00e7\u0131l\u0131r. Bu se\u00e7ene\u011fin arkas\u0131ndaki fikir, konuya (metne) ili\u015fkin tan\u0131mlar\u0131 ve g\u00f6rselleri farkl\u0131 \u00e7evrimi\u00e7i kaynaklardan g\u00f6rerek bilgi edinmektir. <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h3 id=\"h-99-screen-clipping\" class=\"wp-block-heading\">99. Ekran g\u00f6r\u00fcnt\u00fcs\u00fc<\/h3><p> Bazen e-tablonuza ekran g\u00f6r\u00fcnt\u00fcleri eklemeniz gerekir. Ve bunun i\u00e7in Excel&#8217;in ekran\u0131 an\u0131nda yakalay\u0131p daha sonra \u00e7al\u0131\u015fma sayfas\u0131na yap\u0131\u015ft\u0131rabilece\u011finiz bir se\u00e7ene\u011fi var. Bunu yapmak i\u00e7in \u279c Ekle \u279c \u00c7izimler \u279c Ekran K\u0131rpma&#8217;ya gidin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22979\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-clip-ecran-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel ipu\u00e7lar\u0131 p\u00fcf noktalar\u0131 klip ekran\u0131\" width=\"401\" height=\"219\"><\/figure><\/div><p> \u0130lgili \u2013 <a href=\"https:\/\/exceladvisor.org\/tr\/kamera-araci\/\">Excel Kamera<\/a> <\/p><\/div><\/div><div class=\"wp-block-group more-box is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 id=\"h-100-locate-a-keyboard-shortcut\" class=\"wp-block-heading\"> 100. Bir klavye k\u0131sayolu bulun<\/h2><p> Excel 2007&#8217;den Excel 2016&#8217;ya ge\u00e7i\u015f kullan\u0131yorsan\u0131z <strong>ALT tu\u015funa basarak<\/strong> bir klavye k\u0131sayolu bulabilirsiniz. Bir kez bast\u0131\u011f\u0131n\u0131zda, a\u015fa\u011f\u0131daki gibi \u015ferit \u00fczerinde bulunan se\u00e7enek tu\u015flar\u0131n\u0131 g\u00f6r\u00fcnt\u00fcler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-26921\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-conseils-astuces-localiser-clavier-alt-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-tavsiye-p\u00fcf noktalar\u0131-bulma-klavye-alt\" width=\"536\" height=\"159\"><\/figure><\/div><p> Diyelim ki &#8221; <a href=\"https:\/\/exceladvisor.org\/tr\/metni-sar\/\">Metin Sar<\/a> &#8221; butonuna basmak istiyorsunuz ve tu\u015f ALT H W olacak. Ayn\u0131 \u015fekilde <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\">k\u0131sayol tu\u015flar\u0131n\u0131<\/a> kullanarak t\u00fcm se\u00e7eneklere ula\u015fabilirsiniz.<\/p><p> <em>\u0130lgili \u2013 <a href=\"https:\/\/exceladvisor.org\/tr\/bir-satir-ekle\/\">Sat\u0131r Ekle<\/a><\/em><\/p><\/div><\/div><h2 id=\"h-more-tips-and-tricks\" class=\"wp-block-heading\"> Daha fazla ipucu ve p\u00fcf noktas\u0131 <\/h2><div class=\"gb-container gb-container-efbd3596 gb-accordion\"><div class=\"gb-container gb-container-5a43a308 gb-accordion__item\" data-transition=\"slide\"><div class=\"gb-accordion__content\"><div class=\"gb-container gb-container-5e093c75\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/microsoft-excelin-avantajlari\/\">Microsoft Excel&#8217;in En \u00d6nemli 10 Faydas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/a\/\" data-wpil=\"url\">Excel&#8217;de Sekme Rengini De\u011fi\u015ftirme (\u00c7al\u0131\u015fma Sayfas\u0131 Sekmesi Arka Plan Rengi)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satirlari-sil\/\">Excel&#8217;de tek bir sat\u0131r\u0131 veya birden \u00e7ok sat\u0131r\u0131 silin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutunu-kopyala\/\">Excel&#8217;de bir s\u00fctunu kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yakinlastirma\/\">Excel&#8217;de yak\u0131nla\u015ft\u0131rma veya uzakla\u015ft\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sutununu-tasi\/\">Excel&#8217;de bir sat\u0131r\u0131 ve s\u00fctunu ta\u015f\u0131ma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/secenekler\/\">Excel Se\u00e7enekleri (Mac ve Windows)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sinir\/\">Excel&#8217;de kenarl\u0131k ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kenarlik-rengini-degistir\/\">Excel&#8217;de kenarl\u0131k rengini de\u011fi\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutun-genisligi\/\">Excel&#8217;de s\u00fctun geni\u015fli\u011fini de\u011fi\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bicimlendirmeyi-kaldir\/\">Excel&#8217;de Bi\u00e7imlendirmeyi Temizle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bicimlendirmeyi-kopyala\/\">Excel&#8217;de bi\u00e7imlendirmeyi kopyalama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iletisim-kutusu\/\">Excel&#8217;deki ileti\u015fim kutusu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/panjurlari-dondur\/\">Excel&#8217;de b\u00f6lmeleri dondurma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucreyi-degistir\/\">Excel&#8217;de \u0130ki H\u00fccreyi H\u0131zla De\u011fi\u015ftirin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutun-2\/\">Excel&#8217;de s\u00fctun nedir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hat-2\/\">Excel&#8217;de sat\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hizalama\/\">Excel&#8217;de Hizalama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cizgileri-goster\/\">Excel&#8217;de sat\u0131rlar\u0131 g\u00f6ster<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/menzil\/\">Excel&#8217;deki aral\u0131k<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kurdele\/\">Excel&#8217;de \u015eerit<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kopyala-yapistir-sutun-genisligi\/\">Excel&#8217;de s\u00fctun geni\u015fli\u011fini kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/degerleri-bicimlendirmeden-yapistir\/\">De\u011ferleri Excel&#8217;de bi\u00e7imlendirmeden kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dolar-isareti\/\">Excel&#8217;e dolar i\u015fareti ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ilk-satirin-basligini-olustur\/\">Excel&#8217;de ilk sat\u0131r ba\u015fl\u0131\u011f\u0131 olu\u015fturma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dosyayi-kaydet\/\">Excel&#8217;de bir dosyay\u0131 kaydetme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/araligi-sec\/\">Excel&#8217;de aral\u0131\u011f\u0131 se\u00e7in<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-dosyasini-kaydet-mac\/\">Mac&#8217;te bir Excel dosyas\u0131n\u0131 kaydetme (\u00c7al\u0131\u015fma Kitab\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yazdirmadan-once-onizleme\/\">Excel&#8217;de yazd\u0131rma \u00f6nizlemesi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/secime-odaklan\/\">Excel&#8217;de se\u00e7ime odaklan\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aktif-hucre\/\">Excel&#8217;deki etkin h\u00fccre<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-yuvarlanan-aylar\/\">Excel&#8217;de otomatik yuvarlanan aylar<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cap\/\">Excel&#8217;e \u00c7ap Sembol\u00fc Ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pi-sembolu\/\">PI (\u03c0) sembol\u00fcn\u00fc Excel&#8217;e ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kaydirma-kilidi\/\">Klavye y\u00f6n tu\u015flar\u0131 Excel&#8217;de \u00e7al\u0131\u015fm\u0131yor (Kayd\u0131rma Kilidi A\u00c7IK-KAPALI)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kamera-arkasi-gorunumu\/\">Excel&#8217;de Sahne Arkas\u0131 g\u00f6r\u00fcn\u00fcm\u00fcn\u00fc a\u00e7<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/karanlik-mod\/\">Excel&#8217;de Karanl\u0131k Modu Etkinle\u015ftir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kaydirma-cubugu\/\">Excel&#8217;de kayd\u0131rma \u00e7ubu\u011funu kurtar<\/a> <\/li><\/ul><\/div><\/div><\/div><div class=\"gb-container gb-container-62359e56 gb-accordion__item\" data-transition=\"slide\"><div class=\"gb-accordion__content\"><div class=\"gb-container gb-container-25b2d94b\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bagimli-acilir-liste\/\">Excel&#8217;deki ba\u011f\u0131ml\u0131 a\u00e7\u0131l\u0131r liste<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dinamik-liste\/\">Excel&#8217;de dinamik a\u00e7\u0131l\u0131r liste<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bozuk-excel-dosyasini-onar\/\">Bozuk Excel Dosyas\u0131n\u0131 Onar<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ust-alt-degerleri-vurgula\/\">Excel&#8217;de \u00fcst ve alt N de\u011ferlerini vurgulay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/onay-kutusu\/\">Excel&#8217;e onay kutusu ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfa-yonunu-degistir\/\">Excel&#8217;de sayfa y\u00f6n\u00fcn\u00fc de\u011fi\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/varsayilan-yazi-tipi\/\">Varsay\u0131lan yaz\u0131 tipi (stili, boyutu ve rengi de\u011fi\u015ftirin)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-dilimleyici\/\">Excel Dilimleyici (Tam K\u0131lavuz)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/alternatif-cizgileri-vurgula\/\">Renk \u00f6rne\u011fiyle Excel&#8217;deki alternatif sat\u0131rlar\u0131 vurgulay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/renge-gore-filtrele\/\">Excel&#8217;de renge g\u00f6re filtrele<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/macta-varsayilan-olarak-excel\/\">Mac&#8217;te Excel&#8217;i Varsay\u0131lan Yap\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excel-guvenli-mod\/\">Excel&#8217;i G\u00fcvenli Modda a\u00e7\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tabloyu-yeniden-adlandir\/\">Excel&#8217;de bir tabloyu yeniden adland\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/simge-oyunlari\/\" data-wpil=\"url\">Excel&#8217;de simge k\u00fcmelerini kullanma (ko\u015fullu bi\u00e7imlendirme)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutun-numaralari\/\">Excel&#8217;deki s\u00fctun numaralar\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/onbellegi-bosalt\/\">Excel&#8217;de \u00f6nbelle\u011fi temizle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/en-iyi-yazi-tipleri\/\">Microsoft Excel i\u00e7in En \u0130yi 5 Yaz\u0131 Tipi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gri-hucreler\/\">Excel&#8217;deki Gri H\u00fccreler<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sifirlari-gizle\/\">Excel&#8217;de s\u0131f\u0131r de\u011ferleri nas\u0131l gizlenir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucreleri-buyutmek\/\">Excel&#8217;de h\u00fccreleri b\u00fcy\u00fctme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metin-dosyasini-ac\/\">Excel&#8217;de bir metin dosyas\u0131 a\u00e7\u0131n (.TXT)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kisa-cizgileri-kaldir\/\">Excel&#8217;de k\u0131sa \u00e7izgileri kald\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/akilli-sanat\/\">Excel&#8217;de Ak\u0131ll\u0131 Sanat<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfa-kenar-boslugu\/\">Excel&#8217;de Sayfa Kenar Bo\u015flu\u011fu (De\u011fi\u015ftir ve Ayarla)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/birlestirilmis-hucreleri-bul\/\">Excel&#8217;de birle\u015ftirilmi\u015f h\u00fccreleri bulma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kisisellestirilmis-listeler\/\">Excel&#8217;de \u00f6zel bir liste olu\u015fturma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/excelde-pdf\/\">Excel&#8217;e PDF ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kilit-hucreleri-1\/\">Excel&#8217;de H\u00fccreleri Kilitle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-duzeltme\/\">Excel&#8217;de Otomatik D\u00fczelt&#8217;i kullanma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/resim-ekle\/\">Excel&#8217;de bir h\u00fccreye resim ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ad-araligini-bul\/\">Excel&#8217;de bir dizi ad bulma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dosya-yerlestirme\/\">Excel&#8217;e dosya g\u00f6mme<\/a><\/li><li> PDF&#8217;yi Excel&#8217;e d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sadece-oku\/\">Excel&#8217;de salt okunur yap<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/a\/\" data-wpil=\"url\">Excel&#8217;de ko\u015fullu bi\u00e7imlendirmeyi kald\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-kaydetmeyi-devre-disi-birak\/\">Excel&#8217;de Otomatik Kaydetme \u00d6zelli\u011fini Devre D\u0131\u015f\u0131 B\u0131rak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/senaryo-laboratuvari\/\">Excel&#8217;de Komut Dosyas\u0131 Laboratuvar\u0131<\/a> <\/li><\/ul><\/div><\/div><\/div><div class=\"gb-container gb-container-60833771 gb-accordion__item\" data-transition=\"slide\"><div class=\"gb-accordion__content\"><div class=\"gb-container gb-container-a6771b38\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yil-ayi-cikar\/\">Excel&#8217;deki bir tarihten y\u0131l\u0131 veya ay\u0131 \u00e7\u0131kar\u0131n (Al\u0131n)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-ve-saati-birlestir\/\">Excel&#8217;de tarih ve saati birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/en-yakin-binlige-yuvarlama\/\">Excel&#8217;de bir say\u0131y\u0131 en yak\u0131n 1000&#8217;e yuvarlama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-satir\/\">Excel&#8217;de toplam sat\u0131r ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-bir-parca-iceriyorsa\/\">Bir h\u00fccrenin k\u0131smi metin i\u00e7erip i\u00e7ermedi\u011fini kontrol edin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-gorunumu\/\">D\u00dc\u015eEYARA&#8217;y\u0131 ETOPLA ile birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/filtrelenen-satirlari-say\/\">Excel&#8217;de filtrelenen sat\u0131rlar\u0131 say\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iceriyorsa-toplami\/\">Toplam E\u011eER h\u00fccre belirli bir metin i\u00e7eriyorsa (SUMIF k\u0131smi metin)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sumif-yil-2\/\">Y\u0131llara g\u00f6re de\u011ferlerin toplam\u0131 (SUMIF Y\u0131l\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarihe-gore-toplam\/\">Tarihe g\u00f6re ETOPLA (tarihe g\u00f6re de\u011ferlerin toplam\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-degilse-toplam-2\/\">Bo\u015f olmayan ETOPLA (bo\u015f olmayan h\u00fccrelerin toplam de\u011ferleri)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bossa-toplam-2\/\">Bo\u015f de\u011ferleri veya bo\u015f h\u00fccreleri toplamak i\u00e7in ETOPLA&#8217;y\u0131 kullan\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ekleme-sayidan-yuzde-cikarma\/\">Bir say\u0131n\u0131n y\u00fczdesini toplama-\u00e7\u0131karma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-goz-ardi-edilen-hatalar-2\/\">Ortalama ancak hatalar\u0131 g\u00f6z ard\u0131 edin (#YOK ve di\u011fer hatalar)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-sifirlari-haric-tutar-2\/\">Ortalama say\u0131 ancak s\u0131f\u0131rlar\u0131 hari\u00e7 tutun<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-olmayan-hucrelerin-ortalamasi-2\/\">Yaln\u0131zca bo\u015f olmayan h\u00fccrelerin ortalamas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ay-is-gunu\/\">Bir ayda i\u015f g\u00fcn\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-yuzde-2\/\">Y\u00fczde de\u011ferlerinin ortalamas\u0131n\u0131 hesaplay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ortalama-sure-2\/\">Zaman de\u011ferlerinin ortalamas\u0131n\u0131 hesaplay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kumulatif-toplam-2\/\">De\u011ferlerin k\u00fcm\u00fclatif toplam\u0131n\u0131 hesaplay\u0131n (Excel form\u00fcl\u00fc)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-degeri-numarasi-ise\/\">Bir h\u00fccre de\u011ferinin say\u0131 olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ondalik-sayilarla-zaman-1\/\">Excel zaman de\u011ferini ondal\u0131k say\u0131ya (saat) d\u00f6n\u00fc\u015ft\u00fcrme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metin-tarihi-2\/\">Tarihi metne d\u00f6n\u00fc\u015ft\u00fcr<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dakikalardan-saatlere\/\">Dakikalar\u0131 saatlere ve dakikalara d\u00f6n\u00fc\u015ft\u00fcr\u00fcn (SS:DD)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dakika-cinsinden-sure-2\/\">Zaman de\u011ferini dakikaya d\u00f6n\u00fc\u015ft\u00fcr\u00fcn (Excel form\u00fcl\u00fc)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/saniye-cinsinden-sure-2\/\">Zaman de\u011ferini saniyeye d\u00f6n\u00fc\u015ft\u00fcr<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/karakterleri-say-2\/\">Excel&#8217;deki karakterleri sayma (h\u00fccre ve aral\u0131k)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/geri-sayim-gunleri\/\">Geri say\u0131m g\u00fcnleri<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dinamik-kopru-2\/\">Dinamik bir k\u00f6pr\u00fc olu\u015fturma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/en-dusuk-deger\/\">Say\u0131 listesinden en d\u00fc\u015f\u00fck de\u011feri bulun (N)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/en-kucuk-deger-2\/\">Bir h\u00fccre aral\u0131\u011f\u0131ndaki en k\u00fc\u00e7\u00fck de\u011feri bulun (en k\u00fc\u00e7\u00fck say\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aradaki-adlarin-virgulunu-dondur\/\">Ad\u0131 ve soyad\u0131 d\u00f6nd\u00fcr\u00fcn ve aras\u0131na virg\u00fcl ekleyin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/simdiki-zaman-2\/\">Ge\u00e7erli saati al\u0131n (Excel form\u00fcl\u00fc)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dosya-yolu-2\/\">Dosya yolunu al (Excel form\u00fcl\u00fc)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/1.-hucrenin-degeri\/\">Bir h\u00fccrenin de\u011ferini al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sekerleme-zamani-2\/\">Excel&#8217;de Toplam Zaman (Excel Form\u00fcl\u00fc)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2-ile-basla\/\">Bir h\u00fccre de\u011feri metinle veya say\u0131yla ba\u015fl\u0131yorsa<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/medyan-eger-2\/\">IF ile medyan (Ko\u015fullu kriterler)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-1\/\">Excel&#8217;de Otomatik Toplam\u0131 H\u0131zla Kullanma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/eger-daha-azsa-toplam\/\">Belirli bir de\u011ferden k\u00fc\u00e7\u00fck de\u011ferlerin toplam\u0131 (SUMIF k\u00fc\u00e7\u00fckt\u00fcr)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sifirdan-buyukse-toplam-2\/\">S\u0131f\u0131rdan b\u00fcy\u00fck de\u011ferlerin toplam\u0131 (SUMIF)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dolayli-toplam-2\/\">SUM ile DOLAYLI&#8217;y\u0131 kullan\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tarih-arama-v\/\">D\u00dc\u015eEYARA Tarihleri (verilerden bir tarih i\u00e7in D\u00dc\u015eEYARA)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zamana-saniye-ekleyin\/\">S\u00fcreye saniye ekleyin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ninci-kok-2\/\">N&#8217;inci k\u00f6k\u00fc hesapla<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2-numaradaki-ayin-adi\/\">Ay ad\u0131n\u0131 say\u0131ya d\u00f6n\u00fc\u015ft\u00fcr<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/saniyeden-saate-dakika\/\">Saniyeleri saatlere ve dakikalara d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iki-tarih-arasindaki-gun-sayisi\/\">\u0130ki tarih aras\u0131ndaki g\u00fcnleri say\u0131n (COUNTIF tarih aral\u0131\u011f\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/son-kelimeyi-cikar-2\/\">H\u00fccredeki son kelimeyi \u00e7\u0131karma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/en-sik-kullanilan-sayilar\/\">Bir dizinin en s\u0131k say\u0131lar\u0131n\u0131 al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2.-hucrenin-adresini-bul\/\">De\u011fer yerine h\u00fccre adresini bulma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sonunu-kaldir-2\/\">H\u00fccredeki sat\u0131r sonunu kald\u0131rma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/parantezleri-kaldir-2\/\">Excel&#8217;de Parantezleri Kald\u0131rma (Parantezler)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yuvarlak-yuzde-2\/\">Yuvarlak y\u00fczde de\u011ferleri<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/\">Aya g\u00f6re de\u011ferlerin toplam\u0131 (SUMIF)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/birden-cok-degeri-degistir\/\">Birden \u00e7ok (i\u00e7 i\u00e7e ge\u00e7mi\u015f) de\u011feri de\u011fi\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hata-yok\/\">#Yok<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-gruplar-olustur\/\">Rastgele gruplar olu\u015ftur<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bosluk-ekle-2\/\">Alan ekleyin (tekli ve \u00e7oklu)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kar-marji\/\">Br\u00fct kar (marj ve oran)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kdv\/\">KDV&#8217;yi hesapla<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/son-degeri-bul-2\/\">Bir s\u00fctun veya sat\u0131rdaki son de\u011feri bulma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/referans-hatasi\/\">#REF!<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/virgul-ekle\/\">Virg\u00fcl ekle (H\u00fccre-Metin)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kanallari-karsilastir-2\/\">\u0130ki dizeyi kar\u015f\u0131la\u015ft\u0131r\u0131n (metin)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2-ise-birlestir\/\">B\u0130RLE\u015eT\u0130RME IF (Ko\u015fulla Birle\u015ftir)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ay-yil-icindeki-tarih\/\">Tarihi ay ve y\u0131la d\u00f6n\u00fc\u015ft\u00fcrme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ondalik-sayilarda-zaman-3\/\">Zaman\u0131 ondal\u0131k say\u0131lara d\u00f6n\u00fc\u015ft\u00fcr\u00fcn<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/julyen-randevusu-2\/\">J\u00fclyen tarihine d\u00f6n\u00fc\u015ft\u00fcr<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satirlari-say-2\/\">Sat\u0131rlar\u0131 say\u0131n (t\u00fcm\u00fc, bo\u015f, bo\u015f olmayan ve rakaml\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/onceki-pazar-2\/\">\u00d6nceki Pazar g\u00fcn\u00fcn\u00fc al<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/etki-alani-al\/\">E-posta kimli\u011finden alan ad\u0131n\u0131 al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/son-karakteri-sil-2\/\">Bir dizedeki son karakteri kald\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/istenmeyen-karakterleri-kaldir\/\">\u0130stenmeyen karakterleri kald\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-birikir-1\/\">Birikimli toplam<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metni-bosluk-kullanarak-bolme\/\">Aras\u0131nda bo\u015fluk kullanarak metni b\u00f6lme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/2-ise-alt-toplam\/\">IF ile ALTTOPLAM (ko\u015fullu ALTTOPLAM)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/grup-basina-toplam-2\/\">Grup ba\u015f\u0131na de\u011ferlerin toplam\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/baska-bir-sayfadan-vlookup\/\">Ba\u015fka bir sayfadan D\u00dc\u015eEYARA (sayfalar aras\u0131nda)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metin-durumunu-degistir\/\">Metnin b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harflerini de\u011fi\u015ftirin (b\u00fcy\u00fck harf, k\u00fc\u00e7\u00fck harf, uygun)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yalnizca-sayilari-cikar\/\">Bir metinden (dize) yaln\u0131zca say\u0131lar\u0131 \u00e7\u0131karma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/once-sonra-metin\/\">Excel&#8217;de bir karakterin ard\u0131ndan ve \u00f6ncesindeki metni ay\u0131klama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/esitten-buyuk\/\">Operat\u00f6r (&gt;)&#8217;den b\u00fcy\u00fck ve (=)&#8217;ye e\u015fittir<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aritmetik-operatorler\/\">Excel&#8217;de aritmetik operat\u00f6rler nas\u0131l kullan\u0131l\u0131r?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vlookup-2-ile-dolayli\/\">D\u00dc\u015eEYARA ile dolayl\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iki-sutun-gorunumunu-karsilastir\/\">D\u00dc\u015eEYARA ile iki s\u00fctunu e\u015fle\u015ftirin\/kar\u015f\u0131la\u015ft\u0131r\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/virgulleri-kaldir-2\/\">Virg\u00fclleri kald\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kareler-toplami-2\/\">Karelerin toplam\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/xlookup-tum-maclar-2\/\">XLOOKUP T\u00fcm e\u015fle\u015fmeleri d\u00f6nd\u00fcr\u00fcr. Olas\u0131?<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cesitli-olcutlerle-xlookup\/\">\u00c7e\u015fitli \u00f6l\u00e7\u00fctlerle XLOOKUP<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dogru-yanlis\/\">Excel&#8217;de DO\u011eRU ve YANLI\u015e (boole de\u011ferleri)<\/a><\/li><\/ul><\/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-1487","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>2023&#039;te Profesyonel Olmak \u0130\u00e7in Excel&#039;e \u0130li\u015fkin 100 Gizli \u0130pucu<\/title>\n<meta name=\"description\" content=\"K\u0131sa s\u00fcrede ak\u0131ll\u0131 bir Excel kullan\u0131c\u0131s\u0131 olmak i\u00e7in 2021&#039;de \u00f6\u011frenece\u011finiz en iyi Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 bunlar.\" \/>\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\/tavsiye\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2023&#039;te Profesyonel Olmak \u0130\u00e7in Excel&#039;e \u0130li\u015fkin 100 Gizli \u0130pucu\" \/>\n<meta property=\"og:description\" content=\"K\u0131sa s\u00fcrede ak\u0131ll\u0131 bir Excel kullan\u0131c\u0131s\u0131 olmak i\u00e7in 2021&#039;de \u00f6\u011frenece\u011finiz en iyi Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 bunlar.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/tavsiye\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-astuces-Excel-pour-ajouter-des-numeros-de-serie-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=\"46 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/tavsiye\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/tavsiye\/\",\"name\":\"2023&#39;te Profesyonel Olmak \u0130\u00e7in Excel&#39;e \u0130li\u015fkin 100 Gizli \u0130pucu\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/tavsiye\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/tavsiye\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-astuces-Excel-pour-ajouter-des-numeros-de-serie-1.png\",\"datePublished\":\"2023-11-22T02:51:17+00:00\",\"dateModified\":\"2023-12-10T06:04:18+00:00\",\"description\":\"K\u0131sa s\u00fcrede ak\u0131ll\u0131 bir Excel kullan\u0131c\u0131s\u0131 olmak i\u00e7in 2021&#39;de \u00f6\u011frenece\u011finiz en iyi Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 bunlar.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/tavsiye\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/tavsiye\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/tavsiye\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-astuces-Excel-pour-ajouter-des-numeros-de-serie-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-astuces-Excel-pour-ajouter-des-numeros-de-serie-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/tavsiye\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Profesyonel olmak i\u0307\u00e7in 100 gizli excel i\u0307pucu\/p\u00fcf noktas\u0131\"}]},{\"@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":"2023&#39;te Profesyonel Olmak \u0130\u00e7in Excel&#39;e \u0130li\u015fkin 100 Gizli \u0130pucu","description":"K\u0131sa s\u00fcrede ak\u0131ll\u0131 bir Excel kullan\u0131c\u0131s\u0131 olmak i\u00e7in 2021&#39;de \u00f6\u011frenece\u011finiz en iyi Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 bunlar.","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\/tavsiye\/","og_locale":"tr_TR","og_type":"article","og_title":"2023&#39;te Profesyonel Olmak \u0130\u00e7in Excel&#39;e \u0130li\u015fkin 100 Gizli \u0130pucu","og_description":"K\u0131sa s\u00fcrede ak\u0131ll\u0131 bir Excel kullan\u0131c\u0131s\u0131 olmak i\u00e7in 2021&#39;de \u00f6\u011frenece\u011finiz en iyi Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 bunlar.","og_url":"https:\/\/exceladvisor.org\/tr\/tavsiye\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:18+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-astuces-Excel-pour-ajouter-des-numeros-de-serie-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"46 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/tavsiye\/","url":"https:\/\/exceladvisor.org\/tr\/tavsiye\/","name":"2023&#39;te Profesyonel Olmak \u0130\u00e7in Excel&#39;e \u0130li\u015fkin 100 Gizli \u0130pucu","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/tavsiye\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/tavsiye\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-astuces-Excel-pour-ajouter-des-numeros-de-serie-1.png","datePublished":"2023-11-22T02:51:17+00:00","dateModified":"2023-12-10T06:04:18+00:00","description":"K\u0131sa s\u00fcrede ak\u0131ll\u0131 bir Excel kullan\u0131c\u0131s\u0131 olmak i\u00e7in 2021&#39;de \u00f6\u011frenece\u011finiz en iyi Excel ipu\u00e7lar\u0131 ve p\u00fcf noktalar\u0131 bunlar.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/tavsiye\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/tavsiye\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/tavsiye\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-astuces-Excel-pour-ajouter-des-numeros-de-serie-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-astuces-Excel-pour-ajouter-des-numeros-de-serie-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/tavsiye\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Profesyonel olmak i\u0307\u00e7in 100 gizli excel i\u0307pucu\/p\u00fcf noktas\u0131"}]},{"@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\/1487","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=1487"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1487\/revisions"}],"predecessor-version":[{"id":2712,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1487\/revisions\/2712"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}