In 2010, Microsoft added yet another technical term—Power Query—to Excel's long list of jargon, but it's not as complex as it sounds. In fact, once you get started, it's not too steep a ...

Start Excel and open a new or existing spreadsheet. Go to the "Data" tab and click on "From Other Sources" in the Get External Data group. Choose "From Microsoft Query" in the drop-down list.

Power Query is available as part of the interface through Excel 2016. Excel for the web doesn’t support Power Query, but you can run existing queries in an Excel workbook.

1. Click anywhere inside the Excel Table that you want to load into Power Query. 2. Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range.