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

Exceli meistriklass: valemid ja funktsioonid

ITK-472

Duration: 2 days
Price:
250 € (+ VAT 20%)

Course overview:

Language: ENGLISH

MS Excel masterclass: formulas and functions



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

11.11-12.11.2019 2 days Exceli baaskoolitus 250 € (+ VAT 20%)
13.11-14.11.2019 2 days Exceli koolitus edasijõudnutele 250 € (+ VAT 20%)
2 days Exceli meistriklass: andmeanalüüs 250 € (+ VAT 20%)