Automate Boring Excel Tasks with Power Query

Use Power Query to automate data cleaning, transformation, and imports in Excel, replacing hours of repetitive work with refreshable, error‑free workflows.

Course details
This course covers Power Query fundamentals for Excel users who work with data from multiple sources or perform repetitive data‑cleaning tasks. You’ll learn when to use Power Query instead of manual Excel techniques and how to build automated queries that import, clean, combine, and refresh data from files, databases, and the web. The course also introduces Copilot with Power Query, demonstrating how AI can assist with query creation and data‑import workflows.