Details
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.
Testimonials
"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 cpdtraining@engineersireland.ie