Welcome back to our Power Pivot blog. Today, we look at using concatenation with the FILTER function to combine filter criteria.

Last week, we posed a challenging question – given a large table of data, how can we create a set of data validated cells that would automatically update when you select a particular item in the previous cell?

Welcome back to the Final Friday Fix! This month, we are going to draw inspiration from the Excel team’s Ask Me Anything session earlier this month and look to Reddit to find a challenging question. (No cheating by going there to look for the answer!)

Welcome back to our Power BI blog series! This week, we’re going to finish the process of automatically refreshing data, using the Power BI Gateway.

Welcome to our Power Query blog. This week, I look at the differences in the way that the ‘Standard’ button works on the ‘Transform’ and ‘Add Column’ tabs.

Welcome back to our Power Pivot blog. Today, we discuss the IN function, one of the several logical functions in Power Pivot.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DVARP 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 look at iteration control structures.

Welcome back to our Power BI blog series! This week, we’re going to continue the process of setting up our dataset to automatically update from a file on OneDrive.

Welcome to our Power Query blog. This week, I look at merging columns to show that not all ‘Merge Columns’ options are born equal.