Pivot Tables书籍

Pivot Table Data Crunching for Microsoft Office Excel 2007

Excel PivotTables and Charts









Excel 2007 PivotTables & PivotCharts

SPREADSHEET的历史
- 改变了世界的发明

1850
Using rows and columns for accounting can be traced back to August DeMorgan, a London mathematician in an 1846 book entitled Main Principle of Bookkeeping
1964
Richard Mattessich proposes acomputerized rows/columns system which doesn't catch on because of needed main frame and Fortran programming
1983
January 26,Mitch Kapor releases Lotus 1-2-3
1985
Excel for the Macintosh is released
1987
Quattro Pro is released for the PC, Excel 2.0 for Windows is released
1989
Pito Salas invents first pivot table as Improv for NeXt computers
1989-1993
Excel, Quattro and Lotus are in a heated 3-way race for dominance
1991
Lotus Improv for Windows
1993
Lotus and Quattro release viable Windows versions too late to compte with Excel 5.0 - Excel ships more units than Lotus for the first time
1995
Lotus slips to 20% share Excel has 70% share
1997
Microsoft Excel now supports 65,536 rows
2004
Excel holds 90% market share, but upstarts such as StarOffice 7 offer similar functionality at a fraction of the price

SOURCE: "The Spreadsheet at 25" by Bill Jelen