• Business

    Microsoft Excel Advanced

  • Attendance/Duration

    This is a one day course.

  • Cost


What's Involved

This one day course has been designed for those users who wish to discover the advanced features of Excel in order to work more effectively with your data.

By the end of the course, you will be confident in using some of Excel’s more advanced features.

Good understanding of Excel features like tables, cell styles, formatting options is necessary to make awesome Excel workbooks. There is no use if all your analysis is buried in a massive spreadsheet.

Learn how to make fast, effective comparisons from lists of data using tools such as Charts, Sparklines, Pivot Tables and Slicers. Use Names, Ranges and logical functions, like IF, AND and OR functions.

Those attending this advanced course are expected to have a good prior understanding of the basic features available in Microsoft Excel.

Course content:

  • Building Spreadsheets
  • Advanced formatting and functions
  • Charts, analysis tools
  • Top tips for productivity, sharing and editing workbooks

Funding and Fees

This course is eligible for Individual Training Account (ITA) funding, depending on individual circumstances. For further information on funding go to our Funding and Fees tab to the right. Apply for your funding now to ensure it is in place before your course starts.


For further information call 0300 303 0303, or email: businessdevelopment@ayrshire.ac.uk

Course Search


Browse all courses Advanced search