Excel Expert MO-211 (guided self-study) (partnercourse)

Duur
90 dagen
Prijs

€ 249,-
Reviews
1000+ reviews
Planning

Planning ophalen...
Lesvorm
e-training

Schrijf je direct in Meer informatie Brochure downloaden

In this MO-211 course, advanced Microsoft Excel features are used to support data analysis and reporting. The course focuses on working with complex datasets and applying Excel as a reliable analysis and reporting tool in professional environments. It develops skills that support data-driven decision-making and contribute to improving reporting processes within an organization.

The Excel course content covers advanced options for managing and sharing workbooks. It includes working with complex functions for financial and statistical calculations, as well as data validation techniques to help ensure data accuracy and consistency. The course also addresses analyzing large datasets using advanced pivot tables and charts. In addition, automating recurring tasks with macros is covered to improve efficiency and consistency in analytical workflows.

The course is built around practical case studies based on real-world scenarios. By creating complex Excel models and combining data from multiple sources, a structured approach to data analysis and presentation is developed. This hands-on approach aligns with the requirements of the Excel Expert exam and enables direct application of the learned techniques in reports and dashboards, with a focus on clarity, structure, and effective use of Excel functionality.

Doel

After completion, you can perform complex data analyses and automate advanced reports. You will be fully prepared for the official Microsoft exam and earn the Microsoft Office Specialist: Excel Expert (MO-211) certificate upon passing.

Doelgroep

Experienced Excel users who work with complex data and want to improve their skills in advanced data analysis and reporting. It is suitable for professionals in roles such as financial analysts, data analysts, controllers, business analysts, and other professionals who regularly use Excel to create advanced reports, dashboards, and analytical models.

Voorkennis

The following prior knowledge is required: Excel Associate MO-210

Bijzonderheden

This course is delivered in collaboration with Winc academy.
This course is also available in Dutch: Excel Expert MO-211
For this course access to Microsoft Office 365 is necessary
Duration: 12 hours (3 months access).

Jan Struik

senior accountmanager

Onderwerpen

Managing and reusing macros
Using advanced data validation and formatting
Applying logical and conditional functions

Working with advanced charts and PivotTables
Applying all MO-211 skills and techniques

Planning & Prijs

* *Een cursus met start gegarandeerd.
*Een cursus met valt onder de actie Summer Academy.

Alle prijzen zijn excl. BTW.

Wil je meer informatie ontvangen, een vrijblijvende offerte ontvangen of een brochure van deze cursus downloaden? Vul onderstaande gegevens in en je ontvangt de brochure of informatie binnen één werkdag.

Gerelateerde cursussen

Er zijn geen gerelateerde cursussen.

Ervaringen

ervaringen verzameld via

"Training was prima, goede tips gekregen met af en toe een grap en grol. Locatie was prima, goed verzogd vwb koffie/thee, fruit en koekje. Mensen ook zeer vriendelijk. Lunch was perfect en zeer uitgebreid."

"De cursus was goed, en de verzorging ook!Ik heb er veel van opgestoken! De lokatie in Nieuwegein is goed te bereiken met het openbaar vervoer, dus dat is prettig. Tot een volgenden keer."

"Ik vond de training erg leerzaam. De inhoud was van een hoog niveau en de docent was goed thuis in de materie. Ik stel het vooral op prijs dat er diep op de concepten werd ingegaan."

Categorieën

Onderwerpen

Leveranciers

Prijs