Microsoft Excel - Power Query Certification Training Course Overview

Enroll for our 1-day Microsoft Excel - Power Query from Koenig Solutions. In this course you will learn how to perform learn the BI process of importing data, appending and merging tables, conditional logic, data transformation, and organization. Power Query will change the way you work with data in Excel and will save you hours of time that you can then use to explore your data, progress powerful understandings, and make better decisions.

Target Audience:

The training is Intended for data analysts, financial analysts, business analysts, managers.

Learning Objectives:

After completing this course, you will be able to:

  • Learn how to consolidate data from databases and external Excel files
  • Explore the ways to merge data
  • Build your own conditional formulae
  • Use tools to audit your modules

 

Microsoft Excel - Power Query (8 Hours) Download Course Contents

Live Virtual Classroom 650
Group Training
01 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Request More Information

Course Prerequisites
  • A very good knowledge of Excel