Microsoft Excel for Engineers: Intermediate Level


1-day course

CPD Credit: 6 hours, C1

Course Overview

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. 

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.

Trainer’s Profile

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 in excess of 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.


"Excellent instructor: very knowledgeable. Informative course."

Bernard Doherty, Grant Thornton: "Top quality course. John really understands how to deliver Microsoft courses. Kept everything interesting throughout the day. Excellent."

Roderick Cleary, Grant Thornton: "Very relevant. Extremely well delivered. Would recommend to colleagues."

Please contact the Team for further information on scheduled course dates and In-Company options. You can reach us by phone: 01 665 1305 or email