On the final Friday of each month, we’re going to set Excel for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only...

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.