| Section | Time Start | Time End | Pages |
| Intro | 0:00:00 | 3:00 | |
| Freezing worksheet titles | 3:00:00 | 0:03:03 | 2\3 |
| Splitting worksheet windows | 0:03:03 | 0:06:23 | 4\5 |
| Changing the display magnification | 0:06:23 | 0:11:40 | 6\7 |
| in auto-outline, how are the calculations grouped together | 0:11:40 | 0:17:45 | |
| If statements | 0:17:45 | 0:18:24 | 10\11 |
| If functions with multiple 'and' conditions | 0:18:24 | 0:42:26 | 14\15 |
| Defining a named range | 0:42:26 | 1:06:15 | 30\31 |
| Hlookup Function | 1:06:15 | 1:26:53 | 20\21 |
| Date functions | 1:26:53 | 1:32:01 | 22\23 |
| Charting excel data | 1:32:01 | 1:44:48 | 32\33 |
| Changing chart types | 1:44:48 | 1:57:54 | 42\43 |
| Chart options | 1:57:54 | 1:59:46 | 44\45 |
| Chart legend and formatting data markers | 1:59:46 | 2:02:02 | 46\47 |
| Adding trendlines to charts | 2:02:02 | 2:06:23 | 56\57 |
| How can I move my chart to a separate sheet? * | 2:06:23 | 2:12:33 | |
| How do you protect data? (keep someone from altering your work) | 2:12:33 | 2:13:43 | 60\61 |
| How to put a password on your file. | 2:13:43 | 2:21:25 | 70\71 |
| Data analysis: Creating scenarios | 2:21:25 | 2:23:00 | \72 |
| Analyzing data with goalseek | 2:23:00 | 2:23:40 | \80 |
| 2:37:17 | 96\97 |