![how to use pivot tables in excel 2013 how to use pivot tables in excel 2013](https://support.content.office.net/en-us/media/f39fbe18-3a7f-4e7a-a90d-efd8e0e4a621.png)
Select the source for the new column values
![how to use pivot tables in excel 2013 how to use pivot tables in excel 2013](https://www.exceltip.com/wp-content/uploads/2013/07/1-53.png)
Confirm the selection and if it has headers.Select the data, click on Data Menu - From Table/Range (in Excel 2016 or higher) or in the Power Query Menu - From Table/Range (Excel Import the desired data to a blank Excel sheet.
![how to use pivot tables in excel 2013 how to use pivot tables in excel 2013](https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/rev-178a03b/wp-content/uploads/2016/04/Macro-Code-To-Use-VBA-To-Create-Pivot-Table-In-Excel.gif)
Mac users: Power Query is not available for this platform yet.Windows + Excel 2010-2013 with the Microsoft Power Query tool installed.It is also much simpler than typing codes and don't require any 3rd party add-on. This solution is far better than Formulas or VBA Macros because the categories/columns can be auto-updated according to the data source changes.
#How to use pivot tables in excel 2013 for free
This solution does not require macros or long search/replace functions, just the Microsoft Power Query tool that comes with Excel 2016 or can be installed for free as an add-on in previous versions. Create a Pivot table that displays text data or number values that are not summarized (count, sum, etc.).