Excel for Data Analysis
Date: 15-16 November 2016 and 7-8 June 2017
Time: 10.00am - 4.30pm (registration from 9.45am on day 1 of the course)
Venue: Cathie Marsh PC Cluster, Humanities Bridgeford Street Building
Instructor: Rebecca Bromley
Fee: £390 (£280 for those from educational, government and charitable institutions). The Cathie Marsh Institute (CMIST) offers 5 free places to research staff and students within the Faculty of Humanities at The University of Manchester and the North West Doctoral Training Centre.
Postgraduate students requesting a free place will be required to provide a letter of support from their supervisor.
Please note that all free places for the November and May courses are now full. If you wish to be added to the waiting list in case of a cancellation, please complete our online booking form as usual, request a free place and you will be added to our list.
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.
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
A basic knowledge of Excel and Word and familiarity with social research or policy reports.
About the instructors
Nigel de Noronha is completing his PhD in Social Statistics in 2016 looking at the growth of the private rented sector and the ways that this affects how people feel at home, changing living arrangements and neighbourhood spatial polarisation.
He is working as a Q-Step Teaching Fellow in Sociology at the University of Warwick. Prior to study he had extensive experience working in policy, assessment and research with local public services.
Rebecca Bromley has previously worked in Local Government and Third Sector for ten years focusing on communications, demographics and community research partnerships, now based at the University of Manchester.