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, REPTRIGHT , SEARCH, SUBSTITUTE , T , TEXT , TEXTJOINLEFT, 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, INDEXINDIRECTLOOKUP, VLOOKUP, MATCH, ROWS, ROW

3. Date And Time

This section will learn  how to use Excel’s Date And Time Functions such as:

Date, EDATEDatedif, 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:

 ABSACOSACOSHAggregateASINASINHATAN, ATAN2 ,  ATANH ,  CEILING, CEILING.PRECISE, COMBIN, COMBINA, COS, COSH, DEGREES, EVEN, EXP, FACT, FLOOR, INT, LN, LOG, LOG10, MDETERM, MINVERSE, MMULT, MOD, ODD, PI, POWERPRODUCTRADIANSRANDRANDBETWEEN, ROMANROUNDROUNDDOWNROUNDUP, SIGN, SIN, SINH, SQRT, SUBTOTALSUM SUMIFSSUMPRODUCTSUMSQSUMX2MY2SUMXMY2SUMX2PY2TAN , 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, COUNTIFCOUNTIFSCOVARFORECASTFREQUENCYGROWTHINTERCEPT, LARGE, LINEST, MAXMAXAMEDIAN, MIN, MINAMODEMODE.MULTMODE.SNGLPERCENTILEPERCENTRANKPERMUTQUARTILERANKSLOPE, SMALLSTDEVSTDEVASTDEVPSTDEVPAVARVARAVARPVARPA

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, ORNOTFALSETRUE, SWITCH

7. Information

This section will learn  how to use Excel’s  Information Functions such as:

 Cell, Error.type, Info, ISBlank, ISErrorISNUMBERISERRISNAISTEXTISNONTEXTISREFNTypeNA

8. Financial 

This section will learn  how to use Excel’s  Logical Functions such as:

 Accrint, AccrintM, AmordegrcAmorlinc, DBDDBFVIPMTIRRISPMT, MIRR, NPERNPVPMTPPMTRATEPV, SLNSYD, VDBXIRR

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.

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar