Excel: Power Query
With this Power Query course you will discover techniques and strategies that will allow you to treat data effectively, using powerful analytical tools without the need to carry out complicated codes.
Specific goals | Temary
OBJECTIVES
- This training will provide you with a deeper understanding of how to manipulate data efficiently, enhancing your data analysis and decision-making skills.
SYLLABUS
- Power Query Fundamentals
- Introduction to Power Query
- Data connection and filtering
- Data transformation level I and adding columns
- Handling text and dates
- Advanced Power Query Functions
- Data transformations level II
- Combining and appending queries
- Automated folder connection
- Conditional columns and grouping
EXCEL POWER QUERY LEARNING PATH
Level 1
Excel: Power Query - Online
Level 2
Excel: Extract and transform your data with Power Query
Editions
General information
Learn at your own pace
The online training courses are self-paced and you can register at any time.
Enjoy learning from wherever you want, at your own pace and without schedules.
Access
The activities are available at Campus Virtual de Barcelona Activa Certificate
To obtain the certificate of completion, it is necessary to complete the final questionnaire of the course. Once passed, you can download it to your
