View events by type

Microsoft Excel for Engineers - Intermediate Level

  • Date(s)
    Friday, 29 March 2019
  • Time(s)
    9:00 AM - 5:00 PM
  • Venue
    Engineers Ireland, 22 Clyde Road, Ballsbridge, Dublin 4, Ireland
  • Fee

    Members: €375
    Non-Members: €425

    NOTE: You can only book online using credit or debit card details.  If your preferred method of payment is by invoice / purchase order / bank transfer / other, please contact the CPD Training Team on 01-6651305, or email cpdtraining@engineersireland.ie to secure a place.

  • CPD Credit
    7 hours   C2

A laptop with Microsoft Excel is supplied to all delegates for training

Overview

This one day course in Microsoft Excel will include features to manage data, worksheets, and workbooks. It includes tasks such as using large worksheets; working with multiple worksheets, and managing data, worksheets and files. Participants will also learn how to use ranges, other functions, and filter data in a list.

This course covers working with charts, graphics and files. It includes tasks to create and format charts; draw an object; use additional effects and objects; and use AutoShapes and diagrams. Participants will also learn how to use HTML files and work with comments.

Course Outline

  • Exploring Microsoft Excel
  • Using Basic Workbook Skills
  • Working with Ranges
  • Creating Simple Formulas
  • Copying & Moving Data
  • Formatting Numbers & Text
  • Formatting Cells
  • Working with Columns & Rows
  • Using Page Setup
  • Printing 
  • Working with Mulitple Worksheets
  • Using Other Functions 
  • Creating & Editing Charts
  • Using Large Worksheets
  • Managing Data
  • Working with Comments
  • Drawing an Object
  • Additional Effects & Objects
  • Using Autoshapes & Diagrams
  • Using Worksheet Protection
  • Using Paste Special

Course Objectives

By the end of this course participants should be able to:

  • Recognise the main areas of the Excel window & workbook
  • Enter, edit & delete data in a workbook
  • Create workbooks using formulae & functions
  • Enhance the presentation of workbook data
  • Create, display & enhance charts, print worksheets
  • Set up & work with multiple worksheets
  • Freeze titles on a worksheet
  • Sort & subtotal data
  • Add comments to a worksheet

Trainer Profile

The instructor for this Excel for engineers course will be John McGrath from Productive Solutions Ltd.

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.

Make a Booking

29 March 2019

TERMS AND CONDITIONS

Confirmation is subject to event fee being finalised. Cancellation fees calculated at 50% of the estimated total bill will be charge for confirmed bookings cancelled less than 5 working days prior to the date of the planned event. A replacement person can attend instead. Cancellations made the day prior to an event will be charged 75% of the total estimated bill. No-shows will be charged the full fee. All cancellations must be confirmed in writing by email. Engineers Ireland will not be liable for any costs in the event of a course being re-scheduled.  This applies, but is not limited, to any travelling, subsistence or consequential expenses incurred by delegates.

TESTIMONIALS

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

 

IN-COMPANY TRAINING