Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Calendar Creation – Preparing for Dates

12 April 2017

Building a calendar using Power Query is a collaboration between Excel and Power Query...

Read more


A to Z of Excel Functions: the CEILING.MATH Function

10 April 2017

This function sounds like something you calculate whilst swinging from the chandeliers...

Read more


Declaring Variables

7 April 2017

One of the most useful things you can do in VBA is to store values in the program’s memory, so that you can use it in the future...

Read more


Power Query: Excel(lent) functions

5 April 2017

Over the last few weeks I have shown some of the tasks that can be achieved with M language and functions. Today I look at how to replicate some familiar Excel formulas.

Read more


Monday Morning Mulling – March 2017

3 April 2017

Last week, we looked at a strange event – in certain cases when you are creating running totals, Power Query stores the number in strange ways....

Read more


Final Friday Fix – March 2017

31 March 2017

In celebration of having published three full months of Power Query blog articles, we’re dedicating the March Final Friday Fix to a Power Query problem!

Read more


Power Query: One Route to a Running Total

29 March 2017

Welcome to our latest Power Query blog. Last time I looked at row level operators and simplifying bulky code. Today I combine two list functions to show one method to achieve a running total.

Read more


A to Z of Excel Functions: the CEILING Function

27 March 2017

Have you reached your CEILING?

Read more


If I use VBA Then I get better at it!

24 March 2017

This week, we’re going to cover the use of the IF statement in VBA. This is a very useful tool to help apply conditional rules in macros...

Read more


Power Query: Taking (Away) Steps for Efficiency

22 March 2017

Welcome to our latest Power Query blog. Last time we looked at M language syntax in a simple query. Today I add some code to operate on each row in a table and show how bulky code can be simplified.

Read more


Newsletter