Excel在月报统计中的应用

• 作 者: 凌世焱 周宁
• 机 构: 建行湖北汉阳支行,建行湖北长江支行
• 出 处: 统计与决策
• 发表日期: 2003年05期
• 关键词: Excel 单元格 汇总表 筛选条件 担保方式 电子表格软件 银行信贷业务 工程公司 报表格式 企事业单位

目前,我国各类企事业单位都有流水帐记录,私企销售流水帐台帐、银行的《审批台帐》等各种统计记录十分流行,怎样将统计记录表归纳成有价值的统计表呢?对于某些大公司或企业,常采用大型数据库+程序来完成,对于小公司小部门,这样的开销太大了,也不值得。美国微软公司开发的Excel

At present, all kinds of enterprises and institutions in our country have records of running accounts, sales accounts of private sales accounts, and various statistic records such as the “approval of Taiwan’s accounts” of the banks. How can statistical records be summarized into valuable statistical tables? For some large companies or enterprises, often using large databases + procedures to complete, for small business small department, this overhead is too large, it is not worth it. Microsoft developed by Microsoft