函数篇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