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 ...

SEE: Microsoft Excel: How to use Power Query to display a list of duplicate values or records (TechRepublic) This step takes place in Excel, where the data you want to merge is stored.

Figure A We’ll use Power Query to combine the address elements into a single cell. Getting the data into Power Query requires following just a few steps. 1. Click anywhere inside the Excel Table. 2.