Engineers Ireland - Back SUMMER SPECIAL - 50% OFF - Microsoft Excel for Engineers - Intermediate Level - Online Classroom

John McGrath’s aim is to teach you more about Excel in a day than you might learn in years with software documentation or any self-help tutorial. This intermediate level course will include features to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.

Description

SUMMER SPECIAL - 50% OFF

• Normal Rates: Member: €295 / Non-member: €445

• Summer Special Rates: Member: €147.50 / Non-member: €222.50

To book a place

You can book online using a credit or debit card. If you will be paying by invoice / purchase order / bank transfer, please contact the CPD Training Team to place your booking. You can reach us on 01 665 1305 or email cpdtraining@engineersireland.ie

Course Delivery

This is a virtual classroom in which participants will require access to a webcam and microphone for live sessions with the trainer throughout the day. Participants will receive a login code via email. The course will be delivered between 9:30 and 16:30 with running order and break times outlined in advance.

As with the traditional classroom delivery of our courses, class sizes are limited to allow opportunity for all delegates to participate.

Learning objectives

Upon successful completion of this course, participants will be able to:

• Understand and use a range of common worksheet functions.
• Understand and utilise Absolute Referencing.
• Organise a database list by advanced filtering and subtotalling.
• Utilise Conditional Formatting to change cell appearance.
• Create and modify charts to create static dashboards.

Course outline

• Functions and Formulas.
• Working with date and time.
• Conditional formatting.
• Advanced sorting and filtering.
• Advanced charts.

Course prerequisites

Participants will need to have attended or be familiar with the topics covered in the Introduction to Microsoft Excel course, and participants will need to have downloaded the Microsoft Excel application in advance of this programme.

John McGrath from Productive Solutions Ltd. is the instructor for this Excel for Engineers course.

John has over 20 years’ training experience specialising in Microsoft applications and has delivered more than 3,000 training courses. Prior to this, John worked as university Project Management.

John’s aim is to teach you more about Excel in a day than you might learn in years with software documentation or any self-help tutorial. With John’s guidance you’ll discover how to use Excel as it was meant to be used: as a problem-solver, a time-saver, and a streamlined means to an impressive end.