200+ Excel Formulas and Functions

Preface

Getting Started with Excel

• Using Excel
• Conclusion

The 10 Most Popular Functions in Excel

• SUM Function
• IF function
• LOOKUP function
• VLOOKUP function
• MATCH function
• CHOOSE function
• DATE function
• DAYS function
• FIND and FINDB functions
• INDEX function
• Conclusion
• Points to remember

Logical Functions in Excel

• AND function
• FALSE function
• TRUE function
• IFERROR function
• IFNA function
• IFS function
• NOT function
• OR function
• XOR function
• SWITCH function
• Conclusion
• Points to remember

Lookup and Reference Functions in Excel

• ADDRESS function
• AREAS function
• COLUMN and COLUMNS functions
• FILTER function
• FORMULATEXT function
• GETPIVOTDATA function
• HLOOKUP function
• HYPERLINK function
• INDIRECT function
• OFFSET function
• ROW and ROWS functions
• RTD function
• SORT and SORTBY functions
• TRANSPOSE function
• UNIQUE function
• XLOOKUP function
• XMATCH function
• Conclusion
• Points to remember

Math Functions in Excel

• ABS function
• ACOS and ACOSH functions
• ACOT and ACOTH functions
• ASIN and ASINH functions
• ATAN and ATANH functions
• CEILING and FLOOR functions
• COMBIN and COMBINA functions
• COS and COSH functions
• COT and COTH functions
• CSC and CSCH functions
• DECIMAL function
• DEGREES and RADIANS functions
• EVEN and ODD functions
• INT function
• LCM function
• LN and LOG functions
• MMULT functions
• MOD function
• POWER function
• PRODUCT function
• RAND and RANDBETWEEN functions
• ROMAN function
• ROUND, ROUNDUP, and ROUNDDOWN functions
• SEC and SECH functions
• SIGN function
• SIN and SINH function
• SQRT function
• SUBTOTAL function
• SUMIF, SUMPRODUCT, and SUMSQ functions
• TAN and TANH functions
• Conclusion
• Points to remember

Statistical Functions in Excel

• NORM.DIST and NORM.INV functions
• PERCENTILE.INC and PERCENTILE.EXC functions
• PHI function
• POISSON.DIST function
• PROB function
• QUARTILE.EXC and QUARTILE.INC functions
• RANK.AVG and RANK.EQ functions
• RSQ function
• SKEW and SKEW.S functions
• STDEVA and STDEVPA functions
• FORECAST and FORECAST.LINEAR functions
• GEOMEAN and HARMEAN functions
• The formula
• GROWTH function
• LOGNORM.DIST and LOGNORM.INV functions
• MEDIAN function
• MIN function
• NEGBINOM.DIST function
• STEYX function
• T.DIST, T.DIST.2T, and T.DIST.RT functions
• T.INV and T.INV.2T functions
• T.TEST function
• TREND function
• TRIMMEAN function
• VAR.P and VAR.S functions
• Z.TEST function
• Conclusion
• Points to remember

Text Functions in Excel

• CLEAN function
• CODE function
• CONCATENATE function
• DOLLAR function
• EXACT function
• FIND function
• FIXED function
• LEFT and RIGHT functions
• LEN function
• LOWER, UPPER functions
• MID function
• NUMBERVALUE function
• PROPER function
• REPLACE function
• SEARCH function
• SUBSTITUTE function
• Errors to avoid
• TEXT function
• TRIM function
• UNICHAR function
• UNICODE function
• VALUE function
• Conclusion
• Points to remember

Information Functions in Excel

• Cell function
• ERROR.TYPE function
• INFO function
• ISBLANK function
• ISERROR and ISERR functions
• ISEVEN and ISODD functions
• ISFORMULA function
• ISLOGICAL function
• ISNA function
• ISNUMBER function
• ISREF function
• ISTEXT function
• N function
• SHEET function
• Type function
• Conclusion
• Points to Remember

Financial Functions in Excel

• COUPDAYS, COUPNUM, and COUPPCD functions
• CUMIPMT and CUMPRINC functions
• DB and DDB functions
• DISC function
• DURATION and MDURATION functions
• EFFECT function
• INTRATE function
• IPMT function
• IRR, MIRR, and NPV functions
• NOMINAL function
• PRICE, YIELD, YIELDDISC, and YIELDMAT functions
• XIRR and XNPV functions
• VDB function
• Conclusion

Date and Time Functions in Excel

• DATE function
• Uses and applications
• DAY, MONTH, and YEAR functions
• The formula
• DAYS and DAYS360 functions
• EDATE and EOMONTH function
• HOUR, MINUTE, and SECOND functions
• ISOWEEKNUM and WEEKNUM functions
• NETWORKDAYS function
• NOW and TODAY functions
• TIME function
• WEEKDAY function
• Conclusion
• Points to remember

Database Functions in Excel

• DAVERAGE function
• DCOUNT function
• DCOUNTA function
• DGET function
• DMIN and DMAX functions
• DPRODUCT function
• DSUM function
• DSTDEV and DVAR functions
• Conclusion

Cube Functions in Excel

• CUBEMEMBER function
• CUBEKPIMEMBER function
• CUBEMEMBERPROPERTY function
• CUBERANKEDMEMBER function
• CUBEVALUE function
• Conclusion

Web Functions in Excel

• ENCODEURL function
• FILTERXML function
• WEBSERVICE function
• Conclusion

User-defined Functions in Excel

• CALL function
• EUROCONVERT function
• REGISTER.ID function
• Conclusion