1 Page PDF (837 KB)

• PDF (A4)

• Vector graphics

• Printable

• All grades

• For business and educational purposes

Cheater John cheat sheet is not a replacement of the book. Use it as a quick reference guide.

Computer - Microsoft Office

Excel 2010 All Functions 1  NEW

134 Functions, 157 Examples in one page!

Date and Time Functions

DATE, DATEVALUE, DAY, DAYS360, EDATE, EOMONTH, HOUR, MINUTE, MONTH, NETWORKDAYS, NETWORKDAYS.INTL, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, WORKDAY, WORKDAY.INTL, YEAR, YEARFRAC

Text and Date Functions

BAHTTEXT, CHAR, CLEAN, CODE, CONCATENATE, DOLLAR, EXACT, FIND, FIXED, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, T, TEXT, TRIM, UPPER, VALUE

Logical Functions

AND, FALSE, IF, IFERROR, NOT, OR, TRUE

Lookup and Reference Functions

ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS, HLOOKUP, HYPERLINK, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, ROW, ROWS, RTD, TRANSPOSE, VLOOKUP

Math and Trigonometry Functions

ABS, ACOS, ACOSH, AGGREGATE, ASIN, ASINH, ATAN, ATAN2, ATANH, CEILING, CEILING.PRECISE, COMBIN, COS, COSH, DEGREES, EVEN, EXP, FACT, FACTDOUBLE, FLOOR, FLOOR.PRECISE, GCD, INT, LCM, LN, LOG, LOG10, MDETERM, MINVERSE, MMULT, MOD, MROUND, MULTINOMIAL, ODD, PI, POWER, PRODUCT, QUOTIENT, RADIANS, RAND, RANDBETWEEN, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, SERIESSUM, SIGN, SIN, SINH, SQRT, SQRTPI, SUBTOTAL, SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, TAN, TANH, TRUNC

$3.99

$1.99