This is a recording of the April London Excel Meetup (April 20, 2020), organized by Alan Murray, where three speakers from around the world sharing awesome Excel tips.

My presentation was the first of the evening and I presented on Power Query Tips and Tricks.

The other presenters were:

  • Andreas Thehos from Bochum, Germany, presenting on using Power Automate to automatically update Excel spreadsheet or notify you of changes to one
  • Tony de Jonker from the Netherlands who showed us an array of awesome Excel tips using dynamic array formulas and other awesome functions such as INDEX, OFFSET and COUNTA in clever ways.

This was a session full of valuable content!