Excel — Pivot tables 4: Coding consistency
Channel: Susanne Flach
Date: 2020-12-14

If you are inconsistent in your coding, e.g., with typos for your variable levels, this inconsistency will probably show up in pivot tables. While it can also be identified in other ways, here is how you spot and correct inconsistencies via pivot tables.

For data sets & a complete tutorial list see https://sfla.ch/tutorials/excel

The Excel tutorial playlist: https://www.youtube.com/playlist?list=PLIZN-827NSINRq4EtjXeoPlh-62akkXWa

Leave problems with the clip contents or suggestions for new clips in the columns below.