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)
