Please note javascript is required for full website functionality.
MVP

Blog

Blog

VBA Blog Series: Range Modifiers

18 August 2017

Last week we spoke about ranges and how you can refer to them in different ways. This week, we’re going to look at some of the ways you can apply range modifiers to change what set of cells exactly you’re referring to.


Power Query: Pivotal Pivoting

16 August 2017

Power Query’s ability to efficiently transform data allows one to pivot (and unpivot) data at the touch of a button.


A to Z of Excel Functions: the COLUMN Function

14 August 2017

The COLUMN function

Ah, it’s time for my Lord of the Rings impersonation. What do I mean? “COLUMN” (try saying it out loud if you don’t understand – this joke is precious). This function returns the column number of the given cell reference. For example, the...


VBA Blog Series: Referring to Ranges

11 August 2017

There are a number of different ways that we can refer to Excel cells in a worksheet. In the VBA blog series, we’ve been using a fairly consistent approach to referencing cell ranges – that is, using the Range object available in VBA.


Power Query: Passing Through Parameters

9 August 2017

Last week, in In Terms of Conditional Columns, I looked at how parameters were a possible source when defining conditional columns. This week, I take a closer look at parameter creation by using a parameter in a filter...


A to Z of Excel Functions: the CODE Function

7 August 2017

If you find it CODE outside, this function may assist you. CODE returns a numeric code (great dictionary definition) for the first character in a text string. The returned code corresponds to the character set used by your computer.


VBA Blog Series: DoEvents

4 August 2017

It’s a great feeling when you write an involved piece of code with grand loops that apply over thousands of rows. There’s a sweet sensation when you save the file, hit run, and watch your handiwork unfold in front of you… until the screen stops updating...


Power Query: in Terms of Conditional Columns.

2 August 2017

Welcome to our Power Query blog. Today I take a closer look at conditional columns...


Monday Morning Mulling: July Challenge

31 July 2017

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


Final Friday Fix: July Challenge

28 July 2017

On the final Friday of each month, we’re going to set Excel for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights...


Newsletter