{"id":3789,"date":"2024-07-30T18:55:35","date_gmt":"2024-07-30T16:55:35","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=3789"},"modified":"2024-08-01T11:30:54","modified_gmt":"2024-08-01T09:30:54","slug":"koje-poslove-ljudi-rade-u-excelu","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/","title":{"rendered":"Koje poslove ljudi rade u excelu?"},"content":{"rendered":"\n

Zvu\u010di kao floskula kada me polaznici radionice pitaju koje poslove mogu obaviti u excelu, a kada im odgovorim sve ili gotovo sve.
Ima sjajnih “slikara” koji crtaju u excelu i svetski su poznati, jednostavnim bojenjem pozadina \u0107elije tabele pretvaraju\u0107i mozaik od tabele u sliku. Sve po starom sistemu slika je u oku posmatra\u010da!
Za ‘matemati\u010dki’ um to mo\u017ee ipak biti ne prihvatljivo.
Pa dobro, za koje poslove koriste excel kada mislimo na poslovnu primenu?<\/p>\n\n\n\n

Opet, bojenje \u0107elija, redova, kolona i razna druga ozna\u010davanja, nagla\u0161avanja, markiranja upotrebom boje. Ne ne \u0161alim se, potreba da na neki na\u010din ozna\u010dimo neke iznose, sadr\u017eaj \u0107elije ili \u010ditavog reda mo\u017eemo obaviti, upotrebom alata definisanjem osnovne osobine boje \u0107elije.<\/p>\n\n\n\n

Daleko pamtnije je upotrebiti Uslovno formatiranje tabela<\/a> kao \u0161to smo ve\u0107 pisali o tome.<\/p>\n\n\n\n

Od matemati\u010dke obrade takvih redova ozna\u010denih bojom mo\u017eemo uraditi veoma malo, filtriranje redova jedne izabrane boje, sortiranje po boji, moze dovesti do sabiranja, brojanja ili neke druge agregacije vrednosti upotrebom SUBTOTAL<\/a> funkcije ili kako je navedeno u Excel funkcija AGGREGATE<\/a>.<\/p>\n\n\n\n

Izraditi pivot ili izvedenu tabelu svih raznobojnih redova upotrebom standardnog excela nije mogu\u0107e.<\/p>\n\n\n\n

Zato smo napravili dodatnu VBA funkciju koja pretvara boje u brojeve i tek onda imate minimum podataka da pivotirate sve raznobojne redove.<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n\n\n

\n \n
\n \n
\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n <\/div>\n \n
\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n <\/div>\n<\/div>\n \n\n
\n 5\/5 - (4 votes) <\/div>\n <\/div>\n","protected":false},"excerpt":{"rendered":"

Zvu\u010di kao floskula kada me polaznici radionice pitaju koje poslove mogu obaviti u excelu, a kada im odgovorim sve ili<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-3789","post","type-post","status-publish","format-standard","hentry","category-ekscel"],"yoast_head":"\nKoje poslove ljudi rade u excelu? - Kalkulacija u osnovi svega!<\/title>\n<meta name=\"description\" content=\"Koje poslove ljudi rade u excelu kada je re\u010d o poslovnoj primeni? Evo nekih poslova, kao \u0161to su evidentiranje, pra\u0107enje, kalkulacije, itd.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Koje poslove ljudi rade u excelu? - Kalkulacija u osnovi svega!\" \/>\n<meta property=\"og:description\" content=\"Koje poslove ljudi rade u excelu kada je re\u010d o poslovnoj primeni? Evo nekih poslova, kao \u0161to su evidentiranje, pra\u0107enje, kalkulacije, itd.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-30T16:55:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-01T09:30:54+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/koje-poslove-ljudi-rade-u-excelu\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/koje-poslove-ljudi-rade-u-excelu\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Koje poslove ljudi rade u excelu?\",\"datePublished\":\"2024-07-30T16:55:35+00:00\",\"dateModified\":\"2024-08-01T09:30:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/koje-poslove-ljudi-rade-u-excelu\\\/\"},\"wordCount\":223,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"articleSection\":[\"Poslovni Excel\"],\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/koje-poslove-ljudi-rade-u-excelu\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/koje-poslove-ljudi-rade-u-excelu\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/koje-poslove-ljudi-rade-u-excelu\\\/\",\"name\":\"Koje poslove ljudi rade u excelu? - Kalkulacija u osnovi svega!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"datePublished\":\"2024-07-30T16:55:35+00:00\",\"dateModified\":\"2024-08-01T09:30:54+00:00\",\"description\":\"Koje poslove ljudi rade u excelu kada je re\u010d o poslovnoj primeni? Evo nekih poslova, kao \u0161to su evidentiranje, pra\u0107enje, kalkulacije, itd.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/koje-poslove-ljudi-rade-u-excelu\\\/#breadcrumb\"},\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/koje-poslove-ljudi-rade-u-excelu\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/koje-poslove-ljudi-rade-u-excelu\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Koje poslove ljudi rade u excelu?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sr-SR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Koje poslove ljudi rade u excelu? - Kalkulacija u osnovi svega!","description":"Koje poslove ljudi rade u excelu kada je re\u010d o poslovnoj primeni? Evo nekih poslova, kao \u0161to su evidentiranje, pra\u0107enje, kalkulacije, itd.","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:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/","og_locale":"en_US","og_type":"article","og_title":"Koje poslove ljudi rade u excelu? - Kalkulacija u osnovi svega!","og_description":"Koje poslove ljudi rade u excelu kada je re\u010d o poslovnoj primeni? Evo nekih poslova, kao \u0161to su evidentiranje, pra\u0107enje, kalkulacije, itd.","og_url":"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2024-07-30T16:55:35+00:00","article_modified_time":"2024-08-01T09:30:54+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Koje poslove ljudi rade u excelu?","datePublished":"2024-07-30T16:55:35+00:00","dateModified":"2024-08-01T09:30:54+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/"},"wordCount":223,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"articleSection":["Poslovni Excel"],"inLanguage":"sr-SR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/","url":"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/","name":"Koje poslove ljudi rade u excelu? - Kalkulacija u osnovi svega!","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"datePublished":"2024-07-30T16:55:35+00:00","dateModified":"2024-08-01T09:30:54+00:00","description":"Koje poslove ljudi rade u excelu kada je re\u010d o poslovnoj primeni? Evo nekih poslova, kao \u0161to su evidentiranje, pra\u0107enje, kalkulacije, itd.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/#breadcrumb"},"inLanguage":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/koje-poslove-ljudi-rade-u-excelu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Koje poslove ljudi rade u excelu?"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sr-SR"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=3789"}],"version-history":[{"count":7,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3789\/revisions"}],"predecessor-version":[{"id":3801,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3789\/revisions\/3801"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=3789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=3789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=3789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}