Course Duration

1 Day

Location

Cauldon Campus

Course Cost

£ 35.00
Do I have to pay this fee? These courses receive government funding, and some learners will be eligible for FREE tuition if they meet specific criteria. Some L code courses at Level 3 to 6 may also have an Advanced Learning Loan available for learners aged 19 and over. Where the course is more than 1 year fees are payable yearly.

Course Code

PL6132

Start Date

09/09/2026

Start Time

09:00:00

Day

-
Apply Now
Apply Now

Course Summary

This course is intended for those who have a good level of Excel and want to develop their skills further in the following areas:

Upcoming Events

We have many events up and coming at Stoke on Trent College.

View our upcoming events

Entry Requirements

A good level of Excel knowledge.

How Is It Assessed

There is a test but no formal assessment.

How Is It Taught

Classroom based.

What Could I do Next

Higher IT courses in MS Word or PowerPoint.

What Else Do I Need To Know

1. Creating Tables in Excel 2. IF and nested IF Functions 3. V Lookups & H Lookups 4. Working with Formulas (SumIF, CountIF, CountA) 5. Advanced Filters 6. Advanced List management 7. Importing & Exporting Data 8. Spreadsheet Security 9. Pivot Tables 10. Advanced Graphs and Charts

Related News

Courses you might like