Kasulik Koolitus
Menüü
  • Avaleht
  • Distantsõpe
  • Exceli koolitus “Alg- ja kesktase”
  • Exceli koolitus “Edasijõudnud”
  • Exceli makrode koolitus
  • Exceli lisakoolitused (3)
    • Exceli Pivot Table koolitus (1 päev)
    • Exceli Power Query koolitus (1 päev)
    • Diagrammid ja andmete visualiseerimine Excelis (1 päev)
  • Excel Courses in English
  • Outlooki koolitus
  • PowerPointi koolitus
  • Wordi koolitus
  • Google koolitused (3)
    • Google Drive ja Docs koolitus
    • Google kalendri koolitus
    • Gmaili koolitus
  • Kodulehe koolitus
  • Prezi koolitus
  •  Koolitajad & partnerid
    • Koolitajad
    • Partnerid
  • Koolituste kvaliteet
  • E-kursused
  • 55657400
  • asko@kasulikkoolitus.ee

OÜ KehaMeeleKool on positiivselt läbinud Eesti Kõrg- ja Kutsehariduse
Kvaliteediagentuuri poolt läbi viidud lävendipõhise kvaliteedi hindamise.

Oleme esitanud majandus-
tegevusteate täiskasvanute täienduskoolituste korraldamise kohta. Täidame kõiki täiskasvanute koolituse seaduse ning haridus- ja teadusministri määruse  nr 27 (19.06.2015) „Täienduskoolituse standard“ nõudeid.

Lisaks kindlusele koolitaja valikul tähendab see, et meilt saavad koolitusi tellida ka kõik riiklikud asutused.

  • Kuva videod
  • Arvutikoolitused
    • 00 Peidus algus
    • 000 Excel Macros Course
      • 01 Getting Started (3)
      • 02 Creating and saving a macro (7)
      • 03. Using Macros (10)
      • 04. Visual Basic Editor (3)
      • 05 Getting to know Macros code (7)
      • 06 Working with the Macros code (11)
      • 07. More
    • 000 Exceli makrode koolitus
      • 01 Alustamine (3)
      • 02 Makro loomine ja salvestamine (7)
      • 03. Makrode kasutamine (10)
      • 04. Visual Basic Editor (3)
      • 05 Makro koodiga tutvumine (7)
      • 06 Makro koodiga töötamine (11)
      • 07. Lisad
    • Drive koolitus
      • 01 Dokumentide ja kaustade haldamine (13)
      • 02. Ligipääsu õiguste haldamine (11)
      • 03. Dokumentidega ühine töötamine (5)
      • 04. Kommentaaridega töö (5)
      • 05. Dokumentide leidmine ja vaadete seadistamine (7)
      • 06. Arvuti sünkroniseerimine Drive kontoga (3)
      • 07. Arhiveerimine (1)
      • 08. Lisad (9)
      • Kõik videod (57)
    • Excel Advanced Training
      • 01 SUMIF(S), AVERAGEIF(S), COUNTIF(S) functions (6)
      • 02 DSUM, DAVERAGE, DCOUNT(A) functions (4)
      • 03 IF, OR and AND functions (5)
      • 04 VLOOKUP, INDEX and MATCH functions (3)
      • 05 Rounding functions (1)
      • 06 Time functions (4)
      • 07 Text functions (3)
      • 08 Array formulas (1)
      • 09 Working with cells (9)
      • 10 Pivot Table (11)
      • 11 More data tools (7)
      • 12 Power Query (19)
      • 13 Protecting (5)
      • 14 Macros (4)
      • 15 ALL VIDEOS (82)
    • Excel Basic Training
      • 01 Getting started (4)
      • 02 Open, create, close, and save a workbook (3)
      • 03 Excel tools (2)
      • 04 Excel spreadsheet (6)
      • 05 Insert and format data (21)
      • 06 Formulas and functions (8)
      • 07 Relative, absolute and mixed references (3)
      • 08 Hiding and grouping rows or columns (3)
      • 09 View options (3)
      • 10 Sort and filter a data (3)
      • 11 Styles tools (4)
      • 12 Worksheet (3)
      • ALL VIDEOS (63)
    • Exceli edasijõudnute koolitus
      • 01 SUMIF(S), AVERAGEIF(S), COUNTIF(S) funktsioonid (6)
      • 02 DSUM, DAVERAGE, DCOUNT(A) funktsioonid (4)
      • 03 IF, OR ja AND funktsioonid (5)
      • 04 VLOOKUP, INDEX ja MATCH funktsioonid (3)
      • 05 Ümardamisfunktsioonid (1)
      • 06 Ajafunktsioonid (4)
      • 07 Tekstifunktsioonid (3)
      • 08 Lahtritega töötamine (10)
      • 09 Pivot Table (11)
      • 10 Andmetööriistad (6)
      • 11 Power Query (11)
      • 12 Kaitsmine (5)
      • 13 Makrod (4)
      • Kõik videod (73)
    • Google kalender
      • 01 Kalendri vaated ja seaded (5)
      • 02 Sündmused (5)
      • 03 Sündmuse ja kalendri jagamine (6)
      • 04 Teised sündmuste tüübid (4)
      • 05 Kalendri jagamine (3)
      • 06 Kalendrite lisamine (4)
      • 07 Meeldetuletused (1)
      • Kõik videod (28)
    • Google konto ja rakendused
      • 01. Google tooted ja veebilehitseja valik (3)
      • 02. Google konto loomine ja sisselogimine (5)
      • 03. Google rakenduste avamine (5)
      • 04. Google konto haldamine (4)
      • Kõik videod (17)
    • Kodulehe tegemise koolitus WordPressiga
      • 01 Miks WordPress?
      • 02 Kodulehe nimi, serveriteenus ja WordPressi paigaldus (4)
      • 03 Sisuhalduse keskkond ja kodulehe vaade (6)
      • 04 Üldised seaded (3)
      • 05 Kasutajate haldamine (5)
      • 06 Kodulehe turvalisus ja pluginad (2)
      • 07 Kujunduse ehk teema valik (3)
      • 08 Lehtede ja postituste lisamine (10)
      • 09 Lehtede ja postituste avaldamise haldamine (4)
      • 10 Lehtede ja postituste sisu haldamine (8)
      • 11 Linkide lisamine (4)
      • 12 Piltide lisamine (6)
      • 13 Video ja helifaili lisamine (3)
      • 14 Meediafailide haldamine (4)
      • 15 Asukohakaardi lisamine (1)
      • 16 Kommentaaride haldamine (4)
      • 17 Menüüd (4)
      • 18 Moodulid (6)
      • 19 Menüüde ja moodulite haldamise võimalused (1)
      • 20 Kujunduse kohandamine (3)
      • 21 Kodulehest koopia tegemine (1)
      • 22 LISAD (7)
      • KÕIK VIDEOD (84)
    • Kuidas kasutada?
    • Meet ja Hangouts koolitus
      • 01 Meet (3)
      • 02 Hangouts (4)
      • Kõik videod (7)
    • Outlooki koolitus
      • 01. E-posti kontod (6)
      • 02. Alustamine (3)
      • 03. Vaate seaded (4)
      • 04. Kirjade lugemine (4)
      • 05. Otsing ja filtrid (6)
      • 06. Kirjade sorteerimine (3)
      • 07. Kirjade märgistamine (5)
      • 08. Kaustad ja kirjade suunamine (4)
      • 09. Rämpsposti seaded (2)
      • 10. Uus kiri, saaja ja kontaktid (7)
      • 11. Kirja sisu ja kujundus (9)
      • 12. Kirja saatmine ja õigekeel (5)
      • 13. Kirjale vastamine (4)
      • 14. Kiirtoimingud (2)
      • 15. Ülesanded (4)
      • 16. Kalender (23)
      • 17. LISAD (14)
      • KÕIK VIDEOD (105)
    • PWP PowerPointi koolitus
      • 01. Alustamine (4)
      • 02. Avamine, loomine, salvestamine ja sulgemine (4)
      • 03. Vaated ja tööriistad (4)
      • 04. Slaidide haldamine (7)
      • 05. Esitluse kujundus (6)
      • 06. Teksti sisestamine (9)
      • 07. Pildid (11)
      • 08. Kujundid (7)
      • 09. SmartArt (5)
      • 10. Tabelid (4)
      • 11. Diagrammid (2)
      • 12. Video ja heli (8)
      • 13. Vabakäe joonistus (2)
      • 14. Jalused (2)
      • 15. Slaidide üleminekud (4)
      • 16. Jaotiste ja slaidide pildilingid (2)
      • 17. Slaidi sisu animeerimine (13)
      • 18. Ettekandmiseks ettevalmistus (3)
      • 19. Esitluse ettekandmine (5)
      • Kõik videod (103)
    • WOR2010 Wordi koolitus
      • 01. Alustamine (4)
      • 02. Loomine, salvestamine, sulgemine, avamine (5)
      • 03. Tööriistad ja vaade (5)
      • 04. Teksti sisestamine (5)
      • 05. Sisu kleepimine ja importimine (4)
      • 06. Liikumine, märgistamine, otsing ja asendamine (5)
      • 07. Teksti kustutamine, teisaldamine ja sorteerimine (3)
      • 09. Laadide kasutamine ja vormindamine (14)
      • 10. Teksti ja lõikude vormindamine (11)
      • 11. Dokumendi vormindamine (5)
      • 12. MAIL MERGE (1)
How to use e-course
Excel Advanced Course, video from topic 'Macros': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Macros': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Macros': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Macros': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Protecting': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Protecting': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Protecting': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Protecting': 'Using IF and other functions in the PowerQuery', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Protecting': 'Add the conditional column', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Transform data with the PowerQuery', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Create the table from a folder', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Edit queries', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Import and transform data from a pdf file', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Import and transform data from a csv file', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Spliting data to columns', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Using formulas in the Power Query', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Creating the combined table from a folder', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Organizing queries and create tables from queries', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Add new tables into combined queries', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Unpivot columns', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Append rows and create new queries from files', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Append rows and create new queries from files', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'More options to merge columns', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'More options to merge columns', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Refreshing data in the combined table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Refreshing data in the combined table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Power Query': 'Merge columns and get data from files', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'More data tools': 'Merge columns from tables', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'More data tools': 'Why to use the Power Query and Excel versions', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'More data tools': 'Why to use the Power Query and Excel versions', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'More data tools': 'Another sample of the consolidated table and editing only visible cells', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'More data tools': 'Edit, reload and delete the consolidated table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'More data tools': 'Another sample of the consolidated table and editing only visible cells', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'More data tools': 'Creating the consolidated table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': 'Analyzing date data', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': 'Designing a Pivot Table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': 'Designing a Pivot Table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': 'Using filters and slicers', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': 'Create, edit and delete items', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': 'Create, edit and delete fields', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Pivot Table': 'Value field settings', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Working with cells': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Working with cells': 'Filling empty cells with data from above', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Working with cells': 'Removing rows with the same data in the column', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Working with cells': 'Removing rows with the same data in the column', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Working with cells': 'Using the Flash Fill tool', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Working with cells': 'Using the Flash Fill tool', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Working with cells': 'Extracting data from a cell by using formulas - LEN', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Working with cells': 'Split text to columns by the fixed width', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Array formulas': 'Split text to columns by the delimiter', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Text functions': 'Using array formulas', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Text functions': 'Replace content of the cell with new one - SUBSTITUTE function', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Text functions': 'Combine content from cells with a free text - CONCAT function and using & sign', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Time functions': 'PROPER, UPPER, LOWER and TRIM functions', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Time functions': 'Calculating the age from a birthdate', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Time functions': 'Using time functions indside a formula - DAYS, TODAY and NOW', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Time functions': 'NOW, HOUR, MINUTE, SECOND and TIME functions. Refreshing the time data.', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'Rounding functions': 'TODAY, MONTH, YEAR, WEEKDAY, WEEKNUMBER and DATE functions', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'VLOOKUP, INDEX and MATCH functions': '', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'VLOOKUP, INDEX and MATCH functions': 'INDEX and MATCH functions - bringing data from another table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'VLOOKUP, INDEX and MATCH functions': 'VLOOKUP function - find the same text and bring data from another table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'IF, OR and AND functions': 'VLOOKUP function - find the closest number and bring data from another table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'IF, OR and AND functions': 'Using letter(s) or phrase(s) as a criteria', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'IF, OR and AND functions': 'Using letter(s) or phrase(s) as a criteria inside an IF function', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'IF, OR and AND functions': 'OR and AND functions inside an IF function', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'IF, OR and AND functions': 'IF function - setting one or many logical tests', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'DSUM, DAVERAGE, DCOUNT(A) functions': 'Editing criterias or the formula of a database function', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'DSUM, DAVERAGE, DCOUNT(A) functions': 'DCOUNT function', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'DSUM, DAVERAGE, DCOUNT(A) functions': 'Using letter(s) or phrase(s) as a criteria', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'DSUM, DAVERAGE, DCOUNT(A) functions': 'Datebase functions - DSUM', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'SUMIF(S), AVERAGEIF(S), COUNTIF(S) functions': 'AVERAGEIFS and COUNTIFS functions', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'SUMIF(S), AVERAGEIF(S), COUNTIF(S) functions': 'SUMIFS function', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'SUMIF(S), AVERAGEIF(S), COUNTIF(S) functions': 'Using letter(s) or phrase(s) as a criteria', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'SUMIF(S), AVERAGEIF(S), COUNTIF(S) functions': 'AVERAGEIF and COUNTIF functions. Control answers from the status bar.', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'SUMIF(S), AVERAGEIF(S), COUNTIF(S) functions': 'Using a cell reference as a criteria. Quick ways of pasting formulas.', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Advanced Course, video from topic 'SUMIF(S), AVERAGEIF(S), COUNTIF(S) functions': 'SUMIFS function', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training

Arvutikoolitused

  • Exceli koolitus “Alg- ja kesktase”
  • Exceli koolitus “Edasijõudnud”
  • Exceli täiskoolitus asutustele
  • Wordi koolitus
  • Outlooki koolitus
  • Esitluse tegemise koolitus PowerPointiga
  • Esitluse koolitus Preziga
  • Kodulehe koolitus WordPressiga
  • Google Drive ja Docs koolitus
  • Gmaili koolitus
  • Google kalendri koolitus

Kontakt

KehaMeeleKool OÜ / Kasulik Koolitus™
asko@kasulikkoolitus.ee
tel: 55657400

Rüütli 4, 51007 Tartu
Reg nr 11670554
KMKR EE101309286

LHV Pank a/a EE707700771003618362
SWIFT/BIC: LHVBEE22,

Luminor a/a EE741700017002331786
SWIFT/BIC: NDEAEE2X

KehaMeeleKool OÜ I Kasulik Koolitus © 2009-2023