The aim of the course is to provide participants with advanced knowledge on the use of Microsoft Excel (writing formulas and functions, sorting and filtering data on multiple levels, creating custom lists, databases and in-depth data analysis using the pivot table). In addition, knowledge of Power BI will be deepened, with which it will be possible to create data analysis tools independently by building data models and custom dashboards .
Free training courses
Description
Requirements
This course is funded through the active labor market policies program Workers’ Employability Guarantee (GOL).
To access this free course you must:
Be between 16 and 64 years old.
Don’t have a job.
Have residence or domicile in Lombardy.
Not having previously activated an active labor market policy path (GOL Program).
Knowledge of the Italian language.
Intermediate computer skills.
Plan
Professional use of Microsoft Excel : interface, writing formulas and functions , advanced management of sorting and filtering on multiple levels.
Create custom lists and databases to organize data efficiently.
Using PivotTables for in-depth data analysis and visualization of key information.
Deep dive into Power BI to create custom data models and dashboards that provide powerful analytics and decision-making automation.
Career opportunities
Data Analyst
Business Intelligence Specialist
Reporting Specialist
Duration
3 weeks
Where it takes place
At AKG headquarters in Milan or online
