$1.99
Excel 2007 All Functions and Examples Cheat Sheet
If you want to learn how to use Excel 2007 functions and advance your Excel skills, this one page pdf reference sheet is for you. 146 Excel functions and 161 function examples in one page!
As this sheet designed in vector graphics it has infinite resolution and could be printed in high quality.
It fits all levels and can be used for business and educational purposes.
There are below listed sections in this pdf reference sheet that available to download for Microsoft Excel 2007.
Excel 2007 Date and Time Functions
DATE, DATEVALUE, DAY, DAYS360, EDATE, EOMONTH, HOUR, MINUTE, MONTH, NETWORKDAYS, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, WORKDAY, YEAR, YEARFRAC
Excel 2007 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
Excel 2007 Logical Functions
AND, FALSE, IF, IFERROR, NOT, OR, TRUE
Excel 2007 Lookup and Reference Functions
ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS, HLOOKUP, HYPERLINK, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, ROW, ROWS, RTD, TRANSPOSE, VLOOKUP
Excel 2007 Math and Trigonometry Functions
ABS, ACOS, ACOSH, ASIN, ASINH, ATAN, ATAN2, ATANH, CEILING, COMBIN, COS, COSH, DEGREES, EVEN, EXP, FACT, FACTDOUBLE, FLOOR, 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
Excel 2007 Information Functions
CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT, N, NA, TYPE
Excel 2007 All Functions and Examples Cheat Sheet (PDF) Detail
No related posts.
