On the final Friday of each month, we are going to set an Excel / Power BI 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 are no prizes at this stage: you are playing for bragging rights only!

Welcome back to the Power Pivot Principles blog. This week, we’ll talk about some of the inabilities of Power Pivot when it comes to organising data in a meaningful manner.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Decomposition Tree visualisation.

Welcome to our Power Query blog. This week, I look at some ways to make merges more efficient.

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

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to build the “conditional donut chart”.

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at ordering the legend in visualisations.

Welcome to our Power Query blog. This week, I look at solving a problem with a nested join and the M function Table.Buffer().

Welcome back to the Power Pivot Principles blog. This week, we’ll continue where we left off last week, revealing “the truth” about the different negative and positive values.

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