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.

Course Content

Short Introduction

Performing Calculations

• Work with and understand formulas
  • SUM
  • AVERAGE
  • MAX
  • MIN
  • COUNT
• Using the Fill Handle/AutoFill
• Understand and create Relative calculations
• Understand and create Absolute calculations
• Understand and create Mixed References
• Link calculations across Worksheets

Formatting Worksheet Information

• Understand Excel Design and Construction
• Convert Numbers to Text Data Types
• Apply Currency format
• Apply Percent style
• Apply Decimals
• Delete formatting

Work with and Manipulate Data in Lists

• Understand Data Lists
• Create a basic Sort
• Create a multi-sort
• Create a custom Sort
• Create a basic filter
• Create a multi-filter
• Create and understand Subtotals
• Create and understand Outlines
  

Prerequisites

• 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.
• It is ESSENTIAL you own a laptop/computer with the required software installed (Microsoft Excel 2013 or later).

Who should attend?

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.

Certification

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.

Cost

An ‘Early Bird’ discounted rate of €485 is currently available. This training course normal rate is €585. Places are limited to 12 delegates 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.