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

What will I study?

In this intensive half-day session, you’ll dive into advanced functions, dynamic arrays, and data modelling techniques used by professionals. Learn how to automate and transform data with Power Query, build powerful insights with Power Pivot, and apply best practices to create efficient, reliable spreadsheets. This course is ideal for anyone looking to work smarter, handle complex data, and stand out with high-level Excel skills.

Advanced Functions and Dynamic Arrays

  • INDEX, MATCH, XLOOKUP, XMATCH, UNIQUE
  • Array formulas and dynamic arrays

Power Query

  • Importing data (CSV, Excel, web)
  • Cleaning and transforming data
  • Merging and appending queries
  • Loading data to Excel tables or PivotTables

Power Pivot and Data Modelling

  • Enabling Power Pivot
  • Creating data models and relationships
  • Writing calculated columns and measures (DAX basics)
  • Building advanced PivotTables with Power Pivot

Best Practices

  • Auditing formulas and tracing errors
  • Reducing file size and improving performance
  • Protecting workbooks and worksheets
  • Documentation and version control

Course Details

Course: Excel Basics Short Course - Half Day Location: Winter Gardens, North, Royal Parade, Weston-super-Mare BS23 1AJ Date: 17th 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