On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution.

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI 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 this week’s edition of the Power BI blog series. This week, we look at the new Preview feature in Power BI, visual calculations.

Welcome to our Power Query blog. Today, I refine the solution to an issue that occurs when I load to a Table with no headers.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at IF.

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

This week in our series about Microsoft Excel for Mac, we provide a list of keyboard shortcuts that are very helpful to know, especially if you’re using the keyboard on a MacBook.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Power BI add-in for PowerPoint.

Welcome to our Power Query blog. Today, I look at how to solve an issue that occurs when I load to a Table with no headers.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at HOUR.