{"id":18249,"date":"2024-02-08T15:02:06","date_gmt":"2024-02-08T14:02:06","guid":{"rendered":"https:\/\/www.vita.sk\/?post_type=product&#038;p=18249"},"modified":"2026-10-29T10:30:25","modified_gmt":"2026-10-29T09:30:25","slug":"online-kurz-manazerske-uctovnictvo","status":"publish","type":"product","link":"https:\/\/www.vita.sk\/cs\/online-kurz-manazerske-uctovnictvo\/","title":{"rendered":"Online kurz Mana\u017e\u00e9rske \u00da\u010dtovn\u00edctvo"},"content":{"rendered":"<p>Online kurz Mana\u017e\u00e9rske \u00da\u010dtovn\u00edctvo je pre v\u00e1s ide\u00e1lny, ak sa chcete nau\u010di\u0165 pracova\u0165 s firemn\u00fdmi \u00fadajmi, analyzova\u0165 n\u00e1klady a pripravova\u0165 preh\u013eadn\u00e9 podklady na mana\u017e\u00e9rske rozhodovanie. <strong>Ide o certifikovan\u00fd online kurz na mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo s vyu\u017eit\u00edm Microsoft Excel a Power BI<\/strong>. Vysvetl\u00edme si \u00falohu intern\u00fdch inform\u00e1ci\u00ed pri pl\u00e1novan\u00ed, kontrole a hodnoten\u00ed v\u00fdkonnosti firmy. V Exceli sa zorientujete v h\u00e1rkoch, d\u00e1tov\u00fdch tabu\u013ek\u00e1ch a z\u00edskavan\u00ed \u00fadajov z webu vr\u00e1tane uk\u00e1\u017eok pr\u00e1ce s Finstatom. Precvi\u010d\u00edte si s\u00fahrnn\u00e9 v\u00fdpo\u010dty pomocou funkci\u00ed SUBTOTAL, AGGREGATE a SUMPRODUCT aj anal\u00fdzu pomocou kontingen\u010dn\u00fdch tabuliek. Uk\u00e1\u017eeme si tie\u017e mo\u017enosti r\u00fdchlej anal\u00fdzy d\u00e1t a ich vyu\u017eitie pri pr\u00edprave preh\u013eadov.<\/p>\n<p>&nbsp;<\/p>\n<p>Nadvia\u017eeme pr\u00edkladmi faktura\u010dn\u00fdch \u0161abl\u00f3n, \u010dasov\u00fdch v\u00fdkazov a firemn\u00fdch rozpo\u010dtov. Budeme kategorizova\u0165 n\u00e1klady a pracova\u0165 s mar\u017eou pri hodnoten\u00ed ekonomiky firmy alebo e-shopu. Spozn\u00e1te pracovn\u00fd postup v Power BI Desktop od in\u0161tal\u00e1cie a z\u00e1kladn\u00e9ho nastavenia a\u017e po tvorbu vizualiz\u00e1ci\u00ed. Na uk\u00e1\u017ekach z\u00e1kazn\u00edckych d\u00e1t si vysvetl\u00edme v\u00fdznam finan\u010dn\u00fdch KPI a mierok. Nau\u010d\u00edte sa rozli\u0161ova\u0165 mierky a vypo\u010d\u00edtavan\u00e9 st\u013apce, pou\u017e\u00edva\u0165 filtrovanie a orientova\u0165 sa vo funkci\u00e1ch \u010dasovej inteligencie. Bonusov\u00e1 lekcia predstav\u00ed DAX Studio ako n\u00e1stroj na pr\u00e1cu s DAX dopytmi. Pri interpret\u00e1cii \u00fadajov budeme prihliada\u0165 na ich zdroj, obdobie a v\u00fdznam jednotliv\u00fdch ukazovate\u013eov. Z\u00edskate z\u00e1klad na pr\u00edpravu reportov, ktor\u00e9 pom\u00e1haj\u00fa zrozumite\u013ene komunikova\u0165 v\u00fdsledky mana\u017ementu.<\/p>\n<p>&nbsp;<\/p>\n<p>Kurz je vhodn\u00fd pre mana\u017e\u00e9rov, podnikate\u013eov, \u00fa\u010dtovn\u00edkov a za\u010d\u00ednaj\u00facich controllerov, ktor\u00ed chc\u00fa rozv\u00edja\u0165 analytick\u00fa str\u00e1nku svojej pr\u00e1ce. Odpor\u00fa\u010dame z\u00e1kladn\u00fa orient\u00e1ciu v n\u00e1kladoch, v\u00fdnosoch a zisku aj be\u017en\u00fa pr\u00e1cu s Excelom. Na samostatn\u00e9 precvi\u010dovanie Power BI Desktop potrebujete vhodn\u00e9 prostredie Windows. V\u00fdu\u010dba prebieha online v sloven\u010dine a poskytuje ro\u010dn\u00fd pr\u00edstup, tak\u017ee m\u00f4\u017eete postupova\u0165 vlastn\u00fdm tempom. Vide\u00e1 dop\u013a\u0148aj\u00fa materi\u00e1ly na stiahnutie, prezent\u00e1cie, \u0165ah\u00e1ky a priebe\u017en\u00fd aj z\u00e1vere\u010dn\u00fd test. Po \u00faspe\u0161nom absolvovan\u00ed z\u00edskate certifik\u00e1t VITA. Ak sa chcete skuto\u010dne nau\u010di\u0165 vyu\u017e\u00edva\u0165 Excel a Power BI pri mana\u017e\u00e9rskom \u00fa\u010dtovn\u00edctve a sta\u0165 sa istej\u0161\u00edmi pri interpret\u00e1cii firemn\u00fdch \u00fadajov, tak toto je ide\u00e1lny online kurz pre v\u00e1s.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nau\u010dte sa spracov\u00e1va\u0165 firemn\u00e9 \u00fadaje, pripravova\u0165 rozpo\u010dty, analyzova\u0165 n\u00e1klady a vytv\u00e1ra\u0165 finan\u010dn\u00e9 reporty v Exceli a Power BI v online kurze s certifik\u00e1tom VITA.","protected":false},"author":4,"featured_media":18254,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[587,84,73,600],"product_tag":[191,211,770,1082,1108,1117,1179,1283,1807,2065,2066,2067],"class_list":{"0":"post-18249","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-online-kurzy-financie-uctovnictvo","7":"product_cat-online-kurzy-manazerske-kurzy-soft-skills","8":"product_cat-bez-kategorie","9":"product_cat-online-kurzy-manazerske-uctovnictvo","10":"product_tag-manazerske-kurzy","11":"product_tag-projektovy-manazment-v-it","12":"product_tag-controlling","13":"product_tag-microsoft-excel","14":"product_tag-firemne-rozpocty","15":"product_tag-power-bi","16":"product_tag-kontingencne-tabulky","17":"product_tag-manazerske-uctovnictvo","18":"product_tag-financny-reporting","19":"product_tag-analyza-nakladov","20":"product_tag-financne-kpi","21":"product_tag-dax","23":"first","24":"instock","25":"sale","26":"sold-individually","27":"taxable","28":"shipping-taxable","29":"purchasable","30":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.0 (Yoast SEO v25.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo kurz | VITA<\/title>\n<meta name=\"description\" content=\"Online kurz mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo v\u00e1s prevedie rozpo\u010dtami, n\u00e1kladmi a reportmi v Exceli a Power BI. Z\u00edskajte certifik\u00e1t VITA. Prihl\u00e1ste sa \u2705.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online kurz Mana\u017e\u00e9rske \u00da\u010dtovn\u00edctvo\" \/>\n<meta property=\"og:description\" content=\"Online kurz mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo v\u00e1s prevedie rozpo\u010dtami, n\u00e1kladmi a reportmi v Exceli a Power BI. Z\u00edskajte certifik\u00e1t VITA. Prihl\u00e1ste sa \u2705.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/\" \/>\n<meta property=\"og:site_name\" content=\"VITA\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/VitaAcademySK\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-29T09:30:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vita.sk\/wp-content\/uploads\/2024\/02\/kurz-Manazerske-uctovnictvo-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\/\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"WebPage\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/\",\n\t            \"url\": \"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/\",\n\t            \"name\": \"mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo kurz | VITA\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t            },\n\t            \"primaryImageOfPage\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2024\/02\/kurz-Manazerske-uctovnictvo-2.png\",\n\t            \"datePublished\": \"2024-02-08T14:02:06+00:00\",\n\t            \"dateModified\": \"2026-10-29T09:30:25+00:00\",\n\t            \"description\": \"Online kurz mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo v\u00e1s prevedie rozpo\u010dtami, n\u00e1kladmi a reportmi v Exceli a Power BI. Z\u00edskajte certifik\u00e1t VITA. Prihl\u00e1ste sa \u2705.\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"cs\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"ImageObject\",\n\t            \"inLanguage\": \"cs\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#primaryimage\",\n\t            \"url\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2024\/02\/kurz-Manazerske-uctovnictvo-2.png\",\n\t            \"contentUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2024\/02\/kurz-Manazerske-uctovnictvo-2.png\",\n\t            \"width\": 360,\n\t            \"height\": 360\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#breadcrumb\",\n\t            \"itemListElement\": [\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 1,\n\t                    \"name\": \"VITA Academy\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/cs\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 2,\n\t                    \"name\": \"Shop\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/shop\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 3,\n\t                    \"name\": \"Finan\u010dn\u00e9 Riadenie a \u00da\u010dtovn\u00edctvo\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/online-kurzy-financie-uctovnictvo\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 4,\n\t                    \"name\": \"Online kurz Mana\u017e\u00e9rske \u00da\u010dtovn\u00edctvo\"\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"WebSite\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/#website\",\n\t            \"url\": \"https:\/\/www.vita.sk\/\",\n\t            \"name\": \"VITA Academy - Online Kurzy a \u0160kolenia\",\n\t            \"description\": \"\",\n\t            \"publisher\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/#organization\"\n\t            },\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"SearchAction\",\n\t                    \"target\": {\n\t                        \"@type\": \"EntryPoint\",\n\t                        \"urlTemplate\": \"https:\/\/www.vita.sk\/?s={search_term_string}\"\n\t                    },\n\t                    \"query-input\": {\n\t                        \"@type\": \"PropertyValueSpecification\",\n\t                        \"valueRequired\": true,\n\t                        \"valueName\": \"search_term_string\"\n\t                    }\n\t                }\n\t            ],\n\t            \"inLanguage\": \"cs\"\n\t        },\n\t        {\n\t            \"email\": \"admin@vita.sk\",\n\t            \"logo\": \"https:\/\/www.vita.sk\/img\/vita_logo.png \",\n\t            \"address\": {\n\t                \"type\": \"PostalAddress\",\n\t                \"streetAddress\": \"Tom\u00e1\u0161ikova 50\/A\",\n\t                \"addressLocality\": \"Bratislava\",\n\t                \"postalCode\": \"83104\",\n\t                \"addressCountry\": {\n\t                    \"name\": \"SK\",\n\t                    \"type\": \"Country\"\n\t                }\n\t            },\n\t            \"contactPoint\": {\n\t                \"type\": \"ContactPoint\",\n\t                \"telephone\": \"+421 907 375\u00a0543\",\n\t                \"Email\": \"admin@vita.sk\",\n\t                \"contactType\": \"customer service\"\n\t            },\n\t            \"sameAs\": [\n\t                \"https:\/\/www.facebook.com\/VitaAcademySK\/\",\n\t                \"https:\/\/www.linkedin.com\/company\/vita-academy\/\"\n\t            ]\n\t        }\n\t    ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo kurz | VITA","description":"Online kurz mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo v\u00e1s prevedie rozpo\u010dtami, n\u00e1kladmi a reportmi v Exceli a Power BI. Z\u00edskajte certifik\u00e1t VITA. Prihl\u00e1ste sa \u2705.","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:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/","og_locale":"cs_CZ","og_type":"article","og_title":"Online kurz Mana\u017e\u00e9rske \u00da\u010dtovn\u00edctvo","og_description":"Online kurz mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo v\u00e1s prevedie rozpo\u010dtami, n\u00e1kladmi a reportmi v Exceli a Power BI. Z\u00edskajte certifik\u00e1t VITA. Prihl\u00e1ste sa \u2705.","og_url":"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/","og_site_name":"VITA","article_publisher":"https:\/\/www.facebook.com\/VitaAcademySK","article_modified_time":"2026-10-29T09:30:25+00:00","og_image":[{"width":360,"height":360,"url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2024\/02\/kurz-Manazerske-uctovnictvo-2.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/","url":"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/","name":"mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo kurz | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#primaryimage"},"image":{"@id":"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2024\/02\/kurz-Manazerske-uctovnictvo-2.png","datePublished":"2024-02-08T14:02:06+00:00","dateModified":"2026-10-29T09:30:25+00:00","description":"Online kurz mana\u017e\u00e9rske \u00fa\u010dtovn\u00edctvo v\u00e1s prevedie rozpo\u010dtami, n\u00e1kladmi a reportmi v Exceli a Power BI. Z\u00edskajte certifik\u00e1t VITA. Prihl\u00e1ste sa \u2705.","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#primaryimage","url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2024\/02\/kurz-Manazerske-uctovnictvo-2.png","contentUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2024\/02\/kurz-Manazerske-uctovnictvo-2.png","width":360,"height":360},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"VITA Academy","item":"https:\/\/www.vita.sk\/cs\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/www.vita.sk\/shop\/"},{"@type":"ListItem","position":3,"name":"Finan\u010dn\u00e9 Riadenie a \u00da\u010dtovn\u00edctvo","item":"https:\/\/www.vita.sk\/online-kurzy-financie-uctovnictvo\/"},{"@type":"ListItem","position":4,"name":"Online kurz Mana\u017e\u00e9rske \u00da\u010dtovn\u00edctvo"}]},{"@type":"WebSite","@id":"https:\/\/www.vita.sk\/#website","url":"https:\/\/www.vita.sk\/","name":"VITA Academy - Online Kurzy a \u0160kolenia","description":"","publisher":{"@id":"https:\/\/www.vita.sk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vita.sk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"email":"admin@vita.sk","logo":"https:\/\/www.vita.sk\/img\/vita_logo.png ","address":{"type":"PostalAddress","streetAddress":"Tom\u00e1\u0161ikova 50\/A","addressLocality":"Bratislava","postalCode":"83104","addressCountry":{"name":"SK","type":"Country"}},"contactPoint":{"type":"ContactPoint","telephone":"+421 907 375\u00a0543","Email":"admin@vita.sk","contactType":"customer service"},"sameAs":["https:\/\/www.facebook.com\/VitaAcademySK\/","https:\/\/www.linkedin.com\/company\/vita-academy\/"]}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product\/18249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/types\/product"}],"author":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/comments?post=18249"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media\/18254"}],"wp:attachment":[{"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/media?parent=18249"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_brand?post=18249"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_cat?post=18249"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.vita.sk\/cs\/wp-json\/wp\/v2\/product_tag?post=18249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}