Microsoft Excel - Business

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
• choose the analysis tools (functions, graphs, pivot tables) needed according to the requirements and collaborate with other applications

Target audience:

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

Duration: 2 days

Agenda:

• Introduction
• Use of formulas and functions
• Data import and cleaning
• Data analysis - functions, graphs, pivot tables
• Collaboration with PowerPoint, Word, Outlook
• Discussions. Examination. Closing the course

Presented tools:

Data cleaning and extraction functions, Text to columns, Duplicates, Conditional formatting, Problem graphs, Pivot tables and graphs

Elements of collaboration with other applications

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.