Van data naar rapportages in Excel Add to favorites

Do you increasingly work with data that you have to report on? But do you notice that you have trouble organizing it and gaining insights? In this training you will learn how to translate relevant data into clear and concise reports. During the meetings you will get started with Excel, learn to use all basic functionalities and strengthen your reporting skills under the supervision of an expert. At the end of the training you will know how to use Excel efficiently and effectively to create the best reports.

Unique benefits

• You get more out of Excel with less effort
• You can immediately start working on your own reporting
• Guidance from an Excel expert

Target audience
This training is intended for professionals who increasingly have to work with data in Excel in their work and want to get a better grip on this.

Please note: during the meeting you will be working with Excel. It is therefore important that you bring your own laptop with Excel (Office/Microsoft 365) to the meetings.

Result

• You know how to use the possibilities of Excel to organize data
• You turn data into correct information
• You know how to find and fix errors
• You can visualize data clearly
• You translate data into clear reports

Program
Data-driven working & grip on Excel

• The importance of data-driven working in organizations
• Main functionalities of Excel:
• > All basic functions for importing, checking and organizing data
• > Adding helper columns, filtering data with sliders and using pivot tables

Data and information skills

• The importance of critical thinking when working with data
• How do you handle data in Excel?
• How do I turn data into correct information?

Creation and reporting skills

• What is the message I want to convey?
• How do I visualize data and combine visual elements?
• How do I export to Word and PowerPoint?
• How do I include my target group?
• best practices
• Create my own report

Study mode
Intake | Prior to the training you fill in a written intake form in which you answer a number of questions aimed at your personal situation. These questions help you to clearly describe your development goal.

Experienced trainers | An experienced trainer supervises the classroom meetings in which your learning needs are central. Your trainer is an expert in the field of Excel, but above all your personal coach.

Blended learning | At ICM we believe in blended learning, where online learning reinforces classroom learning. Because you gain knowledge in advance, there is more time left during a class meeting to learn from each other.

Online learning environment | In addition to the interactive classroom days, you work with the rich online learning environment that supports you in the learning process. Here you will find information about the basic functions of Excel that you can view prior to the first meeting. This way everyone starts at the same basic level. After the training, you will have unlimited access to all online material for deepening and reference work.

ICM Certificate | If you have followed the entire training, you will receive the ICM certificate.