-
Computing
Microsoft Excel - Intermediate (1 Day)
-
Attendance / Duration
1 Day (9:00am - 4:00pm) Ayr Campus
-
Cost
£220

Book / Enquiry
Wednesday 31st January (Kilmarnock Campus) - Book here
Tuesday 27th February (Kilmarnock Campus) - Book here
To be added to our waiting list for future course dates please email businessgrowth@ayrshire.ac.uk
What's Involved?
For our 2 day course, please click here
This course is suitable for those with good knowledge of creating and formatting simple worksheets and using basic formulae. 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.
Please note you must have the following set up to progress with this course;
- The latest version of Windows
- Microsoft Office 2013 or above
- Microsoft Teams
- A working webcam
- A working microphone
Course Content
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.
Places available
Campus
Ayr
Start Date
21 Dec 2023
Places available
Campus
Kilmarnock
Start Date
31 Jan 2024
Places available
Campus
Kilmarnock
Start Date
27 Feb 2024