Days: Wednesday
Time: 13:30 – 17:00
Date: 10 Jun 2026
Duration: 1 Day
Code: EASCDALW

What will I study?

In this practical, hands-on half-day session, you’ll explore powerful tools including advanced formulas like IF and VLOOKUP, data validation, and PivotTables—helping you analyse, manage, and present data with ease. You’ll also learn how to streamline your work using smarter formatting techniques and dynamic charts.

What you will learn:

Advanced Formulas

  • Logical functions: IF, AND, OR
  • Lookup functions: VLOOKUP, HLOOKUP, INDEX-MATCH
  • Text functions: LEFT, RIGHT, MID, LEN, CONCATENATE, TEXTJOIN
  • Advanced Aggregates: SUMIF, COUNTIF

Advanced Formatting

  • Managing multiple worksheets in a workbook
  • Custom number formatting
  • Conditional formatting with formulas
  • Using themes and cell styles

Working with Tables and Data Validation

  • Creating and formatting Excel tables
  • Structured references
  • Data validation: drop-down lists, input messages, error alerts

PivotTables and PivotCharts

  • Building PivotTables
  • Grouping, filtering, slicers
  • Creating PivotCharts
  • Advanced charts (combination charts, scatter plots)

Course Details

Course: Excel Basics Short Course - Half Day Location: Winter Gardens, North, Royal Parade, Weston-super-Mare BS23 1AJ Date: 10th June 2026 Duration: Half day from Time: 13:30 to 17:00 Delivery: Face to face Cost: £65 per person

Full Fee: £0.00 ?

Supported Fee: £0.00

Most people qualify for FREE tuition and material fees due to discounts we offer. Click on the icon(s) below to find out what you’ll need to pay.

Fee Information

HEAR ABOUT THE LATEST VACANCIES

Sign up to our Apprenticeship Vacancy Mailing list and be the first to hear about the latest opportunities

Mailing list

Got a question?

Whatever you'd like to know, we're here to help...

Register your interest

Marketing Permissions

Once we have responded to your initial enquiry we would love to keep you informed of other, similar courses you may be interested in via email. You can unsubscribe at any time by clicking the link in the footer of our emails. For information about our privacy practices, please visit our policy page.

Marketing permissions selection
Data protection agreement

By submitting this form you are consenting to Weston College recording and processing the personal information on this form, for any purposes of the college associated with the provision of advice and guidance to potential students on the range of courses available to them, college facilities and any other associated information. In accordance with the Data Protection Act 2018, the information will only be used for the above mentioned purposes.

You will need to complete a full enrolment form prior to starting your course.

Apply or find out more


Marketing Permissions

We’d love to keep you informed about vacancies, courses, and updates we think you’ll find valuable. You can unsubscribe or opt out at any time.
Your personal information will be handled in accordance with our Privacy Policy.

Please let us know how you’d like to hear from us:

Email

By submitting this form you are consenting to Weston College recording and processing the personal information on this form, for any purposes of the college associated with the provision of advice and guidance to potential students on the range of courses available to them, college facilities and any other associated information. In accordance with the Data Protection Act 2018, the information will only be used for the above mentioned purposes.

You will need to complete a full enrolment form prior to starting your course.

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
 

Open Evening

Weds 25th March

6:00-8:00PM ALL CAMPUSES