Computing

Start Date: Thursday 24 April. This 2 day course is designed to build on participants’ existing Excel skills and expand their proficiency in Excel. Participants will delve deeper into Excel's functions, data manipulation techniques, and tools, enabling them to solve complex problems and streamline workflows.

£375

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

• Day 1: 24 April 2025 (9am to 4pm)
• Day 2: 1 May 2025 (9am to 4pm)

This Excel Intermediate course is designed to build on participants’ existing Excel skills and expand their proficiency in Excel. Participants will delve deeper into Excel's functions, data manipulation techniques, and tools, enabling them to solve complex problems and streamline workflows. This course is suitable for individuals with a basic understanding of Excel and seeks to take their data analysis and reporting capabilities to the next level.

If you are a beginner to Excel then it is recommended that you complete the Excel Beginners course first.

The course is suitable for those using Microsoft Office 2013 or above.

This course will cover the following:

• Using Relative and Absolute references when copying formulae
• Functions – IF, COUNTIF, SUMIF, AVERAGEIF
• Linking worksheets with formulae
• Charts – learn the best ways to visualise your data in Excel
• Highlighting information with Conditional Formatting
• Limiting data entry with Data Validation
• Summarising data with PivotTables
• Custom sorting
• Filtering data

By the end of this course participants will be able to use some common formulae and tools to extract relevant information from data. They will become more confident in using worksheets, and in organising and interpreting data.