About Excel Functions Tutorial (how-to) Videos
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.
TEST4U is available for PCs only, because it requires the existence of the installed applications of the respective MS-Office suite in order to cooperate adequately.
We encourage you to test your skills at the TEST4U Demo at https://www.test4u.eu/en/download-demo, in order to practice and prepare for the Exams.
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