上班族必备的Excel函数×函数组合应用范例(PDF+素材+视频)

 

本书封面

内容简介

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

本书目录

目 录
第 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 计算多个汇总值的总和···································································

免责声明

本站收集资源,均来自网络仅用于内部交流之用,如有需要,请支持正版(在某东,天猫或当当网上搜索并购买图书,希望对大家有用)

 

为您推荐

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注

联系我们

联系我们

在线咨询: QQ交谈

邮箱: yuetaocn@163.com

工作时间:周一至周五,9:00-17:30,节假日休息http://www.cadhome.com.cn
返回顶部
首页
电子图书
视频教程
搜索
会员