Download the white paper here 👇 Be sure to subscribe for complete access to my analytics resource library Thank you for checking out this white paper. Power Query is the most exciting …
How to filter the results of an Excel worksheet in another worksheet
A friend sent me the following Excel question: I am sorting a list, multiple of thousand entries. When I use the magnifying glass and enter a search term I get a pop-up window that says there are …
Continue Reading about How to filter the results of an Excel worksheet in another worksheet →
How to edit a query that’s already been loaded in Excel Power Query
Have you ever put an analysis together in Power Query, but you'd like to edit the steps once it's already been loaded? Perhaps you want to tweak a filter or add a new column, for example. Let's see …
Continue Reading about How to edit a query that’s already been loaded in Excel Power Query →
How to edit load options in Excel Power Query
In an earlier post I covered how to load data in Power Query. But what about the other side of the ETL pipeline -- that is, loading and editing the connection to those queries? Let's practice on a …
Continue Reading about How to edit load options in Excel Power Query →
How to understand null and missing values in Power Query
I've written in the past how Power Query enforces good data hygiene practices that aren't always in Excel. One of those is the presence of a null or dedicated missing value. This has been a real …
Continue Reading about How to understand null and missing values in Power Query →
How Power Query is the Excel myth buster
One of the central roles of an analyst is myth buster: what is assumed to be true that might not be? And why does it matter? Excel is a legendary business application. But sometimes, legend passes …
Continue Reading about How Power Query is the Excel myth buster →