Microsoft Excel is the most commonly used spreadsheet application. 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, performing calculations, analyzing data 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 also to work across multiple workbooks and worksheets.
All attendees will receive highly useful course notes to refer back 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
- Using Logical Functions
- Work with and Manipulate Data in Lists
Ideally delegates should have completed the ‘Excel Introduction – Level 1’ course or be comfortable in applying the features and functions associated with the Level 1 course content.
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. Please check directly with your association or awarding body to see how many points they will award.
This course costs €465 (normal rate is €565).PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.