Microsoft Excel for Engineers

A laptop with Microsoft Excel is supplied to all delegates for training
Overview
This 1 day course covers the 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. The student 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. The student will also learn how to use HTML files and work with comments.
Learning objectives
With excel being used so regularly within modern businesses for multiple purposes, this course will be of interest to delegates of all fields and levels that use excel on a regular basis and wish to expand their knowledge on the programme.
Course outline
-
Using Large Worksheets
-
Managing Worksheets
-
Managing Data
-
Using Formulas
-
Using AutoFilter
-
Managing Files
-
Using Name Ranges
-
Creating & Formatting Charts
-
Drawing an Object
-
Using Additional Objects & Effects
-
Using AutoShapes & Diagrams
-
Using HTML Files
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 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.
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.