Excel — Pivot tables 1: Basics
Channel: Susanne Flach
Date: 2020-12-14

Once we're done with coding, we often want to aggregate our data, that is, we want to know how often the levels of our variables occur in our data. This is a process known as cross-tabulation: Excel has a very powerful, very quick and less error-prone way of doing this, other than tirelessly counting via filtering — the pivot table.

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.