Excel for Data Analysis

Date: 15-16 November 2016

Level: Intermediate

Fee: £280 for those from educational, government and charitable institutions; £390 others

 

Outline

This course is designed to provide a range of skills and techniques in the use of Excel for social and policy research. 

This course is aimed at people working in social and policy research in public, private and third sector organisations who want to improve their skills in the use of Excel.  The course includes a case study to build a profile of Manchester based on neighbourhood statistics.  Students who wish to use their own material for the course are welcome to do so – please contact the course team to discuss any preparatory work that might be necessary to enable you to do this.

 

Objectives

To enable the student to:

• load and prepare statistical data into Excel from a range of sources including Nomis, Neighbourhood Statistics as well as the considerations for the incorporation of data from organisational sources
• manage data in Excel including recoding, dealing with missing data, deriving new variables, filtering, sorting, totalling and deriving summary statistics through the use of formulae
• explore data using Excel including simple charts and pivot tables
• present data using Excel including charts and tables
• create profiles by combining a database of variables into a Word document using the Merge function

 

Prerequisites

A basic knowledge of Excel and Word and familiarity with social research or policy reports.

 

Recommended reading 

n/a

 

Further details

Further details about this course are available at http://www.cmist.manchester.ac.uk/study/short/intermediate/excel-for-data-analysis/

 

Booking

• Book your place on this course

 

 

CMIST Short Courses | G9 Humanities Bridgeford Street | University of Manchester | Manchester | M13 9PL

Tel 0161 275 0796

Internal 50796