{"id":5689,"date":"2018-04-19T14:24:46","date_gmt":"2018-04-19T12:24:46","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=5689"},"modified":"2023-06-13T20:53:00","modified_gmt":"2023-06-13T18:53:00","slug":"skoleni-excel-vba-zaklady-programovani","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/skoleni-excel-vba-zaklady-programovani\/","title":{"rendered":"Training Excel VBA basics"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5689\" class=\"elementor elementor-5689\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-675d1cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"675d1cc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-narrow\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1af1cbc\" data-id=\"1af1cbc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-216748b elementor-position-left elementor-vertical-align-top elementor-widget elementor-widget-image-box\" data-id=\"216748b\" data-element_type=\"widget\" data-widget_type=\"image-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div class=\"elementor-image-box-wrapper\"><figure class=\"elementor-image-box-img\"><img decoding=\"async\" width=\"86\" height=\"95\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2010\/01\/ex.jpg\" class=\"attachment-full size-full wp-image-413\" alt=\"\" title=\"\"><\/figure><div class=\"elementor-image-box-content\"><div class=\"elementor-image-box-title\">Training description<\/div><p class=\"elementor-image-box-description\">At this training you will learn about concepts such as procedure, method, variable or function, and you will gradually learn the principles for automating Excel activities. In the examples we will show how the conditions and cycles work, what objects are and how to use them. We will prepare user messages or dialogs. Participants will receive free training materials with exercises and a description of how to elaborate tasks.<\/p><\/div><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77943c9 elementor-widget elementor-widget-image\" data-id=\"77943c9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.umimexcel.cz\/online-kurzy\/excel\/excel-vba-makra-zaklady-programovani\/\" target=\"_blank\" rel=\"noopener\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"600\" height=\"85\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2017\/11\/online_kurz.png\" class=\"attachment-full size-full wp-image-5329\" alt=\"Online kurzy Microsoft Office\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2017\/11\/online_kurz.png 600w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2017\/11\/online_kurz-300x43.png 300w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2017\/11\/online_kurz-24x3.png 24w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2017\/11\/online_kurz-36x5.png 36w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2017\/11\/online_kurz-48x7.png 48w\" sizes=\"(max-width: 600px) 100vw, 600px\" title=\"\">\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ae426f9 elementor-widget elementor-widget-text-editor\" data-id=\"ae426f9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p><\/p>\n<h2>Modul EXCEL9<\/h2>\n<ul>\n<li>Recording macros (absolute vs. relative macro, keyboard shortcuts, go to &#8211; special)<\/li>\n<li>Object-oriented approach (Objects WorkSheet, WorkBook, Range, Collection)<\/li>\n<li>Variables, constants, data types and their definitions<\/li>\n<li>Properties and methods<\/li>\n<li>Conditions and cycles (If,&nbsp;Do while,&nbsp;For,&nbsp;For each,&nbsp;Select Case)<\/li>\n<li>Messages and dialogs (MsgBox,&nbsp;InputBox)<\/li>\n<li>Abbreviated writing and code checking<\/li>\n<li>Using ChatGPT for programming<\/li>\n<\/ul>\n<p><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Training description At this training you will learn about concepts such as procedure, method, variable or function, and you will gradually learn the principles for automating Excel activities. In the examples we will show how the conditions and cycles work, what objects are and how to use them. We will prepare user messages or dialogs. [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":413,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3,9],"tags":[10,71],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/5689"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=5689"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/5689\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/413"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=5689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=5689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=5689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}