Excel Power Query Course

 

No More Wasted Time on Manual Data Cleanup – Master Power Query and Automate Your Work!

Do you spend time every month on boring, repetitive data cleansing tasks like:

• Deleting rows, columns, or blanks
• Filtering out data you don’t need
• Fixing the layout so it will work in a PivotTable
• Splitting or joining columns or text
• Removing spaces and special characters from your data
• Merging worksheets, text/CSV files together
• Extracting data from an external database
• Incorporating the next month’s data to an existing report
• ….and all the other laborious repetitive tasks that put you to sleep and give you RSI

What if you could automate all of this and free up your time for what really matters — turning data into actionable insights?

Introducing Power Query: Your Data Transformation Ally

Power Query is the ultimate solution for streamlining data preparation, letting you focus on smarter, faster decision-making. Power Query enables you to:

1. Access Data from Multiple Sources: Whether it's Excel files, CSVs, databases, or web data, Power Query connects seamlessly to various data sources.
2. Clean and Reformat Data Effortlessly: With an intuitive interface, you can perform complex data transformations without writing a single line of code.
3. Automate Data Updates: Once set up, Power Query remembers your transformation steps, allowing you to refresh your data with a single click, ensuring your reports are always up-to-date.

You’ll be up and running faster than it would take you to learn the equivalent formulas required to perform the same tasks.

 

Don’t Just Take Our Word for It – Hear from People Like You

Learning Power Query can revolutionize how you handle data, saving hours of manual effort. Here’s what one of our students had to say after applying these techniques:

"Power Query has been a game changer for me and I now use it all the time to do stuff that simply isn't possible using 'traditional' Excel techniques. It has given me back so much time which I use on adding value, more learning and less time actually working." – SJ

This could be your story, too. Imagine completing data tasks in half the time and with zero frustration. Let us show you how.

What is Power Query?

Power Query is built-in to the Excel data tab. It’s available in all Desktop versions of Excel.

The same Power Query tool is also available in Power BI, so learning these skills go twice as far.

Mac users: Power Query for Mac is still under development and has limited functionality. You can install Windows on Mac using Parallels, Boot Camp or VMWare Fusion and then install Excel for Windows running on your VM.

How does Power Query work?

1. Power Query gets your data from almost anywhere – the web, databases, Excel files, Facebook, OData, SharePoint, Salesforce etc. and the list keeps on growing with new data sources being added all the time. The image below shows the Get External Data menus:

 

 

Note: Not all Excel licenses have access to all data sources. Click here to find out more.

2. Power Query enables you to clean, transform, merge and append data with a point and click style GUI that’s easier to learn than formulas or VBA.

Power Query GUI – easy peasy:

 

 

The cool thing is Power Query records your steps so you can automatically use them again and again.

3. Load the data into Excel and or Power Pivot and consume it in your analysis, reports or export elsewhere.

And next month simply press the Refresh All button on the Data tab to update your reports. Power Query will get the new data, clean it just like last time and add it to the table or Power Pivot model for you.

 

 

Learn from a Recognized Expert

Your instructor, Mynda Treacy, has been a Microsoft MVP for over 10 years, and is Co-founder of My Online Training Hub. With more than 25 years of experience, she’s helped thousands of professionals transform their Excel skills.

When you enroll in her Power Query Course, you’re not just getting high-quality tutorials - you’re also gaining access to Mynda Treacy’s personalized support and mentorship.

As a seasoned Excel trainer, Mynda is passionate about helping students succeed. Throughout the course, you’ll have opportunities to:

- Ask Questions: Get answers to your Excel challenges directly from Mynda.

- Receive Expert Feedback: Gain insights and tips to refine your skills and problem-solving approach.

- Be Part of a Learning Community: Join like-minded professionals and learn through shared experiences and discussions.

This isn’t just a course — it’s a learning journey with a trusted mentor by your side. Mynda’s guidance ensures you’re never stuck or unsure of how to move forward.

And with her streamlined teaching methods, you’ll gain Power Query skills faster than you ever thought possible.

This video gives you a sneak peek into her clear, practical, and engaging teaching style.

Watch a Sample Tutorial on Splitting Text

 

Why Choose Our Power Query Course?

Our course is meticulously crafted to empower you with the skills needed to harness the full capabilities of Power Query:

• Hands on Learning: Each module includes practice files, enabling you to apply what you've learned immediately and reinforce your understanding.
• Comprehensive Video Tutorials: In just 5.5 hours of concise, engaging content, you'll be up to speed fast. With 24/7 access, learn at your own pace, revisiting materials as needed.
• Flexible Access: Enjoy 12 months of online access to course materials, with an option to download videos for offline learning.
• Accessibility Features: The course includes English subtitles and a fully searchable transcript, making it easier to follow along and quickly find specific topics or instructions.
• Certification: Upon completion, receive a 'Certificate of Completion' to showcase your new skills and enhance your professional profile.
• Bonus e-Book: Receive "M is for (Data) Monkey" by Ken Puls and Miguel Escobar, a valuable resource to deepen your Power Query knowledge. The e-book is delivered via email 31 days after joining the course.

Power Query Course Syllabus