Power Query for Excel Users
A practical guide to cleaning, transforming, and automating Excel data with Power Query
Created by Oscar Martínez Valero
Discover how to clean, transform, and automate your Excel data using Power Query. Follow along with real-world office scenarios to learn practical techniques that save time and improve accuracy. Build skills you can use immediately, whether you work with spreadsheets daily or manage business data.
Packt | Jul 2026 | 422 min
What You Will Learn
You'll follow relatable business scenarios as you learn to use Power Query, starting with familiar Excel tasks and gradually building more advanced skills. Each section introduces practical steps for cleaning, combining, and automating data, making the process easy to follow even if you're not a technical expert.
Key Features
- Clean and organize messy Excel data using Power Query's intuitive interface
- Automate repetitive data tasks to save time and reduce manual errors
- Apply AI tools to streamline data transformations and boost productivity
Target Audience
This course is designed for office managers, executive assistants, project coordinators, and anyone who works with business data in Excel. If you spend time cleaning spreadsheets, tracking KPIs, or managing reports, you'll find these skills immediately useful. No coding experience is needed-basic Excel knowledge is all you need to get started.
