Enroll Today


$125

Excel Formulas and Functions

Learn How to Use Formulas and Functions in Excel

Learn the basics of formulas and functions in Excel as well as the specifics of a hundred different Excel functions and take your knowledge of Excel to the next level today.

Example Curriculum

  Course Overview
Available in days
days after you enroll
  Introduction
Available in days
days after you enroll
  Cell Notation
Available in days
days after you enroll
  How Formulas and Functions Work
Available in days
days after you enroll
  Where to Find Functions
Available in days
days after you enroll
  Function Best Practices
Available in days
days after you enroll
  Copying Formulas
Available in days
days after you enroll
  SUM PRODUCT and SUMPRODUCT
Available in days
days after you enroll
  AVERAGE and AVERAGEA
Available in days
days after you enroll
  MEDIAN
Available in days
days after you enroll
  MODE MODE.SNGL and MODE.MULT
Available in days
days after you enroll
  MIN MINA MAX and MAXA
Available in days
days after you enroll
  ROUND ROUNDUP and ROUNDDOWN
Available in days
days after you enroll
  COUNT COUNTA and COUNTBLANK
Available in days
days after you enroll
  COUNTIF and COUNTIFS
Available in days
days after you enroll
  SUMIF and SUMIFS
Available in days
days after you enroll
  AVERAGEIF and AVERAGEIFS
Available in days
days after you enroll
  UPPER LOWER and PROPER
Available in days
days after you enroll
  LEFT RIGHT and MID
Available in days
days after you enroll
  TRIM
Available in days
days after you enroll
  CONCATENATE
Available in days
days after you enroll
  TEXT
Available in days
days after you enroll
  TODAY and NOW
Available in days
days after you enroll
  IF
Available in days
days after you enroll
  VLOOKUP
Available in days
days after you enroll
  AND and OR
Available in days
days after you enroll
  TRUE FALSE and NA
Available in days
days after you enroll
  RAND and RANDBETWEEN
Available in days
days after you enroll
  RANK RANK.EQ and RANK.AVG
Available in days
days after you enroll
  SMALL and LARGE
Available in days
days after you enroll
  IFNA and IFERROR
Available in days
days after you enroll
  NOT
Available in days
days after you enroll
  HLOOKUP
Available in days
days after you enroll
  TRANSPOSE
Available in days
days after you enroll
  INDEX and MATCH
Available in days
days after you enroll
  LEN
Available in days
days after you enroll
  SEARCH and FIND
Available in days
days after you enroll
  EXACT
Available in days
days after you enroll
  CONVERT
Available in days
days after you enroll
  ABS
Available in days
days after you enroll
  MOD QUOTIENT TRUNC and INT
Available in days
days after you enroll
  POWER and SQRT
Available in days
days after you enroll
  PI and SQRTPI
Available in days
days after you enroll
  EXP LOG LN and LOG10
Available in days
days after you enroll
  FACT COMBIN and COMBINA
Available in days
days after you enroll
  PV and NPV
Available in days
days after you enroll
  FORECAST
Available in days
days after you enroll
  FREQUENCY
Available in days
days after you enroll
  How Excel Handles Dates
Available in days
days after you enroll
  DATE
Available in days
days after you enroll
  YEAR MONTH DAY HOUR MINUTE and SECOND
Available in days
days after you enroll
  WEEKDAY WEEKNUM and ISOWEEKNUM
Available in days
days after you enroll
  DAYS and DAYS360
Available in days
days after you enroll
  EDATE and EOMONTH
Available in days
days after you enroll
  NETWORKDAYS and NETWORKDAYS.INTL
Available in days
days after you enroll
  WORKDAY and WORKDAY.INTL
Available in days
days after you enroll
  Combining Functions
Available in days
days after you enroll
  When Things Go Wrong
Available in days
days after you enroll
  Other Functions
Available in days
days after you enroll