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:

• extract the maximum value from your data (numbers, dates, times, text);
• introduce Power Query as a time-saving tool for transforming data lists;
• efficiently create up-to-date pivot tables.

At the end of the course, you will be able to analyze your databases from all perspectives and present them in a didactic and professional manner.

CONTENT

• Features of a correct database
• Advantages of the "table" format
• Sorting and filtering data (advanced techniques)
• Creating pivot tables (Pivottables) based on one or multiple lists/tables
  • Analyzing with pivot tables
  • Basic and advanced techniques in pivot tables
• Querying two linked tables in a data model
• Introduction to Power Pivot for querying multiple linked tables
• Working with Power Query
  • Suitable for cleaning up lists
  • The new way to link data lists/tables in Excel
  • Creating workflows to save time

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

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).

• For those who wish to go beyond the basics
• Learn in a group, in a motivating and targeted way
• Invest together in personal development

• Be on time for the training. It’s best to arrive 10 minutes before it starts.
• Unexpected delay? Inform your on-location contact.
• Febelfin Academy’s reception desk can be reached at +32 (0)2 507 69 61.

• To receive your participation certificate for a classroom training, your presence and active participation are required throughout the entire session. Interaction is key to our trainings.
• Your participation certificate will be published on your MyFA account the day following the course.
• Febelfin Academy wishes you a great learning experience.

This training can be followed by various target groups:

• commercial and administrative staff;
• employees who report;
• managers;
• other roles needing to analyse data.