Ayrshire College homepage
Back to all courses

Microsoft Excel - Advanced

  • Qualifications Other Programmes
  • SCQF Level SCQF Level 5
  • Study mode Professional Learning
  • Campus Ayr
  • Start date September 2025
Apply Now
More information

Attendance / Duration

2 Days (9:00am - 4:00pm)

Overview

Start Date: Wednesday 10 September (Ayr). This 2 day 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

Enquiry

For further information or to be added to our waiting list for future course dates please email engage@ayrshire.ac.uk

Course Dates

  • Wednesday, 10 September 2025 (09:00 - 16:00)
  • Thursday, 11 September 2025 (09:00 - 16:00)

Whats 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.