This course is aimed at fairly experienced Excel users who need to learn more complex functions, nesting, data manipulation and automation.
This training is aimed at Excel users who have attended the Intermediate course, need to use more complex functions and analyse data.
You must have sound Excel skills and understand key concepts of spreadsheets.
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.
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.
Training is held at your offices or any alternative suitable venue.
€450 for up to 5 participants, €90 per extra participant.