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.
In this session, Celia will present 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! Nothing like the start of a new year to challenge ourselves to learn something new that can be the door for a drastic evolution of our Excel skills throughout the year.
