Please note javascript is required for full website functionality.

# Blog

## VBA Blogs: Painting with Excel

21 July 2017

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

## Power Query: Uniting Different Types

19 July 2017

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

## A to Z of Excel Functions: The CHOOSE Function

17 July 2017

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

## VBA Blogs: Save the event!

14 July 2017

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

## Power Query: I Just Want a Trim

12 July 2017

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

## A to Z of Excel Functions: The CHITEST Function

10 July 2017

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

## VBA Blogs: An Eventful Month Coming up!

7 July 2017

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.

## Power Query: Splitting Up is Not so Hard to Do

5 July 2017

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

## Monday Morning Mulling: June Challenge

3 July 2017

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.

## Final Friday Fix: June Challenge

30 June 2017

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!