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.

To chart the performance of your most productive staff, Excel can run a query and paste a selection of the Access table into your spreadsheet. Queries use autofilter drop-down boxes rather than ...

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.

I’m using Microsoft 365, but Power Query is available through 2010, as an add-in. Excel Online doesn’t fully support Power Query, but you can run queries.