Increase your Excel calculation skills using statistical, date, text, financial, and lookup functions and learn how to check for errors in a worksheet.
Course Outcomes
Upon successful completion of this course, you will be able to:
- Create formulas
- Use absolute and mixed cell referencing
- Work with names ranges
- Create formula arrays
- Understand how to work with functions
- Use common statistical, date, text, and lookup functions
- Apply conditional formatting and use logical operations
- Audit a worksheet
- Attach cell comments
- Check for errors in a worksheet
- Use financial functions