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

Excel书籍

以下书籍有助于加强excel方面的知识：

The Spreadsheet at 25
Special Edition Using Microsoft Office Excel 2007









Learn Excel 97 Through Excel 2007 from Mr Excel

F1 Get The Most Out Of Excel Formula & Functions

Excel for Auditor

Excel 网站

以下是对excel用户相当有帮助的网站：

http://www.mrexcel.com/
http://www.ozgrid.com/

Pivot Table

Pivot table is the most powerful tool in excel. Once you are familiar with this function, it would be of great help in financial data analysis as well as in payroll & human resources management analysis.

省时又省力。

HR2000 Payroll software

a very user friendly payroll software, the data can be easily exported out to csv file of which the HR data can then be analysed using pivot table. so far this is the best payroll software for SME I've come accross, it has solved my many headache with its excellent feature of exporting out data into excel format.

问题是很多人事部人员的excel能力是相当有限的。。造成他们浪费很多不必要的时间去分析。

Macro VBA

Macro也是另一个快速的作业方法。试用以下的macro程式以便快速移至您所指定的工作表标签“Sales by Local & Overseas"：

Sub SalesbyLocalOverseas()

Sheets("Sales by Local & Overseas").Visible = True
Sheets("Sales by Local & Overseas").Select

End Sub

Pivot Table 枢纽分析表 - Excel 2003

多用于分析数据库譬如销售统计；薪金结构分析等。检视各类产品的销售额或数量；或显示销售人员的物品销售情形，让您得到有价值的资料。

Excel Add In

很多Excel Add-In 资源可以上网找到。有些Add-In真的方便又好用。只需按一按几下步骤就解决了。

有兴趣者可试一试 Lookup Wizard, ASAP Utilities; JMT Utilities, Cell Spotter 或Choosesheet，还有其他很多的Add-In，都是免费的。

有何Excel难题 ？放马过来

您面对Excel难题吗？请提问，我将尽所能帮您解决。。

从早期的lotus123至目前的Excel 2007, 其中的变化可谓一日千里。一般的Excel使用者只懂得其普通的操作，譬如加减乘除而忽略了其精华。一旦您懂得它的诀窍，各类报表分析将易如反掌。