Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel® Formulas (Excel® 2016)
Contents - Excel® 2016
Introduction (3:05)
FORMULAS 1 - Creating (1:19)
FORMULAS 2 - Mathematical Operators (5:35)
FORMULAS 3 - Creating with cell references (4:25)
FORMULAS 4 - Editing (2:15)
ERROR - #DIV0! (1:04)
ERROR - #REF! (1:30)
ERROR - #VALUE! (1:02)
ERROR - Circular Reference (2:51)
ERROR - Circular Reference - Find and Remove (2:32)
FORMULAS 4 - Introduction to Functions (2:57)
FUNCTION 1 - SUM (2:33)
ERROR - #NAME (1:06)
FORMULAS 5 - Visualize formulas instead of results (1:52)
FORMULAS 6 - Relative cell reference (12:31)
FORMULAS 7 - Absolute cell reference (12:00)
FORMULAS 8 - Mixed cell reference (7:19)
FORMULAS 9 - Copy Formula Result (3:27)
FORMULAS 9 - Copy formula only (2:38)
FORMULAS 9 - Work with several windows side by side (4:37)
FUNCTION 2 - IF (8:39)
FUNCTION 2 - ROUND (4:48)
FUNCTION 3 - NESTED FUNCTIONS (6:31)
FORMULAS 5 - Visualize formulas instead of results
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock