On May 11, 2021, I presented Tips for more productivity with Power Query in Excel for the meetup group organized by the MVP Michael Olafusi.
We talked about why Power Query is a tremendously important tool for Data Analysts and we went over some tips and good-to-know tricks to develop more efficient solutions with this tool.
For example, Enable background refresh property is a setting that we can use to get all queries and pivot tables updated in one single click. Other tips involved ways to organize and recycle your queries and avoiding pitfalls.
Access the practice file here.
Learn Excel and connect with a community of Excel professionals and enthusiasts: