Skip to main content

Data Manipulation

This session is being revised. It will be similar to the below examples.

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 2021 Spring Semester Lecture 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