Advanced Formulae & Functions (FULL COURSE)

Microsoft Excel cover image for advanced formulas and functions

The topics:

  • 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