{"id":239,"date":"2022-08-22T03:37:08","date_gmt":"2022-08-22T00:37:08","guid":{"rendered":"https:\/\/kompiuteriu-kursai.lt\/?p=239"},"modified":"2023-05-13T06:24:17","modified_gmt":"2023-05-13T03:24:17","slug":"ms-excel-eksperto-lygmens-kursai-pagal-microsoft-office-specialist-mos-sertifikavimo-programa","status":"publish","type":"post","link":"https:\/\/kompiuteriu-kursai.lt\/?p=239","title":{"rendered":"MS Excel: eksperto lygmuo pagal Microsoft Office Specialist (MOS) sertifikavimo program\u0105"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\" style=\"font-style:normal;font-weight:300\">| Kurs\u0173 trukm\u0117: 16 akad. val.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-style:normal;font-weight:300\">| Kurs\u0173 kaina: 175 Eur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Trumpas kurso apra\u0161ymas<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kursas skirtas pa\u017eengusiems Excel vartotojams, norintiems visapusi\u0161kai i\u0161naudoti MS Excel programos galimybes. Kurs\u0173 metu susipa\u017einsite su duomen\u0173 analize, duomen\u0173 apsauga, formuli\u0173 auditu, sud\u0117tingesn\u0117mis funkcijomis, makrokomand\u0173 k\u016brimu.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Reikalavimai kurso klausytojams<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Mok\u0117ti dirbti MS Excel programa arba b\u016bti i\u0161klausius MS Excel specialisto lygmens kurs\u0105.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kurso programa<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sud\u0117tingesnis duomen\u0173 formatavimas.\n<ul class=\"wp-block-list\">\n<li>Duomen\u0173 tvarkymas: pasirinktiniai duomen\u0173 formatai, klaiding\u0173 duomen\u0173 identifikavimas, s\u0105lyginis formatavimas.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Sud\u0117tingesni\u0173 formuli\u0173 ir funkcij\u0173 taikymas.\n<ul class=\"wp-block-list\">\n<li>Login\u0117s (IF, AND, OR, NOT) ir statistin\u0117s (SUMIFS, AVERAGEIFS ir COUNTIFS) funkcijos;<\/li>\n\n\n\n<li>Per\u017evalgos ir nuorod\u0173 funkcijos (VLOOKUP, HLOOKUP, LOOKUP, MATCH ir INDEX);<\/li>\n\n\n\n<li>Datos ir laiko funkcijos (TODAY, NOW, DATE, NETWORKDAYS);<\/li>\n\n\n\n<li>Vard\u0173 naudojimas;<\/li>\n\n\n\n<li>Klaid\u0173 taisymas formul\u0117se;<\/li>\n\n\n\n<li>\u201eKas b\u016bt\u0173 jei\u201c analiz\u0117s \u012franki\u0173 naudojimas (Goal Seak, Scenario manager).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Sud\u0117tingesni\u0173 diagram\u0173 k\u016brimas ir darbas su duomen\u0173 lentel\u0117mis.\n<ul class=\"wp-block-list\">\n<li>Nestandartini\u0173 diagram\u0173 naudojimas: dviej\u0173 a\u0161i\u0173 diagramos, diagram\u0173 \u0161ablonai, prognoz\u0117s linijos;<\/li>\n\n\n\n<li>Suvestin\u0117s lentel\u0117s (Pivot Table): suvestini\u0173 lenteli\u0173 k\u016brimas, suvestini\u0173 lenteli\u0173 lauk\u0173 tvarkymas, duomen\u0173 filtr\u0173 \u012fterpimas (Slicers), duomen\u0173 grupavimas, skai\u010diuojami laukai ir \u012fra\u0161ai;<\/li>\n\n\n\n<li>Suvestini\u0173 lenteli\u0173 diagramos (PivotChart).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Makro komandos k\u016brimas ir tvarkymas.\n<ul class=\"wp-block-list\">\n<li>Makrokomand\u0173 naudojimo nustatymai;<\/li>\n\n\n\n<li>Paprast\u0173 makrokomand\u0173 k\u016brimas;<\/li>\n\n\n\n<li>Makrokomand\u0173 redagavimas;<\/li>\n\n\n\n<li>Formos objekt\u0173 naudojimas.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Excel darbo knyg\u0173 nustatym\u0173 bei savybi\u0173 tvarkymas.\n<ul class=\"wp-block-list\">\n<li>MS Excel i\u0161vaizdos keitimas;<\/li>\n\n\n\n<li>Darbo knygos \u0161ablonai;<\/li>\n\n\n\n<li>Darbo knygos ir darbo lapo apsauga;<\/li>\n\n\n\n<li>Darbo knygos versij\u0173 valdymas;<\/li>\n\n\n\n<li>I\u0161orini\u0173 duomen\u0173 naudojimas: s\u0105sajos su kit\u0173 darbaknygi\u0173 duomenimis, duomen\u0173 konsolidacija, duomen\u0173 importavimas.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><a href=\"https:\/\/kompiuteriu-kursai.lt\/?page_id=165\"><strong>Artimiausia mokym\u0173 data ir registracija \u279d<\/strong><\/a><\/h6>\n","protected":false},"excerpt":{"rendered":"<p>| Kurs\u0173 trukm\u0117: 16 akad. val. | Kurs\u0173 kaina: 175 Eur. Trumpas kurso apra\u0161ymas Kursas skirtas pa\u017eengusiems Excel vartotojams, norintiems visapusi\u0161kai i\u0161naudoti MS Excel programos galimybes. Kurs\u0173 metu susipa\u017einsite su duomen\u0173 analize, duomen\u0173 apsauga, formuli\u0173 auditu, sud\u0117tingesn\u0117mis funkcijomis, makrokomand\u0173 k\u016brimu. Reikalavimai kurso klausytojams Mok\u0117ti dirbti MS Excel programa arba b\u016bti i\u0161klausius MS Excel specialisto lygmens [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[207,208,209,179,198,206,197,205,57,200,199],"class_list":["post-239","post","type-post","status-publish","format-standard","hentry","category-kursai","tag-duomenu-analize","tag-duomenu-apsauga","tag-formuliu-auditas","tag-makrokomandos","tag-microsoft-excel","tag-microsoft-office-specialist","tag-ms-excel","tag-ms-excel-eksperto-lygmuo","tag-ms-excel-expert","tag-ms-excel-kursai","tag-ms-excel-mokymai"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/239","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=239"}],"version-history":[{"count":11,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions"}],"predecessor-version":[{"id":3491,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions\/3491"}],"wp:attachment":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}