01-Format | Center Across Selection | 5:33 |
01-Format | Give row A25648-G25648 custom fill | 8:55 |
01-Format | Freeze Panes | 16:48 |
01-Format | DON'T CLICK OUT GRID VIEW! | 19:44 |
01-Format | Validate Data in Column C | 21:32 |
01-Format | Print Title Rows | 26:53 |
02-Conditonal Formatting | NC in Column C | 30:08 |
All Sheets | Select all Worksheets; set header and footers and margins etc. | 33:29 |
03-Hide G & M | Columns | 37:57 |
04-Hide NC Totals | Rows (only green rows) | 38:21 |
05-Summary | Highest No. of Jewish Veterans | 59:24 |
05-Summary | Lowest (this was not demonstrated; same concept as previous with opposite function) | |
05-Summary | Idaho National Laboratory | 1:03:08 |
05-Summary | Copy Data Labels | 1:08:24 |
05-Summary | Paste Data Labels | 1:09:07 |
05-Summary | Autofit Row Height | 1:09:36 |
05-Summary | Divide two values | 1:10:54 |
05-Summary | Display Percentages to two Decimal places. | 1:14:21 |
05-Summary | Grab Handle and drag down | 1:14:48 |
12-Fall Class Schedule | V-LOOKUP | 37:58 |
13-sort NC Zip Codes | | 19:05 |
14-sort state, then year | | 22:23 |
15-Filter Disabled Workers | | 30:15 |
16-Filter Language Goal | | 42:06 |
17-FilterYear&Residential Customer | | 43:16 |
17-FilterYear&Residential Customer Goal | | 47:49 |
18-Chart 1 Data Start | | 25:34 |
18-Chart 1 Data Goal | | 37:14 |
19-Chart 2 Data Start | | 39:02 |
19-Chart 2 Data Goal | | 52:34 |
21-Pivot Table Report | | 51:04 |
21-Pivot Table Report Goal | | 1:02:36 |