Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Formula and Functions
Excel Formula and Functions
Introduction to Calculations (8:22)
Creating Calculations (Formula) you can move or copy anywhere (14:22)
Top 10 Functions including SUM and AVERAGE, Text Functions and use Today's Date in Calculations (22:49)
Logical and Reference Functions including IF and VLOOKUP (29:09)
Linking Cells and Formula in Worksheet and Workbooks (4:53)
Date Calculations - when you need to use dates and or time in your calculations (19:38)
Using Copy and Paste Special (12:58)
Goalseek - when you have the answer and need to work backwards (6:32)
PMT - Financial Function - Learn how to work out payments due on a loan (4:59)
Teach online with
Top 10 Functions including SUM and AVERAGE, Text Functions and use Today's Date in Calculations
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock