{"id":200,"date":"2022-08-22T03:16:43","date_gmt":"2022-08-22T00:16:43","guid":{"rendered":"https:\/\/kompiuteriu-kursai.lt\/?p=200"},"modified":"2023-05-13T07:04:33","modified_gmt":"2023-05-13T04:04:33","slug":"formuliu-ir-funkciju-naudojimas","status":"publish","type":"post","link":"https:\/\/kompiuteriu-kursai.lt\/?p=200","title":{"rendered":"MS Excel: formuli\u0173 ir funkcij\u0173 naudojimas"},"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 wp-block-paragraph\" 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 wp-block-paragraph\" 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 class=\"wp-block-paragraph\">Seminaras skirtas norintiems i\u0161mokti kurti formules, susipa\u017einti su da\u017eniausiai naudojamomis funkcijomis, i\u0161mokti jas pritaikyti savo poreikiams. Visk\u0105, k\u0105 nor\u0117jote su\u017einoti apie MS Excel formules ir funkcijas, su\u017einosite \u0161iame seminare.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Seminaro programa<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Duomen\u0173 \u012fvedimas Excel aplinkoje.<br>Formuli\u0173 ra\u0161ymas.<br>S\u0105lygin\u0117s ir absoliutin\u0117s koordinat\u0117s.<br>Formul\u0117s masyvams.<br>Klaid\u0173 tikrinimas formul\u0117se. Formuli\u0173 derinimas.<br><br>Da\u017eniausiai naudojamos funkcijos:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>sumif, sumifs, countif, countifs, vlookup, lookup, if, index, match, tekstin\u0117s ir datos.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Duomen\u0173 konsolidacija (sujungimas):<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Konsolidacija 3-D formuli\u0173 pagalba;<\/li>\n\n\n\n<li>Konsolidacija pagal pozicij\u0105 arba kategorij\u0105.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Pagrindin\u0117s finansin\u0117s MS Excel funkcijos:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Anuiteto apskai\u010diavimo funkcijos;<\/li>\n\n\n\n<li>Amortizacijos apskai\u010diavimo funkcijos.<\/li>\n<\/ul>\n\n\n\n<h6 class=\"wp-block-heading has-text-align-left\"><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>Seminar\u0173 ciklas \u201eMS Excel programos naudojimo galimyb\u0117s vadybos ir finans\u0173 srityse&#8221; | Seminaro trukm\u0117:&nbsp;4 akad. val. | Seminaro kaina: 60 Eur. Trumpas seminaro apra\u0161ymas Seminaras skirtas norintiems i\u0161mokti kurti formules, susipa\u017einti su da\u017eniausiai naudojamomis funkcijomis, i\u0161mokti jas pritaikyti savo poreikiams. Visk\u0105, k\u0105 nor\u0117jote su\u017einoti apie MS Excel formules ir funkcijas, su\u017einosite \u0161iame seminare. Seminaro programa [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[241,242,198,197,200,199,231],"class_list":["post-200","post","type-post","status-publish","format-standard","hentry","category-seminarai","tag-formules","tag-funkcijos","tag-microsoft-excel","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\/200","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=200"}],"version-history":[{"count":45,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/200\/revisions"}],"predecessor-version":[{"id":3510,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/200\/revisions\/3510"}],"wp:attachment":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}