| 1. Setup worksheet Screenshots | — | — |
| Getting Started: Download the setup worksheet file | 00 | Video: 00a-Download Working File |
| Save File and Setup 05 Summary Sheet | 00 | Video:00b-Save File & Setup 05 Summary |
| Tips on Selecting a Large Data Set | 01a | Video: 01a-Tips on Selecting a Large Data Set |
| Format 01 as a Table and Highlight a Cell | 01b | Video: 01b-Format as Table and Apply Cell Color |
| Freeze Panes and Validate Data | 01c | Video: 01c-Freeze panes and validate Data |
| 2. Rows to Repeat at Top Info Screenshots | 01d | Video: 01d-Rows to Repeat at Top |
| Set up all Worksheets (will demo last week of module) | — | grade sheet recommends doing this after all tasks are done |
| 3. Conditional Formatting Screenshots | 02 | Video: 02-Conditional Formatting |
| Hiding Columns B & F | 03 | Video: 03-Hiding Columns B & F |
| Hiding Row 81 | 04 | Video: 04-Hiding Row 81 |
| 4. Formulas and Functions Info | — | — |
| Summary: Pull Vectored Data | 05a | Video: 05a-Summary Vector Demo |
| Earliest Foundation Date | 05b | Video: 05b-Earliest Foundation Date |
| Total Numbers of Counties in the US | 05c | Video: 05c-Total Number of Counties in the US |
| Number of Navy Programs in North Carolina | 05d | Video: 05d-Number of Navy Programs |
| VLOOKUP | 06 & 07 | Video: 05e-VLOOKUP |