Having stumbled upon the Find method last week, we’re going to lay fingers on some of the parameters. Last time we did the basic search looking for a simple string within a Range. Let’s go back to our worksheet last week: ...

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