On the final Friday of each month, we set a Power BI or 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.

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel / Power BI 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!

Welcome back to this week’s Power BI blog series. This week, we are going to look at the Key Performance Indicator (KPI) visual.

Welcome to our Power Query blog. Today, I look at a way to create a set of data from multiple tables.

Welcome back to our Power Pivot blog. Today, we look at how to create a PivotChart that highlights the number of absent students in university classes.

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

Welcome back to the VBA blog. This week, we are going to expand our learning of how to highlight selected cells in a worksheet from last week’s article.

Welcome back to this week’s Power BI blog series. This week, we are going to create an example of a real-time dashboard.

Welcome to our Power Query blog. Today, I look at an example where renaming a column is performed by column position.

Welcome back to our Power Pivot blog. Today, we expand on the rolling average concept, first introduced in a previous blog, and show you how to include a dynamic period selection range in a rolling average measure.