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

Power BI exercise focusing on JSON files using the NY Powerball data.

This week, I look at what to do if you are short of memory.

Today we discuss proper practices we should adopt when creating measures.

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.

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

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

This week I look at cross joins.