Bolton College

Excel – Mastering Spreadsheets

To extend students knowledge from their basic computing skills for work and life and prepare students in spreadsheets for progression on to Entry 3 EDSQ.
Course Information

Course Type:

Adult

Study Mode:

Qualification:

Other

Location:

See Group Times

Course Code:

CP412-CLPC

Course Length:

4

Start Date:

Various start dates from June 2026

Subject Area:

ENGINEERING AND DIGITAL TECHNOLOGY

To extend students knowledge from their basic computing skills for work and life and prepare students in spreadsheets for progression on to Entry 3 EDSQ.
Location: Brownlow Fold Community Learning Centre. Group: D. First class: 04 June 2026. Last class: 25 Jun 2026
  • Thursday : 09:30 - 12:00
Location: Deane & Derby Community Learning Centre. Group: C. First class: 10 June 2026. Last class: 01 Jul 2026
  • Wednesday : 13:00 - 15:30
Tuition Fee: £37.00

Courses fees are subject to change.
LO1
Mastering the keyboard shortcuts in excel:
1.1 Ctrl+C (copy)
1.2 Ctrl+X (Cut)
1.3 Ctrl_V (paste)
1.4 Ctrl+Z (undo)

LO2
Editing and formatting an excel spreadsheet:
1.1 Format at least 5 cells to 2 decimal places
1.2 Format at least 5 cells to English(UK) date
1.3 Format at least 5 cells from a decimal to a percentage
1.4 Merge & centre, wrap-text and Bold for at least 3 headings in columns

LO3
Formulas in spreadsheets:
1.1 Use the AustoSum feature to calculate ‘Sum’ and ‘Average’ of at least 10 cells
1.2 Use addition, subtraction, multiplication and division formulas to calculate data correctly

LO4
Creating Charts
1.1 Create at least one 2-D column or bar chart and one 3-D column or bar chart
1.2 Create at least one 2-D pie chat and one 3-D pie chart

Through a portfolio:
- observation
- printouts
- activity sheets
Use the yellow 'enrol' button to request to join this course.
Please note: if you enrol without meeting the course entry requirements your place may be cancelled and a refund provided.
Progression to Entry 3 Essential Digital Skills Qualification
Head of Department: Rachel.Upsall@boltoncc.ac.uk Adult Course leader: Anita.Lenihan-Taylor@boltoncc.ac.uk

English and maths classes - for adults and young people who want that grade or confidence boost.

English & maths logo
Learn More

What Our Students Say

Follow Us on Social Media

Facebook-f Instagram X-twitter

Log In to Your Portal

Please choose from the options below to access your account:

Staff Log In: Access your staff portal.

Access

Student Log In: Access your student portal.

Access

Parent/Carer Portal: Track your young person's progress.

Access

Learner Hub: Keep up to date with your application progress.

Access

Need help accessing your account? Contact: info@boltoncc.ac.uk

Log In To Your Portal

Stay in the Loop

Sign up to receive updates about courses, open events, and learning opportunities at Bolton College. You’ll be the first to know when new courses launch and when applications open.

"*" indicates required fields

Name*
What are you interested in?
(Tick all that apply)
Consent to Contact You*

Share a Course

Know someone great for this? To share this course click on a link below

Facebook
Twitter
LinkedIn
WhatsApp
Email
Pinterest
Log In To Your Portal

Got a Question?

If you’d like more information about this course or need help deciding if it’s right for you, we’re here to help. Just fill in your details and someone from our team will get back to you.

"*" indicates required fields

Confirm to submit your details*
Can We Contact You in Future?
Would you like to receive information and offers about future courses or learning opportunities?

Report a Problem

Spotted something wrong with this page? Whether it’s a broken link, outdated information, or a technical issue, we’d appreciate you letting us know so we can fix it quickly.

"*" indicates required fields

(Optional, if you'd like a response)
(e.g. Course title and/or link)
Upload a picture or screen
Accepted file types: jpg, gif, png, pdf, Max. file size: 20 MB.
Confirm to submit your details*
Can We Contact You in Future?*
Would you like to receive information and offers about future courses or learning opportunities?

Questionnaire

Want to hear about the latest job vacancies in your area? Fill out this quick form to tell us about your experience, the type of work you're looking for, and how many hours you want to do. We’ll use this info to match you with local opportunities and send you regular updates.

Term Dates

Autumn Term 2025

Important Dates
Term Time
Start: Monday 8th September 2025
End: Friday 19th December 2025		Half Term
Start: Monday 27th October 2025
End: Friday 31st October 2025

 

Staff Development Days (no classes):
Wednesday 20 August 2025 and Thursday 9th October 2025

All Staff Meeting: Thursday 9th October 2025

Public Holidays:
Thursday 25th December 2025, Friday 26th December 2025 and Wednesday 1st January 2026

Spring Term 2026

Important Dates
Term Time
Start: Monday 5th January 2026
End: Thursday 2nd April 2026		Half Term
Start: Monday 16th February 2026
End: Friday 20th February 2026

Staff Development Day (no classes):
Wednesday 4th February 2026

Public Holidays:
Friday 3rd April 2026 and Monday 6th April 2026

Summer Term 2026

Important Dates
Term Time
Start: Monday 20th April 2026
End: Friday 3rd July 2026		Half Term
Start: Monday 25th May 2026
End: Friday 29th May 2026

Staff Development Day (all College sites):
Wednesday 8th July 2026

Public Holidays:
Monday 4th May and Monday 25th May 2026

IMPORTANT: Please can parents and students book holidays during half term break only.

Enrolment

Thinking of joining Bolton College?

Take a look at the enrolment times below and drop in on a day and time that suits you.
Our friendly staff will be on hand to support you every step of the way. All the information you need for enrolling at our centres is listed below - we’re here to help!

What to bring:

For 16–18 Year Olds:

    • Proof of ID
  • GCSE qualifications on entry – results slip or certificates (if already achieved)
  • A parent or guardian if you’d like someone with you

For Adults:

  • Proof of ID
  • Qualifications on entry – results slip or certificates (if already achieved)
  • Proof of address
  • Evidence of any benefits you receive
  • Proof of residency status (e.g. visa, immigration documents)

Deane Road Campus Opening Hours – Deane Road, BL3 5BG

 MONTUESWEDSTHURSFRI
Hours8.30am–7.30pm8.30am–7.30pm8.30am–7.30pm8.30am–7.30pm8.30am–4.00pm

Deane & Derby Enrolment Times – Ethel Street, BL3 5EH

 MONTUESWEDSTHURSFRI
Enrolment9.00am–4.00pm9.00am–4.00pm9.00am–4.00pm9.00am–4.00pm9.00am–12.00pm

Brownlow Fold Enrolment Times – Eskrick Street, BL1 3EF

 MONTUESWEDSTHURSFRI
Enrolment9.00am–4.00pm9.00am–4.00pm9.00am–4.00pm9.00am–6.30pm9.00am–12.00pm

Farnworth Library Enrolment Times – Market Street, BL4 7PG

 MONTUESWEDSTHURSFRI
Enrolment10.00am–3.30pm10.00am–3.30pm9.30am–2.45pm10.00am–3.30pm10.00am–12.00pm
Browse Courses
Contact Us
Enrolment

ESOL Adult Form

If you need help filling out this form please speak to our friendly staff.

If you need support or have any enquiries, please contact us with by telephone: 01204 482 000 or by email: ESOL.Email@boltoncc.ac.uk

"*" indicates required fields

Name*
DD slash MM slash YYYY
Address*
Please be aware that all learners must complete an assessment before enrolling in ESOL classes. This assessment helps ensure that each learner is placed in the appropriate course level at Bolton College.
Confirm to submit your details*
Can We Contact You?*

ESOL Young People Form

If you need help filling out this form please speak to our friendly staff. Please note this course is designed for 16-18 year old learners only. If you are aged 19+ please access our Adult ESOL course.

If you need support or have any enquiries, please contact us with by telephone: 01204 482 000 or by email: ESOL.Email@boltoncc.ac.uk

"*" indicates required fields

Name*
DD slash MM slash YYYY
Address*
Confirm to submit your details*
Can We Contact You?*

Higher Education Enquiry Form

This enquiry will be sent to the relevant head of area for your chosen course, who will then get in touch to answer any questions you may have.

"*" indicates required fields

What Higher Education course are you interested in?
Confirm to submit your details*
Can We Contact You in Future?
Would you like to receive information and offers about future opportunities?

‘Explore, excel, experience’

Students seeking a work placement can visit the Job Shop to meet with a work placement officer who will help and advise them on how to source a work placement to complement their study programme or T Level.

Discover more about our work placement opportunities for students.

Access Find Your Career Page

Bolton College is home to a talented pool of students who have received training in diverse sectors. 

Employers who welcome a study programme or T Level student into their workplace will benefit from skilled workers eager to learn and develop, at no cost to the business. 

Hours will be tailored to accommodate the employer, from a short period or an extended timeframe across multiple weeks. 

Access Employer Page

‘Real work, real growth’

Apprenticeships are open to all ages and are all about real work, in a real company, training to get the skills companies really want – with a guaranteed salary!

If you’d like to become an apprentice, you can visit our Job Shop to meet with an Employer Engagement Advisor and receive tailored support and advice on how to apply for vacancies.

Alternatively, you can view our Apprenticeship online to discover the range of Apprenticeships we offer, from Business to Teaching.

Access Apprenticeships

Employers can contact the Job Shop to advertise their Apprenticeship vacancies, and to also meet with Employer Engagement Advisors to assist them in identifying Apprenticeship Standards to advertise. To learn more about what our Job Shop offers, access our employer page.

Access Employer Page
Access Live Apprenticeship Vacancies

‘Bridging success’

Bolton College is proud to work with a variety of businesses and organisations throughout Bolton and the North West, and we welcome these stakeholders to share our Job Shop space.

Stakeholders that provide job seeking support and careers advice and guidance can book a regular space in the Job Shop to meet with visitors. These visitors will then be able to enquire about the career and job-seeking activities these stakeholders offer.

‘Your path to employment’

Bolton College Job Shop isn’t just for Bolton College’s students – it’s for members of the public too!

Anyone can visit the Job Shop if they need help with updating their CV; careers advice and guidance; or tailored support in identifying industries they wish to work in.

Visitors will also receive guidance on relevant courses to apply for, assisting them with their employability and closing any skills gaps in their CV. 

If you are an adult looking for work in Bolton and the surrounding areas, we have courses that can help you to create a CV and also show you how to complete application forms to ensure the best possible chance of securing an interview. For further information about these courses, please contact the job.shop@boltoncc.ac.uk.

You can join our mailing list where we send out details of current vacancies in the local area. To join this mailing list, you will just need to complete a quick online questionnaire to give us an idea of the type of work you are looking for / hours etc. 

Access Questionnaire

‘Your Launchpad to Success’

Bolton College Job Shop is a talent hub linking our students to top businesses, kick-starting journeys toward success. 

Dedicated Work Placement Officers, Careers Advisors and an onsite Business Development Team are on hand to offer:

  • Careers information, advice and guidance
  • Tailored 1:1 support
  • Job matching and job search activity
  • Mock interviews
  • Professional profile building
  • Advice and guidance on how to source your own work placement

This means that when it comes to bridging the skills gap, our students are the sought-after professionals that employers crave.

Enrolment & Attendance Certificate

If you are a student wishing to apply for an Enrolment & Attendance Certificate to help with your claim for a Council Tax discount or, you are a parent/carer needing a Certificate to help with your claim for Child or Housing Benefit please complete the form below.

All Certificates will be emailed directly to the relevant Council department. You must provide us with the correct email address for the Council department asking for the information. If you are a learner aged over 18, we may need to contact your Tutor regarding the number of hours you study.

Please note: the details on the form below must match the information we have on your learner (or child’s learner) record. If it does not, we may be unable to produce a Certificate. However, we will contact you if this happens. We cannot produce Certificates until you/your child has been attending classes for at least 4 consecutive weeks.

"*" indicates required fields

DD slash MM slash YYYY
Address*

‘Where employers meet talent’

Bolton College Job Shop is a resource for employers to share vacancies they are currently recruiting for. Vacancies are displayed on the College’s vacancies pages as well as on the interactive screens located in the heart of our Job Shop, access by our students and members of the public.

Apprenticeship Vacancies

Apprenticeship Vacancies

Access our Employer Page

Applicants interested in any of the vacancies will be able to apply using the Job Shop’s computers. Vacancies will also be shared with Bolton College’s talent pool – students who have already expressed an interest in a vacancy and are seeking work.

Employers can also liaise with the Job Shop’s Employer Engagement Advisors to identify gaps in their recruitment and/or workforce. Working together, learning opportunities will be identified from the College’s course offer, thereby addressing and helping to close any skills gaps.