Contact us:
+372 618 1720
info@koolitus.ee

Exceli meistriklass: valemid ja funktsioonid

ITK-472

The same training will also take place at another time. Choose the appropriate
Time: 03.06 - 04.06.2019, at 09:00 Duration: 16 ac. hours Location: II korrus, Lõõtsa 8, Tallinn
Price:
250 € (+ VAT 20%)
Time: 21.08 - 22.06.2021, at 09:00 Duration: 16 ac. hours Location: II korrus, Lõõtsa 8, Tallinn
Price:
250 € (+ VAT 20%)

Course overview:

Language: ENGLISH

MS Excel masterclass: formulas and functions

Trainer: Jaan Vaabel


Contents:

Main topics include:

  • Introduction
  • Formulas and functions
  • Statistics functions: AVERAGE, COUNT, COUNTIF, CORREL, PERCENTILE, LARGE, QUARTILE etc.
  • Logical functions: IF, IFERROR, OR, AND, NOT etc.
  • Text functions: FIND, SEARCH, LEN, PROPER, UPPER, LOWER, SUBSTITUTE etc.
  • Financial functions: PMT, IPMT, PPMT, ISPMT, FV, EFFECT etc.
  • Math functions: ROUND, MROUND, INT, SUMIF, RAND, ROMAN etc.
  • Search and reference functions: LOOKUP, VLOOKUP, HLOOKUP, OFFSET, MATCH, ROW etc.
  • Date and time functions: DATE, YEAR, MONTH, DAY, WORKDAY, WEEKDAY, TODAY, NOW etc.
  • Other topics like protecting/locking the data and functions; preparing for printing etc.
  • Q&A
Additional information:

Additional value:

  • hot drinks, sweets and fruits available all the time;
  • lunch at each training day;
  • free parking.

Related

28.05-29.05.2019 2 days Exceli koolitus edasijõudnutele
Booked
250 € (+ VAT 20%)
10.06-11.06.2019 2 days Exceli meistriklass: andmeanalüüs 250 € (+ VAT 20%)
08.07-09.07.2019 2 days Exceli baaskoolitus 250 € (+ VAT 20%)
01.08-02.08.2019 2 days Exceli koolitus edasijõudnutele 250 € (+ VAT 20%)
12.08-13.08.2019 2 days Exceli meistriklass: andmeanalüüs 250 € (+ VAT 20%)