Back to All Events

Microsoft Excel For Introductory & Intermediate Levels

  • 5 CPD Hours Apex Building, Blackthorn Road Sandyford Business District Dublin 18 (map)

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 CPD certified 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 a highly useful course pack to refer back to at any time, gain valuable CPD points, and have a chance to engage in an informative Q & A on the day.

It is ESSENTIAL to bring along your own laptop with the required software installed (Microsoft Excel 2013 or later). 

Places are limited to 12 delegates to ensure sufficient tutor/delegate interaction – Prompt booking is advised. 

Course Content Includes:

Short Introduction


Performing Calculations

  • Work with and understand Functions

    • SUM

    • AVERAGE

    • MAX

    • MIN

    • COUNT

  • Work with and understand Formulas

  • 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


Using Logical Functions

  • Understand the IF Function

  • Create IF Functions

  • Understand the AND Function

  • Create AND Functions


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.

Who should attend?

This course would be ideal for those who have a basic grounding in Microsoft Excel, this course will provide you with the knowledge and skills to use Excel at a more advanced level.

Certification

On completion you will receive your CMG MasterClass Certificate as well as your CPD Certificate containing 5 Structured CPD Hours. Please note certificates are issued only at the close of the training course to participants who complete the full five hours.

Cost

This course costs €425 (normal rate is €465). ncludes course documentation and light refreshments. While the course fee does not include lunch, we do provide freshly made sandwiches, nespresso coffee and a range of teas and fresh juice for those who require a light lunch. Alternatively, you can avail of the local food stores and coffee shops opposite the training centre for hot food or alternative lunch options.

Earlier Event: November 20
People Management Skills