Microsoft Excel - intermediate level

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

• perform a data import, clean the data and process it for analysis
• to choose the analysis tools (functions, graphs, pivot tables) necessary depending on the requirements,
• to know automation elements - VBA, Power Query

Target audience:

Personnel from production or service companies, involved in the development, control or management of processes - departments: quality, production, logistics, human resources, financial, etc.

Duration: 2 days

Agenda:

• Introduction
• Use of formulas and functions
• Data import and cleaning
• Data analysis - functions, graphs, pivot tables
• Introduction to VBA and Power Query
• Discussions. Examination. Closing the course

Presented tools:

Data cleaning and extraction functions, Text to columns, Duplicates, Conditional formatting, Problem graphs, Pivot tables and graphs, 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.