top of page

Microsoft Excel PowerQUERY Training

The main purpose of this one dat course is to give students the ability to retrieve data from any data source and prepare it for Excel data analysis

Prerequisites

​

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

  • Working knowledge of relational databases.

  • Extensive knowledge of Excel spreadsheets.

 

Objective

​

After completing this course, students will be able to:

  • Retrieve data from any data source, for example from Excel and SQL Server

  • Create complex transformation using visual click, drag, and drop (no coding needed)

bottom of page