Become a Data Master with Power Query
Ken is really excited to be teaching his popular Master Your Data with Power Query class for the first time in New York City! Join us this spring for a small group hands-on workshop and learn how to become a
Ken is really excited to be teaching his popular Master Your Data with Power Query class for the first time in New York City! Join us this spring for a small group hands-on workshop and learn how to become a
Yesterday, I posted a new Power Query Challenge, and in this post I'm going to show my solution to challenge 4. You can pick up this solution as well as solutions created by the community in this thread of the
It's time for Power Query Challenge 4! This one is a tricky little challenge with creating a header row - but from different rows in the data set. The real world scenario driving Power Query Challenge 4 Have you ever
Whether by email or in person at conferences, I've received a lot of requests for more Power Query Challenges. You all seem to love testing your skills, and I really want to keep the Power Query Challenges going. In order
As you may have heard, we have been working on a set of helpful Power Query Recipes for Excel and Power BI and are excited to announce that they are now officially available! Are our Power Query Recipes for you?
Wow… 46 submissions for Power Query Challenge 3! Crazy stuff. So many that I haven't even had time to read them all yet! Due to the overwhelming responses, here's how I'm going to handle this: Show you how I approached
**Please note that the challenge is now closed, so we are no longer accepting submissions. However, you are still welcome to try it out on your own. I've got a lot of feedback that you enjoy the Power Query Challenge
When Ken was at the Microsoft Business Applications Summit a few weeks ago, he met Mr. J.A. Garcia who has been doing some amazing work with Power Query. We wanted to share his story about how he has been using
What an overwhelming response to Power Query Challenge #2! We had 40 submissions, and some with multiple entries in a single submission. Plainly you all enjoyed this! Naturally, there were a couple of submissions that involved custom functions, and a
I'm at the Microsoft Business Application Summit this week, so I thought I'd post another Power Query challenge, especially since our last one was so successful. For this Power Query challenge … Our business challenge here is that we are
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.