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)
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
Excel Basic Course, video from topic 'Worksheet': 'Add, rename, find, hide and delete the worksheet', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Styles tools': 'Conditional formatting', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Styles tools': 'Format as Table', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Styles tools': 'Use and edit cell styles', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Styles tools': 'Design cells and create a new cell style', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Sort and filter a data': 'Reapply or clear filters', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Sort and filter a data': 'Filtering the data', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Sort and filter a data': 'Sorting the data', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'View options': 'Compare the data from different sheets or workbooks', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'View options': 'Split a window view', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'View options': 'Freeze panes', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Hiding and grouping rows or columns': 'Auto outline the rows and columns', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Hiding and grouping rows or columns': 'Group and ungroup the rows and the columns', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Hiding and grouping rows or columns': 'Hide and unhide the rows and the columns', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Relative, absolute and mixed references': 'Change only the part of a cell reference to absolute', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Relative, absolute and mixed references': 'Change relative reference to absolute', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Relative, absolute and mixed references': 'Using data from another workbook. Change relative reference to absolute.', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Formulas and functions': 'Taking data into a function from another sheet', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Formulas and functions': 'Using the status bar instead of insert a function', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Formulas and functions': 'COUNT and COUNTA functions', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Formulas and functions': 'AVERAGE, MIN and MAX functions', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Formulas and functions': 'Copy functions into other cells', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Formulas and functions': 'Insert functions in Excel and SUM function', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Formulas and functions': 'Using formulas in Excel', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'How to bring and transform numbers with dots into Excel', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Fill multiple cells at the same time with same content', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Correct way to build up the tables', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Correct way to build up the tables', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Using the format painter. Format the columns instead of cells.', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Calculating time with a formula. Change format of a cell which incudes time.', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Using times', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Create custom date format', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Autofill dates', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Using dates', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Using percentages', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Change number format and create custom number format', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Increase and decrease decimal', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Autofill numbers', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Autofill text', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Indent the contents of a cell', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Wrap text in a cell', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Wrap text in a cell', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Change text orientation', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Using arrows or tab key?', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Insert and format data': 'Change region settings for inserting data in excel', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Excel spreadsheet': 'Change columns width and rows hight', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Excel spreadsheet': 'Choose a format for inserted rows and columns', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Excel spreadsheet': 'Insert, delete and move rows, columns and cells', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Excel spreadsheet': 'What is a table in excel?', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Excel spreadsheet': 'Selecting cells, rows and columns', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Excel spreadsheet': 'Structure of excel sheets and moving around', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Excel tools': 'Zooming tools', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Excel tools': 'Menu and tools and quick access toolbar', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Open, create, close, and save a workbook': 'Saving options', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Open, create, close, and save a workbook': 'Create a new workbook and use templates', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Open, create, close, and save a workbook': 'Find and open a workbook', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Getting started': 'Using the keyboard', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Getting started': 'Language settings', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Getting started': 'Starting an Excel program', Excel training, Excel e-course, Kasulik Koolitus, Asko Uri, computer training
Excel Basic Course, video from topic 'Getting started': 'Excel versions and getting the latest Excel', 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