On the final Friday of each month, we are going to set an Excel / Power BI 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 are playing for bragging rights only!

We thought we would bring you some news hot off the press this week. Microsoft has recently announced the initial availability of a connected PivotTable refresh in Excel for the web. This new capability makes it easier for organisations to share data and collaborate using Power BI and Excel. You can now explore, and refresh PivotTables connected to Power BI inside Excel for the web, and easily share these workbooks through OneDrive and SharePoint.

Welcome to our Power Query blog. This week, I look at how Power BI Desktop uses query folding in the Power Query engine.

Welcome back to the Power Pivot Principles blog. This week, we are going calculate Cost of Goods Sold and cash payments for Cost of Goods Sold.

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

Welcome back to this week’s Charts and Dashboards blog series. Over the next two weeks, we will discuss creating a bar chart with dynamic ordering.

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will look at improving the measure that compares the previous month’s collection values with the current month’s collection values.

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

Welcome back to the Power Pivot Principles blog. This week, we are going to compare quarterly data using a new Power Pivot function.

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