Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Formulas and Functions
Course Overview
Course Overview (4:25)
Introduction
Introduction (0:41)
Cell Notation
Discussion (2:17)
Demonstration (4:44)
How Formulas and Functions Work
Discussion (5:37)
Demonstration (5:51)
Where to Find Functions
Discussion (1:50)
Demonstration (6:52)
Function Best Practices
Discussion (5:00)
Demonstration (5:49)
Copying Formulas
Discussion (3:37)
Demonstration (4:09)
SUM PRODUCT and SUMPRODUCT
Discussion (3:27)
Demonstration (3:40)
AVERAGE and AVERAGEA
Discussion (2:28)
Demonstration (4:17)
MEDIAN
Discussion (2:18)
Demonstration (1:43)
MODE MODE.SNGL and MODE.MULT
Discussion (3:08)
Demonstration (4:22)
MIN MINA MAX and MAXA
Discussion (1:52)
Demonstration (2:18)
ROUND ROUNDUP and ROUNDDOWN
Discussion (3:57)
Demonstration (4:28)
COUNT COUNTA and COUNTBLANK
Discussion (2:37)
Demonstration (2:30)
COUNTIF and COUNTIFS
Discussion (2:25)
Demonstration (3:08)
SUMIF and SUMIFS
Discussion (2:08)
Demonstration (1:48)
AVERAGEIF and AVERAGEIFS
Discussion (2:14)
Demonstration (1:39)
UPPER LOWER and PROPER
Discussion (1:36)
Demonstration (2:02)
LEFT RIGHT and MID
Discussion (1:33)
Demonstration (1:49)
TRIM
Discussion (0:54)
Demonstration (1:49)
CONCATENATE
Discussion (1:40)
Demonstration (1:25)
TEXT
Discussion (1:11)
Demonstration (2:09)
TODAY and NOW
Discussion (1:18)
Demonstration (1:25)
IF
Discussion (2:50)
Demonstration (3:21)
VLOOKUP
Discussion (2:29)
Demonstration (2:10)
AND and OR
Discussion (1:40)
Demonstration (3:46)
TRUE FALSE and NA
Discussion (2:33)
Demonstration (1:36)
RAND and RANDBETWEEN
Discussion (2:45)
Demonstration (1:18)
RANK RANK.EQ and RANK.AVG
Discussion (1:42)
Demonstration (2:24)
SMALL and LARGE
Discussion (0:49)
Demonstration (1:46)
IFNA and IFERROR
Discussion (2:54)
Demonstration (1:38)
NOT
Discussion (1:29)
Demonstration (3:56)
HLOOKUP
Discussion (1:02)
Demonstration (1:44)
TRANSPOSE
Discussion (1:20)
Demonstration (2:34)
INDEX and MATCH
Discussion (3:48)
Demonstration (4:35)
LEN
Discussion (1:12)
Demonstration (1:36)
SEARCH and FIND
Discussion (1:33)
Demonstration (1:30)
EXACT
Discussion (0:30)
Demonstration (1:35)
CONVERT
Discussion (0:36)
Demonstration (1:26)
ABS
Discussion (0:21)
Demonstration (0:27)
MOD QUOTIENT TRUNC and INT
Discussion (2:26)
Demonstration (2:01)
POWER and SQRT
Discussion (1:02)
Demonstration (1:11)
PI and SQRTPI
Discussion (1:06)
Demonstration (1:00)
EXP LOG LN and LOG10
Discussion (1:46)
Demonstration (1:32)
FACT COMBIN and COMBINA
Discussion (2:54)
Demonstration (2:39)
PV and NPV
Discussion (1:40)
Demonstration (3:28)
FORECAST
Discussion (2:07)
Demonstration (2:19)
FREQUENCY
Discussion (1:16)
Demonstration (1:41)
How Excel Handles Dates
Discussion (3:02)
Demonstration (1:47)
DATE
Discussion (2:01)
Demonstration (1:32)
YEAR MONTH DAY HOUR MINUTE and SECOND
Discussion (2:24)
Demonstration (2:28)
WEEKDAY WEEKNUM and ISOWEEKNUM
Discussion (1:35)
Demonstration (2:15)
DAYS and DAYS360
Discussion (0:50)
Demonstration (0:54)
EDATE and EOMONTH
Discussion (1:06)
Demonstration (1:06)
NETWORKDAYS and NETWORKDAYS.INTL
Discussion (1:17)
Demonstration (2:18)
WORKDAY and WORKDAY.INTL
Discussion (1:33)
Demonstration (2:00)
Combining Functions
Combining Functions (2:13)
When Things Go Wrong
Discussion (6:16)
Demonstration (3:45)
Other Functions
Other Functions (1:48)
Teach online with
Demonstration
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock