Computing

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

Excel Intermediate is a comprehensive course designed for individuals with basic knowledge of Microsoft Excel and who seek to enhance their skills and productivity in spreadsheet management. It will delve into more advanced features and functions of Excel, empowering participants to become proficient Excel users.

Participants should have a solid understanding of basic Excel functions, including navigating the interface, creating simple formulas, and performing basic formatting. Familiarity with spreadsheet concepts and terminology is highly recommended.

This course will cover the following:

• Using Relative and Absolute references when copying formulae
• Functions – IF, COUNTIF, SUMIF, AVERAGEIF ROUND
• Creating and formatting charts - column, bar, pie, combination
• Highlighting information with Conditional Formatting
• Limiting data entry with Data Validation to maintain the integrity of data
• Summarising data with PivotTables

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.