Data Manipulation

08:00 Class Recording | 10:10 Class Recording

note

Download and use this Gradesheet as a checklist before submitting full project to SAKAI by April 26 at 11:55 p.m. This sheet covers all sessions and is repeated at the top of each session: 04/02, 04/09, 04/16, & 04/23

Sort: single level#

  1. Sort the data rows on the 13-sort NC ZIP codes worksheet by ZIP Code.
  2. Have the sort display from smallest to the largest.
  • Mac Video from previous class (different data; same concept): Single-level sort

Sort: multi-level#

  1. Sort the data rows on the 14-SORT STATE, THEN YEAR worksheet
  2. first by State alphabetically (from A to Z)
  3. and then by Year completed from SMALLEST to largest.

Filter: single level#

  1. Filter the data on the15-Filter Disabled Workers worksheet to find the bottom three Congressional Districts in terms of Disabled Workers
  2. Do not sort the results. Simply show the results of filtering out all but the bottom three districts.

Filter: multi-level (1 of 2)#

  1. 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
  2. had Receipt Count (excluding 53rd week) between 1000 and 4000

Filter: multi-level (2 of 2)#

Filters are powerful. Do another one:

  1. Use a multilevel filter on the 17-Year & ResidentialCustomer worksheet to find out which of the Month of PeriodEndDate only in March
  2. had an above average ResidentialCustomerCount

Pivot Table#

Too much detail on this page to condense here so here is the link to the Pivot Table Task on Class Web Page

Mac Users may benefit from looking at these few slides » Mac pivot table filter set as (blank) « for the last step in setting up the filter for showing blanks.

Edit this page