You can also expand Change Data Source, pick a different database (table), and replace the existing pivot table with a new one. Related 10 cool projects you can do with just Microsoft Excel ...

Step 1: Prepare your data. Perhaps the most important step in using Excel pivot tables is to carefully organize your data. The easiest way to do this is to use Excel tables, which let you add rows ...

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

The display is separate from the source data and doesn’t change the source data in any way. In Excel, PivotTable refers to the tool that helps you create a pivot table.

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.