HDTutorial
EN
How to Analyze Demographic Data with Pivot Tables

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Analyze Demographic Data with Pivot Tables

94,548 views October 28, 2017 22:42

Watch on YouTube
ChannelAnn K. Emery

Chapters

Description from the creator

Pivot tables are the fastest, easiest way to make sense of spreadsheets. In this video, I show you how to use pivot tables to quickly tally demographic data -- how many people are in the spreadsheet, how many males and females are included, and so on.

00:00 Why Use Pivot Tables to Analyze Data?
00:22 What is Demographic Data?
00:38 Step 1 – Organize the Spreadsheet
00:45 How to Freeze Rows So They Stay in View
01:52 Insert Filters to Make Data Easier to Sort
03:43 Resize Columns
05:43 Wrap Text to Show Values
06:20 Step 2 – Ensure Pivot Table Prerequisites Are Met
06:28 Prerequisite #1 – Every Column Needs a Label
07:00 Prerequisite #2 – You Need Contiguous Cells
08:56 Step 3 – Insert a New Pivot Table
10:10 Get Organized!
10:59 Step 4 - Navigate the Pivot Table
12:47 Step 5 – Run Frequencies
14:58 Step 6 – Look at Two Variables at a Time
17:15 Step 7 – How to Use Filters
19:13 Step 8 – Explore Missing Data
22:18 Step 9 – Refresh Data

-----

Purchase the spreadsheet and handout used in this video ($5): gum.co/CDbfK

-----

Soar beyond the dusty shelf report with my free 7-day course: depictdatastudio.teachable.com/p/soar-beyond-th… Most "professional" reports are too long, dense, and jargony. Transform your reports with my course. You'll never look at reports the same way again.

About this tutorial

Ann K. Emery published this 22:42 video tutorial on October 28, 2017. It has been watched 94,548 times on YouTube.

Duration
22:42
Published
October 28, 2017
Views
94,548
Likes
996

Tags

Share

This tutorial in other languages