Please note javascript is required for full website functionality.



Power Query: If You Can’t Tell Them Apart, Join Them

11 October 2017

Sometimes, the tasks I have to do are less than thrilling...

A to Z of Excel Functions: the CONFIDENCE.T Function

9 October 2017

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CONFIDENCE.T function.

Power Query: Bring it to the Table

4 October 2017

I like finding ways to save time. That’s why I get someone else to write this. So when I come across a method to create data quickly, then that makes me very happy. This particular method of creating data is ideal for those scenarios where I don’t want Excel...

Monday Morning Mulling: September 2017

2 October 2017

Last week we looked at three charts that pulled data from the same table, however, there was no easy way to format the y-axis on all three charts so that they all share the same range, without using a macro...

Final Friday Fix: September 2017 Challenge

29 September 2017

Near the end of the quarter we usually find ourselves creating quarterly reports and sending them off to head office. And that may cause issues...

Power Query: Setting an Example

27 September 2017

The new feature ‘Column from Examples’ essentially pulls together a number of Power Query functions into one place, so it’s very user friendly.

A to Z of Excel Functions: the CONFIDENCE Function

25 September 2017

Do you need more CONFIDENCE in your Excel files?...

A to Z of Excel Functions: the CONCATENATE Function

22 September 2017

IMPORTANT: In Excel 2016, Excel Mobile, and Excel Online, this function has been replaced with the CONCAT function (see the last functions blog). Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from...

Power Query: In Your Face(book)

20 September 2017

Whilst much of the data I deal with comes from workbooks and databases, it can be useful to pull in data from other sources. There are a number of sites traditionally associated with business, but social media sites like Facebook are becoming more accepted business...