In Excel(lent) Functions, I covered how to replicate some commonly used Excel functions. Readers will recall that although Power Query is an add-on for Excel, it does not always work in the same way....

Need to make a CLEAN getaway? This function removes all nonprintable characters from text. And I’m not talking about expletives...

Today we learn how to make something happen when you click on a cell...

Today we look at how to join columns of data when the data type does not match.

Do you choose to use CHOOSE? This function uses index_num to return a value from the list of value arguments...

This month is Event month! Today, we’re going to be looking at how to set up events to trigger on saving a file.

Welcome to our Power Query blog. Today I look at how the Trim function in Power Query works, and how to make it better

In probability theory and statistics, the chi-squared distribution (also chi-square or ?2-distribution) with k degrees of freedom is the distribution of a sum of the squares of k independent standard normal random variables

Over the next few weeks, we’re going to cover a range of Events - these are the actions that can trigger when something happens, such as opening a file, changing sheets, selecting certain cells, and so on.

Welcome to our Power Query blog. Today I look at dividing a full name column into first and last names.