More than 400 functions are built into Microsoft Excel for simple to complex calculations. Regardless of your work or industry, which of these functions are likely to be most valuable to you to build formulas, analyze data, extract key information, and to more effectively use your Excel worksheets? In this session, focus on many of the frequently used and helpful functions in Microsoft Excel.
Areas Covered in the Session :
- Review of function basics and arguments; SUM, AVERAGE, MAX, MIN
- COUNT and COUNTA
- Creating named ranges
- Data analysis with IF, SUMIF, COUNTIF, and VLOOKUP
- DATE functions
- TEXT functions