{"id":8003,"date":"2024-06-27T11:07:37","date_gmt":"2024-06-27T08:07:37","guid":{"rendered":"https:\/\/kvkoolitus.ee\/?page_id=8003"},"modified":"2025-01-06T15:24:39","modified_gmt":"2025-01-06T13:24:39","slug":"aruannete-prognooside-statistiliste-aruannete-analuuside-loomine-excel-programmi-abil","status":"publish","type":"page","link":"https:\/\/kvkoolitus.ee\/ru\/aruannete-prognooside-statistiliste-aruannete-analuuside-loomine-excel-programmi-abil\/","title":{"rendered":"\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043e\u0442\u0447\u0435\u0442\u043e\u0432, \u043f\u0440\u043e\u0433\u043d\u043e\u0437\u043e\u0432, \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u043e\u0442\u0447\u0435\u0442\u043e\u0432, \u0430\u043d\u0430\u043b\u0438\u0437\u043e\u0432 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u044b Excel."},"content":{"rendered":"<p style=\"text-align: right;\">\u00d5ppekava kinnitamise aeg: 19.12.2024<\/p>\n<p><strong>\u00d5ppekava nimetus<\/strong>: <strong>Aruannete, prognooside, statistiliste aruannete, anal\u00fc\u00fcside loomine Excel programmi abil<\/strong><\/p>\n<p><strong>\u00d5ppekavar\u00fchm:<\/strong> Arvutikasutus<\/p>\n<p><strong>\u00d5ppekava koostamise alus: <\/strong>Kutsestandardid: \u00c4rikorralduse spetsialist tase 5, V\u00e4ikeettev\u00f5tja tase 5, B\u00fcroot\u00f6\u00f6taja, tase 5<\/p>\n<p><strong>\u00a0<\/strong><strong>Koolituse kogumaht akadeemilistes tundides:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 26<\/strong><\/p>\n<p>sh auditoorse t\u00f6\u00f6 maht akadeemilistes tundides:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4<\/p>\n<p>(\u00f5pe loengu, seminari v\u00f5i muus koolis m\u00e4\u00e4ratud vormis)<\/p>\n<p>sh praktilise t\u00f6\u00f6 maht akadeemilistes tundides:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 22<\/p>\n<p>(\u00f5pitud teadmiste ja oskuste rakendamine \u00f5ppekeskkonnas)<\/p>\n<p><strong>\u00a0<\/strong><strong>Kasutatava \u00f5ppekeskkonna kirjeldus:<\/strong><\/p>\n<p>\u00d5ppet\u00f6\u00f6s kasutatakse \u00f5ppeklassi, mis on varustatud multiprojektoriga ning arvutiklassi. Koolitusruum (sh \u00f5ppetehnika) vastab t\u00f6\u00f6tervishoiu ja t\u00f6\u00f6ohutuse seaduses s\u00e4testatud t\u00f6\u00f6tervishoiu ja -ohutuse n\u00f5uetele. Koolitus v\u00f5ib toimuda ka veebip\u00f5hiselt ZOOM\u00b4i keskkonnas.<\/p>\n<p><strong>\u00a0<\/strong><strong>Sihtgrupp ja \u00f5ppe alustamise n\u00f5uded: \u00a0<\/strong>arvutikasutajad, kellel on olemas tabelarvutusprogrammiga t\u00f6\u00f6tamise kogemus ja kes soovivad \u00f5ppida juurde uusi v\u00f5imalusi ja rakendusi, et muuta tabelarvutusprogrammiga t\u00f6\u00f6tamine efektiivsemaks.<\/p>\n<p>\u00d5ppe alustamise n\u00f5uded: MS Office Exceli kasutamine algtasemel.<\/p>\n<p><strong>\u00d5ppe eesm\u00e4rgid:<\/strong> Antud kursus annab v\u00f5imaluse parandada t\u00f6\u00f6 kiirust ja kvaliteeti tabelarvutusprogrammiga t\u00f6\u00f6tades.<\/p>\n<p><strong>\u00d5piv\u00e4ljundid:<\/strong><\/p>\n<ul>\n<li>koostab tasuvuse ja efektiivsuse anal\u00fc\u00fcse, kasutades anal\u00fc\u00fcsi p\u00f5himeetodeid;<\/li>\n<li>valmistab ette andmeid prognooside ja aruannete koostamiseks, l\u00e4htudes ettev\u00f5tte vajadustest ja koostab juhendamisel statistilisi aruandeid;<\/li>\n<li>oskab t\u00f6\u00f6delda ja anal\u00fc\u00fcsida suuri andmehulki;<\/li>\n<li>kasutab erinevaid Exceli funktsioone ning neid kombineerida arvutuste sooritamiseks.<\/li>\n<\/ul>\n<p><strong>\u00d5ppe sisu: <\/strong><\/p>\n<p><strong>Auditoorne t\u00f6\u00f6 \u2013 4 tundi<\/strong><\/p>\n<p><strong>T\u00f6\u00f6tamine tabeliga <\/strong><\/p>\n<p>Sisestuse kontroll, parooliga kaitsmine, valemite varjamine, \u00f5igustep\u00f5hine piirang<\/p>\n<p><strong>Praktiline osa \u2013 22 tundi<\/strong><\/p>\n<p><strong>Lahendajad ja anal\u00fc\u00fcsivahend <\/strong><\/p>\n<p>Eesm\u00e4rgistatud otsing, \u00f5ige l\u00e4htearvu leidmiseks tabelisse stsenaariumid,\u00a0 sorteerimine,\u00a0 filtreerimine, tingimustega filtrid , vahekokkuv\u00f5tted tabelis olevatest andmetest, vahekokkuv\u00f5tte Subtotal funktsioon, andmete otsimine, parandamine ja lisamine, mitme tabeli kokkuv\u00f5te (konsolideerimine), valemite auditeerimine ja j\u00e4litamine.<\/p>\n<p><strong>Erinevate funktsioonide kasutamine ja kombineerimine, arvutamine mitme t\u00f6\u00f6lehe ja failide piires <\/strong><\/p>\n<p>Andmebaasifunktsioonid,\u00a0 Loendus (Count, CountA, CountIF), \u00dcmardamine, Tingimusfunktsioonid (If, SumIF), Mitme tingimuslause kasutamine funktsioonides (AND, OR), Otsingufunktsioon (VLOOKUP, Match, Index jt), Statistilinefunktsioonid, Kuup\u00e4evafunktsioonide kasutamine,\u00a0 Nimeliste piirkondade kasutamine.<\/p>\n<p><strong>Risttabel (Pivot) <\/strong><\/p>\n<p>Risttabeli (Pivot) koostamine Exceli tabelist, funktsioonid Pivot Table\u2019s, aruande muutmine, kujundamine.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>Kasutavad \u00f5ppemeetodid: <\/strong>Loeng, praktiline t\u00f6\u00f6.<\/p>\n<p><strong>Vajalike \u00f5ppematerjalide loend: <\/strong>Koolitaja poolt koostatud \u00f5ppematerjalid.<\/p>\n<p>\u00d5ppematerjalid:<\/p>\n<ul>\n<li>EUCIP kursuse e-\u00f5ppe materjal, <a href=\"http:\/\/www.ecdl.ee\/AO.html\">http:\/\/www.ecdl.ee\/AO.html<\/a><\/li>\n<li>\u0414\u0436\u043e\u043d \u0423\u043e\u043a\u0435\u043d\u0431\u0430\u0445 \u00ab\u0424\u043e\u0440\u043c\u0443\u043b\u044b \u0432 Excel 2013\u00bb<\/li>\n<\/ul>\n<p><strong>\u00a0<\/strong><strong>N\u00f5uded \u00f5pingute l\u00f5petamiseks:<\/strong><\/p>\n<p>V\u00e4hemalt 70% \u00f5ppekava l\u00e4bimine ja arvestusliku t\u00f6\u00f6 sooritamine. Arvestuslik t\u00f6\u00f6 koosneb 6 praktilises \u00fclesandest kursusel l\u00e4bitud teemade seast. Positiivseks soorituseks on vaja kuuest \u00fclesandest t\u00e4ita v\u00e4hemalt viis veatult. \u00d5ppijale v\u00e4ljastatakse \u00f5ppe l\u00f5petamise n\u00f5uete t\u00e4itmisel tunnistus.<\/p>\n<p><strong>\u00a0<\/strong><strong>Koolitaja andmed: <\/strong><\/p>\n<p>Natella Mihhailova \u2013 k\u00f5rgharidus, omab t\u00f6\u00f6kogemust, on olemas kogemus pedagoogilisel t\u00f6\u00f6l (t\u00e4iskasvanute koolitaja staa\u017e &#8211; 25.a.).<\/p>\n<p><strong>Tellimine ja info:<\/strong><\/p>\n<p>Telefon: 55 583 410; 53 475 016<br \/>\nE-post:\u00a0<a href=\"mailto:info@kvkoolitus.ee\">info@kvkoolitus.ee<\/a><\/p>\n<p><strong><form method=\"post\" enctype=\"multipart\/form-data\" id=\"vfbp-form-1\" class=\"vfbp-form\"><div style=\"display:none;\"><label for=\"vfbp-EMAIL-AN8fuQyoDLXem\">\u0415\u0441\u043b\u0438 \u0412\u044b \u0447\u0435\u043b\u043e\u0432\u0435\u043a, \u043e\u0441\u0442\u0430\u0432\u044c\u0442\u0435 \u044d\u0442\u043e \u043f\u043e\u043b\u0435 \u043f\u0443\u0441\u0442\u044b\u043c<\/label><input size=\"25\" autocomplete=\"off\" type=\"text\" name=\"vfbp-EMAIL-AN8fuQyoDLXem\" value=\"\" id=\"\"><\/div><input type=\"hidden\" name=\"_vfb-timestamp-1\" value=\"1776667743\" id=\"\"><input type=\"hidden\" name=\"_vfb-form-id\" value=\"1\" id=\"\"><div class=\"vfb-col-12 vfb-fieldType-hidden\" id=\"vfbField5\"><input id=\"vfb-field-5\" class=\"vfb-form-control\" placeholder=\"\" type=\"hidden\" name=\"vfb-field-5\" value=\"Aruannete, prognooside, statistiliste aruannete, anal&uuml;&uuml;side loomine Excel programmi abil\"><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-col-12 vfb-fieldType-hidden\" id=\"vfbField60\"><input id=\"vfb-field-60\" class=\"vfb-form-control\" placeholder=\"\" type=\"hidden\" name=\"vfb-field-60\" value=\"8003\"><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-well vfb-col-12\" id=\"vfbField4\"><div class=\"vfb-form-group vfb-col-12\"><div><h3 class=\"\">Saada koolituse p\u00e4ring v\u00f5i <a href=\"\/koolitused\">vaata koolituskalendrit<\/a><\/h3><\/div><\/div><div class=\"vfb-col-12 vfb-fieldType-heading\" id=\"vfbField4\"><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-col-4 vfb-fieldType-text\" id=\"vfbField1\"><div class=\"vfb-form-group\"><label for=\"vfb-field-1\" class=\"vfb-control-label\">Nimi <span class=\"vfb-required-asterisk\">*<\/span><\/label><div><input id=\"vfb-field-1\" class=\"vfb-form-control\" placeholder=\"\" required=\"required\" type=\"text\" name=\"vfb-field-1\" value=\"\"><\/div><\/div><\/div><div class=\"vfb-col-4 vfb-fieldType-email\" id=\"vfbField3\"><div class=\"vfb-form-group\"><label for=\"vfb-field-3\" class=\"vfb-control-label\">E-posti aadress <span class=\"vfb-required-asterisk\">*<\/span><\/label><div><input id=\"vfb-field-3\" class=\"vfb-form-control\" placeholder=\"\" required=\"required\" type=\"email\" name=\"vfb-field-3\" value=\"\"><\/div><\/div><\/div><div class=\"vfb-col-4 vfb-fieldType-text\" id=\"vfbField6\"><div class=\"vfb-form-group\"><label for=\"vfb-field-6\" class=\"vfb-control-label\">Telefon <span class=\"vfb-required-asterisk\">*<\/span><\/label><div><input id=\"vfb-field-6\" class=\"vfb-form-control\" placeholder=\"\" required=\"required\" type=\"text\" name=\"vfb-field-6\" value=\"\"><\/div><\/div><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-col-12 vfb-fieldType-select\" id=\"vfbField81\"><label for=\"vfb-field-81\" class=\"vfb-control-label\">Soovin koolitust l\u00e4bida:<\/label><div><div class=\"vfb-form-group\"><select id=\"vfb-field-81\" class=\"vfb-form-control\" placeholder=\"\" name=\"vfb-field-81\"><option value=\"Eesti keeles\">Eesti keeles<\/option><option value=\"Vene keeles\">Vene keeles<\/option><\/select><\/div><\/div><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-col-12 vfb-fieldType-select\" id=\"vfbField196\"><label for=\"vfb-field-196\" class=\"vfb-control-label\">Koolituse tellib:<\/label><div><div class=\"vfb-form-group\"><select id=\"vfb-field-196\" class=\"vfb-form-control\" placeholder=\"\" name=\"vfb-field-196\"><option value=\"Eraisik\">Eraisik<\/option><option value=\"Ettev&otilde;te\">Ettev\u00f5te<\/option><\/select><\/div><\/div><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-col-4 vfb-fieldType-select\" id=\"vfbField11\"><label for=\"vfb-field-11\" class=\"vfb-control-label\">Kes arve tasub?<\/label><div><div class=\"vfb-form-group\"><select id=\"vfb-field-11\" class=\"vfb-form-control\" placeholder=\"\" name=\"vfb-field-11\"><option value=\"Ettev&otilde;te\">Ettev\u00f5te<\/option><option value=\"Eraisik\">Eraisik<\/option><option value=\"T&ouml;&ouml;tukassa\">T\u00f6\u00f6tukassa<\/option><\/select><\/div><\/div><\/div><div class=\"vfb-col-7 vfb-fieldType-text\" id=\"vfbField8\"><div class=\"vfb-form-group\"><label for=\"vfb-field-8\" class=\"vfb-control-label\">Ettev\u00f5tte nimi, kellele arve esitatakse <span class=\"vfb-required-asterisk\">*<\/span><\/label><div><input id=\"vfb-field-8\" class=\"vfb-form-control\" placeholder=\"\" required=\"required\" type=\"text\" name=\"vfb-field-8\" value=\"\"><\/div><\/div><\/div><div class=\"vfb-col-7 vfb-fieldType-text\" id=\"vfbField61\"><div class=\"vfb-form-group\"><label for=\"vfb-field-61\" class=\"vfb-control-label\">Eraisiku nimi, kellele arve esitatakse <span class=\"vfb-required-asterisk\">*<\/span><\/label><div><input id=\"vfb-field-61\" class=\"vfb-form-control\" placeholder=\"\" required=\"required\" type=\"text\" name=\"vfb-field-61\" value=\"\"><\/div><\/div><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-col-12 vfb-fieldType-textarea\" id=\"vfbField12\"><div class=\"vfb-form-group\"><label for=\"vfb-field-12\" class=\"vfb-control-label\">Lisainfo<\/label><div><textarea id=\"vfb-field-12\" class=\"vfb-form-control\" placeholder=\"\" rows=\"5\" name=\"vfb-field-12\" cols=\"50\"><\/textarea><\/div><\/div><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-col-6 vfb-fieldType-checkbox\" id=\"vfbField13\"><label for=\"vfb-field-13\" class=\"vfb-control-label\"><\/label><div><div class=\"vfb-checkbox\"><label><input id=\"vfb-field-13-0\" class=\"\" placeholder=\"\" data-vfb-multiple=\"vfb-field-13\" type=\"checkbox\" name=\"vfb-field-13[0]\" value=\"1\"> Soovin saada infot minu ala kursuste kohta<\/label><\/div><\/div><\/div><div class=\"vfb-col-6 vfb-fieldType-checkbox\" id=\"vfbField14\"><label for=\"vfb-field-14\" class=\"vfb-control-label\"><\/label><div><div class=\"vfb-checkbox\"><label><input id=\"vfb-field-14-0\" class=\"\" placeholder=\"\" data-vfb-multiple=\"vfb-field-14\" type=\"checkbox\" name=\"vfb-field-14[0]\" value=\"1\">Soovin saada infot eripakkumiste ja soodustuste kohta<\/label><\/div><\/div><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-col-12 vfb-fieldType-checkbox\" id=\"vfbField15\"><label for=\"vfb-field-15\" class=\"vfb-control-label\"> <span class=\"vfb-required-asterisk\">*<\/span><\/label><div><div class=\"vfb-checkbox\"><label><input id=\"vfb-field-15-0\" class=\"\" placeholder=\"\" data-vfb-multiple=\"vfb-field-15\" required=\"required\" type=\"checkbox\" name=\"vfb-field-15[0]\" value=\"1\">Kinnitan, et olen tutvunud \u00d5ppet\u00f6\u00f6 korraldusega ja v\u00f5tan enesele k\u00f5ik sellest tulenevad kohustused<\/label><\/div><\/div><\/div><div class=\"vfb-clearfix\"><\/div><div class=\"vfb-col-12 vfb-fieldType-submit\" id=\"vfbField16\"><button id=\"vfb-field-16\" class=\" btn btn-primary\" placeholder=\"\" type=\"submit\" name=\"_vfb-submit\">Registreerimine<\/button><\/div><div class=\"vfb-clearfix\"><\/div><\/div> <!-- .vfb-well --><\/form>[\/fusion_text][\/fusion_builder_column][\/fusion_builder_row][\/fusion_builder_container]<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00d5ppekava kinnitamise aeg: 19.12.2024 \u00d5ppekava nimetus: Aruannete, prognooside, statistiliste aruannete, anal\u00fc\u00fcside loomine Excel programmi abil \u00d5ppekavar\u00fchm: Arvutikasutus \u00d5ppekava koostamise alus: Kutsestandardid: \u00c4rikorralduse spetsialist tase 5, V\u00e4ikeettev\u00f5tja tase 5, B\u00fcroot\u00f6\u00f6taja, tase 5 \u00a0Koolituse kogumaht <a href=\"https:\/\/kvkoolitus.ee\/ru\/aruannete-prognooside-statistiliste-aruannete-analuuside-loomine-excel-programmi-abil\/\"> [&#8230;]<\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-8003","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kvkoolitus.ee\/ru\/wp-json\/wp\/v2\/pages\/8003","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kvkoolitus.ee\/ru\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kvkoolitus.ee\/ru\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kvkoolitus.ee\/ru\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/kvkoolitus.ee\/ru\/wp-json\/wp\/v2\/comments?post=8003"}],"version-history":[{"count":3,"href":"https:\/\/kvkoolitus.ee\/ru\/wp-json\/wp\/v2\/pages\/8003\/revisions"}],"predecessor-version":[{"id":8435,"href":"https:\/\/kvkoolitus.ee\/ru\/wp-json\/wp\/v2\/pages\/8003\/revisions\/8435"}],"wp:attachment":[{"href":"https:\/\/kvkoolitus.ee\/ru\/wp-json\/wp\/v2\/media?parent=8003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}