DISCLOSURE: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.
![]() |
Microsoft Excel - Data Analytics Power Query and PivotTables |
Microsoft Excel's Power Query tool is the biggest feature Microsoft has added to Excel since PivotTables. Seriously, no joke. Read on to learn more about Excel Power Query and how you'll save loads of time as you take advantage of this powerful feature.
In Excel 2016, 2019 and Office 365, Power Query is built directly in the Excel interface through the GET AND TRANSFORM command on the Data tab. (Power Query is NOT available on the MAC release of Excel)
Power Query is available on Excel 2010 and 2013 through a free download from Microsoft as described in the course.
Office Productivity, Microsoft, Excel