Monkey Tools is Here
We are super excited to announce that we’ve (at last) released the first version of our Monkey Tools software! Ken has been working on this software on and off for the better part of 8 years now. But after showing
We are super excited to announce that we’ve (at last) released the first version of our Monkey Tools software! Ken has been working on this software on and off for the better part of 8 years now. But after showing
I'm currently hanging out in New Zealand, with a friend who has generously let me stay at his place instead of a hotel. What I didn't know when he offered a bed though, was that the cost of admission was
Recently I received a question on how to Unfill in Power Query. In other words, we want the opposite of the Fill feature, which fills data into blank cells (cells that contain a null value.) If we see repeating values,
Removing the top five rows from a data set is easy in Power Query, but what do you do when the number of rows changes? There isn’t a built-in Remove Dynamic Number of Top Rows function. In this post we’ll
On this blog, I showcase a lot of different techniques for manipulating and reshaping data. For anyone that follows the blog, you already know this, and you know it's a pretty important topic to me. But the thing we shouldn't
One of the things that I find a bit misunderstood in Power Query is whether or not Data Types matter. I mean, I’m sure everyone agrees to some point that they do, but you do know just how much they
Ken had a blast in June going down to Atlanta for the Microsoft Business Applications Summit (MBAS). There, he and co-author Miguel Escobar led an in-person workshop together for the first time. Ken also presented a breakout session on best
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?
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
Miguel and I were at the Microsoft Business Applications Summit last week, and we were frequently asked for an update on the Master Your Data book (aka M is for (Data) Monkey version 2.0). We were told that it’s time.
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
