You read that correctly, the Data Monkey has landed, and Master Your Data for Excel and Power BI is now available in PDF format from your favourite online bookstore! You may have noticed that the past few months have been
Master Your Data with Excel and Power BI If you are struggling to clean up your data in Excel or Power BI, or spending time performing repetitive data cleanup on a regular basis, you owe it to yourself to learn
For a while now, I have been wanting to have the capability in Power Query to select a query by name PROGRAMMATICALLY. Why? Building a SelectQuery Function would allow me to execute one of multiple “Transform” queries depending on a
We're super excited to let you know that we've just released some new Monkey Tools features! Let's take a quick look as to what is new... The Table Monkey This feature was actually released back in December. However, since we
Wow, it is hard to believe it is already December. And looking back at my blog, I realized that I forgot to tell you that we released a few more free features in Monkey Tools over the past month! In
You know the drill… extract, transform and load your data, relate your tables, then create basic DAX measures. All work that needs to be done before you can really get started on analyzing your data. Today we’ve unleashed the Measure
A question came up in the Excelguru forums today about how to use Excel tables to filter a Power Query. While Power Query can't read a filter from an Excel table natively, there is a cool little trick that you
We've been kind of quiet here, but we're excited to announce that we've just published an update to Monkey Tools QuerySleuth feature. It now contains an "tabbed" experience so that you can easily flip back and forth between queries, "pinning"
We’re super excited to announce that we have given the Monkey Tools calendar creator feature an upgrade. In fact, it is so much of a power up, that this feature has graduated into its own full grown monkey! We call
Have you ever loaded a Power Query to a worksheet and then changed the name to match the query? It's a shame that there is no option to name worksheets after queries, as this would be handy. Well, after seeing
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
