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 clean, transform, and load data efficiently
- Explore advanced data manipulation techniques with Power Query
SYLLABUS
- Introduction to Power Query and its functionalities
- Importing and combining data from different sources
- Data transformation and cleaning with Power Query
- Application of filters, calculated columns, and other advanced functionalities
- Data loading and updating with Power Query
- Resolution of practical exercises to apply the concepts learned
- Discussion of specific use cases with Power Query
RELATED PREVIOUS TRAINING:
Online Course - Excel: Power Query
Editions
Mon 17/06/24 (16:00-21:00h)
Tue 18/06/24 (16:00-21:00h)
Cibernàrium-22@
Carrer Roc Boronat, 117 - 127,
BARCELONA
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
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.
