Take the next step in Microsoft Excel training by becoming an expert using common functions, logical functions, advanced functions and formulas.

Date: 28th February 2018

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 will guide participants through Excel’s Functions and Formulas. Participants learn how to use ‘IF’ functions, look-up functions and many more. 

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).

Book your place now!

This one-day course will give you a greater understanding of how to build complex formulas using nested functions. You will find quicker ways to work with excel and customise formulas by taking advantage of the built-in functions available in Excel. You will save time by learning more sophisticated search and auditing techniques when working with data-heavy spreadsheets.

Quick Review of Common Functions/Formulas

  • Using SUM, AVERAGE, MAX, MIN, COUNT
  • Functions versus Formulas
  • Relative Calculations
  • Absolute Calculations
  • Convert Numbers to Text Data Types
  • Calculate data across Worksheets

Working with Logical Functions

  • Understanding the IF Function
  • Understand the AND Function
  • Nest IF, AND, and OR into IF
  • Work with SUMIFs, AVERAGEIFs, COUNTIFs

Working with Advanced Functions

  • Use VLOOKUP
  • Use HLOOKUP
  • Use PMT
  • Nesting VLOOKUP and TRIM
  • Use Data Validation
  • Use Named Ranges
  • Use Data Validation
  • Use Named Ranges
  • The SUMPRODUCT function
  • Use INDEX and MATCH
  • Use AGGREGATE
  • Use Arrays
  • Deal with Errors

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.

Kelly Meegan – KM Consultancy Services

Kelly has worked as an Application/IT trainer for the last 20 years.  She have delivered training courses both nationally and internationally and has accumulated a wide and varying skill set through continuous learning and up skilling. Specialising in end-user application training such as MS Word, MS Excel, MS PowerPoint, MS Outlook, Business Objects Crystal Reports and Windows SharePoint Server (end-user), she has also been involved in partnering with clients to develop custom courses, induction programmes and associated courseware.

She has recently made a significant contribution to the successful roll out of a Windows SharePoint Server Portal facility for a Government agency. This project required the preparation of courseware – tailored to the specifications of the client – and the delivery of end-user and super-user training.

She has been awarded the Certificate in Training and Continuing Education from the National University of Ireland.  She has also attained the MOS credential for SharePoint 2010, building on my JEB and Microsoft Office Specialist (MOS) Master qualifications.

Training Environment:

CMG Professional Training courses take place at our state-of-the-art training facility in the Apex Building situated in the Beacon Quarter of Sandyford Industrial Estate, Dublin 18. The CMG Training Centre is accessible by the Luas, (Sandyford line, Stillorgan stop – 6 mins walk) several bus options (the number 11 travels from O Connell street Dublin and stops directly outside the training centre) and we are situated very close to the M50 at the Beacon Hospital corner. There are several car parks within a three minute walk from the training centre with very competitive ‘all day’ parking rates and we have a range of coffee shops (including Starbucks) as well as shops and restaurants nearby.

Date, Time & Venue:

Date: 28th February 2018

Times: 9.30 am to 4.00pm

Venue: Apex Building, Blackthorn Road, Sandyford Dublin 18

Course Cost:

This course costs €395 (Early-bird), normal rate is €445. Includes 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 center for hot food or alternative lunch options.

Places are limited and are allocated on a first come first served basis.

If you have any further queries, please contact me at the training desk on – 01 293 4768.

   Telephone:+353 1 2933650

Company Name (required)

Number of Delegates Attending (required)

Delegate's Name(s) (required)

Delegate's Position(s) Within Company (required)

Delegate's Email(s) (required)

Booker's Name (required)

Booker's Email:

Booker's Telephone (required)

Payment Options (required)

We recommend you pay by credit card to ensure you receive the best rate available

Invoicing Address

Accounts Phone Number (required)

Accounts Email (required)

NOTE: Please do not enter your credit card details. A member of our staff will contact you promptly when you have submitted the form.

Terms and Conditions:
General Terms and Conditions: Full Payment is due on booking. In the event of payment by cheque, must be received within seven days from date of invoice and in any case must be paid prior to attending the training course. If you are unable to attend, a substitute attendee may be sent at any time for no additional charge. Cancellations must be received in writing, by fax or letter, no later than 14 days prior to the event for a refund. Regrettably, no refunds can be made after that date. CMG Training reserves the right to make any necessary changes to the advertised training programme including a change of venue. The views expressed by the Trainers are not necessarily those held by the organisers, nor is the organiser responsible for tutors/trainers opinions or statements.

CHANGING BOOKING TO ANOTHER ADVERTISED DATE. If you wish to change your booking to another advertised date for the same course, you must do so no later than 7 days prior to the event taking place. In the case of a request to change to another advertised date with less than 7 days’ notice, it will be treated as a new booking and liable for payment as a new booking. CMG Training reserves the right to make any necessary changes to the advertised training programme including a change of venue. The views expressed by the Trainers are not necessarily those held by the organisers, nor is the organiser responsible for tutors/trainers opinions or statements.

I have read the terms and conditions