第三次全国经济普查作为一项重大的国情国力调查,涉及的普查对象数量异常庞大,各级普查机构在普查前期和过程中需要处理、分析的单位数量纷繁复杂而又数量巨大,如何利用EXCEL表进行大批量数据处理和分析?对于普通的基层统计工作者而言至关重要。现就本人在实际工作中的经验和体会,介绍几招简单而又实用的常用函数,让您的工作效率和质量立马得到提升。一、分裂一个单元格内容——取数函数 The third national economic census, as a major state-to-state strength survey, has an unusually large number of census subjects. Census agencies at all levels need to deal with them in the early stage and in the process of census. The number of units under analysis is numerous and numerous, and how to use EXCEL Table for large quantities of data processing and analysis »For ordinary grassroots statisticians is crucial. Now I am in the actual work experience and experience, introduced a few simple and practical functions commonly used functions, so that your work efficiency and quality immediately be promoted. First, split a cell content - take a few functions