Please note javascript is required for full website functionality.

Blog

VBA Blogs: Going Through the Visual Basics – Part 13

16 November 2018

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.


Power BI Blog: Data Profiling

15 November 2018

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.


Power Query: The Right Combination

14 November 2018

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


Power Pivot Principles: DAX Syntax Requirements – Naming Conventions

13 November 2018

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.


A to Z of Excel Functions: The DURATION Function

12 November 2018

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


VBA Blogs: Going Through the Visual Basics – Part 12

9 November 2018

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 sequential control structures.


Power BI Blog: Using OneDrive and Setting Up Automatic Updates – Part 2

8 November 2018

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.


Power Query: Building Bridges

7 November 2018

Welcome to our Power Query blog. This week, I look at creating a bridge table.


Power Pivot Principles: DAX Requirements – Fully Qualified Names

6 November 2018

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


A to Z of Excel Functions: The DSUM Function

5 November 2018

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


Newsletter