Session Three: Advanced functions and formulas
Download sample files for the Session Three sample lessons|
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction and Objectives | [PDF] | [Video] |
 |
| Lesson 3 1: Understand precedence rules and use the Evaluate feature |
 |
||
| Lesson 3 2: Use common functions with Formula AutoComplete | |||
| Lesson 3 3: Use the formula palette and the PMT function | |||
| Lesson 3 4: Use the PV and FV functions to value investments | |||
| Lesson 3 5: Use the IF logic function | [PDF] | [Video] |
|
| Lesson 3 6: Use the SUMIF and COUNTIF logic functions to create conditional totals |
|
||
| Lesson 3 7: Understand date serial numbers | |||
| Lesson 3 8: Understand common date functions | |||
| Lesson 3 9: Use the DATEDIF function | |||
| Lesson 3 10: Use date offsets to manage projects using the scheduling equation | |||
| Lesson 3 11: Use the DATE function to offset days, months and years | |||
| Lesson 3 12: Enter time values and perform basic time calculations | |||
| Lesson 3 13: Perform time calculations that span midnight | |||
| Lesson 3 14: Understand common time functions and convert date serial numbers to decimal values | |||
| Lesson 3 15 Use the TIME function to offset hours, minutes and seconds | |||
| Lesson 3 16 Use the AND and OR functions to construct complex Boolean criteria | |||
| Lesson 3 17 Understand calculation options (manual and automatic) | |||
| Lesson 3 18: Concatenate strings using the concatenation operator (&) | |||
| Lesson 3 19: Use the TEXT function to format numerical values as strings | |||
| Lesson 3 20: Extract text from fixed width strings using the LEFT, RIGHT and MID functions | |||
| Lesson 3 21: Extract text from delimited strings using the FIND and LEN functions | |||
| Lesson 3 22: Use a VLOOKUP function for an exact lookup | [PDF] | [Video] |
|
| Lesson 3 23: Use an IFERROR function to suppress error messages | |||
| Lesson 3 24: Use a VLOOKUP function for an inexact lookup | |||
| Session 3: Exercise | [PDF] |
|
|
| Session 3 Exercise Answers | |||