Audience
This training is aimed at Excel users who have basic excel skills and who now need to create their own workbooks to gather and analyse data.
Requirements
You must have basic 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:
- Use lookup functions to automate data input
- Create and use excel tables
- Use data validation techniques to verify and restrict data entry
- Create pivot tables
- Use filters to query data
- Automatically highlight data based on criteria
- Create dynamic charts to visually represent your data
- Use a variety of Text and other functions to manipulate data.
- Clean up data imported from other applications or text files.
- Login to the Online Learning system to access course notes and files.
Course Locations
Training is held at your offices or any suitable venue.
Cost
Daily fee of €450 for up to 7 participants, €65 per extra participant.