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 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 →
How Power Query serves as an extract, transform, load (ETL) tool for Excel
Let's be honest, there are a lot of terms in tech that sound way more complicated than they really are. Maybe it goes by an acronym for peak confusion. But peel back the concept and it makes perfect …
Continue Reading about How Power Query serves as an extract, transform, load (ETL) tool for Excel →