Robin E Hunt
Free Lesson

Discover the Power of Power Query in Excel and Power BI

75 min
Dec 7, 2026 11:30 AM

By continuing, you agree to Maven's Terms and Privacy Policy.

What you'll learn

Identify Power Query and Its Capabilities

Explore what Power Query is, where to find it in Excel and Power BI, and how it supports data preparation.

Recognize Opportunities to Simplify Data Preparation

Identify common data cleaning challenges and discover how Power Query reduces repetitive manual tasks.

Explore Data Transformation and Refresh

Discover how Power Query records transformation steps and reapplies them when source data changes.

Why this topic matters

Data preparation is essential to working with data, yet many professionals spend valuable time repeating manual tasks. Power Query provides a practical way to clean, transform, and combine data using tools available in Excel and Power BI. Understanding its capabilities helps reduce repetitive work, improve consistency, and create repeatable processes that support more reliable reporting and analysis.

You'll learn from

Robin E Hunt

Robin E Hunt

Robin Hunt | CompTIA Data+ author, data educator, and ThinkData co-founder.

See all products from ThinkDataSol
Get free access