The Excel PivotTable s Application in the Educational Administration Management Information System of the Radio and TV University;

Application of EXCEL VBA Based Dynamic PivotTable Integrated with Difference Modeling for Hospital Accounting;

Application of EXCEL VBA Based Dynamic PivotTable in Hospital Accounting;

Focussing on the difficult problem that in some data statistics manual work easily make errors in the process of the design of salt making,this paper illustrates and expatiates the use of the function of PivotTable in Excel for the related data calculation and statistic,which can get the exact and reliable result and lighten the workload greatly.

The Data Query based on Pivot Table in the First Page of Medical Records;

The concept of data warehouse and OLAP are introduced briefly, and the pivot table of Excel is used to realize the function of data analysis by combining a practical project to build data warehouse.

According to the concepts of data warehouse and OLAP,the data warehouse will be set up on the basis of the project to be done and the analyzing function can be fulfilled by using the Pivot Table.

The Application of Pivo Table in the Management of College Budget;

This paper introduced the function and usage of Pivo table, and its es tablish-ment and operation.

In process of construction design (specially the architectural design), the designers are initiated to draw a draft of perspective graph simply by studying some incomplete historical information (such as photos and graphs).