Excel 函数×函数组合应用范例.pdf

Excel 函数×函数组合应用范例.pdf
 

书籍描述

编辑推荐
这书的基础是一本台湾引进的日本书,在台湾排在网络销售的前列,找到这本书时,大约排在第12位。本书主要针对有一定的Excel操作基础,同时需要利用多个函数解决实际工作问题的读者,可以作为常备的参考工具书。

作者简介
《Office 2010图解应用大全》张玉良,中国人民大学新闻学院毕业,具有丰富的出版经验,工作期间也一直在提供各种Excel技术咨询服务和培训,并在各大论坛为网友解答办公软件困惑。2010年下半年创办知行时代(北京)文化传播有限公司,从事图书的策划与编写。近期出版图书:《Office办公秘技360招》、《这么玩Excel最给力》、《Office 2010图解应用大全》均有不错的销量

目录
目 录

第 1 章 基本操作

1.1 创建与修改公式··············································································2
1.1.1 创建公式················································································ 2
1.1.2 修改公式················································································3
1.2 复制与隐藏公式··············································································4
1.2.1 复制公式················································································ 4
1.2.2 隐藏公式················································································ 6
1.3 单元格的引用···············································································7
1.3.1 相对引用················································································ 7
1.3.2 绝对引用················································································ 8
1.3.3 混合引用················································································ 9
1.4 应用单个函数···············································································11
1.4.1 初识函数················································································11
1.4.2 插入函数················································································12
1.5 应用多个函数···············································································15
1.5.1 嵌套函数················································································15
1.5.2 组合应用函数··············································································18
1.6 公式错误的解析··············································································19
1.6.1 错误值的含义··············································································19
1.6.2 应用错误检查选项············································································20
1.6.3 公式审核················································································21

第 2 章 输入与条件格式

001 限定输入指定范围的日期·······································································24
应用 限定输入今年元旦至今日的日期 (TODAY + 数据有效性)
002 限定输入文本长度且以特定字符开头···················································27
应用 限定产品编号以“D”开头且共4位 (LEFT + LEN + AND + 数据有效性)
003 避免一列中输入重复数据·······································································30
应用 在员工信息表中输入重复工号时弹出警告 (COUNTIF + 数据有效性)
004 生成动态下拉列表进行输入···································································33
应用 输入部门名称时通过下拉列表选择部门 (INDIRECT + 数据有效性)
005 提示输入内容且输入正确时自动计算···················································36
应用 提示输入数量并自动计算总额 (IF + AND + ISNONTEXT)
006 给奇数、偶数行设置不同的格式···························································39
应用 让表格内容蓝白相间显示 (MOD + ROW + 条件格式)
007 设置工作表中非空单元格格式·······························································42
应用 制作成本表后仅显示表格区域 (条件公式 + 条件格式)
008 屏蔽错误值················································································45
应用 将错误值显示为空白 (ISERROR + 条件格式)
009 比较两个工作表检查输入错误·······························································48
应用 检查在两个工作表中输入的公司名称是否相同 (EXACT + IF)
拓展 常用同类函数···············································································51

第 3 章 统计分析

010 计算多个汇总值的总和···································································

内容简介
在日常办公中,单个Excel函数的功能有限,往往需要组合运用各种函数才能真正解决问题。本书以经典范例的形式讲解Excel函数的组合应用技巧。全书共分为7章,第1章从Excel函数与公式的基础知识入手,让读者快速了解函数的用法;2-6章通过83个实例介绍了组合函数在数据分析处理、日期与时间、数据检索、字符串操作等方面的应用技巧;第7章为综合实例,以此巩固并实践前面各章学到的组合函数应用技巧。
本书以实例+图解的形式展示了组合函数的强大功能,非常实用,又简单易学。同时,在随书光盘中提供了书中实例的素材文件与最终文件,方便读者进行实操演练。


购买书籍

当当网购书 京东购书 卓越购书

PDF电子书下载地址

相关书籍

搜索更多