职场力！最有效的Excel商业数据分析技法
出版时间:
2016-01
版次:
1
ISBN:
9787113207779
定价:
55.00
装帧:
平装
开本:
16开
纸张:
胶版纸
页数:
432页
字数:
503千字
-
本书通过10章的内容详细介绍了使用Excel的15种数据分析方法。第1章为商务数据分析的基础知识，第2章为导入外部数据，第3章为数据透视表，第4章为图表（Excel2010/2007），第5章为图表（Excel2003/2002/2000），第6章为目标查询、规划求解、分析蓝本、运算列表，第7章为关于销售的商业数据分析，第8章为关于企划的商业数据分析，第9章为关于生产的商业数据分析，第10章为关于会计、财务的商业数据分析。
Chapter 01 商务数据分析的基础知识 101 开始商务数据分析 ·····························································2STEP 01 现在可以马上进行的商务数据分析 ····························202 日常业务和商务数据分析的关系 ·······································8STEP 01 日常业务改善的流程和商务数据分析的关系 ·············803 商务数据分析的流程 ·························································9STEP 01 商务数据分析的方法 ·················································904 商务数据分析的基本方法 ················································10STEP 01 算出比率加以分析 ···················································10STEP 02 绘制图表加以分析 ··················································· 11STEP 03 改变切入点加以分析 ···············································12STEP 04 改变维度加以分析 ···················································13Chapter 02 导入外部数据 1501 将分析数据导入Excel ·····················································16STEP 01 数据的导出与导入 ···················································1602 将文本数据导入Excel ·····················································17STEP 01 文本数据格式的种类 ···············································17STEP 02 导入文本数据 ··························································17STEP 03 美化并以Excel 格式存储 ········································2003 在Excel 中导入Access 的数据·······································25STEP 01 导入Access 的数据 ················································2504 加上筛选条件后导入数据 ················································28STEP 01 加上筛选条件导入数据 ············································2805 直接将外部数据制作成数据透视表 ··································31STEP 01 运用数据透视表导入外部数据 ·································3106 将Web 数据导入Excel ···················································35STEP 01 Web 数据的导入······················································3507 将Web 数据以外部数据的形式导入Excel ······················37STEP 01 以外部数据的形式导入Web 数据 ···························3708 练习问题 ·········································································40Chapter 03 数据透视表 4101 何为数据透视表·······························································42STEP 01 数据透视表概要 ·······················································42STEP 02 数据表与数据透视表的构成 ·····································4402 制作数据透视表·······························································46
STEP 01 准备数据透视表 ·······················································46STEP 02 制作数据透视表 ·······················································4903 更改数据透视表的布局 ····················································52STEP 01 更改布局 ·································································5204 筛选数据透视表的数据 ····················································55STEP 01 显示指定的数据 ·······················································5505 制作添加筛选条件的数据透视表 ·····································57STEP 01 添加页字数后根据各项来更改数据透视表 ···············5706 根据报表筛选的项目区分工作表 ·····································60STEP 01 制作项目的统计表 ···················································6007 将数据透视表中的数值数据进行排序 ······························62STEP 01 数值的排序 ······························································62STEP 02 将明细显示的数值进行排序 ·····································6308 显示前10 项 ······································································64STEP 01 显示前10 项 ····························································6409 将项目的顺序加以排序 ····················································67STEP 01 将项目的顺序进行排序 ············································6710 将数据透视表的合计值用百分比表示 ······························68STEP 01 显示百分比 ······························································68STEP 02 设置基准值以比较数据 ············································6911 更改总计的类型 ·······························································71STEP 01 更改值汇总方式 ·······················································7112 将数据透视表的数据创建成组 ·········································73STEP 01 将日期组成组 ··························································7313 更新数据透视表的数据 ····················································76STEP 01 更新数据 ·································································7614 数据透视图 ······································································78STEP 01 制作数据透视图 ·······················································7815 数据透视表的格式化 ·······················································82STEP 01 空白单元格中显示“0” ··········································8216 将数据透视表以“值”的形式显示在别的工作表中 ·········85STEP 01 以“值”的形式显示在其他工作表中 ······················85
-
内容简介:
本书通过10章的内容详细介绍了使用Excel的15种数据分析方法。第1章为商务数据分析的基础知识，第2章为导入外部数据，第3章为数据透视表，第4章为图表（Excel2010/2007），第5章为图表（Excel2003/2002/2000），第6章为目标查询、规划求解、分析蓝本、运算列表，第7章为关于销售的商业数据分析，第8章为关于企划的商业数据分析，第9章为关于生产的商业数据分析，第10章为关于会计、财务的商业数据分析。
-
目录:
Chapter 01 商务数据分析的基础知识 101 开始商务数据分析 ·····························································2STEP 01 现在可以马上进行的商务数据分析 ····························202 日常业务和商务数据分析的关系 ·······································8STEP 01 日常业务改善的流程和商务数据分析的关系 ·············803 商务数据分析的流程 ·························································9STEP 01 商务数据分析的方法 ·················································904 商务数据分析的基本方法 ················································10STEP 01 算出比率加以分析 ···················································10STEP 02 绘制图表加以分析 ··················································· 11STEP 03 改变切入点加以分析 ···············································12STEP 04 改变维度加以分析 ···················································13Chapter 02 导入外部数据 1501 将分析数据导入Excel ·····················································16STEP 01 数据的导出与导入 ···················································1602 将文本数据导入Excel ·····················································17STEP 01 文本数据格式的种类 ···············································17STEP 02 导入文本数据 ··························································17STEP 03 美化并以Excel 格式存储 ········································2003 在Excel 中导入Access 的数据·······································25STEP 01 导入Access 的数据 ················································2504 加上筛选条件后导入数据 ················································28STEP 01 加上筛选条件导入数据 ············································2805 直接将外部数据制作成数据透视表 ··································31STEP 01 运用数据透视表导入外部数据 ·································3106 将Web 数据导入Excel ···················································35STEP 01 Web 数据的导入······················································3507 将Web 数据以外部数据的形式导入Excel ······················37STEP 01 以外部数据的形式导入Web 数据 ···························3708 练习问题 ·········································································40Chapter 03 数据透视表 4101 何为数据透视表·······························································42STEP 01 数据透视表概要 ·······················································42STEP 02 数据表与数据透视表的构成 ·····································4402 制作数据透视表·······························································46
STEP 01 准备数据透视表 ·······················································46STEP 02 制作数据透视表 ·······················································4903 更改数据透视表的布局 ····················································52STEP 01 更改布局 ·································································5204 筛选数据透视表的数据 ····················································55STEP 01 显示指定的数据 ·······················································5505 制作添加筛选条件的数据透视表 ·····································57STEP 01 添加页字数后根据各项来更改数据透视表 ···············5706 根据报表筛选的项目区分工作表 ·····································60STEP 01 制作项目的统计表 ···················································6007 将数据透视表中的数值数据进行排序 ······························62STEP 01 数值的排序 ······························································62STEP 02 将明细显示的数值进行排序 ·····································6308 显示前10 项 ······································································64STEP 01 显示前10 项 ····························································6409 将项目的顺序加以排序 ····················································67STEP 01 将项目的顺序进行排序 ············································6710 将数据透视表的合计值用百分比表示 ······························68STEP 01 显示百分比 ······························································68STEP 02 设置基准值以比较数据 ············································6911 更改总计的类型 ·······························································71STEP 01 更改值汇总方式 ·······················································7112 将数据透视表的数据创建成组 ·········································73STEP 01 将日期组成组 ··························································7313 更新数据透视表的数据 ····················································76STEP 01 更新数据 ·································································7614 数据透视图 ······································································78STEP 01 制作数据透视图 ·······················································7815 数据透视表的格式化 ·······················································82STEP 01 空白单元格中显示“0” ··········································8216 将数据透视表以“值”的形式显示在别的工作表中 ·········85STEP 01 以“值”的形式显示在其他工作表中 ······················85
查看详情
-
九品
重庆市九龙坡区
平均发货11小时
成功完成率96.65%
-
九五品
四川省成都市
平均发货11小时
成功完成率93.51%
-
八五品
上海市浦东新区
平均发货4小时
成功完成率96.52%
-
八五品
广东省东莞市
平均发货14小时
成功完成率93.37%
-
八五品
广东省东莞市
平均发货12小时
成功完成率92.3%
-
八五品
广东省东莞市
平均发货15小时
成功完成率93.15%
-
八五品
广东省东莞市
平均发货19小时
成功完成率91.73%
-
九品
上海市浦东新区
平均发货5小时
成功完成率88.79%
-
九品
上海市浦东新区
平均发货5小时
成功完成率88.79%
-
九品
上海市浦东新区
平均发货5小时
成功完成率88.79%
-
九品
上海市浦东新区
平均发货5小时
成功完成率88.79%
-
九品
天津市宝坻区
平均发货15小时
成功完成率95.34%
-
九五品
河北省保定市
平均发货19小时
成功完成率84.98%
-
九五品
江苏省南京市
平均发货18小时
成功完成率94.55%
-
九五品
江苏省南京市
平均发货21小时
成功完成率92.04%
-
九品
北京市昌平区
平均发货23小时
成功完成率86.63%
-
九品
广东省东莞市
平均发货15小时
成功完成率61.64%
-
九品
-
九五品
江苏省南京市
平均发货21小时
成功完成率90.24%
占位居中
