Excel数据多级分类汇总应用

Application of Multi-level Classification and Aggregation of Excel Data

文中对Excel数据分类汇总进行探索,运用7个Excel内置函数组合成数据筛选公式和汇总公式,实现数据分类汇总的自动化应用,计算生成统计汇总表,解决数据的多级分类汇总应用。此外,这种函数组合方式也带来一种思考:函数组合应用有类似编程的效果。文章对上述思考进行了细致的分析与验证,在不借助编程的情况下,实现了数据分类汇总的自动化应用。

In this paper,Excel data classification and aggregation are explored.Seven excel built-in functions are combined to form data filtering formula and aggregation formula.The automatic application of data classification and aggregation is realized,and the statistical aggregation table is calculated and generated to solve the multi-level classification and aggregation application of data.In addition,this kind of function combination method also brings a kind of thinking:the function combination application has the similar programming effect.This paper makes a detailed analysis and verification of the above thinking,and realizes the automatic application of data classification and aggregation without the aid of programming.