Data Analysis & Presentation – An Introduction to Excel

Search courses
Search staffs.ac.uk

Hit enter to search or ESC to close

This course will teach learners to understand and use data manipulation techniques to manipulate, transform and present data in a meaningful format. As part of this course you will develop skills and knowledge of producing spreadsheets applying automated formatting, scripting, formulas and functions, charts and objects to cleanse, analyse, and manipulate and present data to technical and non-technical audiences.

Course Overview

Content includes using Excel to perform the following:

Spreadsheets, Workbook and Worksheets
Importing Data and Data Types
Sorting and Filtering Data
Data Visualisation
Conditional Formatting
Calculations and Data Transformation
Formulas and Scripting
Charts and Tables
Pivot Tables

Award

After completing this course, you will receive 5 credits which can then be used for future learning.

Delivery method

On campus

Location

Stoke-on-Trent campus

Duration

4 x 4.5hr sessions. 1000 - 1430hrs

Start date

Week 1 Thurs 19^th June 2025

Week 2 Thurs 26^th June 2025

Week 3 Thurs 3^rd July 2025

Week 4 Thurs 10^th July 2025

Entry requirements

This masterclass is open to anyone who lives in Stoke-on-Trent (paying council tax to Stoke-on-Trent city council), is 18 years old and over, and meets the following criteria:

Employed for one hour or more of paid work per week (including those temporarily away from work because they are sick or on holiday).
Temporary and permanent employees who are on fixed-term contracts or agency temping.
Self-employed people.
People on government-supported training programmes, engaging in any form of work, work experience, or work-related training.
People on maternity or paternity leave.

Cost

This course is free to all learners who meet the criteria above.

Staff

Andrew Cartlidge

P/T Lecturer (Hrly) - Computing

How to apply

To apply for this course, please email employers@staffs.ac.uk