Please note javascript is required for full website functionality.

Blog

Monday Morning Mulling: April 2018 Challenge

30 April 2018

On the final Friday of each month, we set an Excel problem 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.


A to Z of Excel Functions: The DB Function

30 April 2018

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


Final Friday Fix: April 2018 Challenge

27 April 2018

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


Power BI Blog: Xenagogue to Markup Lists - Part 3

26 April 2018

Using a multi-row card visualisation to display the USD exchange rate from the RBA RSS feed


Power Query: Hot Cross Joins

25 April 2018

This week I look at cross joins.


Power Pivot Principles: Recognising Measures

24 April 2018

Welcome back to our Power Pivot blog series. Today we discuss how to tell the difference between a measure and a field.


A to Z of Excel Functions: The DAYS360 Function

23 April 2018

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


VBA Blogs: Lost and Found

20 April 2018

It’s easy to get lost in a sea of data, but at times we want to find something in particular, be it a word, number or formula. The Find method in VBA can help us do that!


A to Z of Excel Functions: The DAYS Function

20 April 2018

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


Power BI Blog: Xenagogue to Markup Lists - Part 2

19 April 2018

Using the Power Query Editor to parse through the Reserve Bank of Australia's RSS feed in XML format.


Newsletter