Microsoft Office Tutorials and References
In Depth Information
Creating a PivotTable
It’s true that there’s a lot to learn about PivotTables if you’re interested in turning
yourself into the company guru. In fact, there are two Apress books out there devoted
exclusively to the subject, Beginning PivotTables in Excel 2007 and Excel 2007
PivotTable Recipes , authored by PivotTable expert Debra Dalgleish. But as with many of
Excel’s features, there’s a set of the basics you have learn in order to make PivotTables
do productive work, and I’m going to introduce them here.
NOTE: Because a PivotTable works with a copy of the original database, any mistakes you may
make in the course of your PivotTable design will nevertheless leave the database intact. And you
can always apply the Undo command to PivotTables, just as you can with any other Excel
feature.
Creating a PivotTable
So let’s try to construct some PivotTables, by working with the first 15 records of the
sales data we’ve been looking at.
1.
In a blank workbook, copy the records shown in Figure 8–8, starting in
cell A1.
Figure 8–8. Sales data: Working with text, date, and currency fields
2.
Save the workbook as PivotTables.
 
Search JabSto ::




Custom Search