Excel Functions
This section will explain how to use excel built-in functions or formulas in Microsoft excel.
All excel functions are categorized by their functionality, we will describe the excel functions from the below categories:
1. Text Functions
This section will learn how to use Excel’s Text functions such as:
CHAR, CLEAN, FIND, CODE, EXACT, DOLLAR, PROPER, REPLACE, REPT, RIGHT , SEARCH, SUBSTITUTE , T , TEXT , TEXTJOIN, LEFT, UPPER, LOWER, CONCAT, VALUE, LEN, MID, FIXED
2. Lookup And Reference Functions
This section will learn how to use Excel’s Lookup And Reference Functions such as:
ADDRESS, AREAS , CHOOSE, COLUMN, COLUMNS, Hlookup, HYPERLINK, INDEX, INDIRECT, LOOKUP, VLOOKUP, MATCH, ROWS, ROW
3. Date And Time
This section will learn how to use Excel’s Date And Time Functions such as:
Date, EDATE，Datedif, Day, Days, Days360, Hour, Now, Time, Weekday,WEEKNUM ,WORKDAY , WORKDAY.INTL ,YEAR,TIMEVALUE ,TIME
4. Math And Trigonometry
This section will learn how to use Excel’s Date And Time Functions such as:
ABS, ACOS, ACOSH, Aggregate, ASIN, ASINH, ATAN, ATAN2 , ATANH , CEILING, CEILING.PRECISE, COMBIN, COMBINA, COS, COSH, DEGREES, EVEN, EXP, FACT, FLOOR, INT, LN, LOG, LOG10, MDETERM, MINVERSE, MMULT, MOD, ODD, PI, POWER, PRODUCT, RADIANS, RAND, RANDBETWEEN, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SIN, SINH, SQRT, SUBTOTAL, SUM , SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMXMY2, SUMX2PY2, TAN , TANH , TRUNC.
5. Statistical
This section will learn how to use Excel’s Statistical Functions such as:
Avedev, Average, AverageA, AverageIF, AverageIFS, BETA.DIST, BETADIST, BETA.INV, BETAINV, BINOM.DIST, BINOM.INV, BINOMDIST, CHIDIST, CHIINV, CHITEST, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, COVAR, FORECAST, FREQUENCY, GROWTH, INTERCEPT, LARGE, LINEST, MAX, MAXA, MEDIAN, MIN, MINA, MODE, MODE.MULT, MODE.SNGL, PERCENTILE, PERCENTRANK, PERMUT, QUARTILE, RANK, SLOPE, SMALL, STDEV, STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA
6. Logical
This section will learn how to use Excel’s Logical Functions such as:
AND, FALSE, IF, IFError, IFNA, Nested IF function, nested if statements with ranges, OR, NOT, FALSE, TRUE, SWITCH
7. Information
This section will learn how to use Excel’s Information Functions such as:
Cell, Error.type, Info, ISBlank, ISError, ISNUMBER, ISERR, ISNA, ISTEXT, ISNONTEXT, ISREF, N, Type, NA
8. Financial
This section will learn how to use Excel’s Logical Functions such as:
Accrint, AccrintM, Amordegrc, Amorlinc, DB, DDB, FV, IPMT, IRR, ISPMT, MIRR, NPER, NPV, PMT, PPMT, RATE, PV, SLN, SYD, VDB, XIRR
9. Database
This section will learn how to use Excel’s Database Functions such as: Daverage, Dcount, DcountA, Dget, Dmax, Dmin, etc.
10. Engineering
This section will learn how to use Excel’s Engineering Functions such as: Bin2Dec, Bin2Hex, Bin2Oct, Complex, Convert, etc.
