On  January  6th, 2021, I presented to the Toronto Meetup Group.

I presented some business case scenarios and offer some tips to those who are willing to get Power Query in their tool belt once and for all!

Any professional dealing with Excel regularly can significantly reduce the time spent on data importation and reshaping repetitive tasks by only applying Power Query fundamental techniques. It is not difficult to learn!

Power Query is a tool available in Excel dedicated to facilitating extracting data from different sources, cleaning and reshaping the data to the format needed, and importing it into Excel to be ready for consumption.

Although Power Query has been available for a few years, many Excel users are still unaware of its existence, or they are unsure how they can take advantage of this tool.