HEADER_BACKGROUND
Excel for Data Analysis
On this course you will cover the basics of using Excel for data analysis from tidying and formatting data, using tools such as Pivot tables and functions for analysis and creating charts to present your findings.

We will start by importing data into Excel and using formulas and other techniques to tidy up the information to allow for processing.

We will then use some key functions to analyse our data (including lookup and statistical functions).

Finally, we will consider how different charts can be used to display information in a visual format.
Prosp User 3
This course is for beginners to data analysis however you should have a good level of general IT skills. Some basic Excel knowledge is useful but not essential. You should be confident with managing files and folders.
Prosp User 4
As the course will be delivered online (on Zoom and Google Classroom) you will need a computer or laptop (rather than a tablet or phone) internet access, microphone/ speakers (or headset).

You will need Excel (the full version, not the online app) installed on your computer.
Prosp User 5
Good general computer skills are essential for this course.
Prosp User 6

In order to support keeping York moving, consider travelling to your course by bus or bike. Click here to check out the bus routes closest to the venue for this course using the iTravel website, or discover York's cycle routes by clicking here.
Msg
Alongside gaining course-specific skills, you will develop and showcase transferable skills that boost your confidence, employability, and ability to engage in further learning or volunteering.
Alongside gaining course-specific skills, you will develop and showcase transferable skills that boost your confidence, employability, and ability to engage in further learning or volunteering.
Employers highly value these transferable skills because they equip employees to excel beyond their basic job roles.
Employers highly value these transferable skills because they equip employees to excel beyond their basic job roles.
Prosp User 8

Learners who live in devolved authorities

Learners who live in devolved authorities
York Learning receives government funding which allows us to offer courses at a lower cost. The guidelines relating to devolution means that we cannot apply this funding to learners who live in devolved areas such as the West Yorkshire Combined Authority.
York Learning receives government funding which allows us to offer courses at a lower cost. The guidelines relating to devolution means that we cannot apply this funding to learners who live in devolved areas such as the West Yorkshire Combined Authority.
If you live outside of this area, we recommend that, before committing to a course with York Learning, you explore options to study the course in your local area.
If you live outside of this area, we recommend that, before committing to a course with York Learning, you explore options to study the course in your local area.
If you would prefer to continue your learning with York Learning please note that the price of the course could be double the advertised cost.
If you would prefer to continue your learning with York Learning please note that the price of the course could be double the advertised cost.
In this case, please contact us on 01904 554277 to complete your enrolment.
In this case, please contact us on 01904 554277 to complete your enrolment.

Learners under the age of 19

Learners under the age of 19
Please note that Adult Education funding is for individuals who are over the age of 19 on the 31st of August prior to the start date of their course.
Please note that Adult Education funding is for individuals who are over the age of 19 on the 31st of August prior to the start date of their course.
This means that there will be an additional cost for learners who are under 19 who wish to access funded courses.
This means that there will be an additional cost for learners who are under 19 who wish to access funded courses.
For safeguarding reasons, we cannot accept learners who are under 18 on courses except by prior arrangement. This does not apply to programmes which are designed for 16-18s.
For safeguarding reasons, we cannot accept learners who are under 18 on courses except by prior arrangement. This does not apply to programmes which are designed for 16-18s.
If you are under the age of 19, please contact us on 01904 554277 before booking.
If you are under the age of 19, please contact us on 01904 554277 before booking.
DT2/TU8
21/01/2027
04/02/2027
18:00 - 20:30
Thursday
2.50 hrs per wk
3 weeks
Indrel Doney
0.00
Free