{"id":1781,"date":"2023-11-05T07:04:40","date_gmt":"2023-11-05T07:04:40","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/"},"modified":"2023-12-10T05:58:40","modified_gmt":"2023-12-10T05:58:40","slug":"aylik-miktar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/","title":{"rendered":"Aylara g\u00f6re de\u011ferler nas\u0131l eklenir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2945849897\"><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>De\u011ferleri aya g\u00f6re toplamak i\u00e7in, bir s\u00fctunda tarihleriniz oldu\u011funda SUMIFS veya SUMproduct kullanabilirsiniz. SUMIFS ile y\u0131l\u0131n belirli bir ay\u0131na denk gelen tarihlere ba\u015fvurabilirsiniz. SUMproduct ile y\u0131ldan ba\u011f\u0131ms\u0131z olarak belirli bir ay i\u00e7in toplama yapabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80542\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-basee-sur-les-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"ay baz\u0131nda toplam\" width=\"686\" height=\"273\"><\/figure><\/div><p> Verilerimiz bundan \u00fc\u00e7 y\u0131l sonraki tarihleri g\u00f6steriyor; 2021, 2022 ve 2023. Burada her iki form\u00fcl\u00fc de kullanaca\u011f\u0131z.<\/p><h2 class=\"wp-block-heading\"> De\u011ferleri y\u0131l\u0131n aylar\u0131na g\u00f6re toplamak i\u00e7in SUMIFS&#8217;i kullan\u0131n<\/h2><p> Bu form\u00fcl\u00fc yazmak i\u00e7in \u015fu ad\u0131mlar\u0131 izleyin:<\/p><ol type=\"1\"><li> \u0130lk \u00f6nce bir h\u00fccreye \u00c7OK ETOPLA de\u011ferini girin, ard\u0131ndan ilk ba\u011f\u0131ms\u0131z de\u011fi\u015fkende toplam\u0131 almak istedi\u011finiz aral\u0131\u011fa bak\u0131n.<\/li><li> Bundan sonra, ikinci ba\u011f\u0131ms\u0131z de\u011fi\u015fkende (kriter_aral\u0131k1), tarihlerin bulundu\u011fu aral\u0131\u011f\u0131 belirtin.<\/li><li> Ard\u0131ndan \u00fc\u00e7\u00fcnc\u00fc ba\u011f\u0131ms\u0131z de\u011fi\u015fkene (\u00f6l\u00e7\u00fct) ay\u0131n ba\u015flang\u0131\u00e7 tarihini belirtmek i\u00e7in (\u201c&gt;=\u201d&amp;TAR\u0130H(2022,1,1)) girin.<\/li><li> \u015eimdi \u00f6l\u00e7\u00fct aral\u0131\u011f\u01312&#8217;de, yine tarihlerle birlikte aral\u0131\u011fa referans verin. Ve \u00f6l\u00e7\u00fct2&#8217;ye (\u201c&lt;=\u201d&amp;EOMONTH(\u201c01-Jan-2022\u201d,0)) girin.<\/li><li> Sonunda kapatma parantezlerini yaz\u0131n ve sonucu almak i\u00e7in Enter tu\u015funa bas\u0131n. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80543\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sumifs-a-additionner-par-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"ayl\u0131k miktar\" width=\"724\" height=\"221\"><\/figure><\/div><p> Enter tu\u015funa bast\u0131\u011f\u0131n\u0131zda ise tarihin Ocak 2022 oldu\u011fu de\u011ferlerin toplam\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80544\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-des-valeurs-selon-le-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"ayl\u0131k-de\u011ferlerin toplam\u0131\" width=\"572\" height=\"302\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIFS(B2:B103,A2:A103,\"&gt;=\"&amp;DATE(2022,1,1),A2:A103,\"&lt;=\"&amp;EOMONTH(\"01-Jan-2022\",0))<\/code><\/pre><h3 class=\"wp-block-heading\"> Bu form\u00fcl nas\u0131l \u00e7al\u0131\u015f\u0131yor?<\/h3><p> Bu form\u00fcl\u00fc anlamak i\u00e7in onu \u00fc\u00e7 b\u00f6l\u00fcme ay\u0131rman\u0131z gerekir: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80545\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-formule-divisee-en-trois-parties.png\" sizes=\"auto, \" srcset=\"\" alt=\"form\u00fcl-\u00fc\u00e7 par\u00e7aya b\u00f6l\u00fcnm\u00fc\u015f\" width=\"498\" height=\"162\"><\/figure><\/div><p> \u0130lk b\u00f6l\u00fcmde toplam\u0131 alman\u0131z gereken aral\u0131\u011f\u0131 belirlediniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80546\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-a-dabord-specifie-la-plage-pour-obtenir-la-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplam\u0131 elde etmek i\u00e7in ilk belirtilen aral\u0131k\" width=\"692\" height=\"144\"><\/figure><\/div><p> \u0130kinci b\u00f6l\u00fcmde, tarihlerinizin bulundu\u011fu aral\u0131\u011fa referans verdiniz ve ard\u0131ndan 01-Ocak-2022 \u015feklinde ge\u00e7erli bir tarih olu\u015fturmak i\u00e7in DATE i\u015flevini kulland\u0131n\u0131z.<\/p><p> DATE i\u015fleviyle b\u00fcy\u00fck ve e\u015fittir operat\u00f6rlerini de kulland\u0131n\u0131z. Ve bunu yapt\u0131\u011f\u0131n\u0131zda, SUMIFS&#8217;e yaln\u0131zca 01-Ocak-2022&#8217;ye e\u015fit veya daha b\u00fcy\u00fck tarihler i\u00e7in toplama yapmas\u0131n\u0131 s\u00f6yler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80547\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-specifie-la-plage-qui-a-des-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"tarihleri olan-belirtilen-aral\u0131k\" width=\"578\" height=\"199\"><\/figure><\/div><p> 3. b\u00f6l\u00fcmde tarih aral\u0131\u011f\u0131na tekrar de\u011findiniz.<\/p><p> Kriterlerde 01-Ocak-2022 tarihlerini ve ay olarak 0&#8217;\u0131 i\u00e7eren ve 31-Ocak-2022 Ocak ay\u0131n\u0131n son g\u00fcn\u00fcn\u00fc (tarihini) d\u00f6nd\u00fcren EMONTH fonksiyonunu kulland\u0131n\u0131z. Bununla birlikte k\u00fc\u00e7\u00fckt\u00fcr ve e\u015fittir operat\u00f6r\u00fcne de sahipsiniz.<\/p><p> Bu, SUMIF&#8217;e 31 Ocak 2033&#8217;ten k\u00fc\u00e7\u00fck veya bu tarihe e\u015fit tarihler i\u00e7in de\u011ferleri eklemesini s\u00f6yler. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80548\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-troisieme-partie-a-nouveau-renvoyee-a-la-plage-de-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00fc\u00e7\u00fcnc\u00fc-b\u00f6l\u00fcm-tekrar-tarih aral\u0131\u011f\u0131na-bahsedilen-aral\u0131k\" width=\"514\" height=\"205\"><\/figure><\/div><p> Yukar\u0131daki iki kriterle 01-Ocak-2022 ile 31-Ocak-2022 aras\u0131nda bir tarih aral\u0131\u011f\u0131n\u0131z olur ve form\u00fcl bu iki tarih aras\u0131ndaki t\u00fcm de\u011ferleri \u00f6zetleyecektir.<\/p><h2 class=\"wp-block-heading\"> SUMproduct aya g\u00f6re de\u011fer eklemek i\u00e7in<\/h2><p> Ve y\u0131ldan ba\u011f\u0131ms\u0131z olarak bir aya ait de\u011fer eklemek istiyorsan\u0131z SUMproduct ve AY fonksiyonlar\u0131n\u0131 kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80549\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-sumproduct-a-somme-en-utilisant-le-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplam-toplam-kullan\u0131lan-ay\" width=\"710\" height=\"221\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(B2:B103,--(MONTH(A2:A103)=1))<\/code><\/pre><p> Bu form\u00fclde AY i\u015flevini kulland\u0131n\u0131z ve tarih aral\u0131\u011f\u0131n\u0131n tamam\u0131na at\u0131fta bulundunuz. Bundan sonra 1 ile test edin, bu da Ocak tarihlerini kontrol etmek anlam\u0131na gelir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80550\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-sommeproduit-et-mois-combines.png\" sizes=\"auto, \" srcset=\"\" alt=\"toplam \u00fcr\u00fcn ve ay\u0131n birle\u015fimi\" width=\"683\" height=\"250\"><\/figure><\/div><p> Bundan sonra DO\u011eRU&#8217;yu 1&#8217;e ve YANLI\u015e&#8217;\u0131 0&#8217;a d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in \u00e7ift eksi i\u015faretine sahipsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80551\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-convertir-vrai-et-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"do\u011fru ve yanl\u0131\u015f\u0131 d\u00f6n\u00fc\u015ft\u00fcrme\" width=\"550\" height=\"191\"><\/figure><\/div><p> Sonunda SUMproduct iki tabloyu (Miktar ve 0-1) \u00e7arpar ve ay\u0131n Ocak oldu\u011fu tarihlerin toplam\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80552\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-sumproduct-multiplie-les-deux-tableaux.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumproduct-her ikisini de-dizilerle \u00e7arpar\" width=\"549\" height=\"412\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mois-sumif.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><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\/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 (bir tarihe dayal\u0131 de\u011ferlerin toplam\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-degilse-toplam-2\/\">Bo\u015f olmayan SUMIF (bo\u015f olmayan h\u00fccreler i\u00e7in toplam de\u011ferler)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1781","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 ay baz\u0131nda de\u011ferler nas\u0131l eklenir?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim size aylara dayal\u0131 de\u011ferler eklemek i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\" \/>\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\/aylik-miktar\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de ay baz\u0131nda de\u011ferler nas\u0131l eklenir?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim size aylara dayal\u0131 de\u011ferler eklemek i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T05:58:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-basee-sur-les-mois.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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/\",\"name\":\"Excel&#39;de ay baz\u0131nda de\u011ferler nas\u0131l eklenir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-basee-sur-les-mois.png\",\"datePublished\":\"2023-11-05T07:04:40+00:00\",\"dateModified\":\"2023-12-10T05:58:40+00:00\",\"description\":\"Bu e\u011fitim size aylara dayal\u0131 de\u011ferler eklemek i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-basee-sur-les-mois.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-basee-sur-les-mois.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Aylara g\u00f6re de\u011ferler nas\u0131l eklenir?\"}]},{\"@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 ay baz\u0131nda de\u011ferler nas\u0131l eklenir?","description":"Bu e\u011fitim size aylara dayal\u0131 de\u011ferler eklemek i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","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\/aylik-miktar\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de ay baz\u0131nda de\u011ferler nas\u0131l eklenir?","og_description":"Bu e\u011fitim size aylara dayal\u0131 de\u011ferler eklemek i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","og_url":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T05:58:40+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-basee-sur-les-mois.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/","url":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/","name":"Excel&#39;de ay baz\u0131nda de\u011ferler nas\u0131l eklenir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-basee-sur-les-mois.png","datePublished":"2023-11-05T07:04:40+00:00","dateModified":"2023-12-10T05:58:40+00:00","description":"Bu e\u011fitim size aylara dayal\u0131 de\u011ferler eklemek i\u00e7in Excel form\u00fcllerinin nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 \u00f6\u011fretecektir. Bunu kontrol edelim\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/aylik-miktar\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-basee-sur-les-mois.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-basee-sur-les-mois.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/aylik-miktar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Aylara g\u00f6re de\u011ferler nas\u0131l eklenir?"}]},{"@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\/1781","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=1781"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1781\/revisions"}],"predecessor-version":[{"id":2260,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1781\/revisions\/2260"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}