Description: A guide to some of the more advanced functions available within the Logical, Mathematical, Date & Time and Lookup categories.
Course outline:
- Exploring the Formulas ribbon
- Comparing the Logical functions of IF and IFS
- Using the Statistical functions of COUNTIF and COUNTIFS
- Using the Math & Trig functions of SUMIF and SUMIFS
- Methods of rounding using ROUND, ROUNDDOWN and ROUNDUP
- The differential between dates using DATEDIF and NETWORKDAYS
- Deriving a new date using EDATE and EOMONTH
- Returning the current date/time using TODAY and NOW
- Manipulating a date using DAY, MONTH, YEAR and DATE
- Using the Lookup function of CHOOSE
Course Content
Not Enrolled
Course Includes
- 11 Lessons
- Course Certificate
Login
Accessing this course requires a login. Please enter your credentials below!