Please note javascript is required for full website functionality.
MVP

Blog

Blog


Power Query: Initial Problems

18 October 2017

Welcome to our Power Query blog. This week let's look at how to convert names into an alternative format.



VBA Blog Series: The Value of Declaring Variables

13 October 2017

Take an in depth look of the good coding practice in declaring variables how it helps write better VBA code.


Power Query: If You Can’t Tell Them Apart, Join Them

11 October 2017

Sometimes, the tasks I have to do are less than thrilling...


A to Z of Excel Functions: the CONFIDENCE.T Function

9 October 2017

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



Power Query: Bring it to the Table

4 October 2017

I like finding ways to save time. That’s why I get someone else to write this. So when I come across a method to create data quickly, then that makes me very happy. This particular method of creating data is ideal for those scenarios where I don’t want Excel...


Monday Morning Mulling: September 2017

2 October 2017

Last week we looked at three charts that pulled data from the same table, however, there was no easy way to format the y-axis on all three charts so that they all share the same range, without using a macro...


Final Friday Fix: September 2017 Challenge

29 September 2017

Near the end of the quarter we usually find ourselves creating quarterly reports and sending them off to head office. And that may cause issues...


Newsletter