Learning how to use Excel is an investment in both your personal and professional life. If utilised correctly, the benefits of Microsoft Excel cannot be overstated. Due to the program’s capability of formatting data and analysing data, performing calculations, and integrating information, a working knowledge of Excel is vital for most office-based professionals today.
This Masterclass guides participants through Excel’s Database features. Participants learn how to understand and use key functions, up to and including, the IF function. Participants will learn how to sort, filter and subtotal information and to work across multiple workbooks and worksheets.
All attendees will receive useful course notes to refer to at any time and have a chance to engage in an informative Q&A on the day.
Places are limited to 12 delegates to ensure sufficient tutor/delegate interaction – Prompt booking is advised.
Short Introduction
Performing Calculations
Formatting Worksheet Information
Work with and Manipulate Data in Lists
This course would be ideal for those who work with files that are created by other users, or who have a working knowledge of Microsoft Excel. This course will provide you with the knowledge and skills to use Excel at a more advanced level.
On completion of this one-day training course, you will receive your Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course.
This course may qualify for CPD points. Please check directly with your association or awarding body to see how many points they will award.
An ‘Early Bird’ discounted rate of €499 is currently available. This training course normal rate is €599. Places are limited and are allocated on a first come first served basis. PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.
Excel skill levels are usually defined by the type of tasks you can complete confidently rather than how long you have used the software. Beginner users typically focus on data entry, basic formatting and simple calculations. Intermediate users are comfortable working with formulas, organising data, using functions and managing spreadsheets with more structure. Advanced users work with large datasets, complex formulas, automation and data analysis tools.
Excel is widely used, but often in a limited way. Many users perform familiar tasks repeatedly without realising there are more efficient or structured approaches available, making it difficult to judge whether their skills go beyond a basic level.
Excel Level 2 focuses on developing stronger spreadsheet skills for managing data, formulas and everyday analysis tasks.
It builds beyond basic data entry and formatting to include more structured use of formulas and data handling.
Errors often arise from formula logic, inconsistent data or lack of structure as spreadsheets become more complex.
Stronger Excel skills support accuracy, efficiency and clearer reporting in routine business tasks.
This course examines intermediate Excel concepts and their application in workplace data management.
.png)
.png)
.png)