Microsoft Excel - Power Query Course Overview

Microsoft Excel - Power Query Course Overview

The Microsoft Excel - Power Query course is designed to equip learners with comprehensive skills in data manipulation and automation using Power Query. The course begins with Module 1: What is Power Query?, introducing the tool and its capabilities, guiding learners through navigation and understanding the importance of Applied Steps in the Query Settings.

As learners progress to Module 2: Extract Data, they'll learn to extract data from a variety of sources, including Excel tables, external workbooks, databases, the web, and even multiple files from folders. This sets the stage for more advanced techniques.

In Module 3: Transform Columns & Add Columns, and Module 4: Clean Data, students will master grouping, aggregating, and calculating data, as well as cleaning data by changing text to columns, removing unwanted data, coping with formatting issues, and unpivoting data.

Module 5: Merge & Append focuses on combining data sets effectively, whether from different workbooks or diverse sources. Finally, Module 6: Automate Queries teaches learners to automate their queries, create simple functions, and build dynamic dashboards/reports from Power Query data.

This course is a powerful asset for anyone looking to enhance their data analysis skills, allowing for efficient data transformation and preparation directly within Excel. It empowers learners to handle complex data tasks and streamline their workflow, making it an invaluable resource for professionals in various fields.

Purchase This Course

USD

650

View Fees Breakdown

Course Fee 650
Total Fees
650 (USD)
  • Live Training (Duration : 8 Hours)
  • Per Participant
  • Guaranteed-to-Run (GTR)
  • Classroom Training fee on request
  • Select Date
    date-img
  • CST(united states) date-img

Select Time


♱ Excluding VAT/GST

You can request classroom training in any city on any date by Requesting More Information

Inclusions in Koenig's Learning Stack may vary as per policies of OEMs

  • Live Training (Duration : 8 Hours)
  • Per Participant
  • Classroom Training fee on request

Koeing Learning Stack

Koeing Learning Stack
Koeing Learning Stack

Scroll to view more course dates

♱ Excluding VAT/GST

You can request classroom training in any city on any date by Requesting More Information

Inclusions in Koenig's Learning Stack may vary as per policies of OEMs

Request More Information

Email:  WhatsApp:

Suggested Courses

What other information would you like to see on this page?
USD

Koenig Learning Stack

Inclusions in Koenig's Learning Stack may vary as per policies of OEMs