Microsoft Office Tutorials and References
In Depth Information
spreadsheet databases reside in some very large workbooks. Even
so, when you compare the amount of data in a large spreadsheet
database with the data typically contained by real databases,
spreadsheet databases contain significantly less data.
An Improved Spreadsheet Database
In spite of the foregoing problems, I’ve developed a spreadsheet
methodology that can avoid most of them—at least for companies
with only one unit.
Chapter 7 introduces this methodology, and Chapter 8 explains
how to use it to create and update dashboard reports using an
Method 3: PivotTables
Excel has offered PivotTable technology for years. It’s a powerful
way to populate worksheet cells with data from relational
PivotTables have been around for a long time, and it’s the primary
way that Microsoft offers for bringing external data into Excel. For
these reasons, Excel’s help engine offers excellent advice about
how to set up PivotTables.
Using the GETPIVOTDATA function
Once you set up a PivotTable report in a worksheet, you typically
use the GETPIVOTDATA worksheet function to return data from
the visible cells of the pivot data.
The function has two forms. The form explained in Excel’s help file