-

Power Query - Essentials


This course is designed to introduce beginners to the essential concepts and practical applications of Power Query in Excel, providing a solid foundation for effective data transformation and analysis.

We provide a customizable course according to your company’s requirements! Click on the pdf below for more information.


1. Duration

8 hours


2. Objectives

  • Introduction to Power Query

  • Introduction to Data Transformation in Power Query.

  • Data Transformation Techniques.

  • Introduction to Power Query Functions.

  • Query Folding and Optimization

  • Data Loading and Output

  • Real-world Applications and Case Studies


3. Pre-requisite

You must have worked on Excel for at least 6 months.