Search
Search type

Cathie Marsh Institute for Social Research (CMI)

Excel Essential Skills

Date: 22 November 2019
Time: 1pm - 4pm
Instructor: Patty Doran
Level: Introductory
Fee: £60 

Humanities PGR students at The University of Manchester can apply for a methods@manchester bursary to help cover their costs. All applications will be considered on a case-by-case basis and applicants will be required to provide a supporting statement from their supervisor.

Please click here to make a booking. For queries about methods@manchester bursaries, contact methods@manchester.ac.uk (please note, you must have a confirmed place on the course before requesting a bursary application form). For any other queries about short courses, please contact cmi-shortcourses@manchester.ac.uk.

Please note: this is not guaranteed and is considered on a case by case basis. Please contact us for more information.

Outline

This introductory course will explore the data analysis functionality of Microsoft Excel 2010. Examples will be worked through to demonstrate what Excel can be used for and how to make the most of some of the data analysis functions, including:

  • built-in statistic functions;
  • organising data using filters;
  • pivot tables;
  • charts.

The course will be exercise-based and participants will be encouraged to practice all the techniques as they are taught.  Although this is an introductory course some knowledge of basic statistics is needed.

Course objectives

At the end of the course you will be able to:

  • Apply analysis techniques to datasets in Excel
  • Use statistical functions to understand and describe your data
  • Organise, sort and summarise data for analysis
  • Produce pivot tables and charts to visualise data

Course participants will learn how to: 

  • Open an Excel workbook, enter data and use simple formulae
  • Load existing data and carry out a range of analysis of individual variables to answer a range of research questions
  • Present your findings in simple graphs
  • Work with complex datasets, preparing worksheets and variables for a series of analyses
  • Analyse the interactions between variables and produce pivot tables
  • Present your findings in professional-looking tables and graphs

Prerequisites

Although this is an introductory course some knowledge of basic statistics is needed.

Recommended reading

None

About the instructor

Apply