Please note javascript is required for full website functionality.

# Blog

## 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!

## Power Query: Start and End with Grouping

14 June 2017

For those following the series, my past blogs have often dipped into the expense accounts of my (fictional) salespeople. For today’s scenario, I will extract the start and end date of my employees’ expense period to show how easy it is when I use the grouping...

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

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

## Out and About in Seattle

9 June 2017

Next week our director Tim Heng from the Sydney office will be in Seattle attending Microsoft’s Data Insights Summit!

## Power Query: Replace to Relocate – Simpler than Brexit

7 June 2017

Whilst I was creating data to use for my training and blogs on Power Query, I spent time manipulating my data in a Microsoft Access database. It is however possible to do much of this transforming in Power Query and today I will look at a simple example.