{"id":1659,"date":"2023-11-12T18:51:05","date_gmt":"2023-11-12T18:51:05","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/"},"modified":"2023-12-10T06:03:20","modified_gmt":"2023-12-10T06:03:20","slug":"yildiz-derecelendirmesi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/","title":{"rendered":"Excel&#39;de y\u0131ld\u0131z derecelendirmesi \u015fablonu nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1274893380\"><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\">Excel&#8217;de y\u0131ld\u0131z derecelendirmesi \u015fablonu olu\u015fturman\u0131za yard\u0131mc\u0131 olacak k\u0131sa bir ipucunu burada bulabilirsiniz. Bu y\u0131ld\u0131z derecelendirmesi \u015fablonunu olu\u015fturmak i\u00e7in tek ihtiyac\u0131n\u0131z olan REPT i\u015flevidir. REPT i\u015flevi, belirli bir metni belirli say\u0131da tekrarlamak istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r.<\/p><h2 id=\"h-steps-to-create-a-star-rating-template\" class=\"wp-block-heading\"> Y\u0131ld\u0131z Derecelendirmesi \u015eablonu Olu\u015fturma Ad\u0131mlar\u0131<\/h2><ol><li> E-tablonuza iki farkl\u0131 t\u00fcrde y\u0131ld\u0131z (\u2606\u2605) ekleyin ve bunlar\u0131 iki farkl\u0131 h\u00fccreye yerle\u015ftirin.<\/li><li> Geli\u015ftirici sekmesinden be\u015f se\u00e7enek d\u00fc\u011fmesi (form kontrol\u00fc) ekleyin. Ve t\u00fcm d\u00fc\u011fmeler i\u00e7in tek bir h\u00fccre ba\u011flant\u0131s\u0131 olu\u015fturun. Bunlar\u0131 dikey y\u00f6nde be\u015f h\u00fccreye yerle\u015ftirin.<\/li><li> D\u00fc\u011fmelerinizin bulundu\u011fu 5 h\u00fccreyi, yaln\u0131zca bir s\u00fctun \u00f6ncesinde birle\u015ftirin.<\/li><li> Birle\u015ftirilmi\u015f h\u00fccreye \u201c=REPT(H11,5-K11)&amp;REPT(I11,K11)\u201d yaz\u0131n.<\/li><li> H\u00fccre metni y\u00f6nlendirmesini dikey metne de\u011fi\u015ftirin, ard\u0131ndan metin hizalamas\u0131n\u0131 ortaya ve alta de\u011fi\u015ftirin.<\/li><\/ol><p> Modeliniz haz\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\" sizes=\"\" srcset=\"\" alt=\"Excel'de y\u0131ld\u0131z derecelendirmesi \u015fablonu\"><\/figure><\/div><h2 id=\"h-how-it-works\" class=\"wp-block-heading\"> Nas\u0131l \u00e7al\u0131\u015f\u0131r<\/h2><p> Form\u00fcl\u00fcn ilk k\u0131sm\u0131 size tan\u0131mlanm\u0131\u015f y\u0131ld\u0131zlar\u0131 verecektir. \u00d6rne\u011fin 3 y\u0131ld\u0131zl\u0131 bir derecelendirmeye t\u0131klad\u0131\u011f\u0131n\u0131zda plandaki di\u011fer iki y\u0131ld\u0131z da verilecektir.<\/p><p> Form\u00fcl\u00fcn ikinci k\u0131sm\u0131 size dolu y\u0131ld\u0131zlar verecektir. \u00d6rne\u011fin 4 y\u0131ld\u0131z derecelendirmesine t\u0131klad\u0131\u011f\u0131n\u0131zda 4 dolu y\u0131ld\u0131z alacaks\u0131n\u0131z.<\/p><p class=\"content-box-green\"> Form\u00fcl\u00fcn i\u00e7erisine semboller de ekleyebilir veya diledi\u011finiz gibi ba\u015fka sembol t\u00fcrlerini de kullanabilirsiniz. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Excel dosyas\u0131n\u0131 al\u0131n <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/modele-devaluation-par-etoiles-excel-2.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/div><\/div><\/div><\/div><\/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\/yatay-filtre\/\">Excel&#8217;de yatay filtre olu\u015fturma<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dosya-adini-al\/\">Excel&#8217;de dosya ad\u0131n\u0131 al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfa-adini-al\/\">Excel&#8217;de sayfa ad\u0131n\u0131 al\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/rastgele-harfler-olustur\/\">Excel&#8217;de h\u0131zla rastgele harfler olu\u015fturun<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/listeyi-rastgele-hale-getir\/\">Excel&#8217;de bir listeyi rastgele s\u0131ralama (rastgele s\u0131ralama)<\/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-1659","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 Y\u0131ld\u0131z Derecelendirmesi \u015eablonu Nas\u0131l Olu\u015fturulur?<\/title>\n<meta name=\"description\" content=\"REPT i\u015flevi, belirli bir metni birka\u00e7 kez tekrarlamak istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r. Ve bug\u00fcn bu form\u00fcl\u00fc bir y\u0131ld\u0131z derecelendirmesi modeli olu\u015fturmak i\u00e7in kullanaca\u011f\u0131z.\" \/>\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\/yildiz-derecelendirmesi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Y\u0131ld\u0131z Derecelendirmesi \u015eablonu Nas\u0131l Olu\u015fturulur?\" \/>\n<meta property=\"og:description\" content=\"REPT i\u015flevi, belirli bir metni birka\u00e7 kez tekrarlamak istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r. Ve bug\u00fcn bu form\u00fcl\u00fc bir y\u0131ld\u0131z derecelendirmesi modeli olu\u015fturmak i\u00e7in kullanaca\u011f\u0131z.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:03:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\" \/>\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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/\",\"name\":\"Excel&#39;de Y\u0131ld\u0131z Derecelendirmesi \u015eablonu Nas\u0131l Olu\u015fturulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\",\"datePublished\":\"2023-11-12T18:51:05+00:00\",\"dateModified\":\"2023-12-10T06:03:20+00:00\",\"description\":\"REPT i\u015flevi, belirli bir metni birka\u00e7 kez tekrarlamak istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r. Ve bug\u00fcn bu form\u00fcl\u00fc bir y\u0131ld\u0131z derecelendirmesi modeli olu\u015fturmak i\u00e7in kullanaca\u011f\u0131z.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de y\u0131ld\u0131z derecelendirmesi \u015fablonu nas\u0131l olu\u015fturulur?\"}]},{\"@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 Y\u0131ld\u0131z Derecelendirmesi \u015eablonu Nas\u0131l Olu\u015fturulur?","description":"REPT i\u015flevi, belirli bir metni birka\u00e7 kez tekrarlamak istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r. Ve bug\u00fcn bu form\u00fcl\u00fc bir y\u0131ld\u0131z derecelendirmesi modeli olu\u015fturmak i\u00e7in kullanaca\u011f\u0131z.","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\/yildiz-derecelendirmesi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Y\u0131ld\u0131z Derecelendirmesi \u015eablonu Nas\u0131l Olu\u015fturulur?","og_description":"REPT i\u015flevi, belirli bir metni birka\u00e7 kez tekrarlamak istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r. Ve bug\u00fcn bu form\u00fcl\u00fc bir y\u0131ld\u0131z derecelendirmesi modeli olu\u015fturmak i\u00e7in kullanaca\u011f\u0131z.","og_url":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:03:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/","url":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/","name":"Excel&#39;de Y\u0131ld\u0131z Derecelendirmesi \u015eablonu Nas\u0131l Olu\u015fturulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif","datePublished":"2023-11-12T18:51:05+00:00","dateModified":"2023-12-10T06:03:20+00:00","description":"REPT i\u015flevi, belirli bir metni birka\u00e7 kez tekrarlamak istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r. Ve bug\u00fcn bu form\u00fcl\u00fc bir y\u0131ld\u0131z derecelendirmesi modeli olu\u015fturmak i\u00e7in kullanaca\u011f\u0131z.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modele-devaluation-par-etoiles-dans-excel.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/yildiz-derecelendirmesi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de y\u0131ld\u0131z derecelendirmesi \u015fablonu nas\u0131l olu\u015fturulur?"}]},{"@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\/1659","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=1659"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1659\/revisions"}],"predecessor-version":[{"id":2648,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1659\/revisions\/2648"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}