{"id":202,"date":"2022-08-22T03:17:19","date_gmt":"2022-08-22T00:17:19","guid":{"rendered":"https:\/\/kompiuteriu-kursai.lt\/?p=202"},"modified":"2023-11-16T14:16:58","modified_gmt":"2023-11-16T11:16:58","slug":"ms-excel-seminaras-dideliu-duomenu-lenteliu-tvarkymas-ir-ataskaitu-ruosimas","status":"publish","type":"post","link":"https:\/\/kompiuteriu-kursai.lt\/?p=202","title":{"rendered":"MS Excel: dideli\u0173 duomen\u0173 lenteli\u0173 tvarkymas ir ataskait\u0173 ruo\u0161imas"},"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 class=\"has-text-align-left\" style=\"font-style:normal;font-weight:300\"><br>| Seminaro trukm\u0117:&nbsp;4 akad. val.<\/p>\n\n\n\n<p class=\"has-text-align-left\" style=\"font-style:normal;font-weight:300\">| Seminaro kaina: 60 Eur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><br>Trumpas seminaro apra\u0161ymas<\/h2>\n\n\n\n<p>MS Excel n\u0117ra specializuota duomen\u0173 bazi\u0173 programa, bet ji labai patogi dirbti su didel\u0117mis duomen\u0173 lentel\u0117mis. Jei nieko ne\u017einote apie duomen\u0173 bazes, bet jums reikia apdoroti didelius kiekius duomen\u0173 \u2013 \u0161is seminaras kaip tik jums. Susipa\u017einsite ir prakti\u0161kai i\u0161bandysite ne vien\u0105 MS Excel programos \u012frank\u012f skirt\u0105 didel\u0117ms duomen\u0173 lentel\u0117ms. Ir visi\u0161kai nesvarbu, ar lentel\u0117se tekstin\u0117 informacija ar skai\u010diai \u2013 MS Excel vienodai tinkamas ir patogus dirbti su skirtingos r\u016b\u0161ies informacija.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Seminaro programa<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Duomen\u0173 lentel\u0117s sudarymas ir reik\u0161mi\u0173 tikrinimas (Data Validation);<\/li>\n\n\n\n<li>Duomen\u0173 lentel\u0117s redagavimas naudojant kriterijus;<\/li>\n\n\n\n<li>Duomen\u0173 paie\u0161ka ir keitimas;<\/li>\n\n\n\n<li>Duomen\u0173 lentel\u0117s r\u016b\u0161iavimas;<\/li>\n\n\n\n<li>Duomen\u0173 lentel\u0117s automatinis filtras;<\/li>\n\n\n\n<li>Duomen\u0173 lentel\u0117s Custom filtras;<\/li>\n\n\n\n<li>Duomen\u0173 lentel\u0117s i\u0161pl\u0117stinis (Advanced) filtras;<\/li>\n\n\n\n<li>Ataskait\u0173 k\u016brimas naudojant tarpines sumas (Subtotals);<\/li>\n\n\n\n<li>Sukinys (Pivot Table);<\/li>\n\n\n\n<li>Ataskait\u0173 formato i\u0161saugojimas su Custom View;<\/li>\n\n\n\n<li>Duomen\u0173 bazi\u0173 funkcijos: DSUM, DAVERAGE, DCOUNT, DMIN, DMAX, DGET. <\/li>\n\n\n\n<li>Duomen\u0173 lentel\u0117s apsauga.<\/li>\n<\/ol>\n\n\n\n<p><br><a href=\"https:\/\/kompiuteriu-kursai.lt\/?page_id=2436\" title=\"\"><strong>Artimiausia mokym\u0173 data ir registracija \u279d<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jei nieko ne\u017einote apie duomen\u0173 bazes, bet jums reikia apdoroti didelius kiekius duomen\u0173 \u2013 \u0161is MS Excel seminaras kaip tik jums.<\/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":[238,240,239,197,200,199,231],"class_list":["post-202","post","type-post","status-publish","format-standard","hentry","category-seminarai","tag-ataskaitu-ruosimas","tag-duomenys","tag-lenteliu-tvarkymas","tag-ms-excel","tag-ms-excel-kursai","tag-ms-excel-mokymai","tag-ms-excel-seminaras"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/202","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=202"}],"version-history":[{"count":14,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/202\/revisions"}],"predecessor-version":[{"id":3882,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/202\/revisions\/3882"}],"wp:attachment":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}