On the final Friday of each month, we’re going to set an Excel challenge 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...

This week, we’re going to divert a little bit away from Power BI directly, and talk about how it can integrate into Microsoft Teams. This is the central part of what Tim’s presentation in Singapore last week was all about. We’ll spread this over the next few...

Welcome to our Power Query blog. This week, I look at extracting a number from a mixed column.

Welcome back to our Power Pivot blog. Today, we discuss how to use variables in DAX.

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

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

This week, there are no new tips and tricks, but that’s because we’re presenting at Microsoft Ignite – The Tour over in Singapore!

Welcome to our Power Query blog. This week, I look at a neat way of linking tables with similar key data.

Welcome back to our Power Pivot blog. Today, we discuss an alternate way to keep the CALCULATE function from misbehaving.

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