Ways of recycling work in Power Query and saving time T0028

Having to repeat work is not fun or productive. Let’s see how we can transfer some of the work done in one query in Power query to other queries in the same Excel file.

Check the video of the question:
https://youtu.be/6GNx7p7nbqs

Chapters:
0:00 – Introduction
0:51 – explaining the problem
1:32 – how to copy steps from one query to another
5:22 – duplicating a query
6:36 – referencing a query
7:54 – breaking a query into two queries (extract previous)
9:50 – deleting the final query steps (delete until the end)
-----
Get access to the EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel
Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia
Boost your Excel skills with the best Excel books - Mr Excel Book store - https://www.e-junkie.com/ecom/gb.php?cl=211017&c=ib&aff=348636

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn: https://www.linkedin.com/in/celiajordaoalves
Facebook: https://www.facebook.com/solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel
YouTube: https:www//youtube.com/celiaalvessolveexcel

#excel #msexcel #exceltraining #msexceltraining #powerquery #powerquerytraining #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA