Power Query and Power Pivot work well together, however Power Query is not exclusive to Power Pivot though, as it may be used with ordinary PivotTables. There is a good reason for doing this too...

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