职场力！写给经理人的超强Excel函数效率提升术

图书标准信息

• 作者 [日]西沢梦路 著；黄园园 译
• 出版社 中国铁道出版社
• 出版时间 2016-01
• 版次 1
• ISBN 9787113207977
• 定价 49.00元
• 装帧 平装
• 开本 16开
• 纸张 胶版纸
• 页数 376页
• 字数 490千字

【内容简介】

　　本书分为两篇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