Teaching analytics with modern Excel
Probably one of the most thriving niches of the "learn Excel" industry is to memorize keyboard shortcuts. The idea is that using a mouse is slow and inefficient. Keyboard shortcuts can speed up your …
Continue Reading about Excel users need to do this before memorizing keyboard shortcuts →
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 …
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 →
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 →
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 →
null and missing values in Power QueryI'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 →