{"id":1920,"date":"2023-10-28T01:54:46","date_gmt":"2023-10-28T01:54:46","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/"},"modified":"2023-12-10T06:01:32","modified_gmt":"2023-12-10T06:01:32","slug":"hedef-aramak","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/","title":{"rendered":"Excel&#39;de hedef arama nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2527264804\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p class=\"has-text-align-left\">Lisedeyken denklemin sonucunu elde etti\u011fim ancak girdi de\u011ferini alamad\u0131\u011f\u0131m matematik denklemlerini \u00e7\u00f6zerdim. Dolay\u0131s\u0131yla, ayn\u0131 t\u00fcr sorunlar\u0131 Excel&#8217;de \u00e7\u00f6zmeyi planl\u0131yorsan\u0131z, size yard\u0131mc\u0131 olabilecek \u00f6zel bir araca sahipsiniz.<\/p><p> <strong>Hedef Ara<\/strong><\/p><p> Temel fikri, form\u00fcl\u00fcn bu sonucu elde etmek i\u00e7in ihtiya\u00e7 duydu\u011fu girdi de\u011ferini bulmakt\u0131r. Basit\u00e7e s\u00f6ylemek gerekirse, hangi ger\u00e7ek sonu\u00e7 de\u011ferini istedi\u011finizi biliyorsan\u0131z, bunu elde etmek i\u00e7in en iyi girdi de\u011ferini bulmak amac\u0131yla Hedef Arama&#8217;y\u0131 kullanabilirsiniz.<\/p><p> \u00d6rnek: Diyelim ki arkada\u015f\u0131n\u0131zdan bor\u00e7 para alman\u0131z gerekiyor. Ne kadar paraya ihtiyac\u0131n\u0131z oldu\u011funu, krediyi ne kadar s\u00fcrede \u00f6demek istedi\u011finizi ve her ay ne kadar \u00f6deyebilece\u011finizi biliyorsunuz.<\/p><p> Arkada\u015f\u0131n\u0131zla birlikte alman\u0131z gereken faiz oran\u0131n\u0131 hesaplamak i\u00e7in hedef aramay\u0131 kullanabilirsiniz. Hedef aray\u0131\u015f\u0131yla \u00e7\u00f6zebilece\u011finiz N say\u0131da karma\u015f\u0131k problem vard\u0131r.<\/p><p> Bug\u00fcn bu makalede Excel&#8217;de Hedef Arama&#8217;n\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131, nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 ve dikkat etmeniz gereken \u00f6nemli \u015feyleri \u00f6\u011freneceksiniz. Ba\u015flayal\u0131m.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Hedef Arama nas\u0131l a\u00e7\u0131l\u0131r?<\/h2><p> Bir merce\u011fi a\u00e7mak i\u00e7in bu iki y\u00f6ntemden birini kullanmay\u0131 deneyin.<\/p><ul><li> Veri sekmesi \u2192 Hipotez Analizi \u2192 Hedef Arama&#8217;ya gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-ouvert-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de a\u00e7\u0131k objektif arama\"><\/figure><\/div><ul><li> Alt + T + G k\u0131sayol tu\u015funu kullan\u0131n.<\/li><\/ul><p> Microsoft Excel&#8217;in 2007 &#8211; 2016 s\u00fcr\u00fcmlerinde hedef aramay\u0131 etkinle\u015ftirmek i\u00e7in bu y\u00f6ntemleri kullanabilirsiniz.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Hedef Arama fonksiyonunun bile\u015fenleri<\/h2><p> Hedef Aramay\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda, veri girmek i\u00e7in k\u00fc\u00e7\u00fck bir a\u00e7\u0131l\u0131r pencere g\u00f6receksiniz. Temel olarak \u00fc\u00e7 gerekli bile\u015fenden olu\u015fur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/objectif-chercher-dans-excel-une-petite-fenetre-pop-up-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de objektif arama k\u00fc\u00e7\u00fck bir a\u00e7\u0131l\u0131r pencere\"><\/figure><\/div><ol><li> H\u00fccreyi Ayarla: \u0130stenilen sonucu elde etmek istedi\u011finiz h\u00fccre. Burada bahsetti\u011finiz h\u00fccrenin bir form\u00fcl i\u00e7erdi\u011finden emin olun.<\/li><li> De\u011fere: Sonu\u00e7 olarak istedi\u011finiz de\u011fer.<\/li><li> H\u00fccreleri de\u011fi\u015ftirerek: De\u011fi\u015fikli\u011fin sonucu \u00fcretmesini istedi\u011finiz h\u00fccre &#8220;de\u011ferine&#8221; e\u015fittir. Burada bahsetti\u011finiz h\u00fccrenin &#8220;H\u00fccreyi Tan\u0131mla&#8221; b\u00f6l\u00fcm\u00fcnde bahsedilen h\u00fccrenin form\u00fcl\u00fcnde kullan\u0131ld\u0131\u011f\u0131ndan emin olun.<\/li><\/ol><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> Hedef Arama ile Excel&#8217;deki bir sorunu \u00e7\u00f6zme<\/h2><p> En d\u00fc\u015f\u00fck fiyat\u0131 teklif ederek ihaleyi kazanmaya \u00e7al\u0131\u015fan bir \u015firkette \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z\u0131 hayal edin.<\/p><p> Bunun i\u00e7in ini\u015f fiyat\u0131n\u0131z\u0131n (m\u00fc\u015fteri i\u00e7in) 1000$ olmas\u0131 gereken bir fiyatland\u0131rma yap\u0131s\u0131 haz\u0131rlaman\u0131z gerekiyor. \u015eu anki son fiyat\u0131n\u0131z 1089,9$. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/structure-de-prix-des-produits-pour-lutilisation-de-la-recherche-dobjectifs-dans-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de hedef aramay\u0131 kullanmak i\u00e7in \u00fcr\u00fcn fiyatland\u0131rma yap\u0131s\u0131\"><\/figure><\/div><p> E\u011fer manuel olarak yapmak istiyorsan\u0131z iki se\u00e7ene\u011finiz var.<\/p><ol><li> Taban fiyata ula\u015fmak i\u00e7in a\u00e7\u0131l\u0131\u015f fiyat\u0131ndan (1.000 ABD Dolar\u0131) t\u00fcm vergi ve har\u00e7lar\u0131 \u00e7\u0131karman\u0131z gereken bir geri hesaplama yap\u0131n.<\/li><li> Ancak istedi\u011finiz nihai fiyat\u0131 alabilmeniz i\u00e7in taban fiyat\u0131n\u0131z\u0131 de\u011fi\u015ftirmeniz gerekir.<\/li><\/ol><p> G\u00f6r\u00fcnd\u00fc\u011f\u00fc kadar kolay de\u011fil ama gol bulmak burada oyunun kurallar\u0131n\u0131 de\u011fi\u015ftirebilir.<\/p><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-dans-excel.zip\" rel=\"nofollow\">Bu dosyay\u0131 buradan indirin<\/a> ve a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin.<\/p><ul><li> Hedef aramay\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda a\u015fa\u011f\u0131daki gibi bir pencereyle kar\u015f\u0131la\u015facaks\u0131n\u0131z. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-la-recherche-dobjectifs-dans-Excel-pour-calculer-le-nouveau-prix-final-1.png\" sizes=\"\" srcset=\"\" alt=\"yeni nihai fiyat\u0131 hesaplamak i\u00e7in Excel'deki hedef aramay\u0131 kullan\u0131n\"><\/figure><\/div><ul><li> \u015eimdi a\u015fa\u011f\u0131daki de\u011ferleri girmeniz gerekiyor.<ol><li> \u201cDe\u011feri Ayarla\u201dya t\u0131klay\u0131n ve a\u00e7\u0131l\u0131\u015f fiyat\u0131n\u0131n bulundu\u011fu h\u00fccreye bak\u0131n.<\/li><li> &#8220;De\u011ferine&#8221; t\u0131klay\u0131n ve sonu\u00e7 olarak istedi\u011finiz de\u011feri a\u00e7\u0131l\u0131\u015f fiyat\u0131n\u0131n bulundu\u011fu h\u00fccreye girin.<\/li><li> Sonunda \u201cH\u00fccreyi de\u011fi\u015ftirerek\u201d se\u00e7ene\u011fine t\u0131klay\u0131n ve baz fiyat\u0131 olan h\u00fccreye bak\u0131n. <\/li><\/ol><\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/specifier-les-valeurs-a-utiliser-la-recherche-dobjectifs-dans-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de hedef aramay\u0131 kullanmak i\u00e7in de\u011ferleri belirtin\"><\/figure><\/div><ul><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><li> Hedef Arama e-tablonuzla buna benzer bir \u015fey yapacakt\u0131r. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-la-recherche-dobjectifs-dans-Excel-pour-calculer-le-prix-de-chargement-1.gif\" sizes=\"\" srcset=\"\" alt=\"Y\u00fckleme fiyat\u0131n\u0131 hesaplamak i\u00e7in Excel'de hedef aramay\u0131 kullan\u0131n\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h3><p> \u015eimdi taban fiyat h\u00fccresini kontrol etti\u011finizde de\u011feri 925$ olarak de\u011fi\u015fiyor ve bununla birlikte a\u00e7\u0131l\u0131\u015f fiyat\u0131n\u0131z da 1000$ olarak de\u011fi\u015fiyor. Temeliniz <a href=\"https:\/\/www.meritnation.com\/ask-answer\/question\/how-to-use-hit-and-trial-method\/mensuration\/3630981\" target=\"_blank\" rel=\"noreferrer noopener\">, deneme yan\u0131lma y\u00f6ntemi<\/a> kullan\u0131larak objektif aramayla de\u011fi\u015ftirildi. Ancak objektif arama olduk\u00e7a h\u0131zl\u0131 ve s\u00fcrecin tamam\u0131n\u0131 g\u00f6remiyorsunuz.<\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> Hedef Aramayla ilgili \u00f6nemli noktalar<\/h2><p> Bunlar, hedef bulmay\u0131 kullan\u0131rken ak\u0131lda tutulmas\u0131 gereken birka\u00e7 noktad\u0131r.<\/p><ol><li> Ayar h\u00fccresi olarak kullan\u0131lan bir h\u00fccrenin, &#8220;H\u00fccreleri de\u011fi\u015ftirirken&#8221; h\u00fccresine ba\u011fl\u0131 bir form\u00fcl i\u00e7ermesi gerekir.<\/li><li> Hedef Arama, &#8220;De\u011ferine&#8221; b\u00f6l\u00fcm\u00fcnde belirtti\u011finiz hedef de\u011fere ula\u015fmak i\u00e7in yineleme y\u00f6ntemini kullan\u0131r. Yinelemesini Dosya-&gt;Se\u00e7enekler-&gt;Form\u00fcller&#8217;den ayarlayabilirsiniz (bu, hassasiyet d\u00fczeyini art\u0131rabilir).<\/li><li> Bazen Excel size istedi\u011finiz sonucu veremeyebilir ve &#8220;belki de bir \u00e7\u00f6z\u00fcm bulamad\u0131&#8221; \u015feklinde bir mesaj g\u00f6r\u00fcnt\u00fcleyebilir. Bu durumda, sonucunuza daha yak\u0131n bir de\u011fer girip tekrar deneyebilirsiniz (1000$ yerine 999,95$). Ayr\u0131ca yukar\u0131daki iki i\u015faret\u00e7iyi kontrol etti\u011finizden emin olun.<\/li><li> Hedef arama ayn\u0131 anda yaln\u0131zca bir h\u00fccre giri\u015f de\u011feriyle \u00e7al\u0131\u015fabilir.<\/li><\/ol><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> Hedef Aramay\u0131 VBA koduyla kullanma<\/h2><p> Excel&#8217;in hedef bulucu komutu ile \u00e7al\u0131\u015f\u0131rken kahvenizin tad\u0131n\u0131 \u00e7\u0131karabilirsiniz. Umar\u0131m VBA&#8217;y\u0131 kullanarak ilave \u00e7ikolata ekleyebilirseniz sorun olmaz. Evet hakl\u0131s\u0131n\u0131z, VBA ile hedef aramay\u0131 kullanabilirsiniz.<\/p><p> ifade.GoalSeek(Hedef, De\u011fi\u015fen H\u00fccre)<\/p><ol><li> \u0130fade: Bu, istedi\u011finiz sonuca ula\u015fmak istedi\u011finiz bir h\u00fccre olmal\u0131d\u0131r.<\/li><li> Hedef: Sonu\u00e7 olarak d\u00f6nd\u00fcrmek istedi\u011fimiz sonu\u00e7.<\/li><li> De\u011fi\u015fen H\u00fccre: Sonu\u00e7 de\u011ferini elde etmek i\u00e7in de\u011fi\u015fiklik yap\u0131lmas\u0131 gereken h\u00fccre.<\/li><\/ol><p> \u0130\u015fte kullanabilece\u011finiz baz\u0131 makro kodlar\u0131.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub GoalSeekVBA() Rem: \/\/\/\/\/\/\/\/\/\/ Code by Exceladvisor.org Dim Target As Long On Error GoTo Errorhandler Target = InputBox(\"Enter the required value\", \"Enter Value\") Worksheets(\"Goal_Seek\").Activate With ActiveSheet.Range(\"C7\") .GoalSeek _ Goal:=Target, _ ChangingCell:=Range(\"C2\") End With Exit Sub Errorhandler: MsgBox (\"Sorry, value is not valid.\") End Sub<\/code><\/pre><p> <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-dans-excel.zip\" rel=\"nofollow\"><strong>\u00f6rnek dosya<\/strong><\/a><\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Dedi\u011fim gibi, manuel bir y\u00f6ntem uygulayarak giri\u015f de\u011ferini bulmaya \u00e7al\u0131\u015f\u0131rsan\u0131z, geri hesaplama yapmak i\u00e7in \u00e7ok fazla zaman harcaman\u0131z veya form\u00fcl olu\u015fturman\u0131z gerekir.<\/p><p> Ancak Lens Aramay\u0131 kullanarak bunu tek t\u0131klamayla yapabilirsiniz. T\u00fcm karma\u015f\u0131k hesaplamalar\u0131 sizin i\u00e7in bir saniyede yapacak. En iyi yan\u0131, onu VBA ile de kullanabilmenizdir. Umar\u0131m bu Excel&#8217;de daha iyi olman\u0131za yard\u0131mc\u0131 olur.<\/p><p class=\"qt-tip\"> <em><strong>K\u0131sa Not<\/strong> : Bu, <a href=\"https:\/\/exceladvisor.org\/tr\/excel-becerileri\/\">Excel Becerilerinizi<\/a> geli\u015ftirmenize yard\u0131mc\u0131 olabilecek <a href=\"https:\/\/exceladvisor.org\/tr\/tavsiye\/\" data-wpil=\"url\">Excel ipu\u00e7lar\u0131ndan<\/a> biridir.<\/em><\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excel-ilerlemesi\/\">\u0130leri Excel Dersleri<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kamera-araci\/\">Excel Kamera Arac\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/pencereyi-izle\/\">Excel&#8217;de pencereyi izle<\/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\/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><\/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-1920","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de Hedef Arama nas\u0131l kullan\u0131l\u0131r? (Manuel + VBA)<\/title>\n<meta name=\"description\" content=\"Sonu\u00e7 de\u011ferini biliyorsan\u0131z ve bu sonucu elde etmek i\u00e7in giri\u015f de\u011ferini bilmek istiyorsan\u0131z Excel&#039;de Hedef Arama&#039;y\u0131 kullan\u0131n.\" \/>\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\/hedef-aramak\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Hedef Arama nas\u0131l kullan\u0131l\u0131r? (Manuel + VBA)\" \/>\n<meta property=\"og:description\" content=\"Sonu\u00e7 de\u011ferini biliyorsan\u0131z ve bu sonucu elde etmek i\u00e7in giri\u015f de\u011ferini bilmek istiyorsan\u0131z Excel&#039;de Hedef Arama&#039;y\u0131 kullan\u0131n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-ouvert-dans-excel-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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/\",\"name\":\"Excel&#39;de Hedef Arama nas\u0131l kullan\u0131l\u0131r? (Manuel + VBA)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-ouvert-dans-excel-1.png\",\"datePublished\":\"2023-10-28T01:54:46+00:00\",\"dateModified\":\"2023-12-10T06:01:32+00:00\",\"description\":\"Sonu\u00e7 de\u011ferini biliyorsan\u0131z ve bu sonucu elde etmek i\u00e7in giri\u015f de\u011ferini bilmek istiyorsan\u0131z Excel&#39;de Hedef Arama&#39;y\u0131 kullan\u0131n.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-ouvert-dans-excel-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-ouvert-dans-excel-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de hedef arama nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de Hedef Arama nas\u0131l kullan\u0131l\u0131r? (Manuel + VBA)","description":"Sonu\u00e7 de\u011ferini biliyorsan\u0131z ve bu sonucu elde etmek i\u00e7in giri\u015f de\u011ferini bilmek istiyorsan\u0131z Excel&#39;de Hedef Arama&#39;y\u0131 kullan\u0131n.","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\/hedef-aramak\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Hedef Arama nas\u0131l kullan\u0131l\u0131r? (Manuel + VBA)","og_description":"Sonu\u00e7 de\u011ferini biliyorsan\u0131z ve bu sonucu elde etmek i\u00e7in giri\u015f de\u011ferini bilmek istiyorsan\u0131z Excel&#39;de Hedef Arama&#39;y\u0131 kullan\u0131n.","og_url":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-ouvert-dans-excel-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/","url":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/","name":"Excel&#39;de Hedef Arama nas\u0131l kullan\u0131l\u0131r? (Manuel + VBA)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-ouvert-dans-excel-1.png","datePublished":"2023-10-28T01:54:46+00:00","dateModified":"2023-12-10T06:01:32+00:00","description":"Sonu\u00e7 de\u011ferini biliyorsan\u0131z ve bu sonucu elde etmek i\u00e7in giri\u015f de\u011ferini bilmek istiyorsan\u0131z Excel&#39;de Hedef Arama&#39;y\u0131 kullan\u0131n.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/hedef-aramak\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-ouvert-dans-excel-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/recherche-dobjectif-ouvert-dans-excel-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/hedef-aramak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de hedef arama nas\u0131l kullan\u0131l\u0131r?"}]},{"@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\/1920","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=1920"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1920\/revisions"}],"predecessor-version":[{"id":2536,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1920\/revisions\/2536"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}