How to Convert Access Reports to Excel Tables. One of the prime attractions of Microsoft Office Suite is the ability to transfer and convert data for use in each of the different programs that ...

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Before you convert your Excel data into a table, make sure you have column headers along the top row. This will make dealing with and using the data much more straightforward down the line.

After converting the data sets to Table objects, you can create the relationships. To do so, click anywhere inside a Table and then click the Power Pivot tab to open the Power Pivot window.

Notice that the pivot table is displaying only the data that’s pertinent to our present analysis. On the right-hand side, you’ll find the criteria that Excel used to create it in the ...