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