Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


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

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


Come on, Make My Spreadsheet, Come on!

2 June 2017

On one of our very focused weekdays, one us stumbled on this nifty parody of Ed Sheeran's "Shape of You" about Excel by Clint Tuttle...


Newsletter