April 18, 2022
October 18, 2018
Here is a good link to learn about PQ
July 16, 2010
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.