Categories
Badges
User Profile
Sharer Hub
Close
Microsoft Excel - Intermediate (1 Day)
This 1 day course is designed for individuals with basic knowledge of Microsoft Excel and who seek to enhance their skills and productivity in spreadsheet management. 2 day version also available.
Provider
Ayrshire College, Scotland (A mix of both online and in-person sessions)(For price, check with provider)
Enquire via the Ayrshire College website.
Description
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. A 2 day version of this course is also available. This course will cover the following: • Understanding Relative and Absolute cell referencing • Conditional functions – IF, COUNTIF, SUMIF, AVERAGEIF • Linking worksheets • Charts – beyond the basics • Highlighting information with Conditional Formatting • Data Validation • Introduction to PivotTables • Custom sorting 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.
About Ayrshire College
Our aim is to serve the people, communities and employers across Ayrshire. Ayrshire College plays a key role in helping to develop the economy in Ayrshire, by ensuring that students develop the right skills and positive attitudes to support the local, regional and national workforce needs. Ayrshire College offers a range of courses targeted at individuals who are looking to develop their professional or technical skills and those who are simply interested in the joy of learning. We are offering, on-line, face-to-face and a mix of day and evening classes across a range of subjects including leadership and management, digital skills, and aeronautical sector specific courses All forthcoming courses are outlined here and on our website and we will continue to develop new offerings over this year and beyond so please watch this space! Book your place now and we look forward to supporting your training.
