Η συμμετοχή στο σεμινάριο προϋποθέτει εμπειρία σε βασικές γνώσεις Microsoft Excel.
Συνοπτικό Πρόγραμμα Σεμιναρίου:
Numerical Functions
DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DSUM
Date and time functions
DATE, DATEVALUE, DAY, DAYS360, HOUR, MINUTE, MONTH, NETWORKDAYS, NOW, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, WORKDAY, YEAR,
Key Financial functions
Information functions
CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT, N, NA,
Logical functions
AND, FALSE, IF, NOT, OR, TRUE
Lookup and reference functions
COLUMN, COLUMNS, GETPIVOTDATA, HLOOKUP, HYPERLINK, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, ROW, ROWS, RTD, TRANSPOSE, LOOKUP,
Key Math and trigonometry functions
Statistical functions
AVERAGE, AVERAGEA, COUNT, COUNTA, COUNTBLANK, COUNTIF, MAX, MAXA, MEDIAN, MIN, MINA,
Text functions
CHAR, CLEAN, CONCATENATE, DOLLAR, EXACT, FIND, FINDB, FIXED, LEFT, LEFTB, LEN, LENB, LOWER, MID, MIDB, PROPER C,REPLACE, REPLACEB, REPT, RIGHT, RIGHTB, SUBSTITUTE, T, TEXT, TRIM, UPPER, VALUE,