本书先从客户、老板、上司的全新角度,剖析工作报告对于个人职业发展的重要性,接着阐述了数
据图形化在商务报告中不可替代的地位及作用,然后以广泛使用的E xcel作为工具,介绍如何制作适用于
不同工作报告的各类图表。
与其他图表制作类书籍相比,本书并未满足于单纯的图表制作,而是站在应用的层次去思考,如何
让图表与报告、PPT、邮件完美融合,以制作出适合辅助决策、现场演示、远程说服等实际商用场景的作
品。其中数据收集、分析,图表规划、装饰的案例,都是经过精心挑选的。通过实践、模仿,读者可更快
理解本书所介绍的内容,并在实际工作中获得立竿见影的效果。
本书适用于所有希望提升自己工作境遇,以及想提升自己报告品质的读者。尤其适合初入职场的学
生以及经常需要作商务报告的办公人员。
Excel商务图表应用与技巧108例:双色版/张九玖编著. —北京:电子工业出版社,2012.1
ISBN 978-7-121-15445-4
Ⅰ. ①E… Ⅱ. ①张… Ⅲ. ①表处理软件,Excel Ⅳ. ①TP391.13
中国版本图书馆CIP数据核字(2011)第255189号
策划编辑:张慧敏
责任编辑:安 娜
印 刷:涿州市京南印刷厂
装 订:涿州市桃园装订有限公司
出版发行:电子工业出版社
北京市海淀区万寿路173信箱 邮编:100036
开 本:787×1092 1/16 印张:20.75 字数:531千字
印 次:2012年1月第1次印刷
定 价:49.00元
凡所购买电子工业出版社图书有缺损问题,请向购买书店调换。若书店售缺,请与本社发行部联系,
联系及邮购电话:(010)88254888。
质量投诉请发邮件至zlts@ phei.com .cn,盗版侵权举报请发邮件至dbqq@ phei.com .cn。
服务热线:(010)88258888。
Be in others shoes
2012.3.26
IV
1 ..........................................................................................1
1.1 .................................................................................................2
1.2 .................................................................................................5
1.3 500Good ...............................................................................8
1.4 EQ ............................................................................................9
1.5 .............................................................................10
2 .................................................................................................................... 14
2.1 ............................................................................................15
2.1.1 80% ............................................................................................ 15
2.1.2 ........................................................................................... 19
2.2 ............................................................................................22
2.2.1 ....................................................................................................... 23
2.2.2 ........................................................................................... 32
2.2.3 ........................................................................................... 41
2.2.4 ....................................................................................... 45
2.3 .................................................................................53
2.3.1 ....................................................................................................... 53
2.3.2 ....................................................................................................... 58
2.3.3 ................................................................................................... 61
2.3.4 ....................................................................................................... 64
3 ............................................................................................................... 68
3.1 ..........................................................................................................69
3.1.1 ........................................................................................... 69
3.1.2 ................................................................................................... 71
3.1.3 ................................................................................................... 74
3.2 .....................................................................................................................75
3.2.1 ....................................................................................................................... 75
3.2.2 ............................................................................................... 76
3.2.3 ........................................................................... 80
3.2.4 ....................................................................................... 89
4 ................................................................................................................................ 91
4.1 Excel .................................................................................................92
4.1.1 ............................................................................... 92
4.1.2 ........................................................................................................... 98
4.1.3 ................................................................................................. 104
4.1.4 ................................................................................................. 108
4.1.5 ..................................................................... 111
4.1.6 ......................................................................................... 111
4.1.7 ................................................................................. 116
4.2 ........................................................................................................119
4.2.1 ..................................................................................... 119
4.2.2 ..................................................................................................... 124
4.2.3 ................................................................................................. 127
4.2.4 ......................................................................................... 128
4.3 ....................................................................................................132
4.3.1 ............................................................................................................. 132
4.3.2 ............................................................................................................. 135
4.3.3 ............................................................................................................. 138
4.3.4 ..................................................................... 140
4.3.5 ................................................................................................. 141
VI
5 .............................................................................................................144
5.1 Word ........................................................................................145
5.1.1 ......................................................................................................... 145
5.1.2 ......................................................................................................... 146
5.1.3 ..................................................................................................................... 151
5.1.4 ..................................................................................................... 155
5.2 PPT ........................................................................................................157
5.2.1 ................................................................................................. 157
5.2.2 PPT .......................................................................................................... 161
5.2.3 ............................................................................. 164
5.2.4 ..................................................................................................... 166
5.3 ........................................................................................................169
6 ...........................................................................................174
6.1 90% ...........................................................................175
6.2 Visio ..................................................................................180
6.3 ...............................................................................182
6.4 Flash ......................................................................................................183
6.4.1 Flash......................................................................................... 183
6.4.2 Rich ChartFlash ........................................................................................... 185
6.4.3 ................................................................................. 187
6.5 ....................................................................................................187
6.5.1 DIY Chart ................................................................ 188
6.5.2 Chartgo ............................................................................................ 189
7 .......................................................................................................191
7.1 ...............................................................................192
7.2 ..................................................................................196
VII
7.3 ...........................................................................201
7.4 ...............................................................................210
7.5 ...........................................................................214
7.6 ......................................................................................223
7.7 .............................................................................................227
7.8 ..........................................................................................231
A Excel ..............................................................................................239
VIII