Excel Essential Skills
Date: 22 November 2019
Time: 1pm - 4pm
Instructor: Patty Doran
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 firstname.lastname@example.org (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 email@example.com.
Please note: this is not guaranteed and is considered on a case by case basis. Please contact us for more information.
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;
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.
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
Although this is an introductory course some knowledge of basic statistics is needed.