Excel: Power Query
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 0
Excel: Power Query - Online
Level 1
Excel: Extract and transform your data with Power Query
Editions
General information
>> Online activities are asynchronous. You can enroll at any time.
>> During the enrollment period, you can find the activity in your Personal Space or by directly accessing it through the virtual campus link.
>> You will receive a certificate of completion once you complete at least one of the training modules. You can download it in your personal space.
Course ratings
Lesson taught by
BARCELONA ACTIVA
Related courses
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.