Power Query is an amazing tool that lets you build modules that calculate upon source spreadsheets, and unlike macros and VBA, makes no changes to the source documents. **If you think that a lot of tasks done in Excel can be automated, Power Query is for you.**