{"id":12169,"date":"2023-05-03T09:40:04","date_gmt":"2023-05-03T07:40:04","guid":{"rendered":"https:\/\/www.vita.sk\/?post_type=product&#038;p=12169"},"modified":"2024-10-07T19:10:06","modified_gmt":"2024-10-07T17:10:06","slug":"online-kurz-vba-automatizacia-ii-mierne-pokrocily","status":"publish","type":"product","link":"https:\/\/www.vita.sk\/en\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/","title":{"rendered":"Online kurz VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd"},"content":{"rendered":"<p>Online kurz VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd VBA je pre v\u00e1s ide\u00e1lny, ak sa chcete nau\u010di\u0165 programovac\u00ed jazyk VBA (Visual Basic for Applications), ktor\u00fd vyvinula firma Microsoft pre svoj kancel\u00e1rsky bal\u00edk Microsoft Office. <strong>Ide o jedin\u00fd akreditovan\u00fd a certifikovan\u00fd online kurz na VBA na Slovensku. <\/strong>Uk\u00e1\u017eeme si form\u00e1tovanie tabuliek, buniek, tvorbu fakt\u00far, objedn\u00e1vok. Pou\u017e\u00edvanie vzorcov a v\u00fdpo\u010dtov priamo vo VBA vr\u00e1tane r\u00f4znych udalosti bude pre v\u00e1s samozrejmos\u0165ou. Nau\u010d\u00edme sa analyzova\u0165 a \u010disti\u0165 d\u00e1ta priamo v Excel h\u00e1rkoch a s\u00faboroch. Te\u0161i\u0165 sa m\u00f4\u017eete na pou\u017e\u00edvanie enumer\u00e1ci\u00ed a kon\u0161t\u00e1nt pre efekt\u00edvnej\u0161ie ukladanie d\u00e1t. Vytvor\u00edme si pou\u017e\u00edvate\u013esky pr\u00edvetiv\u00e9 formul\u00e1re s interakt\u00edvnymi ovl\u00e1dac\u00edmi prvkami a vyu\u017eijeme aj podmienen\u00e9 form\u00e1tovanie. Ak sa skuto\u010dne chcete nau\u010di\u0165 programova\u0165 a automatizova\u0165 vo VBA, tak toto je ide\u00e1lny online kurz pre v\u00e1s.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Online kurz VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd VBA je pre v\u00e1s ide\u00e1lny, ak sa chcete nau\u010di\u0165 programovac\u00ed jazyk VBA (Visual Basic for Applications), ktor\u00fd vyvinula firma Microsoft pre svoj kancel\u00e1rsky bal\u00edk Microsoft Office. Ide o jedin\u00fd akreditovan\u00fd a certifikovan\u00fd online kurz na VBA na Slovensku. Uk\u00e1\u017eeme si form\u00e1tovanie tabuliek, buniek, tvorbu fakt\u00far, objedn\u00e1vok.","protected":false},"author":4,"featured_media":585,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[67,66,99,110,73],"product_tag":[187,189],"class_list":{"0":"post-12169","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-online-kurzy-programovacie-jazyky","9":"product_cat-online-kurzy-visual-basic","10":"product_cat-bez-kategorie","11":"product_tag-kancelarske-baliky","12":"product_tag-programovacie-jazyky","14":"first","15":"instock","16":"sale","17":"sold-individually","18":"taxable","19":"shipping-taxable","20":"purchasable","21":"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 VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd  | VITA<\/title>\n<meta name=\"description\" content=\"V online kurze VBA Automatiz\u00e1cia II. Mierne pokro\u010dil\u00fd sa nau\u010d\u00edte pokro\u010dil\u00e9 techniky automatiz\u00e1cie \u00faloh v Exceli pomocou jazyka VBA. \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-vba-automatizacia-ii-mierne-pokrocily\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online kurz VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd\" \/>\n<meta property=\"og:description\" content=\"V online kurze VBA Automatiz\u00e1cia II. Mierne pokro\u010dil\u00fd sa nau\u010d\u00edte pokro\u010dil\u00e9 techniky automatiz\u00e1cie \u00faloh v Exceli pomocou jazyka VBA. \u2705\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/\" \/>\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=\"2024-10-07T17:10:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/kurz-VBA.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=\"1 minute\" \/>\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-vba-automatizacia-ii-mierne-pokrocily\/\",\n\t            \"url\": \"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/\",\n\t            \"name\": \"Online kurz VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd 2024 | 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-vba-automatizacia-ii-mierne-pokrocily\/#primaryimage\"\n\t            },\n\t            \"image\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/#primaryimage\"\n\t            },\n\t            \"thumbnailUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/kurz-VBA.png\",\n\t            \"datePublished\": \"2023-05-03T07:40:04+00:00\",\n\t            \"dateModified\": \"2024-10-07T17:10:06+00:00\",\n\t            \"description\": \"V online kurze VBA Automatiz\u00e1cia II. Mierne pokro\u010dil\u00fd sa nau\u010d\u00edte pokro\u010dil\u00e9 techniky automatiz\u00e1cie \u00faloh v Exceli pomocou jazyka VBA. \u2705\",\n\t            \"breadcrumb\": {\n\t                \"@id\": \"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/#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-vba-automatizacia-ii-mierne-pokrocily\/\"\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-vba-automatizacia-ii-mierne-pokrocily\/#primaryimage\",\n\t            \"url\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/kurz-VBA.png\",\n\t            \"contentUrl\": \"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/kurz-VBA.png\",\n\t            \"width\": 360,\n\t            \"height\": 360,\n\t            \"caption\": \"Online kurz VBA\"\n\t        },\n\t        {\n\t            \"@type\": \"BreadcrumbList\",\n\t            \"@id\": \"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/#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 VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd\"\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 VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd  | VITA","description":"V online kurze VBA Automatiz\u00e1cia II. Mierne pokro\u010dil\u00fd sa nau\u010d\u00edte pokro\u010dil\u00e9 techniky automatiz\u00e1cie \u00faloh v Exceli pomocou jazyka VBA. \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-vba-automatizacia-ii-mierne-pokrocily\/","og_locale":"en_US","og_type":"article","og_title":"Online kurz VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd","og_description":"V online kurze VBA Automatiz\u00e1cia II. Mierne pokro\u010dil\u00fd sa nau\u010d\u00edte pokro\u010dil\u00e9 techniky automatiz\u00e1cie \u00faloh v Exceli pomocou jazyka VBA. \u2705","og_url":"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/","og_site_name":"VITA","article_publisher":"https:\/\/www.facebook.com\/VitaAcademySK","article_modified_time":"2024-10-07T17:10:06+00:00","og_image":[{"width":360,"height":360,"url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/kurz-VBA.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/","url":"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/","name":"Online kurz VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd 2024 | VITA","isPartOf":{"@id":"https:\/\/www.vita.sk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/#primaryimage"},"image":{"@id":"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/kurz-VBA.png","datePublished":"2023-05-03T07:40:04+00:00","dateModified":"2024-10-07T17:10:06+00:00","description":"V online kurze VBA Automatiz\u00e1cia II. Mierne pokro\u010dil\u00fd sa nau\u010d\u00edte pokro\u010dil\u00e9 techniky automatiz\u00e1cie \u00faloh v Exceli pomocou jazyka VBA. \u2705","breadcrumb":{"@id":"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/#primaryimage","url":"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/kurz-VBA.png","contentUrl":"https:\/\/www.vita.sk\/wp-content\/uploads\/2018\/10\/kurz-VBA.png","width":360,"height":360,"caption":"Online kurz VBA"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vita.sk\/online-kurz-vba-automatizacia-ii-mierne-pokrocily\/#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 VBA Automatiz\u00e1cia II. Mierne Pokro\u010dil\u00fd"}]},{"@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\/12169","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=12169"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/media\/585"}],"wp:attachment":[{"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/media?parent=12169"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_brand?post=12169"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_cat?post=12169"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.vita.sk\/en\/wp-json\/wp\/v2\/product_tag?post=12169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}