I'm super excited that Power Query Intellisense and Highlighting features are finally here in Excel! It's been a long time coming, with these features debuting in Power BI Desktop months ago. Where do Intellisense and Highlighting Show up? Let's look
Hopefully you’ve had a chance to try and build a solution to Power Query Challenge 5. In this thread, I’ll show you how I approached it. Challenge Goals The challenge in this case was to allocate a fixed amount for
It’s been a while since our last challenge, so hopefully you’re ready for Power Query Challenge 5! This is one that came up as I was teaching one of our 3 day Excel BI Bootcamp courses for a client, (similar
COACHED: Self Service BI Boot Camp Course Description Prepare to change your company’s reporting game forever! We know that data is not usually stored in nicely curated databases and often – even when it is – the data analyst doesn’t
A recent question from one of our Power Query Academy registrants was about creating a fiscal Saturday calendar - or a calendar where periods end on the last Saturday of each month. I cooked up a sample of one way
If you’re on Office 365 and don’t have Excel’s new Rich Data Types, you should know that they’ll be coming to you soon. Giving us the ability to create both Stocks and Geographies, these are going to add some exciting
In the good old days, it was easy to check the application version in Office with VBA. You just used a little test of Val(Application.Version) to return the number. 12 was Office 2007, 14 was Office 2010, 15 was Office
At long last, we have confirmation that the Cache Shared Nodes Fix is live in Excel. If you're not familiar with this issue, it's one of the most important changes implemented in Power Query in quite some time. You can
As 2018 draws to a close, I've been taking a look back and thought I'd share a quick Year in Review for the last 12 months at Excelguru. This is not by any means a complete look at things, but
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
