Welcome back to our Power Pivot blog. Today, we go over when to use fully qualified names.

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

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog takes a high-level look at control structures.

Welcome back to our Power BI blog series! This week, and throughout November, we’re going to walk through an example of how to connect Power BI to a data source saved on OneDrive.

Welcome to our Power Query blog. This week, I look at how M and culture can go together.

Welcome back to our Power Pivot blog. Today, we discuss factors to consider when creating and using Calculated Columns.

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 – or two as in this case. 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!

October is Ideas month for our Power BI blog!

Welcome to our Power Query blog. This week, I look at how text output can be presented.