This is a special post to to discuss a suggestion to improve the Pivot Table experience, especially for Power Pivot users. This week I’m at the 2015 MVP Summit in Redmond, WA. It’s a trip I’m lucky enough to make
This past weekend I attended SQL Saturday in Portland, OR. While I was there, I attended Reza Rad’s session on Advanced Data Transformations with Power Query. During that session, Reza showed a cool trick to merge data based on two
M is for (Data) Monkey: The Excel Pro's Definitive Guide to Power Query In August 2021, we published the second edition of this book under the name Master Your Data for Excel and Power BI. Click here to learn more
I’m pleased to let people know that breaking Power Query via Power Pivot is a thing of the past … at least for users of Excel 2013 or higher. (Sorry, if you’re on 2010, you still need to be careful.)
One of my favourite add-ins of all time just got an upgrade, and I’m super stoked about it. Why? Because I can use it again! As I began my VBA journey, there were two add-ins that I used all the
Some more savvy Excel users know that you can break text onto multiple lines in a cell by pressing Alt+Enter mid entry. Today’s post explores how we can split by line breaks in order to break these types of cell
The other day as I was working through a model, I once again tripped upon the fact that Power Query’s Text.Trim function doesn’t clean whitespace inside the text string, only at the ends. For those who are used to Excel’s
I ran into an interesting wrinkle in a model I’m building, where I need to allocate units based on dates. The idea here is to allow a user to the number of units to allocate, the start date and the
I’m pleased to say that I received the email this morning to let me know that I’ve been renewed as an MVP for another year. This is my 10th Microsoft Excel MVP award, and there have been a lot of
One of the attendees at today’s Power Query Workshop (now Power Query Academy) asked about a specific scenario today. His company doesn’t have a solid IT infrastructure for sharing data, and he’s trying to figure out the best method for
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
