uCertify

200+ Excel Formulas and Functions

Get started with the full-power course & master everyday Excel functions like: SUM, IF, VLOOKUP, LOOKUP, & Index.

Lessons
AI Tutor (Add-on)
Get A Free Trial

About This Course

Supercharge your data skills with our 200+ Excel Formulas & Functions Course. 

Gain hands-on training to perform day-to-day data analysis. The advanced course for business professionals covers functions that one can perform to streamline their data analytics procedure & enhance their work productivity. It includes mathematical functions like SUM, AVERAGE, MIN, MAX, ROUND, INT, &Logical functions such as IF, AND, OR, NOT, TRUE, and FALSE. 

Develop your business intelligence by enrolling in the course & get access to a list of all Excel formulas curated just for your business. 

Skills You’ll Get

  • Efficiency Enhancement: Master your Excel skills with a top-tier formulas & Excel functions list to speed up your data & analytics tasks. 
  • Data Management Improvement: Organize, analyze, & present your data more efficiently with Excel formulas course & functions. 
  • Increased Work Productivity: Boost your work productivity by automating repetitive tasks & streamlining workflows.
  • Career Advancement: Elevate your career by enhancing your advanced Excel skills.
  • Mastering Navigation & Shortcuts: Master your Excel skills to use shortcuts for common tasks for easy navigation.
Download Course Outline

1

Preface

2

Getting Started with Excel

  • Using Excel
  • Conclusion
3

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
4

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
5

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
6

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
7

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
8

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
9

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
10

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
11

Date and Time Functions in Excel

  • DATE function
  • 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
12

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
  • Join our course's Discord space
13

Cube Functions in Excel

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

Web Functions in Excel

  • ENCODEURL function
  • FILTERXML function
  • WEBSERVICE function
  • Conclusion
15

User-defined Functions in Excel

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

Any questions?
Check out the FAQs

  Want to Learn More?

Contact Us Now

To learn Excel formulas & functions, you can start with the top-tier arithmetic operations & then navigate to advanced calculations. One can leverage the online resources, & practice formulas daily & even create an Excel formula cheat sheet for yourself. 

Here is the list of all Excel formulas: 

  • SUM
  • MIN & MAX
  • AVERAGE
  • COUNT
  • POWER
  • CEILING & FLOORa
  • CONCAT
  • TRIM

Hlookup, also known as Horizontal Lookup, is an Excel function used to search for a particular value in the above row of the table & then return a value in the specific row that you want to specify.  

To be specific, there are over 450 primary formulas in Excel. Learn these to perform basic arithmetic operations, complex calculations, as well as data manipulation, and many more. 

Related Courses

All Course