{"id":247,"date":"2014-08-03T17:38:18","date_gmt":"2014-08-03T17:38:18","guid":{"rendered":"http:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/?page_id=247"},"modified":"2026-04-26T12:40:29","modified_gmt":"2026-04-26T12:40:29","slug":"preziga-esitluste-loomise-e-kursus","status":"publish","type":"page","link":"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/","title":{"rendered":"Exceli edasij\u00f5udnute koolitus e-kursusena"},"content":{"rendered":"<div class=\"wp-playlist wp-video-playlist wp-playlist-light\">\n\t\t<video controls=\"controls\" preload=\"none\" width=\"643\"\n\t\t height=\"362\"\t><\/video>\n\t<div class=\"wp-playlist-next\"><\/div>\n\t<div class=\"wp-playlist-prev\"><\/div>\n\t<noscript>\n\t<ol>\n\t\t<li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/07\/intro_in.mp4'>intro_in<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/01_Funktsioonide-sisestamine-ja-muutmine-Excelis.mp4'>01_Funktsioonide sisestamine ja muutmine Excelis<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/02_Tingimuslik-vahemiku-liitmine-SUMIF.mp4'>02_Tingimuslik vahemiku liitmine (SUMIF)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/03_Tingimuslik-keskmine-AVERAGEIF.mp4'>03_Tingimuslik keskmine (AVERAGEIF)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/04_Tingimuslik-loendamine-COUNTIF.mp4'>04_Tingimuslik loendamine (COUNTIF)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/05_Tingimuslik-liitmine-mitme-kriteeriumi-p\u00f5hjal-SUMIFS.mp4'>05_Tingimuslik liitmine mitme kriteeriumi p\u00f5hjal (SUMIFS)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/06_Tingimuslik-keskmine-ja-loendus-mitme-kriteeriumiga-AVERAGEIFS-ja-COUNTIFS.mp4'>06_Tingimuslik keskmine ja loendus mitme kriteeriumiga (AVERAGEIFS ja COUNTIFS)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/07_Tingimuse-seadmine-valemites-\u00fcks-V\u00d5I-teine-kriteeriumi-alusel.mp4'>07_Tingimuse seadmine valemites \u00fcks V\u00d5I teine kriteeriumi alusel<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/08_Kriteerumi-seadmine-teksti-osa-p\u00f5hjal.mp4'>08_Kriteerumi seadmine teksti osa p\u00f5hjal<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/09_Tingimuste-seadmine-liitmisele-andmebaasi-funktsiooniga.mp4'>09_Tingimuste seadmine liitmisele andmebaasi funktsiooniga<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/10_Tingimuste-seadmine-keskmise-arvutamisel-andmebaasi-funktsiooniga.mp4'>10_Tingimuste seadmine keskmise arvutamisel andmebaasi funktsiooniga<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/11_Tingimuste-seadmine-loendamisel-andmebaasi-funktsiooniga.mp4'>11_Tingimuste seadmine loendamisel andmebaasi funktsiooniga<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/12_IF-funktsiooni-kasutamine.mp4'>12_IF funktsiooni kasutamine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/13_Mitme-tingimuse-korraga-seadmine-IF-funtksioonis-I.mp4'>13_Mitme tingimuse korraga seadmine IF funtksioonis I<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/14_Mitme-tingimuse-korraga-seadmine-IF-funtksioonis-II-sh-ISBLANK-ja-ISTEXT.mp4'>14_Mitme tingimuse korraga seadmine IF funtksioonis II (sh ISBLANK ja ISTEXT)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/15_\u00dcks-tingimustest-OR-ja-k\u00f5ik-tingimused-AND-IF-funktsioonis.mp4'>15_\u00dcks tingimustest (OR) ja k\u00f5ik tingimused (AND) IF funktsioonis<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/16_VLOOKUP-funktsioon.mp4'>16_VLOOKUP funktsioon<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/17_Legendi-teisaldamine-VLOOKUP-funktsioonis.mp4'>17_Legendi teisaldamine VLOOKUP funktsioonis<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/18_Juhusliku-v\u00e4\u00e4rtuse-kuvamine-lahtris-RAND-ja-RANDBETWEEN.mp4'>18_Juhusliku v\u00e4\u00e4rtuse kuvamine lahtris (RAND ja RANDBETWEEN)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/19_Lahtri-arvv\u00e4\u00e4rtuse-\u00fcmardamine-ROUND.mp4'>19_Lahtri arvv\u00e4\u00e4rtuse \u00fcmardamine (ROUND)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/20_Rahandusfunktsioonid-laenu-makse-arvutamise-n\u00e4itel-PMT.mp4'>20_Rahandusfunktsioonid laenu makse arvutamise n\u00e4itel (PMT)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/21_Ajafunktsioonid-TODAY-ja-NOW.mp4'>21_Ajafunktsioonid TODAY ja NOW<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/22_Lahtis-oleva-teksti-suur-ja-v\u00e4iket\u00e4htede-muutmine-PROPER-UPPER-ja-LOWER.mp4'>22_Lahtis oleva teksti suur- ja v\u00e4iket\u00e4htede muutmine (PROPER; UPPER ja LOWER)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/23_Lahtri-t\u00e4itmine-teiste-lahtrite-sisu-ja-vaba-tekstiga-CONCATENATE.mp4'>23_Lahtri t\u00e4itmine teiste lahtrite sisu ja vaba tekstiga (CONCATENATE)<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/24_Lahtri-sisu-viimine-erinevatesse-veergudesse.mp4'>24_Lahtri sisu viimine erinevatesse veergudesse<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/25_Kiirt\u00e4ite-t\u00f6\u00f6riist-lahtri-sisu-kokkupanekul-ja-lahku-viimisel.mp4'>25_Kiirt\u00e4ite t\u00f6\u00f6riist lahtri sisu kokkupanekul ja lahku viimisel<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/26_Samasuguse-sisuga-lahtrite-eemaldamine-tabelist.mp4'>26_Samasuguse sisuga lahtrite eemaldamine tabelist<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/27_Pivot-Table-liigendtabeli-kasutamise-vajadus-ja-aruandetabeli-moodustamine.mp4'>27_Pivot Table liigendtabeli kasutamise vajadus ja aruandetabeli moodustamine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/28_Andmete-lisamine-Pivot-Table-aruandesse.mp4'>28_Andmete lisamine Pivot Table aruandesse<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/29_Andmete-v\u00e4rskendamine-aruande-tabelis.mp4'>29_Andmete v\u00e4rskendamine aruande tabelis<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/30_Lahtri-sisu-vaatamine-eraldi-tabelis-ridadena-lahtiv\u00f5etult.mp4'>30_Lahtri sisu vaatamine eraldi tabelis ridadena lahtiv\u00f5etult<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/31_Koondtulemuste-arvutamise-valikud.mp4'>31_Koondtulemuste arvutamise valikud<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/32_Veergude-teisaldamine-ja-r\u00fchmituse-kasutamine.mp4'>32_Veergude teisaldamine ja r\u00fchmituse kasutamine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/33_Filtri-ja-t\u00fckeldi-kasutamine.mp4'>33_Filtri ja t\u00fckeldi kasutamine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/34_Tabeli-vormindamine.mp4'>34_Tabeli vormindamine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/35_Nimede-kasutamine-lahtrite-vahemikele-viitamisel.mp4'>35_Nimede kasutamine lahtrite vahemikele viitamisel<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/36_Lahtri-t\u00e4itmisele-tingimuste-seadmine-rippmen\u00fc\u00fc-lisamine-lahtrile.mp4'>36_Lahtri t\u00e4itmisele tingimuste seadmine, rippmen\u00fc\u00fc lisamine lahtrile<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/37_Arvu-ja-kuup\u00e4evavahemiku-kriteerium-valesti-t\u00e4idetud-lahtritest-\u00fclevaade.mp4'>37_Arvu- ja kuup\u00e4evavahemiku kriteerium, valesti t\u00e4idetud lahtritest \u00fclevaade<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/38_Sihiotsing.mp4'>38_Sihiotsing<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/39_Solver.mp4'>39_Solver<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/40_Andmetabel.mp4'>40_Andmetabel<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/41_Stsenaariumi-haldur.mp4'>41_Stsenaariumi haldur<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/42_Konsolideerimine.mp4'>42_Konsolideerimine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/43_Dokumendi-kaitsmine-salvestamise-valikuna.mp4'>43_Dokumendi kaitsmine salvestamise valikuna<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/44_T\u00f6\u00f6lehe-terviklik-v\u00f5i-valitud-lahtrite-kaitsmine.mp4'>44_T\u00f6\u00f6lehe terviklik v\u00f5i valitud lahtrite kaitsmine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/45_Toimingute-piiramine-t\u00f6\u00f6lehel.mp4'>45_Toimingute piiramine t\u00f6\u00f6lehel<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/46_T\u00f6\u00f6vihiku-kaitsmine.mp4'>46_T\u00f6\u00f6vihiku kaitsmine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/47_Lihtsam-t\u00f6\u00f6-makrodega.mp4'>47_Lihtsam t\u00f6\u00f6 makrodega<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-001-001-power-query-tooriist.mp4'>Power Query t\u00f6\u00f6riist<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-001-002-paringute-loomine-ja-tabelite-kuvamine-toovihikus.mp4'>P\u00e4ringute loomine ja tabelite kuvamine t\u00f6\u00f6vihikus<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-001-003-mitme-paringu-korraga-importimine-paringute-haldamine.mp4'>Mitme p\u00e4ringu korraga importimine, p\u00e4ringute haldamine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-001-004-paringute-sisu-varskendamine-algtabelite-muutmisel.mp4'>P\u00e4ringute sisu v\u00e4rskendamine algtabelite muutmisel<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-002-005-tabelite-liitmine-veergudena.mp4'>Tabelite liitmine veergudena<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-002-006-veergude-liitmise-erivalikud.mp4'>Veergude liitmise erivalikud<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-007-tabelite-liitmine-ridadena.mp4'>Tabelite liitmine ridadena<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-008-ridade-liitmine-kui-veeru-paise-nimed-ei-kattu.mp4'>Ridade liitmine kui veeru p\u00e4ise nimed ei kattu<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-009-liidetud-paringusse-uute-tabelite-lisamine-ja-eemaldamine.mp4'>Liidetud p\u00e4ringusse uute tabelite lisamine ja eemaldamine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-0010-kaustast-koigi-failide-tabelite-liitmine.mp4'>Kaustast k\u00f5igi failide tabelite liitmine<\/a><\/li><li><a href='https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-0011-paringu-andmete-varskendamine-pivot-tabelis.mp4'>L\u00e4bi p\u00e4ringu andmete v\u00e4rskendamine Pivot tabelis<\/a><\/li>\t<\/ol>\n\t<\/noscript>\n\t<script type=\"application\/json\" class=\"wp-playlist-script\">{\"type\":\"video\",\"tracklist\":true,\"tracknumbers\":true,\"images\":true,\"artists\":true,\"tracks\":[{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/07\/intro_in.mp4\",\"type\":\"video\/mp4\",\"title\":\"intro_in\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"2:28\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/01_Funktsioonide-sisestamine-ja-muutmine-Excelis.mp4\",\"type\":\"video\/mp4\",\"title\":\"01_Funktsioonide sisestamine ja muutmine Excelis\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"8:40\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/02_Tingimuslik-vahemiku-liitmine-SUMIF.mp4\",\"type\":\"video\/mp4\",\"title\":\"02_Tingimuslik vahemiku liitmine (SUMIF)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"6:53\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/03_Tingimuslik-keskmine-AVERAGEIF.mp4\",\"type\":\"video\/mp4\",\"title\":\"03_Tingimuslik keskmine (AVERAGEIF)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"3:37\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/04_Tingimuslik-loendamine-COUNTIF.mp4\",\"type\":\"video\/mp4\",\"title\":\"04_Tingimuslik loendamine (COUNTIF)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"2:36\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/05_Tingimuslik-liitmine-mitme-kriteeriumi-p\\u00f5hjal-SUMIFS.mp4\",\"type\":\"video\/mp4\",\"title\":\"05_Tingimuslik liitmine mitme kriteeriumi p\\u00f5hjal (SUMIFS)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:03\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/06_Tingimuslik-keskmine-ja-loendus-mitme-kriteeriumiga-AVERAGEIFS-ja-COUNTIFS.mp4\",\"type\":\"video\/mp4\",\"title\":\"06_Tingimuslik keskmine ja loendus mitme kriteeriumiga (AVERAGEIFS ja COUNTIFS)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"5:34\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/07_Tingimuse-seadmine-valemites-\\u00fcks-V\\u00d5I-teine-kriteeriumi-alusel.mp4\",\"type\":\"video\/mp4\",\"title\":\"07_Tingimuse seadmine valemites \\u00fcks V\\u00d5I teine kriteeriumi alusel\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:13\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/08_Kriteerumi-seadmine-teksti-osa-p\\u00f5hjal.mp4\",\"type\":\"video\/mp4\",\"title\":\"08_Kriteerumi seadmine teksti osa p\\u00f5hjal\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:51\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/09_Tingimuste-seadmine-liitmisele-andmebaasi-funktsiooniga.mp4\",\"type\":\"video\/mp4\",\"title\":\"09_Tingimuste seadmine liitmisele andmebaasi funktsiooniga\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"6:04\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/10_Tingimuste-seadmine-keskmise-arvutamisel-andmebaasi-funktsiooniga.mp4\",\"type\":\"video\/mp4\",\"title\":\"10_Tingimuste seadmine keskmise arvutamisel andmebaasi funktsiooniga\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"3:37\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/11_Tingimuste-seadmine-loendamisel-andmebaasi-funktsiooniga.mp4\",\"type\":\"video\/mp4\",\"title\":\"11_Tingimuste seadmine loendamisel andmebaasi funktsiooniga\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"5:07\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/12_IF-funktsiooni-kasutamine.mp4\",\"type\":\"video\/mp4\",\"title\":\"12_IF funktsiooni kasutamine\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"6:33\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/13_Mitme-tingimuse-korraga-seadmine-IF-funtksioonis-I.mp4\",\"type\":\"video\/mp4\",\"title\":\"13_Mitme tingimuse korraga seadmine IF funtksioonis I\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:10\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/14_Mitme-tingimuse-korraga-seadmine-IF-funtksioonis-II-sh-ISBLANK-ja-ISTEXT.mp4\",\"type\":\"video\/mp4\",\"title\":\"14_Mitme tingimuse korraga seadmine IF funtksioonis II (sh ISBLANK ja ISTEXT)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"8:08\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/15_\\u00dcks-tingimustest-OR-ja-k\\u00f5ik-tingimused-AND-IF-funktsioonis.mp4\",\"type\":\"video\/mp4\",\"title\":\"15_\\u00dcks tingimustest (OR) ja k\\u00f5ik tingimused (AND) IF funktsioonis\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:32\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/16_VLOOKUP-funktsioon.mp4\",\"type\":\"video\/mp4\",\"title\":\"16_VLOOKUP funktsioon\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"8:28\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/17_Legendi-teisaldamine-VLOOKUP-funktsioonis.mp4\",\"type\":\"video\/mp4\",\"title\":\"17_Legendi teisaldamine VLOOKUP funktsioonis\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"2:26\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/18_Juhusliku-v\\u00e4\\u00e4rtuse-kuvamine-lahtris-RAND-ja-RANDBETWEEN.mp4\",\"type\":\"video\/mp4\",\"title\":\"18_Juhusliku v\\u00e4\\u00e4rtuse kuvamine lahtris (RAND ja RANDBETWEEN)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:50\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/19_Lahtri-arvv\\u00e4\\u00e4rtuse-\\u00fcmardamine-ROUND.mp4\",\"type\":\"video\/mp4\",\"title\":\"19_Lahtri arvv\\u00e4\\u00e4rtuse \\u00fcmardamine (ROUND)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:21\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/20_Rahandusfunktsioonid-laenu-makse-arvutamise-n\\u00e4itel-PMT.mp4\",\"type\":\"video\/mp4\",\"title\":\"20_Rahandusfunktsioonid laenu makse arvutamise n\\u00e4itel (PMT)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"5:00\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/21_Ajafunktsioonid-TODAY-ja-NOW.mp4\",\"type\":\"video\/mp4\",\"title\":\"21_Ajafunktsioonid TODAY ja NOW\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"7:02\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/22_Lahtis-oleva-teksti-suur-ja-v\\u00e4iket\\u00e4htede-muutmine-PROPER-UPPER-ja-LOWER.mp4\",\"type\":\"video\/mp4\",\"title\":\"22_Lahtis oleva teksti suur- ja v\\u00e4iket\\u00e4htede muutmine (PROPER; UPPER ja LOWER)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"2:49\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/23_Lahtri-t\\u00e4itmine-teiste-lahtrite-sisu-ja-vaba-tekstiga-CONCATENATE.mp4\",\"type\":\"video\/mp4\",\"title\":\"23_Lahtri t\\u00e4itmine teiste lahtrite sisu ja vaba tekstiga (CONCATENATE)\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"2:56\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/24_Lahtri-sisu-viimine-erinevatesse-veergudesse.mp4\",\"type\":\"video\/mp4\",\"title\":\"24_Lahtri sisu viimine erinevatesse veergudesse\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"3:50\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/25_Kiirt\\u00e4ite-t\\u00f6\\u00f6riist-lahtri-sisu-kokkupanekul-ja-lahku-viimisel.mp4\",\"type\":\"video\/mp4\",\"title\":\"25_Kiirt\\u00e4ite t\\u00f6\\u00f6riist lahtri sisu kokkupanekul ja lahku viimisel\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"3:00\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/26_Samasuguse-sisuga-lahtrite-eemaldamine-tabelist.mp4\",\"type\":\"video\/mp4\",\"title\":\"26_Samasuguse sisuga lahtrite eemaldamine tabelist\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"3:17\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/27_Pivot-Table-liigendtabeli-kasutamise-vajadus-ja-aruandetabeli-moodustamine.mp4\",\"type\":\"video\/mp4\",\"title\":\"27_Pivot Table liigendtabeli kasutamise vajadus ja aruandetabeli moodustamine\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:22\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/28_Andmete-lisamine-Pivot-Table-aruandesse.mp4\",\"type\":\"video\/mp4\",\"title\":\"28_Andmete lisamine Pivot Table aruandesse\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"6:48\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/29_Andmete-v\\u00e4rskendamine-aruande-tabelis.mp4\",\"type\":\"video\/mp4\",\"title\":\"29_Andmete v\\u00e4rskendamine aruande tabelis\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"1:51\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/30_Lahtri-sisu-vaatamine-eraldi-tabelis-ridadena-lahtiv\\u00f5etult.mp4\",\"type\":\"video\/mp4\",\"title\":\"30_Lahtri sisu vaatamine eraldi tabelis ridadena lahtiv\\u00f5etult\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"3:02\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/31_Koondtulemuste-arvutamise-valikud.mp4\",\"type\":\"video\/mp4\",\"title\":\"31_Koondtulemuste arvutamise valikud\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"2:27\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/32_Veergude-teisaldamine-ja-r\\u00fchmituse-kasutamine.mp4\",\"type\":\"video\/mp4\",\"title\":\"32_Veergude teisaldamine ja r\\u00fchmituse kasutamine\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:01\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/33_Filtri-ja-t\\u00fckeldi-kasutamine.mp4\",\"type\":\"video\/mp4\",\"title\":\"33_Filtri ja t\\u00fckeldi kasutamine\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"3:58\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/02\/34_Tabeli-vormindamine.mp4\",\"type\":\"video\/mp4\",\"title\":\"34_Tabeli vormindamine\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"2:20\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/35_Nimede-kasutamine-lahtrite-vahemikele-viitamisel.mp4\",\"type\":\"video\/mp4\",\"title\":\"35_Nimede kasutamine lahtrite vahemikele viitamisel\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"7:24\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/36_Lahtri-t\\u00e4itmisele-tingimuste-seadmine-rippmen\\u00fc\\u00fc-lisamine-lahtrile.mp4\",\"type\":\"video\/mp4\",\"title\":\"36_Lahtri t\\u00e4itmisele tingimuste seadmine, rippmen\\u00fc\\u00fc lisamine lahtrile\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"5:38\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/37_Arvu-ja-kuup\\u00e4evavahemiku-kriteerium-valesti-t\\u00e4idetud-lahtritest-\\u00fclevaade.mp4\",\"type\":\"video\/mp4\",\"title\":\"37_Arvu- ja kuup\\u00e4evavahemiku kriteerium, valesti t\\u00e4idetud lahtritest \\u00fclevaade\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"5:06\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/38_Sihiotsing.mp4\",\"type\":\"video\/mp4\",\"title\":\"38_Sihiotsing\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"3:38\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/39_Solver.mp4\",\"type\":\"video\/mp4\",\"title\":\"39_Solver\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"7:09\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/40_Andmetabel.mp4\",\"type\":\"video\/mp4\",\"title\":\"40_Andmetabel\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"9:12\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/41_Stsenaariumi-haldur.mp4\",\"type\":\"video\/mp4\",\"title\":\"41_Stsenaariumi haldur\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"7:08\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/42_Konsolideerimine.mp4\",\"type\":\"video\/mp4\",\"title\":\"42_Konsolideerimine\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"6:30\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/43_Dokumendi-kaitsmine-salvestamise-valikuna.mp4\",\"type\":\"video\/mp4\",\"title\":\"43_Dokumendi kaitsmine salvestamise valikuna\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:14\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/44_T\\u00f6\\u00f6lehe-terviklik-v\\u00f5i-valitud-lahtrite-kaitsmine.mp4\",\"type\":\"video\/mp4\",\"title\":\"44_T\\u00f6\\u00f6lehe terviklik v\\u00f5i valitud lahtrite kaitsmine\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"5:21\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/45_Toimingute-piiramine-t\\u00f6\\u00f6lehel.mp4\",\"type\":\"video\/mp4\",\"title\":\"45_Toimingute piiramine t\\u00f6\\u00f6lehel\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"4:24\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/46_T\\u00f6\\u00f6vihiku-kaitsmine.mp4\",\"type\":\"video\/mp4\",\"title\":\"46_T\\u00f6\\u00f6vihiku kaitsmine\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"1:37\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2015\/03\/47_Lihtsam-t\\u00f6\\u00f6-makrodega.mp4\",\"type\":\"video\/mp4\",\"title\":\"47_Lihtsam t\\u00f6\\u00f6 makrodega\",\"caption\":\"\",\"description\":\"\",\"meta\":{\"length_formatted\":\"5:26\"},\"dimensions\":{\"original\":{\"width\":1600,\"height\":900},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-001-001-power-query-tooriist.mp4\",\"type\":\"video\/mp4\",\"title\":\"Power Query t\\u00f6\\u00f6riist\",\"caption\":\"Power Query t\\u00f6\\u00f6riist\",\"description\":\"Power Query koolituse teema 'Power Query t\\u00f6\\u00f6riist' video 'Power Query t\\u00f6\\u00f6riist', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"1:40\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-001-002-paringute-loomine-ja-tabelite-kuvamine-toovihikus.mp4\",\"type\":\"video\/mp4\",\"title\":\"P\\u00e4ringute loomine ja tabelite kuvamine t\\u00f6\\u00f6vihikus\",\"caption\":\"P\\u00e4ringute loomine ja tabelite kuvamine t\\u00f6\\u00f6vihikus\\n\",\"description\":\"Power Query koolituse teema 'Power Query t\\u00f6\\u00f6riist' video 'P\\u00e4ringute loomine ja tabelite kuvamine t\\u00f6\\u00f6vihikus', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"4:42\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-001-003-mitme-paringu-korraga-importimine-paringute-haldamine.mp4\",\"type\":\"video\/mp4\",\"title\":\"Mitme p\\u00e4ringu korraga importimine, p\\u00e4ringute haldamine\",\"caption\":\"Mitme p\\u00e4ringu korraga importimine, p\\u00e4ringute haldamine\\n\",\"description\":\"Power Query koolituse teema 'Tabelite liitmine veergudena' video 'Mitme p\\u00e4ringu korraga importimine, p\\u00e4ringute haldamine', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"4:50\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-001-004-paringute-sisu-varskendamine-algtabelite-muutmisel.mp4\",\"type\":\"video\/mp4\",\"title\":\"P\\u00e4ringute sisu v\\u00e4rskendamine algtabelite muutmisel\",\"caption\":\"P\\u00e4ringute sisu v\\u00e4rskendamine algtabelite muutmisel\\n\",\"description\":\"Power Query koolituse teema 'Tabelite liitmine veergudena' video 'P\\u00e4ringute sisu v\\u00e4rskendamine algtabelite muutmisel', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"3:00\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-002-005-tabelite-liitmine-veergudena.mp4\",\"type\":\"video\/mp4\",\"title\":\"Tabelite liitmine veergudena\",\"caption\":\"Tabelite liitmine veergudena\\n\",\"description\":\"Power Query koolituse teema 'Tabelite liitmine veergudena' video 'Tabelite liitmine veergudena', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"8:13\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-002-006-veergude-liitmise-erivalikud.mp4\",\"type\":\"video\/mp4\",\"title\":\"Veergude liitmise erivalikud\",\"caption\":\"Veergude liitmise erivalikud\\n\",\"description\":\"Power Query koolituse teema 'Tabelite liitmine ridadena' video 'Veergude liitmise erivalikud', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"7:58\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-007-tabelite-liitmine-ridadena.mp4\",\"type\":\"video\/mp4\",\"title\":\"Tabelite liitmine ridadena\",\"caption\":\"Tabelite liitmine ridadena\\n\",\"description\":\"Power Query koolituse teema 'Tabelite liitmine ridadena' video 'Tabelite liitmine ridadena', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"4:28\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-008-ridade-liitmine-kui-veeru-paise-nimed-ei-kattu.mp4\",\"type\":\"video\/mp4\",\"title\":\"Ridade liitmine kui veeru p\\u00e4ise nimed ei kattu\",\"caption\":\"Ridade liitmine kui veeru p\\u00e4ise nimed ei kattu\\n\",\"description\":\"Power Query koolituse teema 'Tabelite liitmine ridadena' video 'Ridade liitmine kui veeru p\\u00e4ise nimed ei kattu', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"3:50\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-009-liidetud-paringusse-uute-tabelite-lisamine-ja-eemaldamine.mp4\",\"type\":\"video\/mp4\",\"title\":\"Liidetud p\\u00e4ringusse uute tabelite lisamine ja eemaldamine\",\"caption\":\"Liidetud p\\u00e4ringusse uute tabelite lisamine ja eemaldamine\\n\",\"description\":\"Power Query koolituse teema 'Tabelite liitmine ridadena' video 'Liidetud p\\u00e4ringusse uute tabelite lisamine ja eemaldamine', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"3:42\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-0010-kaustast-koigi-failide-tabelite-liitmine.mp4\",\"type\":\"video\/mp4\",\"title\":\"Kaustast k\\u00f5igi failide tabelite liitmine\",\"caption\":\"Kaustast k\\u00f5igi failide tabelite liitmine\\n\",\"description\":\"Power Query koolituse teema 'Tabelite liitmine ridadena' video 'Kaustast k\\u00f5igi failide tabelite liitmine', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"4:02\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}},{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-content\/uploads\/2019\/09\/EX_PQ-003-0011-paringu-andmete-varskendamine-pivot-tabelis.mp4\",\"type\":\"video\/mp4\",\"title\":\"L\\u00e4bi p\\u00e4ringu andmete v\\u00e4rskendamine Pivot tabelis\",\"caption\":\"L\\u00e4bi p\\u00e4ringu andmete v\\u00e4rskendamine Pivot tabelis\\n\",\"description\":\"Power Query koolituse teema 'Tabelite liitmine ridadena' video 'L\\u00e4bi p\\u00e4ringu andmete v\\u00e4rskendamine Pivot tabelis', Power Query koolitus, Exceli koolitus, Exceli e-kursus, Kasulik Koolitus, Asko Uri, arvutikoolitus\\n\",\"meta\":{\"length_formatted\":\"3:12\"},\"dimensions\":{\"original\":{\"width\":1920,\"height\":1080},\"resized\":{\"width\":643,\"height\":362}},\"image\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64},\"thumb\":{\"src\":\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-includes\/images\/media\/video.svg\",\"width\":48,\"height\":64}}]}<\/script>\n<\/div>\n\t\n<p>Exceli koolituse II osa &#8220;Edasij\u00f5udnud&#8221; e-kursuses on 58 videot kogukestvusega 4 tundi ja 37 minutit. E-kursuses k\u00e4sitletavatest teemadest saad \u00fclevaate parema men\u00fc\u00fc jaotistel klikkides.<\/p>\n<p><span style=\"color: #333333;\">Videote vaatamiseks\u00a0vali paremast men\u00fc\u00fcst soovitud\u00a0teema ja selle alt video ning sisesta kasutajanimi ja parool (\u00fchekordne toiming).\u00a0<\/span><span style=\"color: #333333;\">Soovitame vaadata videosid \u00fcleekraani vaates (video all ribal parempoolne nupp).<\/span><\/p>\n<p><span style=\"color: #333333;\">Kasuta e-kursusega t\u00f6\u00f6tamisel ka Exceli t\u00f6\u00f6vihikuid,\u00a0mille leiad Materjalid men\u00fc\u00fcst alavalikust\u00a0<a style=\"color: #333333;\" title=\"Exceli t\u00f6\u00f6vihikud edasij\u00f5udnud\" href=\"https:\/\/docs.google.com\/document\/d\/1ZOnzuWJTp3QXrOiNWh2xj4VUEViH_f-S3_Z47S_Sxqg\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">&#8220;Exceli t\u00f6\u00f6vihikud edasij\u00f5udnud&#8221;<\/a>.<\/span><\/p>\n<p><span style=\"color: #333333;\">Tagasiside ja k\u00fcsimused on alati oodatud:\u00a0<\/span><span style=\"color: #333333;\">Asko Uri,\u00a0<\/span><span style=\"color: #333333;\">E-post\u00a0<a style=\"color: #333333;\" href=\"mailto: asko@kasulikkoolitus.ee\">asko@kasulikkoolitus.ee<\/a>, tel: 55657400<\/span><\/p>\n<hr \/>\n<h3>Exceli edasij\u00f5udnute koolituse e-kursuse maksumus<\/h3>\n<p>Exceli edasij\u00f5udnute koolitusel osalenule on e-kursuse kasutus (nagu ka individuaalne j\u00e4reln\u00f5ustamine) koolituse hinna sees.\u00a0Koolitust on aga v\u00f5imalik l\u00e4bida e-kursuse abil ka iseseisvalt,\u00a0ostes sobivaima e-kursuse paketi. Pakettide erinevus seisneb koolitaja poolse individuaalse n\u00f5ustamise perioodis (puudub, 2 kuud v\u00f5i 12 kuud).<\/p>\n<table style=\"width: 582px;\">\n<tbody>\n<tr>\n<td><\/td>\n<td>Maksumus<\/td>\n<td>Kasutusaeg<\/td>\n<td>Uuendused<\/td>\n<td>N\u00f5ustamine<\/td>\n<td>Tunnistus<\/td>\n<\/tr>\n<tr>\n<td><strong>E-kursus<\/strong><\/td>\n<td>59 \u20ac + km<\/td>\n<td>piiramatu<\/td>\n<td>tasuta<\/td>\n<td>&#8211;<\/td>\n<td>&#8211;<\/td>\n<\/tr>\n<tr>\n<td><strong>E-kursus PLUS<\/strong><\/td>\n<td>79 \u20ac + km<\/td>\n<td>piiramatu<\/td>\n<td>tasuta<\/td>\n<td>2 kuud<\/td>\n<td>&#8211;<\/td>\n<\/tr>\n<tr>\n<td><strong>E-kursus EXTRA<\/strong><\/td>\n<td>99 \u20ac + km<\/td>\n<td>piiramatu<\/td>\n<td>tasuta<\/td>\n<td>12 kuud<\/td>\n<td>jah*<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin-top: -12px;\"><em><sub>* enne tunnistuse v\u00e4ljastamist toimub vestlus (telefon, Skype v\u00f5i Hangouts) koos ekraanipildi jagamisega<\/sub><\/em><\/p>\n<p>E-kursuse ostusoovi korral t\u00e4ida palun\u00a0<a href=\"https:\/\/kasulikkoolitus.ee\/exceli-koolitus-edasijoudnud\/#kontaktivorm\" target=\"_blank\" rel=\"noopener noreferrer\">kontaktivorm<\/a>, kirjuta\u00a0<a href=\"mailto:asko@kasulikkoolitus.ee\">asko@kasulikkoolitus.ee<\/a> v\u00f5i helista 55657400.<\/p>\n<hr \/>\n<h3>\u00d5ppe maht, aeg ja tunnistuse v\u00e4ljastamine<\/h3>\n<p class=\"entry-title\">Teave\u00a0koolituse toimumise perioodi, kestvuse, \u00f5piv\u00e4ljundite ja -eesm\u00e4rkide, \u00f5ppevahendite ning \u00f5piv\u00e4ljundite hindamise kohta on toodud\u00a0<a href=\"https:\/\/docs.google.com\/document\/d\/1ZOnzuWJTp3QXrOiNWh2xj4VUEViH_f-S3_Z47S_Sxqg\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">Exceli edasij\u00f5udnute koolitus E-KURSUSENA \u00f5ppekavas<\/a>.<\/p>\n<hr \/>\n<p class=\"entry-title\"><span style=\"color: #ffffff;\"><a style=\"color: #ffffff;\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1WgXZXTXDw76u_r8H1ein-mwjjx8tyzRMAA64xisdkKo\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0Link<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exceli koolituse II osa &#8220;Edasij\u00f5udnud&#8221; e-kursuses on 58 videot kogukestvusega 4 tundi ja 37 minutit. E-kursuses k\u00e4sitletavatest teemadest saad \u00fclevaate parema men\u00fc\u00fc jaotistel klikkides. Videote vaatamiseks\u00a0vali paremast men\u00fc\u00fcst soovitud\u00a0teema ja selle alt video ning sisesta kasutajanimi ja parool (\u00fchekordne toiming).\u00a0Soovitame vaadata videosid \u00fcleekraani vaates (video all ribal parempoolne nupp). Kasuta e-kursusega t\u00f6\u00f6tamisel ka Exceli t\u00f6\u00f6vihikuid,\u00a0mille\u2026 <span class=\"read-more\"><a href=\"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":463,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-247","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-json\/wp\/v2\/pages\/247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-json\/wp\/v2\/users\/463"}],"replies":[{"embeddable":true,"href":"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-json\/wp\/v2\/comments?post=247"}],"version-history":[{"count":62,"href":"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-json\/wp\/v2\/pages\/247\/revisions"}],"predecessor-version":[{"id":2341,"href":"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-json\/wp\/v2\/pages\/247\/revisions\/2341"}],"wp:attachment":[{"href":"https:\/\/kasulikkoolitus.ee\/excel-edasijoudnud\/wp-json\/wp\/v2\/media?parent=247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}