{"id":2055,"date":"2020-04-23T10:22:44","date_gmt":"2020-04-23T08:22:44","guid":{"rendered":"http:\/\/www.munera3.si\/?post_type=seminar&#038;p=2055"},"modified":"2020-09-24T11:45:25","modified_gmt":"2020-09-24T09:45:25","slug":"excel-nadaljevalni-za-podporo-procesov-v-zavarovalnicah","status":"publish","type":"seminar","link":"https:\/\/www.munera3.si\/?seminar=excel-nadaljevalni-za-podporo-procesov-v-zavarovalnicah","title":{"rendered":"Excel nadaljevalni za podporo procesov v zavarovalnicah"},"content":{"rendered":"<section class=\"wpb-content-wrapper\"><p>[vc_row][vc_column width=&#8221;3\/4&#8243;][stm_post_info][vc_column_text el_class=&#8221;obojestransko&#8221;]Te\u010daj Excel nadaljevalni je 50 urni te\u010daj namenjen obstoje\u010dim uporabnikom, ki bi \u017eeleli nadgraditi svoje znanje in spretnosti pri uporabi programa Excel s poudarkom na podpori procesov v zavarovalnicah[\/vc_column_text][stm_color_separator][stm_animation_block duration=&#8221;300&#8243; delay=&#8221;0&#8243;][vc_column_text]<\/p>\n<h2>Podrobnosti usposabljanja<\/h2>\n<p>[\/vc_column_text][\/stm_animation_block][vc_tta_accordion][vc_tta_section i_icon_fontawesome=&#8221;fa fa-user-plus&#8221; add_icon=&#8221;true&#8221; title=&#8221;Ciljna skupina&#8221; tab_id=&#8221;1546118685728-8d7622cd-c1eb36d3-60fce443-522a098d-2e67&#8243; el_class=&#8221;modra&#8221;][vc_column_text]Ciljna skupina usposabljanja so:<\/p>\n<p>Zaposleni in samozaposleni, ki se pri svojem delu sre\u010dujejo z uporabo excela in \u017ee obvladajo osnove omenjenega programa s poudarkom na podpori procesov v zavarovalnicah[\/vc_column_text][\/vc_tta_section][vc_tta_section i_icon_fontawesome=&#8221;fa fa-book&#8221; add_icon=&#8221;true&#8221; title=&#8221;Vsebina programa&#8221; tab_id=&#8221;1548249931745-7fb228a8-b549e443-522a098d-2e67&#8243;][vc_column_text]<\/p>\n<ul>\n<li>Napredno urejenje podatkov in uporaba formul \u2013 9 ur<\/li>\n<li>Kratka osve\u017eitev naprednega urejanja podatkov\u00a0: zamrzovanje, uvoz podatkov, za\u0161\u010dita delovnega lista in celic, oblikovanje, razvr\u0161\u010danje povezovanje delovnih listov, 3D vsote, hitre bli\u017enjice in najuporabnej\u0161i triki<\/li>\n<li>Kratka osve\u017eitev uporabe formul v Excelu\u00a0in razumevanje napak (SUM, AVERAGE\u00a0; COUNT, MIN\/MAX, ROUND)<\/li>\n<li>Funkcije<\/li>\n<li>3D formule in povezave v izra\u010dunih<\/li>\n<li>Ra\u010dunanje z datumi<\/li>\n<li>Zahtevne funckije\u00a0: IF, VLOOKUP, IFERROR in njihovo gnezdenje<\/li>\n<li>Analiza podatkov<\/li>\n<li>Napredni grafi\u010dni prikaz podatkov, pogojno oblikovanje \u0161tevil, oblikovanje zahtevnej\u0161ih grafikonov<\/li>\n<li>Vrtilne tabele in vrtilni grafikoni, sekundarna os, \u010dasovni trendi<\/li>\n<li>Uporaba ve\u010dnivojskega razvr\u0161\u010danja za pregled obse\u017enih seznamov podatkov<\/li>\n<\/ul>\n<p>[\/vc_column_text][\/vc_tta_section][vc_tta_section i_icon_fontawesome=&#8221;fa fa-bookmark&#8221; add_icon=&#8221;true&#8221; title=&#8221;Pridobljene kompetence&#8221; tab_id=&#8221;1546119145441-58b132f2-07a536d3-60fce443-522a098d-2e67&#8243;][vc_column_text]Zna samostojno napredno uporabljati program Excel.[\/vc_column_text][\/vc_tta_section][\/vc_tta_accordion][\/vc_column][vc_column width=&#8221;1\/4&#8243;][stm_animation_block type=&#8221;fade-down&#8221; duration=&#8221;3000&#8243; delay=&#8221;2000&#8243;][vc_btn title=&#8221;Vklju\u010dite se&#8221; style=&#8221;flat&#8221; color=&#8221;success&#8221; size=&#8221;lg&#8221; i_icon_fontawesome=&#8221;lnr lnr-pushpin&#8221; add_icon=&#8221;true&#8221; link=&#8221;url:http%3A%2F%2Fwww.munera3.si%2Flms%2F||target:%20_blank|&#8221; css=&#8221;.vc_custom_1551790828446{margin-top: 38px !important;}&#8221;][vc_zigzag color=&#8221;vista_blue&#8221; css=&#8221;.vc_custom_1548872459573{margin-top: 10px !important;border-bottom-width: 20px !important;}&#8221;][vc_empty_space height=&#8221;15px&#8221;][vc_column_text]<\/p>\n<h4><strong>Kako se\u00a0registriram?<\/strong><\/h4>\n<p>[\/vc_column_text][vc_video link=&#8221;https:\/\/www.youtube.com\/embed\/E9Q5qkq70LE&#8221;][vc_widget_sidebar sidebar_id=&#8221;default&#8221;][\/stm_animation_block][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"featured_media":2056,"template":"","drzava":[],"class_list":["post-2055","seminar","type-seminar","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.munera3.si\/index.php?rest_route=\/wp\/v2\/seminar\/2055","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.munera3.si\/index.php?rest_route=\/wp\/v2\/seminar"}],"about":[{"href":"https:\/\/www.munera3.si\/index.php?rest_route=\/wp\/v2\/types\/seminar"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.munera3.si\/index.php?rest_route=\/wp\/v2\/media\/2056"}],"wp:attachment":[{"href":"https:\/\/www.munera3.si\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2055"}],"wp:term":[{"taxonomy":"drzava","embeddable":true,"href":"https:\/\/www.munera3.si\/index.php?rest_route=%2Fwp%2Fv2%2Fdrzava&post=2055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}