{"id":6704,"date":"2026-09-30T13:56:55","date_gmt":"2026-09-30T13:56:55","guid":{"rendered":"https:\/\/tecor.rs\/?p=6704"},"modified":"2026-09-30T14:01:01","modified_gmt":"2026-09-30T14:01:01","slug":"popunjavanje-praznih-polja-fill-blanks","status":"publish","type":"post","link":"https:\/\/tecor.rs\/en\/popunjavanje-praznih-polja-fill-blanks\/","title":{"rendered":"Popunjavanje praznih polja &#8211; Fill Blanks"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"6704\" class=\"elementor elementor-6704\">\n\t\t\t\t<div class=\"elementor-element elementor-element-878728e e-flex e-con-boxed rt-default-class e-con e-parent\" data-id=\"878728e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4162e30 rt-default-class elementor-widget elementor-widget-text-editor\" data-id=\"4162e30\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p class=\"mcePastedContent\">Office 365 u Excelu nam omogu\u0107ava da kreiramo sopstvene funkcije, da ih zapamtimo i koristimo svaki put kada nam ponovo zatrebaju. Jedna od takvih funkcija koju delimo sa vama je <strong>tecor_FILLBLANKS.<\/strong> Ova funkcija nam omogu\u0107ava da izbegnemo ru\u010dnu korekciju podataka kada je prazne \u0107elije u nekoj koloni nephodno popuniti unosima koji se iznad njih nalaze, \u0161to mo\u017ee biti \u010desta potreba nakon primene opcije Unmerge Cells, kopiranja Pivot tabela ili \u010dak eksporta podataka iz sistema.<\/p><p class=\"mcePastedContent last-child\">Umesto da manuelno sre\u0111ujete podatke: Go To &#8211; Special &#8211; Blanks&#8230; mo\u017eete iskoristiti ovu funkciju da koriguje unose i obezbediti vi\u0161e vremena za analizu podataka.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a3817b9 e-flex e-con-boxed rt-default-class e-con e-parent\" data-id=\"a3817b9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b9752b5 rt-default-class elementor-widget elementor-widget-button\" data-id=\"b9752b5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1BAfYGZWe4LTWMzoUj1ryXEolNsP81MrY\/edit?usp=drive_link&#038;ouid=117086689258919247174&#038;rtpof=true&#038;sd=true\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Preuzmite fajl<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fafca7a e-flex e-con-boxed rt-default-class e-con e-parent\" data-id=\"fafca7a\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1af2045 rt-default-class elementor-widget elementor-widget-text-editor\" data-id=\"1af2045\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>*Funkcija iz primera je kompatibilna sa Office 365 verzijom Excela.<\/p>\n<p class=\"MsoNormal\" style=\"text-size-adjust: 100%; margin: 0px; padding: 0px; word-break: break-word; color: rgb(0, 0, 0); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, Verdana, sans-serif; font-size: medium; line-height: 1.5; text-align: justify; direction: ltr;\"><span style=\"font-family: Arial, &quot;Helvetica Neue&quot;, Helvetica, sans-serif;\">Jovo Stoki\u0107,<\/span><\/p><p class=\"mcePastedContent\" style=\"text-size-adjust: 100%; margin: 0px; padding: 0px; word-break: break-word; color: rgb(0, 0, 0); font-family: &quot;Helvetica Neue&quot;, Helvetica, Arial, Verdana, sans-serif; font-size: medium; line-height: 1.5; direction: ltr;\"><em><span style=\"font-family: Arial, &quot;Helvetica Neue&quot;, Helvetica, sans-serif;\">Trener i konsultant<\/span><\/em><span style=\"font-family: Arial, &quot;Helvetica Neue&quot;, Helvetica, sans-serif;\">, Tecor Lean &amp; Kaizen Consulting<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Office 365 u Excelu nam omogu\u0107ava da kreiramo sopstvene funkcije, da ih zapamtimo i koristimo svaki put kada nam ponovo zatrebaju. Jedna od takvih funkcija koju delimo sa vama je tecor_FILLBLANKS. Ova funkcija nam omogu\u0107ava da izbegnemo ru\u010dnu korekciju podataka kada je prazne \u0107elije u nekoj koloni nephodno popuniti unosima koji se iznad njih nalaze,&#8230;<\/p>","protected":false},"author":1,"featured_media":6706,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[152],"tags":[158,159],"class_list":["post-6704","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-newsletter-arhiva","tag-excel-365","tag-excel-kutak"],"_links":{"self":[{"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/posts\/6704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/comments?post=6704"}],"version-history":[{"count":4,"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/posts\/6704\/revisions"}],"predecessor-version":[{"id":6710,"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/posts\/6704\/revisions\/6710"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/media\/6706"}],"wp:attachment":[{"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/media?parent=6704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/categories?post=6704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tecor.rs\/en\/wp-json\/wp\/v2\/tags?post=6704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}