Im looking at automating some of my workload and a lot on the web comes up about using power queries to streamline some of the more simple reports i work with on a regular basis. Can someone explain what power query is and is it basically i water down VBA tool?
Here is a good link to learn about PQ
https://www.simplilearn.com/tutorials/excel-tutorial/power-query-in-excel
Hi and welcome to our forum.
I wouldn't classify Power Query as a watered down VBA tool. It's a dedicated ETL (Extract, Transform and Load data) tool which automates the repetitive and laborious tasks of getting and cleaning data. It replaces the ETL tasks we used to use VBA to automate, but it's not designed to do everything VBA can do.
The link Alan shared is a written introduction to Power Query. If you prefer video, then my introduction to Power Query video will get you started, and will give you an overview of some of its capabilities.
Of course, Power Query is a vast tool with many more features and you can get a comprehensive step by step Power Query course from me here.
Please let us know if we can help with any other questions on Power Query.
Mynda
