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 looks at actually recording a macro.

As we promised in our recent newsletter, we’ll be spending the next couple of months talking about some of the new Power BI features that are being rolled out.

Welcome to our Power Query blog. This week, I look at last week’s problem again, but this time I translate numbers to letters in multiple columns by joining tables.

Welcome back to our Power Pivot blog. Today, we discuss why disconnected tables may be useful in Power Pivot.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DISC 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 second part looks at how to record a macro.

As we promised in our recent newsletter, we’ll be spending the next couple of months talking about some of the new Power BI features that are being rolled out.

Welcome to our Power Query blog. This week, I look at an example where I need to translate numbers to letters in multiple columns using the M function List.ReplaceMatchingItems().

Welcome back to our Power Pivot blog. Today, we discuss how the CALCULATE function can benefit from connected tables.

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