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.

Welcome back to our Power Pivot blog. Today, we introduce the DATEADD function.

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

Welcome back to our Power BI blog series! This week, we’re going to talk about a new feature that was launched in October 2018 called Data Profiling.

Welcome to our Power Query blog. This week, I look at whether to append or merge when combining data.

Welcome back to our Power Pivot blog. Today, we go over the DAX syntax naming requirements and conventions when it comes to tables, columns and measures.

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