{"id":212,"date":"2022-08-22T03:20:17","date_gmt":"2022-08-22T00:20:17","guid":{"rendered":"https:\/\/kompiuteriu-kursai.lt\/?p=212"},"modified":"2024-09-06T15:35:44","modified_gmt":"2024-09-06T12:35:44","slug":"ms-excel-makrokomandos-ir-vba","status":"publish","type":"post","link":"https:\/\/kompiuteriu-kursai.lt\/?p=212","title":{"rendered":"MS Excel: makrokomandos ir VBA"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Seminar\u0173 ciklas \u201eMS Excel programos naudojimo galimyb\u0117s vadybos ir finans\u0173 srityse&#8221;<\/h3>\n\n\n\n<p style=\"font-style:normal;font-weight:300\"><br>| Seminaro trukm\u0117: 8 akad. val.<\/p>\n\n\n\n<p style=\"font-style:normal;font-weight:300\">| Seminaro kaina: 145 Eur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Trumpas seminaro apra\u0161ymas<\/h2>\n\n\n\n<p>Seminaras skirtas daug dirbantiems MS Excel programa, atliekantiems daug pasikartojan\u010di\u0173 u\u017eduo\u010di\u0173 ir norintiems i\u0161mokti automatizuoti savo darb\u0105. Mokym\u0173 metu i\u0161moksite ne tik kurti makrokomandas, bet ir \u012fgysite pradini\u0173 Visual Basic for Applications programavimo \u012fg\u016bd\u017ei\u0173, leid\u017eian\u010di\u0173 atlikti sud\u0117tingesnes automatizavimo u\u017eduotis. \u012esitikinsite, kad kartais keli\u0173 valand\u0173 darb\u0105 galima atlikti vieno mygtuko paspaudimu.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Seminaro programa<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">1. Makrokomandos paskirtis ir nustatymai.<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">2. Darbas su makrokomandomis:<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u012era\u0161ymas.<\/li>\n\n\n\n<li>Vykdymas.<\/li>\n\n\n\n<li>Priskyrimas mygtukui arba grafikos valdikliui.<\/li>\n\n\n\n<li>Redagavimas ir trikd\u017ei\u0173 \u0161alinimas.<\/li>\n\n\n\n<li>Saugojimo vietos, eksportavimas ir importavimas.<\/li>\n\n\n\n<li>Naikinimas.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">3. Makrokomand\u0173 saugumo parametr\u0173 keitimas.<\/h4>\n\n\n\n<h4 class=\"wp-block-heading\">4. Makrokomandos k\u016brimas naudojantis Microsoft Visual Basic.<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>VBA redaktoriaus strukt\u016bra.<\/li>\n\n\n\n<li>Funkcij\u0173 ir proced\u016br\u0173 vykdymas redaktoriuje.<\/li>\n\n\n\n<li>Kintamieji.<\/li>\n\n\n\n<li>Programavimo prad\u017eiamokslis.\n<ul class=\"wp-block-list\">\n<li>S\u0105lyginis sakinys (IF)<\/li>\n\n\n\n<li>Ciklai (For, While)<\/li>\n\n\n\n<li>Bendravimo su vartotoju priemon\u0117s (Msgbox, Input Method)<\/li>\n\n\n\n<li>Populiarios VBA funkcijos&nbsp;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Vartotojo funkcijos (User Defined Function)<\/li>\n\n\n\n<li>Excel objektai ir \u012fvykiai ( Excel Objects and Events ).<\/li>\n<\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong><a href=\"https:\/\/kompiuteriu-kursai.lt\/?p=2439\" title=\"\">Registracija \u279d<\/a><\/strong><\/h6>\n","protected":false},"excerpt":{"rendered":"<p>Seminar\u0173 ciklas \u201eMS Excel programos naudojimo galimyb\u0117s vadybos ir finans\u0173 srityse&#8221; | Seminaro trukm\u0117: 8 akad. val. | Seminaro kaina: 145 Eur. Trumpas seminaro apra\u0161ymas Seminaras skirtas daug dirbantiems MS Excel programa, atliekantiems daug pasikartojan\u010di\u0173 u\u017eduo\u010di\u0173 ir norintiems i\u0161mokti automatizuoti savo darb\u0105. Mokym\u0173 metu i\u0161moksite ne tik kurti makrokomandas, bet ir \u012fgysite pradini\u0173 Visual Basic [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[179,198,197,200,199,231,196],"class_list":["post-212","post","type-post","status-publish","format-standard","hentry","category-seminarai","tag-makrokomandos","tag-microsoft-excel","tag-ms-excel","tag-ms-excel-kursai","tag-ms-excel-mokymai","tag-ms-excel-seminaras","tag-visual-basic-for-applications"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=212"}],"version-history":[{"count":12,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/212\/revisions"}],"predecessor-version":[{"id":4602,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/212\/revisions\/4602"}],"wp:attachment":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}