{"id":210,"date":"2022-08-22T03:19:31","date_gmt":"2022-08-22T00:19:31","guid":{"rendered":"https:\/\/kompiuteriu-kursai.lt\/?p=210"},"modified":"2025-01-04T16:55:40","modified_gmt":"2025-01-04T13:55:40","slug":"pivot-table-duomenu-analizei","status":"publish","type":"post","link":"https:\/\/kompiuteriu-kursai.lt\/?p=210","title":{"rendered":"MS Excel: Pivot Tables efektyviai duomen\u0173 analizei"},"content":{"rendered":"\n<p><\/p>\n\n\n\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: 4 akad. val.<\/p>\n\n\n\n<p 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>Seminaras skirtas dirbantiems su didel\u0117s apimties duomenimis. Mokymo metu i\u0161moksite sukurti suvestines lenteles (Pivot table), skirting\u0173 \u0161altini\u0173 suvestines lenteles (Multiple Pivot table), o duomenis atvaizduosite PivotChart diagramose.<\/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>Paprast\u0173 suvestini\u0173 lenteli\u0173 (Pivot Table) k\u016brimas;<\/li>\n\n\n\n<li>Suvestini\u0173 lenteli\u0173 (Pivot Table) lauk\u0173 tvarkymas;<\/li>\n\n\n\n<li>Suvestini\u0173 lenteli\u0173 (Pivot Table) dizaino (Design) \u012frankiai;<\/li>\n\n\n\n<li>Suvestini\u0173 lenteli\u0173 (Pivot Table) nustatymai;<\/li>\n\n\n\n<li>Suvestini\u0173 lenteli\u0173 (Pivot Table) parametr\u0173 keitimas;<\/li>\n\n\n\n<li>Suvestini\u0173 lenteli\u0173 (Pivot Table) skai\u010diuojami laukai ir \u012fra\u0161ai;<\/li>\n\n\n\n<li>Duomen\u0173 filtr\u0173 \u012fterpimas (Slicers);<\/li>\n\n\n\n<li>Skirting\u0173 \u0161altini\u0173 suvestin\u0117s lentel\u0117s (Multiple Pivot Table);<\/li>\n\n\n\n<li>Duomen\u0173 atvaizdavimas PivotChart diagramose;<\/li>\n\n\n\n<li>Ataskait\u0173 k\u016brimas naudojant tarpines sumas (Subtotals);<\/li>\n\n\n\n<li>Duomen\u0173 lentel\u0117s apsauga.<\/li>\n<\/ol>\n\n\n\n<p>Seminaro trukm\u0117 &#8211; 4 akad. val.<\/p>\n\n\n\n<h6 class=\"wp-block-heading\"><strong><a href=\"https:\/\/kompiuteriu-kursai.lt\/?p=375\" title=\"\">Artimiausia mokym\u0173 data ir 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: 4 akad. val. | Seminaro kaina: 60 Eur. Trumpas seminaro apra\u0161ymas Seminaras skirtas dirbantiems su didel\u0117s apimties duomenimis. Mokymo metu i\u0161moksite sukurti suvestines lenteles (Pivot table), skirting\u0173 \u0161altini\u0173 suvestines lenteles (Multiple Pivot table), o duomenis atvaizduosite PivotChart diagramose. Seminaro programa Seminaro [&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":[207,198,197,200,199,231,80,232],"class_list":["post-210","post","type-post","status-publish","format-standard","hentry","category-seminarai","tag-duomenu-analize","tag-microsoft-excel","tag-ms-excel","tag-ms-excel-kursai","tag-ms-excel-mokymai","tag-ms-excel-seminaras","tag-pivot-tables","tag-suvestines-lenteles"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/210","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=210"}],"version-history":[{"count":20,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/210\/revisions"}],"predecessor-version":[{"id":4923,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/210\/revisions\/4923"}],"wp:attachment":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}