Skip to main content

2021 SS1 Data Lab

Panopto Video Bookmarks for Data Tasks#

SheetTaskTime
01-FormatCenter Across Selection5:33
01-FormatGive row A25648-G25648 custom fill8:55
01-FormatFreeze Panes16:48
01-FormatDON'T CLICK OUT GRID VIEW!19:44
01-FormatValidate Data in Column C21:32
01-FormatPrint Title Rows26:53
02-Conditonal FormattingNC in Column C30:08
All SheetsSelect all Worksheets; set header and footers and margins etc.33:29
03-Hide G & MColumns37:57
04-Hide NC TotalsRows (only green rows)38:21
05-SummaryHighest No. of Jewish Veterans59:24
05-SummaryLowest (this was not demonstrated; same concept as previous with opposite function)
05-SummaryIdaho National Laboratory1:03:08
05-SummaryCopy Data Labels1:08:24
05-SummaryPaste Data Labels1:09:07
05-SummaryAutofit Row Height1:09:36
05-SummaryDivide two values1:10:54
05-SummaryDisplay Percentages to two Decimal places.1:14:21
05-SummaryGrab Handle and drag down1:14:48
12-Fall Class ScheduleV-LOOKUP37:58
13-sort NC Zip Codes19:05
14-sort state, then year22:23
15-Filter Disabled Workers30:15
16-Filter Language Goal42:06
17-FilterYear&Residential Customer43:16
17-FilterYear&Residential Customer Goal47:49
18-Chart 1 Data Start25:34
18-Chart 1 Data Goal37:14
19-Chart 2 Data Start39:02
19-Chart 2 Data Goal52:34
21-Pivot Table Report51:04
21-Pivot Table Report Goal1:02:36