Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Functions
Introduction
Introduction (0:41)
What are you going to learn from this module? (0:59)
How to practice (1:52)
Foundation of functions
What is a function? (1:18)
How to use any functions (2:40)
Conditional functions
Introduction to the IF function (1:26)
Use the IF function (2:56)
Nested IF functions (5:43)
IFS (4:47)
IF, OR + AND (3:47)
SUMIF (2:41)
SUMIFS (3:17)
COUNTIF (1:26)
COUNTIFS (2:17)
MAXIFS and MINIFS (3:51)
Functions for working with text
LEFT, RIGHT, and MID (3:19)
Finding the length of a cell (0:52)
SEARCH (1:37)
Combination of text functions (3:10)
Joining cells (2:06)
Date functions
Working with dates (2:33)
Dissecting dates (1:33)
Using today’s date in Excel (4:34)
Toolbox features
Typical errors (3:23)
IFERROR (2:00)
Evaluating formulas (1:40)
Named ranges (2:56)
Wrapping up
Certificate (0:47)
What now? (1:05)
Bonus
Assignments (0:42)
What are you going to learn from this module?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock