This week, I take a look at how extracting data from multiple lists can be confusing when nulls are involved.

Today we consider some of the various menu options in the Power Pivot window...

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

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

Welcome to Power BI Tips. Following on from last week, creating our first visualization, a clustered column chart

Welcome to our Power Query blog. This week, I take a look at how to pass Excel data as a parameter in Power Query.

Today we discuss what are relationships (in Power Pivot) and how we may create them...

Last week, we asked how you could set up a cell to pick up text from parts of an Excel spreadsheet, and present it in a ready-for-email form.

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

Friday is normally our VBA blog day, so for this week’s Final Friday Fix, we’re going to look at a problem that is fairly easy to solve in VBA, but a bit more challenging in Excel…