These are called “relationships” and save you from continually duplicating fields/data on three different spreadsheets (or tables). ... How to create an Excel table. 1.

The pivot table in Excel. We’ll need a pivot table before we can start filtering, so to that end, we’ll build the pivot table shown in Figure A, based on the data shown in the same sheet.

Using Power Query to Clean Up Excel Data . I always use Power Query to clean up data in my Excel sheets. Suppose you have ...

As you’re working on your own pivot tables, you can experiment to see how added and removing fields affects the data that’s displayed. You’ll find that Excel does a great job of making ...

Click anywhere inside the Excel Table that you want to load into Power Query. 2. ... All that’s left to do is to save the modified data to Microsoft Excel, as follows: 5.