Power Query remembers the user’s data transformation steps, effectively automating lengthy and manual processes.

Power Query is an invaluable tool for any analyst working in Excel, saving users hours of time, reducing manual errors, and allowing users to source data from a central source of truth.

Power Query is a data transformation tool available in both Microsoft Excel and Power BI.

Details about the updates can be found in the linked KB articles from Microsoft. Office 2013 already dropped out of mainstream support on April 10, 2018, but will continue to receive security updates until April 11, 2023. Update for Microsoft Office 2013 ( KB5001937): This update fixes an issue where some users see additional entries in Excel Add-Ins list.

Microsoft Office 2013 also only received the following update: Office 2016 dropped out of mainstream support on October 13, 2020, but will continue to receive security updates until October 14, 2025. Update for Microsoft Office 2016 ( KB5001948): This update fixes the issue that prevents Power Query and Power Pivot from updating data from a text file when you use delimiters other than commas. This time there were only the following updates: The packages are automatically distributed via Windows Update, but can also be downloaded and installed manually via the linked KB articles.

Microsoft lists the updates on this page. For this reason, Office 2019 no longer appears in the list below, where only click-to-run installers are available. Click-to-run packages receive the updates through other channels. The updates apply to the installable MSI version of Office and are delivered via Windows Update.

Power query office 2016