How to Analyze Demographic Data with Pivot Tables
85 هزار بار بازدید -
7 سال پیش
-
Pivot tables are the fastest,
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): https://gum.co/CDbfK
-----
Soar beyond the dusty shelf report with my free 7-day course: https://depictdatastudio.teachable.co... 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.
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): https://gum.co/CDbfK
-----
Soar beyond the dusty shelf report with my free 7-day course: https://depictdatastudio.teachable.co... 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.
7 سال پیش
در تاریخ 1396/01/31 منتشر شده
است.
85,055
بـار بازدید شده