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

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 are no prizes at this stage: you’re playing for bragging rights only!

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to edit the print layout of tables in the Power BI Report Builder.

Welcome to our Power Query blog. This week, I look at how to find the unique or distinct values in a list of data.

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a new way of using a DAX function to create a calendar table.

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

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s look at Stock Charts.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to create reporting tables in the Power BI Report Builder.

Welcome to our Power Query blog. This week, I look at using some numerical functions to sort out expense formatting.