Last Updated : 11 Sep 2023

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.

5.0

Purchase This Course

USD

375^♱

View Fees Breakdown

Course Fee	375
Total Fees	375 (USD)

USD

275^♱

View Fees Breakdown

Course Fee	275
Total Fees	275 (USD)

USD

^♱

View Fees Breakdown

Flexi Video	16,449
Official E-coursebook
Exam Voucher (optional)
Hands-On-Labs²	4,159
+ GST 18%	4,259
Total Fees (without exam & Labs)	22,359 (INR)
Total Fees (with Labs)	28,359 (INR)

Fee On Request

Live Training (Duration : 8 Hours)
Per Participant
Guaranteed-to-Run (GTR)
Classroom Training fee on request

4 Hours

Week Days

8 Hours

Weekends

Select Date
CST(united states)

Select Time

Day	Time
to	to

♱ 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

Happiness Guaranteed

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

Koeing Learning Stack

Koenig Learning Stack

Free Pre-requisite Training

Join a free session to assess your readiness for the course. This session will help you understand the course structure and evaluate your current knowledge level to start with confidence.

Assessments (Qubits)

Take assessments to measure your progress clearly. Koenig's Qubits assessments identify your strengths and areas for improvement, helping you focus effectively on your learning goals.

Post Training Reports

Receive comprehensive post-training reports summarizing your performance. These reports offer clear feedback and recommendations to help you confidently take the next steps in your learning journey.

Class Recordings

Get access to class recordings anytime. These recordings let you revisit key concepts and ensure you never miss important details, supporting your learning even after class ends.

Free Lab Extensions

Extend your lab time at no extra cost. With free lab extensions, you get additional practice to sharpen your skills, ensuring thorough understanding and mastery of practical tasks.

Free Revision Classes

Join our free revision classes to reinforce your learning. These classes revisit important topics, clarify doubts, and help solidify your understanding for better training outcomes.

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

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

Happiness Guaranteed

Can't Attend Live Online Classes? Choose Flexi- A self paced learning option

Request More Information

Email: WhatsApp:

Koenig's Unique Offerings

1-on-1 Training

Schedule personalized sessions based upon your availability.

Learn More

Customized Training

Learning without limits. Create custom courses that fit your exact needs, from blended topics to brand-new content.

Learn More

Happiness Guaranteed

Experience exceptional training with the confidence of our Happiness Guarantee, ensuring your satisfaction or a full refund.

Learn More

Destination Training

Immerse yourself in a focused learning environment, free from distractions, where you can sharpen your skills in popular global destinations.

Learn More

Fly-Me-A-Trainer (FMAT)

Flexible on-site learning for larger groups. Fly an expert to your location anywhere in the world.

Learn More

1-on-1 Training

Schedule personalized sessions based upon your availability.

Learn More

Customized Training

Learning without limits. Create custom courses that fit your exact needs, from blended topics to brand-new content.

Learn More

Happiness Guaranteed

Experience exceptional training with the confidence of our Happiness Guarantee, ensuring your satisfaction or a full refund.

Learn More

Destination Training

Immerse yourself in a focused learning environment, free from distractions, where you can sharpen your skills in popular global destinations.

Learn More

Fly-Me-A-Trainer (FMAT)

Flexible on-site learning for larger groups. Fly an expert to your location anywhere in the world.

Learn More

Koenig is the ANZ Winner of FY24 Superstar Campaign

Winner of the Microsoft’s Asia Superstar Campaign in FY 22

Download Course Contents

Course Prerequisites

To ensure a successful learning experience in the Microsoft Excel - Power Query course, participants should possess the following minimum prerequisites:

Basic understanding of Microsoft Excel, including familiarity with the Excel interface, creating workbooks, and using basic formulas and functions.
Ability to perform simple data manipulations in Excel such as sorting, filtering, and basic calculations.
Comfort with using a computer, managing files and folders, and navigating the Windows operating system.
An eagerness to learn and explore new tools within Excel for enhancing data analysis capabilities.

Please note that while prior experience with Power Query is not required, a foundational knowledge of Excel will help you grasp the concepts more efficiently.

Target Audience for Microsoft Excel - Power Query

Koenig Solutions' Microsoft Excel - Power Query course empowers users to extract, transform, and automate data for advanced analytics and reporting.

Data Analysts and Scientists
Business Intelligence Professionals
Financial Analysts and Accountants
Marketing Analysts
Supply Chain Analysts
HR Analysts
Reporting Specialists
IT Professionals working with data
Project Managers requiring data manipulation
Excel Power Users seeking to upgrade their skills
Consultants who analyze and visualize data
Researchers compiling and cleaning data sets
Administrative personnel who manage data regularly

Learning Objectives - What you will Learn in this Microsoft Excel - Power Query?

Introduction to Learning Outcomes:

This Microsoft Excel - Power Query course equips participants with essential skills to import, cleanse, transform, and automate the preparation of data efficiently using Power Query.

Learning Objectives and Outcomes:

Understand the fundamental concepts and capabilities of Power Query in Excel.
Navigate the Power Query interface and comprehend the significance of Applied Steps in Query Settings.
Extract data from various sources including Excel tables, external workbooks, databases, web pages, and other miscellaneous sources.
Implement data transformation techniques such as grouping, aggregating, and creating calculated columns using text functions.
Perform data cleaning operations like splitting text into columns, removing redundant data, and addressing formatting issues.
Master unpivoting of data and replacing errors or specific values within columns to tidy datasets.
Learn to merge and append data from different Excel workbooks and various external data sources effectively.
Automate queries within Power Query to streamline repetitive tasks and improve productivity.
Develop an understanding of how to create basic functions in Power Query to enhance data manipulation capabilities.
Create dynamic dashboards and reports from data prepared in Power Query, enabling better data-driven decision-making.