| ScreenCapture TimeStamp (Tape 4: 08-09-07) | ||
| Excel Module 4: Data Analysis With Functions | ||
| Topic | Time | Page |
| Freezing Worksheet Titles | 0:03:10 | 2 |
| Splitting Worksheet Windows | 0:06:23 | 4 |
| Zoom Levels | 0:09:20 | 6 |
| Conditional Formulas | 0:10:58 | 8 |
| "If" Function | 0:10:58 | 8 |
| Multiple "If's" | 0:19:05 | 10 |
| "If-And" | 0:29:12 | 12 |
| "If-Or" | 0:34:20 | 13 |
| "ISERROR" Function | N/A | 14 |
| "SumIf", "CountIf", "AverageIf" | 0:37:49 | 16-18 |
| Retrieving Data w/ Vlookup | 0:51:22 | 20 |
| Ranking Data | 1:01:40 | 22 |
| Percentile Function | 1:02:30 | 22 |
| PercentRank Function | 1:05:20 | 23 |
| Quartile Function | 1:07:08 | 24 |
| Rank Function | 1:08:45 | 25 |
| Date Function | 1:11:35 | 26 |
| Financial Functions | N/A | 34 |
| Text Functions | N/A | 36 |