Tips for more productivity with Power Query- Solve and Excel

Excel Office Hour: Tips for more productivity with Power Query in Excel

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 how to automate your Excel reports
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists
Check other posts about Power Query and Excel in this Blog,

About the Author: Celia Alves

Celia Alves is an awarded Microsoft MVP and Certified Excel Expert, specializing in building highly complex solutions combining VBA, Power Query, and Power Pivot to automate Excel reporting procedures. By combining her experience as an Excel Consultant and two decades as a Mathematics teacher, Celia created a training program to pass on her knowledge and techniques to those who want to stop wasting time in Excel with repetitive and meaningless tasks. Celia is also the founder and leader of the MS Excel meetup group in Toronto, with over 3,000 members worldwide.