Data analysis in MS Excel
Data analysis is rapidly evolving, and Excel is keeping up with this trend. Through this training, you will not only gain up-to-date insights into pivot tables but also become familiar with Power Query. This knowledge is essential for anyone who needs to clean/transform data before analysing it.
The objectives of this training are to:
- introduce Power Query as a time-saving tool for transforming data lists;
- efficiently create up-to-date pivot tables.
Total price *
Members: € 550
Non-members: € 650
Partners/ BZB: € 550
Incompany: tailor-made, prices on request
* Price: service in the context of continuing professional training, exempt from VAT
Please let us know you're interested in this training should there be no date available, the planned date does not suit you and/or this session is full. As soon as about 5 people are registered on the interest list, we will propose a new course date. Your registration on the interest list is free of charge and without any obligation.
Target group
This training can be followed by various target groups:
- commercial and administrative staff;
- employees who report;
- managers;
- other roles needing to analyse data.
Required prior knowledge
Personal development training: this training requires a general basic knowledge of the subject.
Required prior knowledge:
- Basic knowledge of Excel;
- Familiarity with sorting and filtering in Excel;
- Basic knowledge of pivot tables is helpful but not required.
Programme
CONTENT
- Working with Power Query
- Suitable for cleaning lists
- The new way to link data lists/tables in Excel
- Creating workflows to save time
- Creating pivot tables based on one or more lists/tables
- Analysing with pivot tables
- Basic and advanced techniques in pivot tables
PRACTICAL INFORMATION
- Duration: 1 day training (6 class hours)
- Hours: 09:00 to 17:00
- Location: Febelfin Academy: Phoenix building, Koning Albert II-laan/Boulevard du Roi Albert II 19, 1210 Brussels
- Language: This training will be given in English
Methodology
You follow a ‘Classroom training’ in a group. You, the other participants and the teacher are all present in the same classroom at an agreed time. There is an opportunity for interaction and feedback, both from the participants to the teacher and vice versa. The teaching material consists as a basis of a presentation via the MyFA learning platform, supplemented with various other items (such as digital syllabus, presentation, audiovisual fragments, etc.).
Training material: Powerpoint presentation (slides).
Teachers
Betsy Calcoen
Personal development
