Setup Workbook
My recitation from Spring 2024 did not meet so I used Dr. Bergquist's recording and added bookmarks. He is better at Excel than I am, so enjoy!
Download Datasets Workbook: task04f2024.datasets.xlsx from Canvas.
Gradesheet: task042024gradesheet.xlsx
| Task | Video Link |
|---|---|
| Download file It is a large file... be patient. don't follow instructions in this video. Get the files from above. It takes some time to download. | 0:00 |
| Enable Editing ( if you don't get the enable editing message, disregard this segment) | 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 date 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; this will be in next week's session. |