Excel for Data Analysis

Date:

07/06/2017 - 08/06/2017

Organised by:

University of Manchester

Presenter:

Rebecca Bromley

Level:

Intermediate (some prior knowledge)

Contact:

Michelle Kelly
cmist-courses@manchester.ac.uk
0161 275 4579

Map:

View in Google Maps  (M13 9PL)

Venue:

The University of Manchester
Humanities Bridgeford Street Building

Description:

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

Cost:

£390 (£280 for those from educational, government and charitable institutions).

Website and registration:

Region:

North West

Keywords:

Quantitative Data Handling and Data Analysis, ICT and Software, Quantitative Software, Excel, Excel , social research , data preparation , charts and graphs , presenting information

Related publications and presentations:

Quantitative Data Handling and Data Analysis
ICT and Software
Quantitative Software
Excel

Back to archive...