Who this course is for:

• This course is suitable for any level of Excel user from beginning to advanced but it is mostly geared toward beginning and intermediate level learners.

• This course is for you if you are looking for a clearer understanding of how to use functions, where to find them and some tips and tricks to make your work with functions easier

. This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

If you're ready to gain full control of Excel Formulas TODAY, take the “Microsoft Excel - Top 51 Formulas in 50 minutes " course right now and master the following formulas:

· Financial Functions - PV, FV, NPV, PMT, PPMT

· Lookup & Reference Functions such as - VLOOKUP, HLOOKUP, INDEX, MATCH, INDEXMATCH

· Logical Functions - IF, IFS, IFNA, IFERROR, OR, AND

· Math & Trig Functions - SUM, SUMIF, SUMIFS, AVERAGE, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, ROUND, ROUNDDOWN, ROUNDUP

· Text Functions - CONCAT, UPPER, PROPER, LOWER, LEN, REPLACE, SUBSTITUTES, LEFT, RIGHT, MID, TRIM

· Date & Time Functions - NOW, TODAY, DAY, MONTH, YEAR, TIME, HOUR, MINUTE, SECOND