Power Query for Excel Training

Discover how to clean, transform, and combine your data in Excel.

Objectives and Methodology

Power Query for Excel Training is designed for those who work with data in Excel and want to learn how to clean, transform, and model their data with Power Query, Excel’s ETL tool. The training adopts a “hands-on” methodology, where explanations and demonstrations alternate with exercises and practical activities.

Course Structure

Power Query for Excel

Introduction and Overview of Features
Connecting to Data
Table Transformations
Pivot and Unpivot

Column Transformations
Join and Union
Creating New Columns (Custom and From Examples)
Saving Changes

IN-PERSON OR ONLINE

ITALIAN, ENGLISH

4 HOURS
OF TRAININGS

FINAL
CERTIFICATION

FINAL SELF-ASSESMENT TEST

In-depth and Useful Information:

Skills You Will Gain

By completing the course, you will acquire the necessary skills to manage and model your data in Excel. You will learn to connect to various data sources, model your data, and perform complex table and column transformations.

Prerequisites

None. Don’t worry, the Power Query for Excel training is suitable for anyone working with data, regardless of technical and analytical background.

Technical Requirements

We invite you to install Excel to be able to perform the practical exercises included in the course. To access course materials and download exercise files, you’ll need to register on the Visualitics learning portal: LearnToViz.

Training Delivery Methods

You can participate in all our trainings either in person or remotely, depending on your needs. Both the in-person and online training sessions are conducted in a single 4-hour session. You will have access to our LearnToViz learning platform to complete practical exercises, view the presented materials, engage in post-training exercises, interact with the community, and enhance your skills with numerous free resources.