Logo Visualitics - Esperti di Data Analysis

Power Query for Excel Training

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

Objectives and Methodology

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.

Already Trusted By

Are you interested in signing up for the Power Query for Excel Training?

Are you interested in this course and would like to receive information?
Fill out your request: our Team will get back to you as soon as possible.