Microsoft Power Query for Excel

Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

i would like to highlight this excel tool that i recently discovered


Power Query enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, and more.

If you want to go deeper with this tool you can review these articles:

Power Query italian & English Guide

Power Query M function reference

Power Query M Reference