Please note javascript is required for full website functionality.

Blog

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.


VBA Blogs: Going Through the Visual Basics – Part 11

2 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 high-level look at control structures.


Power BI Blog: Using OneDrive and Setting Up Automatic Updates

1 November 2018

Welcome back to our Power BI blog series! This week, and throughout November, we’re going to walk through an example of how to connect Power BI to a data source saved on OneDrive.


Power Query: Appearing Cultured

31 October 2018

Welcome to our Power Query blog. This week, I look at how M and culture can go together.


Power Pivot Principles: Resource Management with Calculated Columns

30 October 2018

Welcome back to our Power Pivot blog. Today, we discuss factors to consider when creating and using Calculated Columns.


Challenges: Monday Morning Mulling: October 2018 Challenge

29 October 2018

On the final Friday of each month, we set an Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution – or two as in this case. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Newsletter