{"id":1044,"count":5,"description":"Online kurzy Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling s\u00fa ur\u010den\u00e9 pre finan\u010dn\u00fdch mana\u017e\u00e9rov, controllerov, \u00fa\u010dtovn\u00edkov, ekon\u00f3mov, finan\u010dn\u00fdch analytikov, pracovn\u00edkov reportingu, projektov\u00fdch mana\u017e\u00e9rov, podnikate\u013eov a \u010fal\u0161\u00edch pou\u017e\u00edvate\u013eov, ktor\u00ed chc\u00fa vyu\u017e\u00edva\u0165 Microsoft Excel pri spracovan\u00ed finan\u010dn\u00fdch \u00fadajov, tvorbe rozpo\u010dtov, controllingu a mana\u017e\u00e9rskom rozhodovan\u00ed. Nau\u010d\u00edte sa pracova\u0165 s finan\u010dn\u00fdmi a \u00fa\u010dtovn\u00fdmi funkciami, fakt\u00farami, s\u00favahami, rozpo\u010dtami, finan\u010dn\u00fdmi ukazovate\u013emi, n\u00e1kladmi, v\u00fdnosmi, KPI a analytick\u00fdmi n\u00e1strojmi.\r\n\r\nV kurze <strong><a href=\"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-financie-a-financne-funkcie\/\">Microsoft Excel \u2013 Financie a Finan\u010dn\u00e9 Funkcie<\/a><\/strong> sa nau\u010d\u00edte vyu\u017e\u00edva\u0165 Excel pri finan\u010dnej anal\u00fdze a spracovan\u00ed firemn\u00fdch \u00fadajov. Kurz zah\u0155\u0148a tvorbu firemn\u00fdch rozpo\u010dtov, na\u010d\u00edtanie \u00fadajov z Finstatu a webov\u00fdch zdrojov, pr\u00e1cu so vzorcami a finan\u010dn\u00fdmi funkciami, fakt\u00farami a da\u0148ov\u00fdmi dokladmi, \u00fa\u010dtovnou s\u00favahou a grafmi. Osvoj\u00edte si aj postupy na vyhodnocovanie efekt\u00edvnosti podnikov\u00fdch a investi\u010dn\u00fdch projektov.\r\n\r\nNa \u00fa\u010dtovn\u00edcke vyu\u017eitie Excelu sa podrobnej\u0161ie zameriava <strong><a href=\"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-uctovne-a-financne-funkcie\/\">Microsoft Excel \u2013 \u00da\u010dtovn\u00e9 a Finan\u010dn\u00e9 Funkcie<\/a><\/strong>. Nau\u010d\u00edte sa spracov\u00e1va\u0165 d\u00e1tov\u00e9 tabu\u013eky, pou\u017e\u00edva\u0165 funkcie SUBTOTAL, AGGREGATE a SUMPRODUCT, vytv\u00e1ra\u0165 kontingen\u010dn\u00e9 tabu\u013eky, fakt\u00fary, da\u0148ov\u00e9 doklady a \u010dasov\u00e9 v\u00fdkazy a pracova\u0165 s \u00fa\u010dtovnou s\u00favahou. Kurz zah\u0155\u0148a aj finan\u010dn\u00e9 a \u00fa\u010dtovn\u00e9 v\u00fdpo\u010dty, rozpo\u010dty, grafy a praktick\u00e9 spracovanie podnikov\u00fdch finan\u010dn\u00fdch \u00fadajov.\r\n\r\nPre controlling, reporting a finan\u010dn\u00e9 pl\u00e1novanie je ur\u010den\u00fd <strong><a href=\"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-controllerov\/\">Microsoft Excel pre Controllerov<\/a><\/strong>. Kurz vysvet\u013euje finan\u010dn\u00fd, procesn\u00fd a marketingov\u00fd controlling, met\u00f3du ABC (Activity Based Costing) a vyu\u017eitie Excelu pri kontrole n\u00e1kladov, v\u00fdnosov a pl\u00e1nov. Nau\u010d\u00edte sa pracova\u0165 s filtrami, \u010d\u00edseln\u00edkmi, funkciami VLOOKUP, HLOOKUP a LOOKUP, identifikova\u0165 jedine\u010dn\u00e9 a duplicitn\u00e9 hodnoty, importova\u0165 d\u00e1ta z Accessu a SQL Servera, vytv\u00e1ra\u0165 rozpo\u010dty a prep\u00e1ja\u0165 Excel s PowerPivotom a Microsoft Power BI.\r\n\r\nFinan\u010dn\u00e9 rozhodovanie a controlling roz\u0161iruje <strong><a href=\"https:\/\/www.vita.sk\/online-kurz-manazerske-uctovnictvo\/\">Mana\u017e\u00e9rske \u00da\u010dtovn\u00edctvo<\/a><\/strong>. Kurz sa venuje anal\u00fdze n\u00e1kladov, v\u00fdnosov a ziskovosti, fixn\u00fdm a variabiln\u00fdm n\u00e1kladom, kalkul\u00e1ci\u00e1m, firemn\u00fdm rozpo\u010dtom a pr\u00edprave finan\u010dn\u00fdch podkladov pre mana\u017ement. Nau\u010d\u00edte sa pou\u017e\u00edva\u0165 Microsoft Excel a Power BI pri finan\u010dnej anal\u00fdze, pracova\u0165 s KPI, spracov\u00e1va\u0165 \u00fadaje z Finstatu a pripravova\u0165 podklady pre rozhodovanie o cen\u00e1ch, invest\u00edci\u00e1ch a kapacit\u00e1ch.\r\n\r\nMicrosoft Excel patr\u00ed medzi z\u00e1kladn\u00e9 n\u00e1stroje finan\u010dn\u00fdch oddelen\u00ed, \u00fa\u010dtovn\u00edkov, controllerov a analytikov. Vyu\u017e\u00edva sa pri pl\u00e1novan\u00ed rozpo\u010dtov, porovn\u00e1van\u00ed pl\u00e1nu a skuto\u010dnosti, anal\u00fdze n\u00e1kladov a v\u00fdnosov, reportingu, tvorbe finan\u010dn\u00fdch modelov, kontrole \u00fa\u010dtovn\u00fdch \u00fadajov a pr\u00edprave podkladov pre mana\u017e\u00e9rske rozhodovanie. Online kurzy Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling v\u00e1m pom\u00f4\u017eu prepoji\u0165 praktick\u00e9 znalosti Excelu s finan\u010dnou anal\u00fdzou, \u00fa\u010dtovn\u00edctvom, controllingom a reportingom.","link":"https:\/\/www.vita.sk\/en\/online-kurzy-excel-financie-uctovnictvo-controlling\/","name":"Microsoft Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling","slug":"online-kurzy-excel-financie-uctovnictvo-controlling","taxonomy":"product_cat","parent":66,"meta":[],"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>Microsoft Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling | VITA<\/title>\n<meta name=\"description\" content=\"Online kurzy Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling v\u00e1s nau\u010dia rozpo\u010dty, finan\u010dn\u00e9 funkcie, \u00fa\u010dtovn\u00edctvo, reporting, KPI a controlling. \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-kurzy-excel-financie-uctovnictvo-controlling\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling arch\u00edvy\" \/>\n<meta property=\"og:description\" content=\"Online kurzy Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling v\u00e1s nau\u010dia rozpo\u010dty, finan\u010dn\u00e9 funkcie, \u00fa\u010dtovn\u00edctvo, reporting, KPI a controlling. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/\" \/>\n<meta property=\"og:site_name\" content=\"VITA\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t    \"@context\": \"https:\/\/schema.org\",\n\t    \"@graph\": [\n\t        {\n\t            \"@type\": \"CollectionPage\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/\",\n\t            \"url\": \"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/\",\n\t            \"name\": \"Microsoft Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling | VITA\",\n\t            \"isPartOf\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/#website\"\n\t            },\n\t            \"description\": \"Online kurzy Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling v\u00e1s nau\u010dia rozpo\u010dty, finan\u010dn\u00e9 funkcie, \u00fa\u010dtovn\u00edctvo, reporting, KPI a controlling. \u2705\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"en-US\"\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/#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\/en\/\"\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\": \"Kancel\u00e1rske Bal\u00edky (Microsoft Office)\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/online-kurzy-kancelarske-baliky\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 4,\n\t                    \"name\": \"Microsoft Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling\"\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\",\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\": \"en-US\"\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":"Microsoft Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling | VITA","description":"Online kurzy Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling v\u00e1s nau\u010dia rozpo\u010dty, finan\u010dn\u00e9 funkcie, \u00fa\u010dtovn\u00edctvo, reporting, KPI a controlling. \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-kurzy-excel-financie-uctovnictvo-controlling\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling arch\u00edvy","og_description":"Online kurzy Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling v\u00e1s nau\u010dia rozpo\u010dty, finan\u010dn\u00e9 funkcie, \u00fa\u010dtovn\u00edctvo, reporting, KPI a controlling. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/","og_site_name":"VITA","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"CollectionPage","@id":"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/","url":"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/","name":"Microsoft Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"description":"Online kurzy Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling v\u00e1s nau\u010dia rozpo\u010dty, finan\u010dn\u00e9 funkcie, \u00fa\u010dtovn\u00edctvo, reporting, KPI a controlling. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/#breadcrumb"},"inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurzy-excel-financie-uctovnictvo-controlling\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"VITA Academy","item":"https:\/\/www.vita.sk\/en\/"},{"@type":"ListItem","position":2,"name":"Shop","item":"https:\/\/www.vita.sk\/shop\/"},{"@type":"ListItem","position":3,"name":"Kancel\u00e1rske Bal\u00edky (Microsoft Office)","item":"https:\/\/www.vita.sk\/online-kurzy-kancelarske-baliky\/"},{"@type":"ListItem","position":4,"name":"Microsoft Excel pre Financie, \u00da\u010dtovn\u00edctvo a Controlling"}]},{"@type":"WebSite","@id":"https:\/\/www.vita.sk\/#website","url":"https:\/\/www.vita.sk\/","name":"VITA","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":"en-US"},{"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\/en\/wp-json\/wp\/v2\/product_cat\/1044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_cat"}],"about":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/taxonomies\/product_cat"}],"up":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_cat\/66"}],"wp:post_type":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product?product_cat=1044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}