The question of how to convert Julian dates to Gregorian dates using Power Query came up today in a course I was teaching. Although I haven't ever used JD Edwards myself, apparently this is quite common in that system, so
Recently, a reader commented on a blog post that I wrote back in 2015. Their question essentially boiled down to working out how to label duplicates with Power Query. As an additional twist though, they also wanted to ensure that
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
This past weekend we published a major redesign at Skillwave.Training. Months in the making, this has been a total overhaul to focus on delivering the best online learning experience for our clients. Check out some of the images from the
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
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
Have you ever built multiple queries in one Power Query session? You get to choose one load destination, then have to change each of the incorrect ones... one by one. Have you ever wished you could change multiple load destinations
We’re pleased to announce the first Monkey Tools update is now available for download! This one contains a new feature, some new logic and an update to one of our data connectors. Read on for more information! I can’t believe
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
