This course is aimed at fairly experienced Excel users who need to learn more complex functions, nesting, data manipulation and automation.
Audience
This training is aimed at Excel users who have attended the Intermediate course, need to use more complex functions and analyse data.
Requirements
You must have sound Excel skills and understand key concepts of spreadsheets.
Self Assessment
Click the button below to take a 3 minute self assessment. It will give you an idea of whether you are ready for this course.
Course Duration
1 Day
Objectives
After the training, you will be able to:
- Design a well structured workbook
- Protect and verify data input
- Filter and highlight data
- extract Information
- report Information
- prevent and correct errors
- Work across multiple sheets and workbooks
- Create and use data models
- Query using external data (Excel 2013, 2016, 365)
- Login to the Online Learning system to access course notes and files.
Course Locations
Training is held at your offices or any alternative suitable venue.
Cost
€450 for up to 5 participants, €90 per extra participant.