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

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

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

Need a function you can COUNT on?

How use DataBodyRange property to manipulate table ranges.

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

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

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

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

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?