This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
Linking Cells and Formula in Worksheet and Workbooks
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock