Excel: Extract and transform your data with Power Query
Excel: Extract and transform your data with Power Query
Deepen the capabilities of Power Query with this course, learning how to transform data and simplify processes in Excel. Optimize your efficiency by manipulating tables and getting accurate results.
Specific goals | Temary
OBJECTIVES
- Use Power Query to efficiently clean, transform, and load data
- Explore advanced data manipulation techniques with Power Query
SYLLABUS
- Introduction to Power Query and its functionalities
- Data import and combination from different sources
- Data transformation and cleaning with Power Query
- Applying filters, calculated columns, and other advanced features
- Loading and updating data with Power Query
- Practical exercises to apply learned concepts
- Discussion of specific use cases with Power Query
EXCEL POWER QUERY LEARNING PATH
Level 0
Excel: Power Query - Online
Level 1
Excel: Extract and transform your data with Power Query
Editions
Thu 10/10/24 (15:00-20:00h)
Fri 11/10/24 (15:00-20:00h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
Mon 11/11/24 (16:00-19:00h)
Tue 12/11/24 (16:00-19:00h)
Wed 13/11/24 (16:00-19:00h)
Virtual classroom
General information
>> In case the format is virtual via streaming, it will be carried out through the free platform Microsoft Teams. Registered individuals will receive the invitation link and access instructions by email before the session starts.
>> Entry to the classroom will not be allowed after 15 minutes once the activity has started.
>> The language in which each session is conducted is informed in the description of each activity.
>> Any of the training actions of Cibernàrium may be recorded through an image capture system that aims to subsequently disseminate them through a medium or support within the scope of the mission of Barcelona Activa to contribute to economic promotion and employment. In the recording process, images of attendees may eventually be recorded. Registration for Cibernàrium activities implies authorization for Barcelona Activa to use these images for the aforementioned purpose.
Course ratings
Lesson taught by
FERRER ARNALDO
Related courses
Personal Data Protection Law
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.