Microsoft Office Tutorials and References
In Depth Information
Second Example—Larger Database
SECOND EXAMPLE—LARGER DATABASE
On the Second Example worksheet in the Excel Chapter 25 file, you will find the data
we used in previous chapters. The data, shown in Figure 25.11, contains information
about 1,000 customers. What I want to find out is the average income and the
average amount spent by customers with 0 children, 1 child, 2 children, and so on.
The first step is to sort data by the number of children. After the database is
sorted, you can use the Subtotal menu.
In the Subtotal menu, for
At each change in
field, select Children. For
select Average, and for
Add subtotal to
choose both Income and Pur-
chases as shown in Figure 25.12.
The final result is shown in Figure 25.13. I used the grouping level number 2 on
the left to show only the relevant summarized data.
APPENDIX: CREATING SUBTOTALS IN EXCEL 2003
AND MAC EXCEL 2011
The only difference in Excel 2003 is the way to activate the Subtotal.
Open Excel 2003. Use Data
Subtotal. See Figure 25.14.
All the rest is the same as described above.
Visible Cells Only Icon in Excel 2003
In Excel 2003, to add the Select Visible Cells command, do the following:
FIGURE 25.11 Second Database