Excel Functions Tutorial (how-

Description

This provides the users with the opportunity to get an initial picture about various MS-Excel Functions.

You will find many questions, accompanied by their video-solutions about Microsoft Excel functions. Watching the videosolutions will allow you to get a good idea concerning the skills that you have and assess your level.

The videosolutions are classified into categories so as to let you focus wherever you believe there is some skill shortage. This is how there is almost no time wasted in repeating the parts that you are already familiar with.

The full version is known as TEST4U and constitutes a complete self-study, interactive guide, available since 2003, with more than 700.000 satisfied users.

The candidates can access the full training package in order to be able to respond successfully to Certification Examinations not only for MS-Excel, but also for MS-Word, MS-PowerPoint, MS-Access, Internet & Windows for the Basic or the Advanced level of Microsoft-Certiport Exams, ECDL-ICDL Exams, e.tc.



Functions included:

Error Solving
VALUE, ISERROR, IFERROR, ISFORMULA, ISTEXT, ISBLANK, ISERR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, FORMULATEXT

Text functions
FIND, EXACT, SEARCH, REPLACE, SUBSTITUTE, TEXT, CHAR, T(), REPT, PROPER, UPPER, LOWER, CONCATENATE, LEFT, MID, TRIM, RIGHT

Mathematical Functions
ABS, CEILING, EXP, FLOOR, INT, LN, MOD, PI, ROUND, PI,MROUND, PRODUCT, RAND, RANDBETWEEN, ROUND, ROUNDDOWN, ROUNDUP, SQRT, ABS, SUBTOTAL, SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ

Logical functions
AND, IF, OR, IF, NOT

Date and Time functions
DATE, DATEDIF, TODAY, HIDDEN, DATEVALUE, DAY, DAY, MONTH, YEAR, DAYS, DATEDIF, NETWORKDAYS, EDATE, EOMONTH, NETWORKDAYS, NOW, TIMEVALUE, TODAY, WEEKDAY, WORKDAY, WORKDAY.INTL

Lookup functions
CELL, CHOOSE, HLOOKUP, INDEX, INDEX, MATCH,, INDIRECT, ISREF, INDIRECT, LOOKUP, MATCH, SUM, OFFSET, VLOOKUP

Financial Functions
ACCRINT, ACCRINTM, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMPRINC,CUMIPMT, DB, DDB, DISC, DOLLARDE, DOLLARFR, DURATION, EOQ, FV, INTRATE, IPMT, IRR, LOGNORM.DIST,LOGNORM.INV, MDURATION, MIRR, NPER, NPV, PMT, PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RAND, NORM.INV, RATE, RECEIVED, SLN, SLOPE,INTERCEPT, STDEV.S, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, VDB, WEIBULL.DIST, XIRR, XNPV, YIELD, YIELDDISC, YIELDMAT


Statistical functions
AVERAGE, AVERAGEIF, AVERAGEIFS, BINOM.DIST, BINOM.INV, BINOM.INV, RAND, CORREL, CORRELATION, COEFFICIENT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, COVAR, COVARIANCE, COVARIANCE.S, COVARIANCE.P, DAVERAGE, DCOUNT, DMIN, DMAX, DSUM, EXPON.DIST, HYPGEOM.DIST, LARGE, MEDIAN, MODE, MIN, NEGBINOM.DIST, NORM.DIST, NORM.INV, PERCENTILE, PERCENTILE.EXC, PERCENTILE.INC, POISSON.DIST, QUARTILE, QUARTILE.INC, QUARTILE.EXC, RANK, SMALL, STDEV, STDEVP,STDEV.P, STDEV.S, SUM, MAX, COUNT, TREND, TRIMMEAN, GEOMEAN, VAR, VAR.S, VAR.P, VARP

Array Formulas
FREQUENCY, SUM,LARGE, TRANSPOSE

Cube Functions
CUBEKPIMEMBER, CUBEVALUE, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBESETCOUNT, CUBEVALUE