How To Create A Pivot Table Based On Multiple Tables In Excel 2013

Learn how to Remove Duplicate Entries and how to add decimal points in ExcelHere’s how to Add a Drop-Down List in ExcelSee how to use Conditional Formatting in Excel to Color-Code Specific Cells

1. Click “Insert” at the top of the screen.
2. Click the “PivotTable” button on the Ribbon.
3. Select the first table you want to add to the pivot table. 4. Check the box labeled “Add this data to the Data Model” and press OK.
4. Click “All” in the PivotTable Fields window to view all of the tables. Excel automatically detects multiple tables, so you won’t need to repeat these steps for each additional table.
5. Check the boxes of the cells you wish to include in the pivot table.

15 PC-Cleaning Tools to Speed Your Computer8 Essential Tips for Your New Windows 8 PC8 Laptop Buying Tips for Students