Microsoft Office Tutorials and References
In Depth Information
Data Analysis with Pivot Tables
Data Analysis with Pivot Tables
Pivot tables are so very versatile because they enable you to easily analyze
summaries of large amounts of data by using a variety of summary functions
(although totals created with the SUM function will probably remain your old
standby). When setting up the original pivot table (as described in the
following section), you make several decisions: what summary function to use,
which columns (fields) the summary function is applied to, and which
columns (fields) these computations are tabulated with.
Pivot tables are perfect for cross-tabulating one set of data in your data list
with another. For example, you can create a pivot table from an employee
database table that totals the salaries for each job category cross-tabulated
(arranged) by department or job site.
Pivot tables via the Quick Analysis tool
Excel 2013 makes creating a new pivot table a snap with its new Quick
Analysis tool. To preview various types of pivot tables that Excel can create
for you on the spot using the entries in a data table or list that you have open
in an Excel worksheet, simply follow these steps:
1. Select the data (including the column headings) in your table or list as
a cell range in the worksheet.
2. Click the Quick Analysis tool that appears right below the lower-right
corner of the current cell selection.
Doing this opens the palette of Quick Analysis options with the initial
Formatting tab selected and its various conditional formatting options
displayed.
3. Click the Tables tab at the top of the Quick Analysis options palette.
Excel selects the Tables tab and displays its Table and PivotTable
option buttons. The Table button previews how the selected data
would appear formatted as a table (see Chapter 3 for details). The other
PivotTable buttons preview the various types of pivot tables that can be
created from the selected data.
Search JabSto ::




Custom Search