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 (if you’re not already on Christmas break). There’s no prizes at this stage, you’re playing for bragging rights only (or first pick of the boxes under the tree)!

Welcome back to this week’s Power BI blog series. This week, we are going to look at how to toggle between several sets of data more efficiently in a single visualisation.

Welcome to our Power Query blog. This week, I look at another example of unpivoting.

Welcome back to the Power Pivot Principles blog. This week, we are going to look at an example of applying functions for parent-child hierarchies in a business case.

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

Welcome back to Charts and Dashboards blog series. This week, we’ll continue to look at the Format sub-tab from the contextual Chart Tools tabs.

Welcome back to this week’s Power BI blog series. This week, we are going to look at how to create a dynamic calendar table in Power BI.

Welcome to our Power Query blog. This week, I look at another use for unpivoting.

Welcome back to the Power Pivot Principles blog. Before we learn more functions for parent-child hierarchies in DAX, this week, we are going to look aside at one function of looking up values in DAX.

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