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

Are you a CONVERT?

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

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

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

Is CONFIDENCE your NORM?...

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 users to change any values...

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...

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...

The new feature ‘Column from Examples’ essentially pulls together a number of Power Query functions into one place, so it’s very user friendly.