您的位置 > 首页 > 办公软件书籍

职场力!写给经理人的超强Excel函数效率提升术(附光盘)

职场力!写给经理人的超强Excel函数效率提升术(附光盘)
书籍作者:
[日] 西沢梦路
书籍出版:
中国铁道出版社
书籍页数:
332
书籍ISBN:
9787113207977
书籍人气:
391
推荐指数:
★★★★

职场力!写给经理人的超强Excel函数效率提升术(附光盘)
编辑推荐想要提高办公效率,就要彻底学会Excel的函数与宏功能。
内容简介本书分为两篇13章,第一篇为函数篇,包含第1章到第7章,第1章介绍函数的基本知识,第2章介绍谜一样的“$”,第3章介绍活用字符串,第4章介绍日期时间的操作,第5章介绍IF函数的用法,第6章介绍数学函数,第7章为函数的活用合集。第二篇是宏篇,包含第8章到第13章,第8章为宏入门,第9章为输入到单元格,第10章为认识对象、属性和方法,第11章为若是……就执行……的解决方法,第12章为循环的宏,第13章为用事件来触发宏。
目录

函数篇CHAPTER 01 函数的基本知识 1

01 求和按钮达人 ····································································2

STEP01 快速输入求和的技巧 ··················································2

STEP02 计算平均值、计数也是如法炮制 ································4

STEP03 聪明的按钮 ·····························································6

02 所谓的函数是何方神圣 ······················································9

STEP01 按钮到底做了些什么 ···············································9

STEP02 什么是函数 ·······························································10

STEP03 什么是参数 ·······························································10

STEP04 什么是引用 ······························································· 11

03 函数的输入方法·······························································13

STEP01 只用键盘输入 ···························································13

STEP02 用“键盘+ 鼠标”输入 ············································15

STEP03 用“插入函数”对话框输入······································17

04 使用拖动就能更改引用区域 ·············································20

STEP01 引用区域的确认························································20

STEP02 引用区域的更改························································21

05 函数功能大提升·······························································24

06 练习题 ·············································································26

问题01 快速将指定区域的合计值显示在不相邻的单元格中 ···26

问题02 将引用区域更改为其他工作表 ···································27

问题03 难题!几乎无限大的加法工具 ···································27

函数篇CHAPTER 02 谜一样的$ 29

01 复制函数 ·········································································30

STEP01 复制公式 ··································································30

STEP02 引用区域被任意调整而感到困惑的范例····················31

STEP03 什么是相对引用························································32

STEP04 粉墨登场——绝对引用中的“$” ····························33

STEP05 各种绝对引用 ···························································34

02 排出次序的RANK 函数 ···················································40

STEP01 输入RANK 函数·······················································40

STEP02 设置为绝对引用························································42

STEP03 从分数低的人开始排名次 ·········································44

03 zui方便的查询函数——VLOOKUP ··································46

STEP01 VLOOKUP 的基础知识 ············································46

STEP02 VLOOKUP 参数详解 ················································48

STEP03 再度登场的绝对引用 ················································49


04 无论是行列转置还是跳过一格都能随意引用的OFFSET

函数 ················································································53

STEP01 不可思议!纵向数据转换成横向数据 ·······················53

STEP02 对角线上的引用························································57

STEP03 不管跳一格还是跳两格都可使用OFFSET 函数 ·······60

05 函数大提升 ······································································61

06 练习题 ·············································································62

问题01 复杂的行加列绝对引用 ··············································62

问题02 求出累加值 ································································62

问题03 使用一张对照表来连续查找多列数据 ························63

函数篇CHAPTER 03 灵活运用文本 65

01 连接字符串 ······································································66

STEP01 利用“&”连接符来连接字符串································66

STEP02 连接〒、邮政编码、地址,并以空格分隔 ················67

STEP03 能记住CONCATENATE 的拼法吗 ···························68




函数篇CHAPTER 01 函数的基本知识 1

01 求和按钮达人 ····································································2

STEP01 快速输入求和的技巧 ··················································2

STEP02 计算平均值、计数也是如法炮制 ································4

STEP03 聪明的按钮 ·····························································6

02 所谓的函数是何方神圣 ······················································9

STEP01 按钮到底做了些什么 ···············································9

STEP02 什么是函数 ·······························································10

STEP03 什么是参数 ·······························································10

STEP04 什么是引用 ······························································· 11

03 函数的输入方法·······························································13

STEP01 只用键盘输入 ···························································13

STEP02 用“键盘+ 鼠标”输入 ············································15

STEP03 用“插入函数”对话框输入······································17

04 使用拖动就能更改引用区域 ·············································20

STEP01 引用区域的确认························································20

STEP02 引用区域的更改························································21

05 函数功能大提升·······························································24

06 练习题 ·············································································26

问题01 快速将指定区域的合计值显示在不相邻的单元格中 ···26

问题02 将引用区域更改为其他工作表 ···································27

问题03 难题!几乎无限大的加法工具 ···································27

函数篇CHAPTER 02 谜一样的$ 29

01 复制函数 ·········································································30

STEP01 复制公式 ··································································30

STEP02 引用区域被任意调整而感到困惑的范例····················31

STEP03 什么是相对引用························································32

STEP04 粉墨登场——绝对引用中的“$” ····························33

STEP05 各种绝对引用 ···························································34

02 排出次序的RANK 函数 ···················································40

STEP01 输入RANK 函数·······················································40

STEP02 设置为绝对引用························································42

STEP03 从分数低的人开始排名次 ·········································44

03 zui方便的查询函数——VLOOKUP ··································46

STEP01 VLOOKUP 的基础知识 ············································46

STEP02 VLOOKUP 参数详解 ················································48

STEP03 再度登场的绝对引用 ················································49


04 无论是行列转置还是跳过一格都能随意引用的OFFSET

函数 ················································································53

STEP01 不可思议!纵向数据转换成横向数据 ·······················53

STEP02 对角线上的引用························································57

STEP03 不管跳一格还是跳两格都可使用OFFSET 函数 ·······60

05 函数大提升 ······································································61

06 练习题 ·············································································62

问题01 复杂的行加列绝对引用 ··············································62

问题02 求出累加值 ································································62

问题03 使用一张对照表来连续查找多列数据 ························63

函数篇CHAPTER 03 灵活运用文本 65

01 连接字符串 ······································································66

STEP01 利用“&”连接符来连接字符串································66

STEP02 连接〒、邮政编码、地址,并以空格分隔 ················67

STEP03 能记住CONCATENATE 的拼法吗 ···························68


  • 下载地址

数据库书籍

网络通讯书籍

系统管理书籍