Ayrshire College homepage
Back to all courses

Microsoft Excel - Advanced (Evening) (ONLINE) (TAF Eligible)

  • Qualifications Other Programmes
  • SCQF Level SCQF Level 5
  • Study mode Evenings only and Weekends
  • Campus Ayr
  • Start date February 2027
Apply Now
More information

Attendance / Duration

4 evenings (6:30pm - 9:00pm) ONLINE
Dates available to book
Monday 22 February 2027, Online - Book here
Wednesday 7 June 2027, Online - Book here

This course is also being delivered as a 2 day campus course.

Overview

Start Date: Monday 22 February 2027. This 4 evening session online course is designed to equip participants with the knowledge and practical skills to harness the potential of Microsoft Excel for data analysis, reporting, and automation.

Cost

£360 (Payment Plan options available, please contact our finance department for further information). Full funding is available through the Training Access Fund (TAF) subject to individual eligibility. Click 'Apply Now' to check your eligibility and complete your application.

Course Dates

  • Monday, 22 February 2027 (18:30 - 21:00)
  • Tuesday, 23 February 2027 (18:30 - 21:00)
  • Monday, 01 March 2027 (18:30 - 21:00)
  • Tuesday, 02 March 2027 (18:30 - 21:00)

What's Involved?

This Excel Advanced course is designed to equip participants with the knowledge and practical skills to harness the potential of Microsoft Excel for data analysis, reporting, and automation.

Participants should have a solid foundation in Microsoft Excel, including proficiency in basic functions (SUM, AVERAGE, IF, etc.), using charts and pivot tables, and working with worksheets and workbooks. Knowledge of Excel's intermediate features is recommended.

Microsoft Office 2013 or above is required.

Course Content

This course will cover the following:

  • Summarise data with grouping, outlining, subtotals and PivotTables
  • Manage and analyse data with Excel Tables
  • WhatIF Analysis - Scenarios, Goal Seek and Data Tables
  • Advanced functions – Logical, Financial, LOOKUP
  • Working with dates and times
  • Visualise data with more advanced chart techniques
  • Record Macros to automate tasks

By the end of this course participants will have an understanding of the more advanced functions of Excel. They will be able to manipulate and analyse data to extract meaningful information which will help increase their productivity.