HDTutorial
EN
How to Analyze Satisfaction Survey Data in Excel with Countif

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

How to Analyze Satisfaction Survey Data in Excel with Countif

554,092 views October 27, 2013 4:16

Watch on YouTube
ChannelAnn K. Emery

Chapters

Description from the creator

Purchase the spreadsheet (formulas included!) that's used in this tutorial: gum.co/satisfactionsurvey

Follow along with the video:

00:00 Intro
00:33 Use =COUNTA to Find Out How Many People Answered Each Question
00:49 Use =COUNTBLANK to Find the Blanks
01:11 Use =COUNTIF to See How Many People Responded to Each Question
01:55 Use Simple Math to Find the Valid Percent
02:21 How to Make the Finished Table
02:33 Copy and Paste Questions into New Spreadsheet
02:51 Copy and Paste Ends/Total into New Spreadsheet
03:03 Copy and Paste Percentages into New Spreadsheet
03:19 Format to Make Look Better

-----

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. depictdatastudio.teachable.com/p/soar-beyond-th…

About this tutorial

Ann K. Emery published this 4:16 video tutorial on October 27, 2013. It has been watched 554,092 times on YouTube.

Category
Education
Duration
4:16
Published
October 27, 2013
Views
554,092
Likes
2,750

Tags

Share

This tutorial in other languages