Essential Skills Excel
Date: 29 March 2019
Time: 1pm - 4pm
Instructor: Patty Doran
CMI offers up to five subsidised places at a reduced rate of £60 per course day to research staff and students within Humanities at The University of Manchester. These places are awarded in order of application.
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 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.
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