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: 29.01 - 30.01.2020, at 09:30 Duration: 16 ac. hours Location: Vana-Lõuna 39/1
Price:
275 € (+ VAT 20%)
Time: 17.03 - 18.03.2020, at 09:30 Duration: 16 ac. hours Location: Vana-Lõuna 39/1
Price:
275 € (+ 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

29.01-30.01.2020 2 days Exceli baaskoolitus 275 € (+ VAT 20%)
05.02-06.02.2020 2 days Exceli koolitus edasijõudnutele 275 € (+ VAT 20%)
26.02-27.02.2020 2 days Exceli baaskoolitus 275 € (+ VAT 20%)
11.03-12.03.2020 2 days Exceli koolitus edasijõudnutele 275 € (+ VAT 20%)
04.05-05.05.2020 2 days Exceli baaskoolitus 275 € (+ VAT 20%)
14.05-15.05.2020 2 days Exceli koolitus edasijõudnutele 275 € (+ VAT 20%)