Microsoft Office Tutorials and References
In Depth Information
Data Analysis with Pivot Tables
Figure 9-3:
Creating a
new pivot
table from
the sample
pivot tables
displayed in
the
Recommended
PivotTables
dialog box.
Excel then opens the Create PivotTable dialog box and selects all the data
in the list containing the cell cursor (indicated by a marquee around the cell
range). You can then adjust the cell range in the Table/Range text box under
the Select a Table or Range button if the marquee does not include all the
data to summarize in the pivot table. By default, Excel builds the new pivot
table on a new worksheet it adds to the workbook. If, however, you want the
pivot table to appear on the same worksheet, click the Existing Worksheet
button and then indicate the location of the first cell of the new table in the
Location text box, as shown in Figure 9-4. (Just be sure that this new pivot
table isn’t going to overlap any existing tables of data.)
If the data source for your pivot table is an external database table created
with a separate database management program, such as Access, you need to
click the Use an External Data Source button, click the Choose Connection
button, and then click the name of the connection in the Existing Connections
dialog box. (See Chapter 11 for information on establishing a connection with
an external file and importing its data through a query.) Also, for the first time,
Excel 2013 supports analyzing data from multiple related tables on a
worksheet (referred to as a Data Model). If the data in new pivot table you’re
creating is to be analyzed along with another existing pivot table, be sure to select
the Add This Data to the Data Model check box.
Search JabSto ::




Custom Search