You’re likely aware of other methods for utilizing data from Dynamics 365 in Excel (opening D365 data in Excel Online, downloading a static worksheet, etc.), but many of them will only give you a snapshot—a image of what that data looked like at that moment. The Power Query Excel connector allows you to live-sync your data from D365, meaning that you have access to the most up-to-date information with the push of a button (or automatically upon opening Excel).
Data Transformation Options and Robust Query Engine
This connector is also valuable for its breadth of data transformation options. Power Query is a robust data modeling tool that allows users to bring in CRM data and model it in a way that makes sense for their business. You can relate tables, add columns, create calculated columns and more all before you start doing any work in Excel.