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

Exceli meistriklass: valemid ja funktsioonid

ITK-472

Time: 08.10 - 09.10.2019, at 09:00 Duration: 16 ac. hours Location: Vana-Lõuna 39/1
Price:
250 € (+ VAT 20%)

Course overview:

Language: ENGLISH

MS Excel masterclass: formulas and functions

Trainer: Uno Kõrsmaa


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

17.09-18.09.2019 2 days Exceli koolitus edasijõudnutele
Booked
250 € (+ VAT 20%)
01.10-02.10.2019 2 days Exceli meistriklass: andmeanalüüs 250 € (+ VAT 20%)
03.10-04.10.2019 2 days Exceli baaskoolitus 250 € (+ VAT 20%)