Excel – Power Functions
Learn to use 10 Excel functions recommended by the experts. Excel provides over 400 functions to perform a variety of calculations within your data. With this many functions, it’s guaranteed you’re missing out on some powerhouse formulas that can make your day easier. This course explores 10 functions recommended by experts to expedite your data analysis.
Covered in this course:
- Syntax, Criteria and Wildcards
- DATEDIF
- EDATE and EOMONTH
- CONVERT
- INDEX and MATCH
- INDEX MATCH MATCH
- OFFSET and COUNTA
- SUMPRODUCT
