Welcome to our Power Query blog. This week, I look at how to make a query more functional.

Welcome back to our Power Pivot blog. Today, we discuss how to create conditional custom columns with multiple criteria.

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.

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

Welcome back to the Power BI blog series! This week we are going to take a look at the Infographic Designer, typically one of the featured custom visuals on the marketplace.

Welcome to our Power Query blog. This week, I introduce more Value() M functions; Value.Type() and Value.ReplaceType().

Welcome back to our Power Pivot blog. We continue on our CAGR series. Today, we shall look into making our CAGR measure more dynamic and discuss additional improvements to the measures.

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

Welcome back to this week’s VBA blog! This month, we have been looking at the interaction between charts and macros.

Welcome back to the Power BI blog series. This week, we’re going to look at tables that you can customised to your needs, where you can arrange rows, add custom formulas, for example Profit and Loss statement (P&L) that we’ll particularly create in this post.