Become a Power Query Master in Excel in Less Than One Hour
Offered By: Great Learning via YouTube
Course Description
Overview
Master Power Query in Excel with this comprehensive 58-minute video tutorial. Learn to gather, clean, and transform data from various sources, streamlining your data preparation process for efficient analysis. Explore key characteristics, functions, and prerequisites of Power Query while gaining hands-on experience with data transformation and cleaning techniques. Follow along with a practical demonstration and discover how to automate data tasks, optimize your workflow, and manage large datasets effectively. Perfect for intermediate Excel users looking to enhance their skills and boost productivity in data handling and analysis.
Syllabus
Introduction to Power Query
Key characteristics and functions of Power Query
Prerequisites and System Requirements for Power Query
Using Functions in Power Query
Types of Functions in Power Query
Data Transformation and Cleaning
Demo of Power Query
Summary
Taught by
Great Learning
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX