{"id":225,"date":"2022-08-22T03:30:47","date_gmt":"2022-08-22T00:30:47","guid":{"rendered":"https:\/\/kompiuteriu-kursai.lt\/?p=225"},"modified":"2023-10-27T20:18:40","modified_gmt":"2023-10-27T17:18:40","slug":"ms-excel-specialisto-lygmens-kursai-pagal-microsoft-office-specialist-mos-sertifikavimo-programa","status":"publish","type":"post","link":"https:\/\/kompiuteriu-kursai.lt\/?p=225","title":{"rendered":"MS Excel: specialisto lygmuo pagal Microsoft Office Specialist (MOS) sertifikavimo program\u0105"},"content":{"rendered":"\n<p style=\"font-style:normal;font-weight:300\">| Kurs\u0173 trukm\u0117: 16 akad. val.<\/p>\n\n\n\n<p style=\"font-style:normal;font-weight:300\">| Kurs\u0173 kaina: 145 Eur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Trumpas kurso apra\u0161ymas<\/h2>\n\n\n\n<p>Kursas skirtas visiems, norintiems praktini\u0173 u\u017esi\u0117mim\u0173 metu \u012fgyti nuosekli\u0173 bazini\u0173 \u017eini\u0173 dirbti su MS Excel programa. Mokym\u0173 metu susipa\u017einsite su duomen\u0173 formatais, formuli\u0173 ra\u0161ymo ypatumais, funkcijomis, duomen\u0173 lenteli\u0173 tvarkymo \u012frankiais.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Reikalavimai kurso klausytojams<\/h2>\n\n\n\n<p>B\u016bti \u0161iek tiek susipa\u017einusiems su MS Excel programa.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kurso programa<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">Darbas Excel aplinkoje<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Navigacija darbo lape (Go To Special dialog box, klavi\u0161ai, klavi\u0161\u0173 kombinacijos)<\/li>\n\n\n\n<li>Darbo lapo ir darbo knygos spausdinimas:\n<ul class=\"wp-block-list\">\n<li>Dalies arba visos darbo knygos spausdinimas (spausdinimo srities nustatymas).<\/li>\n\n\n\n<li>Puslapio l\u016b\u017ei\u0173 nustatymas.<\/li>\n\n\n\n<li>Tinklelio, eilu\u010di\u0173 ir stulpeli\u0173 antra\u0161\u010di\u0173 spausdinimas.<\/li>\n\n\n\n<li>Lap\u0173 antra\u0161\u010di\u0173 ir pora\u0161\u010di\u0173 \u012fterpimas ir spausdinimas.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Excel aplinkos personalizavimas:\n<ul class=\"wp-block-list\">\n<li>Programos funkcionalumo valdymas (Excel Options lango kortel\u0117s Formula ir Advanced).<\/li>\n\n\n\n<li>Meniu juost\u0173 ir greitos prieigos juostos modifikavimas.<\/li>\n\n\n\n<li>Darbo knygos valdymas (dokumento savyb\u0117s (Properties) ir versijos).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Duomen\u0173 \u012fvedimas<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Duomenys langeliuose:\n<ul class=\"wp-block-list\">\n<li>Kopijavimas (Paste special).<\/li>\n\n\n\n<li>\u012eterpimas ir i\u0161trynimas.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Automatinis u\u017epildymas.\n<ul class=\"wp-block-list\">\n<li>Duomen\u0173 sekos u\u017epildymas.<\/li>\n\n\n\n<li>Duomen\u0173 sekos kopijavimas.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Nuorodos:\n<ul class=\"wp-block-list\">\n<li>Nuorod\u0173 k\u016brimas.<\/li>\n\n\n\n<li>Nuorod\u0173 modifikavimas.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Darbo lapo ir langeli\u0173 formatavimas<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Langelio formatavimas:\n<ul class=\"wp-block-list\">\n<li>Langelyje esan\u010dios informacijos formatavimas.<\/li>\n\n\n\n<li>Langelio fono ir r\u0117meli\u0173 formatavimas.<\/li>\n\n\n\n<li>Eilu\u010di\u0173 auk\u0161\u010dio ir stulpeli\u0173 plo\u010dio nustatymas.<\/li>\n\n\n\n<li>Duomen\u0173 formatai.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Langeli\u0173 apjungimas ir padalinimas.<\/li>\n\n\n\n<li>Lentel\u0117s antra\u0161\u010di\u0173 spausdinimas kiekviename puslapyje.<\/li>\n\n\n\n<li>Eilu\u010di\u0173 ir stulpeli\u0173 pasl\u0117pimas.<\/li>\n\n\n\n<li>Darbo lapo parametr\u0173 nustatymas (Page Setup Options).<\/li>\n\n\n\n<li>Stili\u0173 langeliams k\u016brimas ir taikymas.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Darbo lap\u0173 ir knyg\u0173 tvarkymas<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Darbo lapo suk\u016brimas ir formatavimas.<\/li>\n\n\n\n<li>Lang\u0173 valdymas.\n<ul class=\"wp-block-list\">\n<li>Freezing ir Split komandos.<\/li>\n\n\n\n<li>Darbas su keliais langais.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Darbo knygos per\u017ei\u016bros valdymas.\n<ul class=\"wp-block-list\">\n<li>Skirting\u0173 per\u017ei\u016bros r\u0117\u017eim\u0173 pasirinkimas.<\/li>\n\n\n\n<li>Programos lango modifikavimas.<\/li>\n\n\n\n<li>Darbo lapo modifikavimas.<\/li>\n\n\n\n<li>Mastelio keitimas.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Formul\u0117s ir funkcijos<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Formuli\u0173 ra\u0161ymas.<\/li>\n\n\n\n<li>Langeli\u0173 adresai. Formuli\u0173 kopijavimas. \u201e3D formules\u201c.<\/li>\n\n\n\n<li>Funkcij\u0173 naudojimas (tekstin\u0117s, datos, lookup ir kt. da\u017eniau naudojamos funkcijos).<\/li>\n\n\n\n<li>Logini\u0173 funkcij\u0173 naudojimas (if, averageif, averageifs, countif, countifs, sumif, sumifs, iferror, and, or ir kt.).<\/li>\n\n\n\n<li>Keli\u0173 funkcij\u0173 panaudojimas formul\u0117je.<\/li>\n\n\n\n<li>Langeli\u0173 vard\u0173 naudojimas formul\u0117se.<\/li>\n\n\n\n<li>Langeli\u0173 diapazon\u0173 naudojimas formul\u0117se.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Grafinis duomen\u0173 atvaizdavimas<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Diagramos:\n<ul class=\"wp-block-list\">\n<li>Diagram\u0173 k\u016brimas.<\/li>\n\n\n\n<li>Maket\u0173 ir stili\u0173 taikymas diagramoms.<\/li>\n\n\n\n<li>Diagramos perk\u0117limas ir dyd\u017eio keitimas.<\/li>\n\n\n\n<li>Diagramos duomen\u0173 keitimas.<\/li>\n\n\n\n<li>Diagramos element\u0173 modifikavimas.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Iliustracijos:\n<ul class=\"wp-block-list\">\n<li>Iliustracij\u0173 \u012fterpimas i\u0161 galerijos (ClipArt) ir j\u0173 modifikavimas.<\/li>\n\n\n\n<li>Schem\u0173 (SmartArt) \u012fterpimas ir modifikavimas.<\/li>\n\n\n\n<li>Fig\u016br\u0173 \u012fterpimas ir modifikavimas.<\/li>\n\n\n\n<li>Ekrano vaizdo kopijavimas.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Paveiksl\u0117li\u0173 \u012fterpimas ir modifikavimas.<\/li>\n\n\n\n<li>Miniati\u016brin\u0117s diagramos (Sparklines).<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Excel duomen\u0173 pateikimas kitiems vartotojams<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Darbo lapo duomen\u0173 i\u0161saugojimas \u012fvairiais formatais.<\/li>\n\n\n\n<li>Komentar\u0173 \u012fterpimas ir valdymas.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Duomen\u0173 analiz\u0117 ir tvarkymas<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Duomen\u0173 tikrinimas (Data Validation).<\/li>\n\n\n\n<li>S\u0105lyginis formatavimas (naudojant taisykles, piktogramas, if funkcij\u0105).<\/li>\n\n\n\n<li>Duomen\u0173 rikiavimas (pagal reik\u0161m\u0119, \u0161rifto spalv\u0105, langelio spalv\u0105).<\/li>\n\n\n\n<li>Duomen\u0173 filtravimas (AutoFilter).<\/li>\n\n\n\n<li>Tarpini\u0173 sum\u0173 \u012fterpimas.<\/li>\n\n\n\n<li>Sukinys (PivotTable).<\/li>\n<\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong><a href=\"https:\/\/kompiuteriu-kursai.lt\/?p=1640\" title=\"\">Artimiausia mokym\u0173 data ir registracija \u279d<\/a><\/strong><\/h6>\n","protected":false},"excerpt":{"rendered":"<p>| Kurs\u0173 trukm\u0117: 16 akad. val. | Kurs\u0173 kaina: 145 Eur. Trumpas kurso apra\u0161ymas Kursas skirtas visiems, norintiems praktini\u0173 u\u017esi\u0117mim\u0173 metu \u012fgyti nuosekli\u0173 bazini\u0173 \u017eini\u0173 dirbti su MS Excel programa. Mokym\u0173 metu susipa\u017einsite su duomen\u0173 formatais, formuli\u0173 ra\u0161ymo ypatumais, funkcijomis, duomen\u0173 lenteli\u0173 tvarkymo \u012frankiais. Reikalavimai kurso klausytojams B\u016bti \u0161iek tiek susipa\u017einusiems su MS Excel programa. [&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":[198,197,200,199,69],"class_list":["post-225","post","type-post","status-publish","format-standard","hentry","category-kursai","tag-microsoft-excel","tag-ms-excel","tag-ms-excel-kursai","tag-ms-excel-mokymai","tag-ms-excel-specialist"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/225","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=225"}],"version-history":[{"count":13,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/225\/revisions"}],"predecessor-version":[{"id":3822,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/225\/revisions\/3822"}],"wp:attachment":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}