Please note javascript is required for full website functionality.
MVP

Blog

Blog

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...


Power Query: Knowing Your Type is the Key

28 June 2017

When transforming data with Power Query, the most important skill is knowing where to start, and this week I look at one such scenario.


A to Z of Excel Functions: the CHISQ.TEST Function

26 June 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.


Hidden vs Very Hidden

23 June 2017

We haven’t seen the VBA blog in a little while. So let’s take a look at things we can’t see. If something is hidden, it’s hard to see. Therefore, if something is very hidden, it must be very hard to see, right?


Power Query: Viewing Query Dependencies

21 June 2017

Workbooks which are built using multiple queries can become complex, and the Power Query Dependencies Viewer is a tool which allows an overview of how each query has been built.


A to Z of Excel Functions: the CHISQ.INV.RT Function

19 June 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.


Seattle doesn't Settle...

16 June 2017

Our Sydney Director, Tim Heng, has just come back from Seattle where he was attending Microsoft’s Data Insights Summit!


Newsletter