Course description

Course Overview

This course is designed to provide participants with a comprehensive understanding of Excel Power Query. The course will cover the basics of Power Query along with advanced techniques to effectively manipulate and transform data within Excel.

Key Learning Objectives

By the end of the course, participants will be able to:

• Understand the fundamentals of Power Query
• Import and transform data from various sources
• Create and manage data models
• Use advanced data transformation techniques
• Automate data refresh and update processes

Requirements

Participants are required to have a basic understanding of Excel and data manipulation. Access to a computer with Microsoft Excel installed is also necessary.

Outcomes

Upon completion of the course, participants will be able to:

• Demonstrate proficiency in using Power Query to import and transform data
• Create and manage data models for complex data analysis
• Apply advanced data transformation techniques to extract and manipulate data
• Automate data refresh and update processes for efficient data management

Certification

Upon successful completion of the course, participants will receive a certification in Excel Power Query.

What will i learn?

• Understand the fundamentals of Power Query
• Import and transform data from various sources
• Create and manage data models
• Use advanced data transformation techniques
• Automate data refresh and update processes