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.
This post will guide you how to use Excel DVARP function with syntax and examples in Microsoft excel. Description The Excel DVARP Function will get the variance of a population based on the entire population of numbers in a column ...
This post will guide you how to use Excel DVAR function with syntax and examples in Microsoft excel. Description The Excel DVAR Function will get the variance of a population based on a sample of numbers in a column in ...
This post will guide you how to use Excel DSUM function with syntax and examples in Microsoft excel. Description The Excel DSUM Function will add the numbers in a column or database that meets a given criteria. And so you ...
This post will guide you how to use Excel DSTDEVP function with syntax and examples in Microsoft excel. Description The Excel DSTDEVP returns the standard deviation of a population based on the entire population of numbers in a column or ...
This post will guide you how to use Excel DSTDEV function with syntax and examples in Microsoft excel. Description The Excel DSTDEV returns the standard deviation of a population based on a sample of numbers in a column or database ...
This post will guide you how to use Excel DMIN function with syntax and examples in Microsoft excel. Description The Excel DMIN returns the minimum value from a database or a column of a list that matches the specified conditions. ...
This post will guide you how to use Excel DPRODUCT function with syntax and examples in Microsoft excel. Description The Excel DPRODUCT returns the product of values from a set of records that match criteria that you specify. The DPRODUCT ...
This post will guide you how to use Excel XIRR function with syntax and examples in Microsoft excel. Description The Excel XIRR function returns the internal rate of return for a series of cash flows that is not necessarily periodic. ...
This post will guide you how to use Excel VDB function with syntax and examples in Microsoft excel. Description The Excel VDB function calculates the depreciation of an asset for a specified period based on the double declining balance method. ...
This post will guide you how to use Excel SYD function with syntax and examples in Microsoft excel. Description The Excel SYD function calculates the sum-of-years’digits depreciation of an asset for a specified period. And it will return a numeric ...
