You'll use this to specify where the data for your pivot table lives (in an Excel table or range, or an external data source, such as a database) and where the pivot table you are creating will be placed.
COMPLICATED PIVOT TABLES IN EXCEL 2013 HOW TO
In this lesson, we'll choose the PivotTable button so you can learn how to build a PivotTable from scratch: This is the fastest way to create a PivotTable, although you may still need to modify it to match your requirements.
This lesson takes you through the following steps to build an Excel Pivot Table" This lesson will show you how to create a simple PivotTable in Excel to summarize a set of daily sales data for a team of several sales people. Not only that, but they also allow you to quickly change how your data is summarized with almost no effort at all. If you are finding yourself writing lots of formulas to summarize data in Excel (using functions such as SUMIF and COUNTIF) then PivotTables can save you a lot of time and work and give you insights into your data that are otherwise too hard to discover. Excel's PivotTable feature is an incredibly powerful tool that makes it easy to tabulate and summarize data in your spreadsheets, particularly if your data changes a lot.