Details
1-day course
CPD Credit: 6 hours, C1
Course Delivery Options
Course Overview
This course examines several advanced features of Excel for What-if analysis, database analysis, and how to build calculations using advanced functions as well as how to automate processes.
Learning objectives
Upon successful completion of this course, participants will be able to:
- Build complex calculations with advanced functions
- Link, export and consolidate data
- Limit data entry and build complex models with Lookup functions
- Analyse data with simple Tables, PivotTables and PivotCharts
- Create and modify Macros
Course outline
- Protecting your data
- Functions
- Range names
- Data Validation
- Getting and transforming data
- Tables
- Workbook linking
- Data consolidation
- Exporting data
- PivotTable reports
- PivotCharts
- Macros
- Circular references
Course prerequisites
Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate 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 CPD Training Team for further information on scheduled course dates and In-Company options.