( 商品编号B01ARMZCMG )职场力!写给经理人的超强Excel函数效率提升术 / 西沢梦路

  • 本店售价:RM38.71
  • 市场价格:RM49.00
  • 商品点击数:48
  • 购买此商品可使用:3333 消费积分

购买数量:

商品总价:38.71

购买 快速订购

加入收藏夹

商品描述

1.请注意,本店所有的图书均需订购
2.所有图书从下单汇款批次结束日期起计算,大约6个星期左右抵达,详情请查看下单须知时间表,谢谢 :)
3.下单后请耐心等待店主确认订单,如果缺货的话店主将会通过email联系。请等待店主确认订单后才汇款。
4.周一至周五,店主通常都仅能在晚上7时过后才能确认订单.
5.所有订单图书仅在汇款后生效,因此所有下单后3天内没汇款的一律取消哦。
6.汇款后请记得email或sms店主,不然店主是不懂谁汇款的
7.请记得,电话号码仅供汇款通知用途,如有任何疑问欢迎email店主或在留言板留言。但如果是sms或电话询问将一律不回复哦
8.最后祝大家购书愉快~ =^.^=


基本信息

书名:职场力!写给经理人的超强excel函数效率提升术

定价:49.00元

作者:西沢梦路

出版社:中国铁道出版社

出版日期:2016年1月1日

ISBN:9787113207977

字数:

页码:363

版次:第1版

装帧:平装

开本:16

商品标识:B01ARMZCMG

编辑推荐

暂无

媒体推荐

暂无

作者介绍

作者:(日)西沢梦路 译者:黄园园

内容提要

想要提高办公效率,就要彻底学会excel的函数与宏功能。

目录


函数篇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
02 转换文本的类型·······························································70
STEP01 切换大写、小写························································70
STEP02 切换全角、半角························································73
STEP03 显示拼音标注 ···························································76
03 截取字符串的一部分 ·······················································78
STEP01 从左边截取 ·······························································78
STEP02 从右边截取 ·······························································80
STEP03 从任一位置截取想要的部分······································82
04 查看文本的长度、位置 ····················································85
STEP01 查看指定字符的位置 ················································85
STEP02 只截取位于“@”前面的字符串 ······························87
STEP03 查看文本长度(一) ················································90
STEP04 查看文本长度(二) ················································91
05 有趣又实用的文本函数 ····················································94
STEP01 重复文本 ··································································94
STEP02 替换文本中的一部分 ················································97
STEP03 以自己想要的格式来显示字符串 ······························99
06 函数大提升 ····································································103
07 练习题 ···········································································105
问题01 显示中文的拼音 ·······················································105
问题02 在空格处换行 ··························································105
问题03 将“对不起”改为m(__)m、将“哇~”改为(^o^) ···106

函数篇CHAPTER 04 彻底学会日期和时间的操作 107
01 excel 中日期和时间的处理 ············································108
STEP01 日期和时间的输入方式 ···········································108
STEP02 什么是序列值 ························································· 110
STEP03 日期的计算 ····························································· 112
STEP04 NOW 函数 ······························································ 112
02 处理日期和时间····························································· 114
STEP01 更改数字显示格式来显示日期和时间 ····················· 114
STEP02 通过TEXT 函数来更改数字格式 ···························· 115
STEP03 取出年、月、日的元素 ··········································· 116
STEP04 取出时、分、秒的元素 ··········································· 118
03 操作序列值 ····································································120
STEP01 计算序列值的差······················································120
STEP02 从年月日来求出序列值 ···········································122
STEP03 从出生年月日来算出星座 ·······································124
04 麻烦的星期显示·····························································127
STEP01 使用TEXT 函数来显示星期 ···································127
STEP02 出生在星期几 ·························································129
STEP03 使用CHOOSE 函数来显示星期 ·····························132
05 函数大提升 ····································································134
06 练习题 ···········································································135
问题01 古风风格的中文数字时钟 ········································135
问题02 按时间来变换显示信息 ············································135
问题03 万年历当月的行程预订表 ········································136
函数篇CHAPTER 05 向IF 函数挑战 137
01 根据年龄段来处理的IF 函数 ·········································138
STEP01 IF 函数 ···································································138
STEP02 如果为60 以上就显示“good” ·····························139
STEP03 清除不必要的显示 ··················································141
STEP04 将IF 函数设置成嵌套结构 ······································142
02 可统计个数的COUNTIF 函数 ·······································145
STEP01 查找符合条件的数据个数 ·······································145
STEP02 将字符串设置成条件 ··············································147
STEP03 使用通配符 ·····························································148
03 只求指定部分的和 ·························································150
STEP01 只对10 万以下的数据求和 ·····································150

STEP02 用SUMIF 函数对其他范围求和 ······························152
STEP03 可更改的查找条件 ··················································153
04 函数大提升 ····································································155
05 练习题 ···········································································156
问题01 根据男女分别计算出英语、数学、语文的合计值 ····156
问题02 心电感应函数 ··························································156
问题03 全自动!超完美!万年历 ··········································158
问题04 全自动!超完美!实用!可作为普通万年历来使用 ····158
函数篇CHAPTER 06 简单学数学 159
01 思考“四舍五入” ·························································160
STEP01 不合理的显示(一) ··············································160
STEP02 不合理的显示(二) ··············································161
STEP03 四舍五入 ································································161
02 随机数和模拟 ································································164
STEP01 随机数 ····································································164
STEP02 无条件舍去 ·····························································168
STEP03 掷骰子模拟 ·····························································169
03 π、弧度、三角函数 ·····················································171
STEP01 π ···········································································171
STEP02 弧度与度 ································································172
STEP03 三角函数 ································································174
04 函数大提升 ····································································176
05 练习题 ···········································································177
问题01 猜拳模拟 ··································································177
问题02 钱币的各种面额计算 ················································177
问题03 描绘山形 ··································································178
函数篇CHAPTER 07 函数活用特辑 179
01 引用其他工作表·····························································180
STEP01 工作表间的引用······················································180
STEP02 立体引用的技巧······················································181
02 公式也可变换成值 ·························································184
STEP01 公式与值 ································································184
STEP02 将公式转换成值······················································185
03 根据喜好为引用的单元格区域命名 ································187
STEP01 为引用的单元格区域命名(一) ····························187

STEP02 利用名称来进行引用 ··············································190
STEP03 为引用的单元格区域命名(二) ····························192
04 函数大提升 ····································································193
05 练习题 ···········································································194
问题01 只以函数来显示星期二上的第5 节课 ······················194
问题02 瞬间输入“删除完毕” ············································195
问题03 将企业中文名称全部改为英文名称 ··························196
宏 篇CHAPTER 08 宏入门 197
01 宏的录制、宏入门 ·························································198
STEP01 什么是宏 ································································198
STEP02 录制宏的操作步骤 ··················································199
STEP03 宏的执行 ································································205
STEP04 宏的保存位置 ·························································207
STEP05 使用宏的准备工作 ··················································208
STEP06 将1 000 个数据分开分布——相对引用的
宏录制 ····································································213
02 虽为附加功能却很厉害的VBE ······································217
STEP01 认识VBE ·······································

购买记录

近期成交数量0

还没有人购买过此商品

商品评论

已有0人评论

暂时还没有任何用户评论

请在这里发表你的评论

用户名: 匿名用户

评价等级:

购买记录

近期成交数量0

还没有人购买过此商品

商品评论

已有0人评论

暂时还没有任何用户评论

请在这里发表你的评论

用户名: 匿名用户

评价等级: