Excel数据透视表“布局”设计的应用——以建水县公益林区划界定成果表统计为例

Excel数据透视表功能强大,尤其在数据多、属性信息量大的统计任务中,数据透视表报表布局设计与自动统计汇总功能快捷高效。文章以Excel数据透视表在建水公益林区划界定报表统计任务中的应用为例,抛砖引玉,介绍数据透视表创建及布局设计操作方法,以减轻劳动强度、提高工作效率和准确率。

Data Pivot Table Applied In Distribution of Excel

Excel Pivot Table is powerful,especially in the data more informative and attributes in statistical work.The layout of the Pivot Table report,aggregate functions and automatic fast and efficient.This paper to Excel pivot tables in-building Jianshui count ecological regionalization define statements application example of statistical work,wants to create and introduced pivot table layout design operation method;in order to reduce labor intensity;improve work efficiency and accuracy.