Setup Workbook
Since we don't have class today, I have edited Dr. Berqquist's recitation recording so that the downtime in the class has been removed and I have set up a Table of Contents. He did not get to the last task on the 05-Summary worksheet. We will pick up there and get that done in recitation next week.
Prepare Worksheet | Prepare Workbook | Conditional Formatting | Formulas/Functions
| Task | Video Link |
|---|---|
| Download file It is a large file... be patient. It takes some time to download. | 0:00 |
| Enable Editing | 1:20 |
| Save File Name | 2:30 |
| Create 05 Summary and move it to correct position | 3:49 |
| 01-Format: Make top row green | 5:54 |
| 01-Format: Change font to Century Gothic 16 pt | 10:11 |
| 01-Format: Make the font white | 10:40 |
| 01-Format: Format the dat as a Table | 11:18 |
| 01-Format: Format your Home County with an Orange Fill | 15:54 |
| 01-Format: Freeze Panes | 21:16 |
| 01-Format: Reformat and validate data in Column D | 24:13 |
| Section 2: Prepare Workbook | 33:17 |
| 01-Format: Setup Header Row for Print Display | 34:38 |
| Format all Sheets: Set up Footer | 39:26 |
| Format all Sheets: Set up Header | 41:58 |
| Format all Sheets: Set up Margins | 43:23 |
Format all Sheets: Set as letter, Landscape and then Over then Down | 44:15 |
| Deselect all your Selected Worksheets | 47:15 |
| 02-Conditional Format Demonstration | 47:51 |
| Hiding Data Intro | 52:53 |
| 03-Hide Column | 54:06 |
| 04-Hide Row | 55:30 |
| Section 4: Formulas/functions | 56:46 |
| 05-Summary: Earliest Foundation Date | 57:03 |
| 05-Summary: Total Number of Counties | 1:00:40 |
| 05-Summary: Navy programs in NC | 1:04:44 |
| 05- Summary: Pulling Vectored data from two worksheets | Not yet demonstrated |