Computing

Wednesday 5th April - Book here

Tuesday 27th June - Book here

To be added to our waiting list for upcoming courses please email businessgrowth@ayrshire.ac.uk

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

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.