• Business

    Microsoft Excel - Intermediate

  • Attendance/Duration

    2 hour online session running from 2.00pm to 4.00pm

  • Cost


What's Involved

Attendees must have Excel 2016 or 2013 desktop client installed on their machine and should have some familiarity with Microsoft Windows.

This course is aimed at those who are familiar with the basics of Excel and need to broaden their knowledge. Attendees must be confident with creating basic formulas, use of AUTOSUM and filling formulas.

On completion of this course, attendees will be able to create and apply a range of functions, apply formatting based on conditions, and summarise and analyse data using Pivot Tables.

This 2 hour session will cover the following:

  • Absolute cell referencing
  • Using Conditional formatting
  • Introduction to the following functions: IF, SUMIF, COUNTIF
  • Introduction to the VLOOKUP function
  • Create a Pivot Table
  • Filter a Pivot Table

Funding and Fees

This course is eligible for ITA Funding. To apply for ITA please visit the SDS My World of Work website by clicking here

Once you have applied for ITA you will still have to apply for this course here on the College website.


For further information please email businessgrowth@ayrshire.ac.uk

Course Search


Browse all courses Advanced search