Please note javascript is required for full website functionality.

# Blog

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

## Power Query: Less Aggravating Aggregating

31 May 2017

Today I look at combining data from tables in Excel worksheets in other workbooks (again), with less steps thanks to the recent Combining Files improvements.

## Monday Morning Mulling: May Challenge

29 May 2017

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us...

## Final Friday Fix: May Challenge

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