Pivot tables

One of Excel's most powerful tools is its pivot tables. A pivot table is capable of summarizing data in a handy table, and this table can be arranged in many ways simply by dragging your mouse. In addition, a pivot table can be manipulated entirely by VBA. Data for a pivot table comes from a worksheet database or an external database and is stored in a special cache, which enables Excel to recalculate rapidly after a pivot table is altered. Figure 2-13 shows a pivot table.

Fi

Ü

A

BCD

E I F G H

1

Branch

(All!

2

3

Sum of Amount

OpenedBy

Drag items to the PivotTable report

4

AcctTvpe ▼

NewAccts Teller

Grand Total

6

Checking

1,808,325 226,214 337,459 48,571

2,034,539 386.030

_I Amount

QAcctType [—1 OpenedBy

J Branch

8

Savinqs

590,690 48,266

638.956

9

Grand Total

2.821,028 451,251

3,272,279.

10 11 12

14

I Add To 1 I Row Area

1 b

PivotTable- S fâ I"1 *i 1 ? ¡3

20

M 4 ► n|\sheetl/ September / | ■> |

Figure 2-13: Excel's pivot table feature has many applications.

Figure 2-13: Excel's pivot table feature has many applications.

See Chapter 17 for information about manipulating pivot tables with VBA.

0 0

Post a comment