Please note javascript is required for full website functionality.
MVP

Blog

Blog

A to Z of Excel Functions: the COUNTA Function

18 December 2017

This is neither the Italian COUNT function nor an Excel calculator dedicated to tallying the number of times the letter “a” occurs in a spreadsheet...


VBA Blog: DataBodyRange - New Frontier

15 December 2017

The fifth in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA featuring DataBodyRange.


Power Query: Cleanse, Tone and Upload

13 December 2017

This week I look at combining several Power Query functions in order to standardise some incoming data...


A to Z of Excel Functions: the COUNT Function

11 December 2017

Need a function you can COUNT on?


VBA Blog: DataBodyRange Part 1

8 December 2017

How use DataBodyRange property to manipulate table ranges.


Power Query: Pivot the Blanks

6 December 2017

The scenario is familiar, a huge Excel table comes in with lots of columns and rows, but in some cases a column or row is empty and it needs to be condensed...


A to Z of Excel Functions: the COTH Function

4 December 2017

This function returns the hyperbolic cotangent of a hyperbolic angle. Clear as mud?..


VBA Blog: Close Range

1 December 2017

This is the third in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA.


Power Query: Blanking the Blanks

29 November 2017

A huge Excel table comes in with lots of columns and rows, but in some cases a column or row is completely empty, and the table needs to be condensed...


Monday Morning Mulling: November 2017 Freaky Black Friday!

27 November 2017

For any given Friday – like Black Friday 24th, when can I expect it to happen?

For any given year, which date is the Black Friday so one can get specials?

And as a bonus question, when will we have another Black Friday sale on the 24th of November?


Newsletter