Compare with 1 courses

Excel Power Query Course

Excel Power Query Course

$9.99

$69.99

The Excel Power Query Course is designed to teach participants how to efficiently import, cleanse, and transform data within Microsoft Excel using the Power Query tool. This course will cover the basic functionalities of Power Query, including data connections, data manipulation, and data transformation. Participants will learn how to extract and clean data from various sources, create custom queries and merge data from multiple data sets. By the end of the course, participants will have gained the skills to effectively use Power Query to streamline their data analysis and reporting processes.

Learn more
Has discount
Expiry period Lifetime
Made in English
Last updated at Sun Sep 2024
Level
Beginner
Total lectures 41
Total quizzes 0
Total duration 04:47:29 Hours
Total enrolment 0
Number of reviews 0
Avg rating
Short description The Excel Power Query Course is designed to teach participants how to efficiently import, cleanse, and transform data within Microsoft Excel using the Power Query tool. This course will cover the basic functionalities of Power Query, including data connections, data manipulation, and data transformation. Participants will learn how to extract and clean data from various sources, create custom queries and merge data from multiple data sets. By the end of the course, participants will have gained the skills to effectively use Power Query to streamline their data analysis and reporting processes.
Outcomes
  • 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