Microsoft Excel - advanced level

Objectives - at the end of the course the participants will be able to

• import data from multiple sources and process it for analysis
• create and use a Data Model in pivot tables and in Power Pivot, process automation with VBA and Power Query

Target audience:

Personnel from production or service companies, involved in analysis and reporting - departments: quality, production, logistics, human resources, financial, etc.

Duration: 2 days

Agenda:

• Introduction
• Advanced use of formulas and functions
• Data import, cleaning and analysis, Advanced graphics,
• Advanced use of pivot tables, Power Pivot
• Creation and use of VBA and Power Query
• Discussions. Examination. Closing the course

Presented tools:

Advanced data cleaning and extraction functions, Dynamic Array - New Office 365 functions, Advanced graphics, Data Model, Power Pivot, VBA and Power Query.

Full practical course. Requires own computer with Microsoft Office 2016/2019/2021 or Microsoft 365.

Trainer:

He is certified as a Microsoft Certified Trainer (MCT) and has over 20 years of experience in professional training, consulting, and teaching activities in information technology.

For more information, please contact us.