Excel and Questionnaires: How to enter the data and create the charts

2.2KLikes

583,988Views

2013Feb 14

This is a tutorial on how to enter the results of your questionnaires in Excel 2010. It then shows you how to create frequency tables (using the countif function not the frequency function). The next stage is creating charts.

put in some headings at the top

3:25

put in a heading results for question 1

3:30

keep all the data on the first sheet

5:15

use the countif function in microsoft excel

6:21

Transcript

Follow along using the transcript.

Deirdre Macnamara

4.49K subscribers

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

Excel Campus - Jon

15M views10 years ago

How to enter survey data into Excel from a pen-and-paper questionnaire

Kent Lofgren

309K views10 years ago

How to tabulate, analyze, and prepare graph from Likert Scale questionnaire data using Ms Excel.

Edifo

448K views8 years ago

Office 2010, Excel Basics

Deirdre Macnamara

926 views13 years ago

Part 1 - Using Excel for Open-ended Question Data Analysis

Jacqueline C

342K views12 years ago

Learn SPSS IN 20 MINUTES. GO FROM ZERO TO HERO IN SPSS QUICKLY. ULTIMATE BEGINNERS GUIDE TO SPSS

SPSS4RESEARCH

170K views3 years ago

Setting up a survey codebook in Excel -- Tutorial

watsonpho1

37K views4 years ago

How to Download & Prepare Survey Data for Analysis in Excel

David Dunaetz

156K views7 years ago

How to create a table from survey data in Excel | Questionnaires & pivot tables for beginners

Kent Lofgren

104K views5 years ago

7 Excel Time Hacks Everyone Should Know | Learn Excel the FAST Way!

Excel University

479K views2 years ago

Analysing Questionnaires

Southampton Education School

324K views12 years ago

9 Excel Functions Made Easy (VLOOKUP, IF, SUMIF, INDEX MATCH and more)

Spreadsheeto

25K views3 years ago

How to use Microsoft Access - Beginner Tutorial

Kevin Stratvert

4.1M views4 years ago

Enter Questionnaire Data in Stata | Survey Data in Stata

The Data Hall

23K views3 years ago

Easiest way to Code Open Ended Survey Responses

One Year Dissertation

42K views4 years ago

How to SORT Data in Excel | 7 Tips

Chris Menard

135K views3 years ago

Excel Solver & Goal Seek Tutorial

Kevin Stratvert

209K views4 years ago

How to keep Inventory using an Excel Spreadsheet - [create your own Template]

Mr.SpreadSheet

958K views4 years ago

Excel for Beginners - The Complete Course

Technology for Teachers and Students

12M views2 years ago

How to create figures in Excel: Survey/questionnaire results/data | APA Style graphs

Kent Lofgren

154K views9 years ago

Excel and Questionnaires: How to enter the data and create the charts

Key moments View all

put in some headings at the top

put in some headings at the top

put in some headings at the top

put in a heading results for question 1

put in a heading results for question 1

put in a heading results for question 1

keep all the data on the first sheet

keep all the data on the first sheet

keep all the data on the first sheet

use the countif function in microsoft excel

use the countif function in microsoft excel

use the countif function in microsoft excel

select this column from cell a1 to a nine

select this column from cell a1 to a nine

select this column from cell a1 to a nine

use the countif function

use the countif function

use the countif function

Deirdre Macnamara

Excel and Questionnaires: How to enter the data and create the charts

Comments 189

Key moments

put in some headings at the top

put in some headings at the top

put in some headings at the top

put in a heading results for question 1

put in a heading results for question 1

put in a heading results for question 1

keep all the data on the first sheet

keep all the data on the first sheet

keep all the data on the first sheet

use the countif function in microsoft excel

use the countif function in microsoft excel

use the countif function in microsoft excel

select this column from cell a1 to a nine

select this column from cell a1 to a nine

select this column from cell a1 to a nine

use the countif function

use the countif function

use the countif function

Description

Key moments View all

put in some headings at the top

put in some headings at the top

put in some headings at the top

put in a heading results for question 1

put in a heading results for question 1

put in a heading results for question 1

keep all the data on the first sheet

keep all the data on the first sheet

keep all the data on the first sheet

use the countif function in microsoft excel

use the countif function in microsoft excel

use the countif function in microsoft excel

Deirdre Macnamara

Transcript

Key moments

Key moments