{"id":4788,"date":"2021-03-07T14:16:01","date_gmt":"2021-03-07T13:16:01","guid":{"rendered":"https:\/\/www.vita.sk\/?post_type=product&#038;p=4788"},"modified":"2025-12-02T21:06:14","modified_gmt":"2025-12-02T20:06:14","slug":"online-kurz-microsoft-excel-pre-analytikov","status":"publish","type":"product","link":"https:\/\/www.vita.sk\/en\/online-kurz-microsoft-excel-pre-analytikov\/","title":{"rendered":"Online kurz Microsoft Excel pre Analytikov"},"content":{"rendered":"<p>Microsoft Excel pre Analytikov pre v\u00e1s ide\u00e1lny, ak sa chcete nau\u010di\u0165 spracov\u00e1va\u0165 a analyzova\u0165 \u00fadaje pomocou pokro\u010dil\u00fdch analytick\u00fdch n\u00e1strojov priamo v prostred\u00ed Excelu. <strong>Ide o akreditovan\u00fd a certifikovan\u00fd online kurz na Microsoft Excel pre Analytikov.<\/strong> Kurz v\u00e1s prevedie \u0161irokou \u0161k\u00e1lou analytick\u00fdch techn\u00edk, ktor\u00e9 vyu\u017eijete v praxi pri d\u00e1tovej anal\u00fdze, vizualiz\u00e1cii trendov, \u0161tatistickom spracovan\u00ed a optimaliza\u010dn\u00fdch v\u00fdpo\u010dtoch. Nau\u010d\u00edte sa, ako vytv\u00e1ra\u0165 regresn\u00e9 modely a progn\u00f3zy pomocou funkcie LINEST, analyzova\u0165 korel\u00e1cie medzi premenn\u00fdmi \u010di pou\u017ei\u0165 jednofaktorov\u00fa anal\u00fdzu ANOVA na porovnanie skup\u00edn. Osvoj\u00edte si pr\u00e1cu s n\u00e1strojmi Rie\u0161ite\u013e (Solver) a H\u013eadanie Rie\u0161enia, ktor\u00e9 umo\u017e\u0148uj\u00fa optimalizova\u0165 v\u00fdsledky a pl\u00e1nova\u0165 scen\u00e1re v\u00fdvoja. D\u00f4le\u017eitou s\u00fa\u010das\u0165ou kurzu je doplnok Data Analysis ToolPak, s ktor\u00fdm sa nau\u010d\u00edte realizova\u0165 regresn\u00e9 modely a trendov\u00e9 anal\u00fdzy. Dozviete sa tie\u017e, ako konsolidova\u0165 \u00fadaje z viacer\u00fdch h\u00e1rkov a efekt\u00edvne ich zl\u00fa\u010di\u0165 do jedn\u00e9ho v\u00fdstupu. V oblasti spr\u00e1vy d\u00e1t sa nau\u010d\u00edte pou\u017e\u00edva\u0165 kontingen\u010dn\u00e9 tabu\u013eky, medzis\u00fa\u010dty, triedenie, filtre, pr\u00e1cu s ve\u013ek\u00fdm mno\u017estvom \u00fadajov, n\u00e1hodn\u00e9 \u010d\u00edslovanie a pokro\u010dil\u00e9 mo\u017enosti nastavenia vidite\u013enosti buniek pomocou stavu veryhidden. Z\u00edskate zru\u010dnosti v SQL pr\u00edkazoch priamo v Exceli \u2013 nau\u010d\u00edte sa pou\u017e\u00edva\u0165 pr\u00edkazy SELECT, WHERE, GROUP BY, ORDER, LIKE, LIMIT a ich kombin\u00e1cie na na\u010d\u00edtanie a transform\u00e1ciu d\u00e1t. Spozn\u00e1te rozdiel medzi klasick\u00fdmi XLSX s\u00fabormi a efekt\u00edvnej\u0161\u00edm form\u00e1tom XLSB, ktor\u00fd umo\u017e\u0148uje r\u00fdchlej\u0161ie na\u010d\u00edtavanie ve\u013ek\u00fdch datasetov. S\u00fa\u010das\u0165ou kurzu s\u00fa aj praktick\u00e9 uk\u00e1\u017eky pr\u00e1ce s korel\u00e1ciou a regresiou v IBM SPSS, ktor\u00e9 dop\u013a\u0148aj\u00fa pochopenie \u0161tatistickej anal\u00fdzy mimo Excelu. Z\u00e1ver kurzu tvor\u00ed miniprojekt, kde vytvor\u00edte zoznam kurzov, pou\u017eijete filtre, viacero h\u00e1rkov, tabu\u013eky a prep\u00e1janie \u00fadajov, \u010d\u00edm si upevn\u00edte z\u00edskan\u00e9 vedomosti. Tento kurz je vhodn\u00ed pre d\u00e1tov\u00fdch analytikov, ekon\u00f3mov, v\u00fdskumn\u00edkov, \u0161tudentov \u010di profesion\u00e1lov v oblasti controllingu a reportingov\u00fdch t\u00edmov, ktor\u00ed potrebuj\u00fa posun\u00fa\u0165 svoje znalosti Excelu na vy\u0161\u0161iu \u00farove\u0148 a pracova\u0165 s re\u00e1lnymi d\u00e1tov\u00fdmi \u00falohami. Ak sa chcete skuto\u010dne nau\u010di\u0165 pou\u017e\u00edva\u0165 Microsoft Excel a pracova\u0165 ako analytik, tak toto je ide\u00e1lny online kurz pre v\u00e1s.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Online kurz Microsoft Excel pre Analytikov v\u00e1s nau\u010d\u00ed pracova\u0165 s pokro\u010dil\u00fdmi analytick\u00fdmi n\u00e1strojmi, funkciami a technikami, ktor\u00e9 s\u00fa nevyhnutn\u00e9 na profesion\u00e1lnu pr\u00edpravu d\u00e1t, tvorbu preh\u013eadov a spr\u00e1vne rozhodovanie. Kurz je ur\u010den\u00fd pre v\u0161etk\u00fdch, ktor\u00ed chc\u00fa zvl\u00e1dnu\u0165 n\u00e1ro\u010dnej\u0161iu pr\u00e1cu s anal\u00fdzou d\u00e1t v ka\u017edodennej praxi.","protected":false},"author":4,"featured_media":4360,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[67,66,73],"product_tag":[187,198],"class_list":{"0":"post-4788","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-online-kurzy-microsoft-excel","7":"product_cat-online-kurzy-kancelarske-baliky","8":"product_cat-bez-kategorie","9":"product_tag-kancelarske-baliky","10":"product_tag-excel","12":"first","13":"instock","14":"sale","15":"sold-individually","16":"taxable","17":"shipping-taxable","18":"purchasable","19":"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>Online kurz Microsoft Excel pre Analytikov 2026 | VITA<\/title>\n<meta name=\"description\" content=\"V online kurze Microsoft Excel pre Analytikov v\u00e1s nau\u010d\u00edme spracov\u00e1va\u0165 d\u00e1ta a realizova\u0165 nad nimi \u0161tatistick\u00e9 a analytick\u00e9 \u00falohy. \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-microsoft-excel-pre-analytikov\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online kurz Microsoft Excel pre Analytikov\" \/>\n<meta property=\"og:description\" content=\"V online kurze Microsoft Excel pre Analytikov v\u00e1s nau\u010d\u00edme spracov\u00e1va\u0165 d\u00e1ta a realizova\u0165 nad nimi \u0161tatistick\u00e9 a analytick\u00e9 \u00falohy. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/\" \/>\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=\"2025-12-02T20:06:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz_excel-pre-analytikov.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=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\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-microsoft-excel-pre-analytikov\/\",\n\t            \"url\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/\",\n\t            \"name\": \"Online kurz Microsoft Excel pre Analytikov {Y} | 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-microsoft-excel-pre-analytikov\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz_excel-pre-analytikov.png\",\n\t            \"datePublished\": \"2021-03-07T13:16:01+00:00\",\n\t            \"dateModified\": \"2025-12-02T20:06:14+00:00\",\n\t            \"description\": \"V online kurze Microsoft Excel pre Analytikov v\u00e1s nau\u010d\u00edme spracov\u00e1va\u0165 d\u00e1ta a realizova\u0165 nad nimi \u0161tatistick\u00e9 a analytick\u00e9 \u00falohy. \u2705\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/#breadcrumb\"\n\t            },\n\t            \"inLanguage\": \"en-US\",\n\t            \"potentialAction\": [\n\t                {\n\t                    \"@type\": \"ReadAction\",\n\t                    \"target\": [\n\t                        \"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/\"\n\t                    ]\n\t                }\n\t            ]\n\t        },\n\t        {\n\t            \"@type\": \"ImageObject\",\n\t            \"inLanguage\": \"en-US\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/#primaryimage\",\n\t            \"url\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz_excel-pre-analytikov.png\",\n\t            \"contentUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz_excel-pre-analytikov.png\",\n\t            \"width\": 360,\n\t            \"height\": 360,\n\t            \"caption\": \"Online kurz Excel pre Analytikov\"\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/#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\",\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\",\n\t                    \"item\": \"https:\/\/www.vita.sk\/online-kurzy-microsoft-excel\/\"\n\t                },\n\t                {\n\t                    \"@type\": \"ListItem\",\n\t                    \"position\": 5,\n\t                    \"name\": \"Online kurz Microsoft Excel pre Analytikov\"\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":"Online kurz Microsoft Excel pre Analytikov 2026 | VITA","description":"V online kurze Microsoft Excel pre Analytikov v\u00e1s nau\u010d\u00edme spracov\u00e1va\u0165 d\u00e1ta a realizova\u0165 nad nimi \u0161tatistick\u00e9 a analytick\u00e9 \u00falohy. \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-microsoft-excel-pre-analytikov\/","og_locale":"en_US","og_type":"article","og_title":"Online kurz Microsoft Excel pre Analytikov","og_description":"V online kurze Microsoft Excel pre Analytikov v\u00e1s nau\u010d\u00edme spracov\u00e1va\u0165 d\u00e1ta a realizova\u0165 nad nimi \u0161tatistick\u00e9 a analytick\u00e9 \u00falohy. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/","og_site_name":"VITA","article_publisher":"https:\/\/www.facebook.com\/VitaAcademySK","article_modified_time":"2025-12-02T20:06:14+00:00","og_image":[{"width":360,"height":360,"url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz_excel-pre-analytikov.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/","url":"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/","name":"Online kurz Microsoft Excel pre Analytikov {Y} | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/#primaryimage"},"image":{"@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz_excel-pre-analytikov.png","datePublished":"2021-03-07T13:16:01+00:00","dateModified":"2025-12-02T20:06:14+00:00","description":"V online kurze Microsoft Excel pre Analytikov v\u00e1s nau\u010d\u00edme spracov\u00e1va\u0165 d\u00e1ta a realizova\u0165 nad nimi \u0161tatistick\u00e9 a analytick\u00e9 \u00falohy. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/#primaryimage","url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz_excel-pre-analytikov.png","contentUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2020\/11\/kurz_excel-pre-analytikov.png","width":360,"height":360,"caption":"Online kurz Excel pre Analytikov"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurz-microsoft-excel-pre-analytikov\/#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","item":"https:\/\/www.vita.sk\/online-kurzy-kancelarske-baliky\/"},{"@type":"ListItem","position":4,"name":"Microsoft Excel","item":"https:\/\/www.vita.sk\/online-kurzy-microsoft-excel\/"},{"@type":"ListItem","position":5,"name":"Online kurz Microsoft Excel pre Analytikov"}]},{"@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\/4788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/types\/product"}],"author":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/comments?post=4788"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/media\/4360"}],"wp:attachment":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/media?parent=4788"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_brand?post=4788"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_cat?post=4788"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_tag?post=4788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}