Data Analysis with Excel
Do you think you could use Microsoft Excel in a more efficient way? We've got you! Elevate your Excel proficiency with our 2-day, instructor-led course on data analysis, creating data models, and crafting graphical dashboards.
Next date
Language
Duration
Format
Prerequisite
Price
Need financial support to follow this track?
Why should I take this course?
You’re the perfect match if you…
Basic skills in Excel
This course is designed for people who have basic Excel skills and want to take the next step.
Education Level
We estimate that you need to have higher education or equivalent professional experience to be able to follow along.
Workers and job seekers
Everyone is eligible for this training: employed, self-employed and job seekers.
Language
This course is given in Dutch and in English: you can choose which one suits you best. The study material is in English.
Age
We believe in age diversity. If you want to qualify for the STAP budget, you must be over 18 and not yet eligible for state pension.
Laptop or computer
Preferably Office 365 or 2021, but earlier versions (after 2010) can also participate.
Learn to analyze data in Excel in 2 days
Here’s what you’re going to learn
This course is designed for those who have basic Excel skills and want to enrich their skills. The pace is fast. You'll learn in 2 days how data analysis works and how to build a data model with a graphical dashboard. Therefore, it's important to have basic knowledge of Excel.
Day 1
- Get data into Excel quickly and conveniently
- Enriching data using formulas and functions
- Creating and using tables
- Creating pivot tables
- Creating charts
- Simple data analysis with Excel
Day 2
- Power Query: Importing data from different sources
- Transforming and cleaning data
- PowerPivot: Creating a Data Model
- Creating relationships
- Building a data model with DAX functions
- Creating a visual report from the data model
Why Learning at Techionista Academy is different?
Frequently asked questions
When will I know if my STAP application has been approved?
The UWV can take up to 4 weeks to approve applications but aims to do so within a few working days. For most applications, if the conditions are met, the STAP budget is awarded almost immediately.
Do I have to wait for my STAP budget application to be approved before I can apply for training?
No, you don’t have to wait. The first step is to enroll in the Techionista Academy training of your choice. After enrollment, you will receive a certificate of enrollment. From November 1st you can apply for the STAP budget via stapuwv.nl. If the STAP budget is granted, we will receive a copy in the form of a purchase order, and you are ready to start the training!
For which of your courses can I use the STAP budget?
Techionista Academy is registered in the STAP Training Register, which means that the STAP budget of € 1,000 can be used for all our trainings.
What if I want to take a course that costs more than €1,000?
Would you like to take one of our long-track courses? Then it is also possible to make use of the STAP budget. You will receive a discount of € 1.000 and pay the rest of the costs yourself.