Data Manipulation
Media | Link |
---|---|
Slides: | Data Manipulation Google Slides |
Class Recording: | This Class as a Panopto Recording |
Sort: single level​
- Sort the data rows on the
13-sort NC ZIP codes
worksheet by ZIP Code. - Have the sort display from smallest to the largest.
View 13-sort NC ZIP codes on Panopto Recording
Sort: multi-level​
- Sort the data rows on the
14-SORT STATE, THEN YEAR
worksheet - first by State alphabetically (from A to Z)
- and then by Year completed from SMALLEST to largest.
View 14-SORT STATE, THEN YEAR on Panopto Recording
Filter: single level​
- Filter the data on the
15-Filter Disabled Workers
worksheet to find the bottom three Congressional Districts in terms of Disabled Workers - Do not sort the results. Simply show the results of filtering out all but the bottom three districts.
View 15-Filter Disabled Workers on Panopto Recording
Filter: multi-level (1 of 2)​
- Use a multilevel filter on the
16-Language Preferences
worksheet to find out which of the languages whose names start with the letter A only - had Receipt Count (excluding 53rd week) between 1000 and 4000
View 16- Language Preferences on Panopto Recording
Filter: multi-level (2 of 2)​
Filters are powerful. Do another one:
- Use a multilevel filter on the
17-Year & ResidentialCustomer
worksheet to find out which of the Month of PeriodEndDate only in March - had an above average ResidentialCustomerCount
View 17-Year & Residential Customer Filters on Panopto Recording