Computing

To be added to our waiting list for future course dates please email businessgrowth@ayrshire.ac.uk

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.

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.