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

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!

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

This week I look at cross joins.

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

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

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!

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

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

Whilst there are often multiple ways to achieve the same objective in Power Query, the purpose of today’s example is become familiar with the M function, Table.Join.