Please note javascript is required for full website functionality.
MVP

Blog

Blog

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

17 April 2017

Do you know where your CEILING is precisely?? If not, this function won’t help you.


For Loops

14 April 2017

Last week, we showed you how to declare variables. This week, we’re going to use a variable to create a loop. Let’s introduce the For loop.


Power Query: Calendar Creation – Preparing for Dates

12 April 2017

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


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


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


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.


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


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!


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.


A to Z of Excel Functions: the CEILING Function

27 March 2017

Have you reached your CEILING?


Newsletter