Please note javascript is required for full website functionality.



A to Z of Excel Functions: the COMBIN Function

1 September 2017

Are you often COMBIN the Excel functions to see how many subsets you can make? This function returns the number of combinations for a given number of items (i.e. the number of distinct subsets of items where order is unimportant). You should use COMBIN to...

Power Query: Null and Not Void

30 August 2017

In Pivotal Pivoting, I showed how easy it was to pivot columns. When I pivoted my expense code column to show the amounts for each expense code, I had a table with lots of null values in it, as shown below. I am going to use this table to show how I can sum...

Monday Morning Mulling: August Challenge

28 August 2017

Last Friday, we posed perhaps one of the hardest challenges that we’ve had so far: can you create a file that will refresh your Power Query queries, and pop up a message box letting us know when it’s finished?

Final Friday Fix: August Challenge

25 August 2017

Welcome to this month’s Final Friday Fix! The inspiration for this month’s challenge comes from an actual problem that we’ve been trying to solve for some client work, that we couldn’t find an answer to anywhere online. But first, let’s talk about refreshing...

Power Query: Structured Columns Deconstructed

23 August 2017

In Power Query, explore the ‘Structured Column’ section on the ‘Transform’ tab, which is not available for most column types.

A to Z of Excel Functions: The COLUMNS Function

21 August 2017

This is one of the pillars of Excel’s features. Yes, the jokes get no better...

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.