Attendance / Duration
2 Days (9:30am - 4:00pm)Overview
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. 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.
Cost
£375
Enquiry
For further information or to be added to our waiting list for future course dates please email engage@ayrshire.ac.uk
What's Involved?
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.
Course Content
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.