Years ago I published an article on my site called Five Very Useful Functions For Working With Text. This post is alternative version, but with a twist. I bring you 5 Very Useful Text Formulas - Power Query Edition. The
My last two blog posts detailed some frustration that I ran into when working with Power Query. First the issue that I couldn’t trust folders, but got stuck trusting files, and then the issue where I overloaded my credentials area.
After my last post on Power Query Security Woes, Ehren – a developer on the Power Query team – sent me a message on Twitter about it. I will blog about that later, after I’ve had a chance to test
Recently I’ve been working on automating a business process for a client. It’s become a really interesting project that uses a mix of Excel tables, Power Query, Power Pivot and VBA, as well as a WinAutomation script. Before I talk
A couple of weeks ago I was teaching a course on Power Query. I distributed a bunch of sample files, started to walk the attendees through the steps, and a hand went up. “I get an error in my date
At our last MVP summit, I sat in on a session on PowerQuery. Our presenter, who is pretty passionate about it, at one point asked us “Who has wanted to use PowerQuery on their email inbox?” And honestly, I have
Several years ago, when Power Pivot first hit the scene, I was talking to a buddy of mine about it. The conversation went something like this: My Friend: “Ken, I’d love to use PowerPivot, but you don’t understand the database
I was fooling around with the latest build of Power Query (for Excel 2010/2013), and I’ve got to say that I’m actually really impressed with this piece. I think the user experience still needs a bit of work, but once
Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
