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 are 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 consider the SUMMARIZE function and create customised summary tables in Power BI.

Welcome to our Power Query blog. This week, I look at sorting issues.

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a method to derive the unique values in a column by using DAX.

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

Welcome back to this week’s Charts and Dashboards blog series. This week, I will treat you with a Pie…

Welcome back to this week’s Power BI blog series. This week, we are going to talk about creating tables in Power BI.

Welcome to our Power Query blog. This week, I look at a common problem in Finance – performing that pesky bank reconciliation!

Welcome back to the Power Pivot Principles blog. This week, we are going to learn one way of joining tables together in DAX.

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