职场力!最有效的Excel商业数据分析技法
出版时间:
2016-01
版次:
1
ISBN:
9787113207779
定价:
55.00
装帧:
平装
开本:
16开
纸张:
胶版纸
页数:
432页
字数:
503千字
14人买过
-
本书通过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
查看详情
-
全新
北京市通州区
平均发货10小时
成功完成率88.04%
-
全新
河北省保定市
平均发货30小时
成功完成率85.21%
-
全新
北京市朝阳区
平均发货13小时
成功完成率85.36%
-
全新
山东省泰安市
平均发货23小时
成功完成率85.78%
-
九品
北京市昌平区
平均发货23小时
成功完成率86.24%
-
八五品
广东省东莞市
平均发货14小时
成功完成率91.9%
-
八五品
广东省东莞市
平均发货16小时
成功完成率92.81%
-
八五品
-
全新
河北省保定市
平均发货21小时
成功完成率83.79%
-
九品
天津市宝坻区
平均发货14小时
成功完成率95.42%
-
全新
河北省保定市
平均发货17小时
成功完成率82.93%
-
全新
山东省泰安市
平均发货23小时
成功完成率85.78%
-
全新
河北省廊坊市
平均发货16小时
成功完成率82.06%
-
全新
北京市丰台区
平均发货8小时
成功完成率90.48%
-
全新
北京市朝阳区
平均发货14小时
成功完成率84.88%
-
全新
上海市黄浦区
平均发货11小时
成功完成率94.52%
-
九五品
江苏省南京市
平均发货21小时
成功完成率92.09%
-
全新
山东省泰安市
平均发货18小时
成功完成率92.6%
-
全新
北京市通州区
平均发货9小时
成功完成率89.05%
-
九五品
四川省成都市
平均发货11小时
成功完成率93.21%
-
八五品
上海市浦东新区
平均发货4小时
成功完成率96.68%
-
九五品
江苏省南京市
平均发货18小时
成功完成率94.49%
-
九品
重庆市九龙坡区
平均发货11小时
成功完成率97.05%
-
九品
上海市浦东新区
平均发货5小时
成功完成率88.13%
-
九品
上海市浦东新区
平均发货5小时
成功完成率88.13%
-
九品
上海市浦东新区
平均发货5小时
成功完成率88.13%
-
九品
上海市浦东新区
平均发货5小时
成功完成率88.13%
-
全新
河北省保定市
平均发货21小时
成功完成率85.39%
-
八五品
广东省东莞市
平均发货18小时
成功完成率92.03%
-
九品
上海市长宁区
平均发货19小时
成功完成率75.27%
-
全新
河北省保定市
平均发货14小时
成功完成率83.21%
-
全新
广东省广州市
平均发货9小时
成功完成率86.98%
-
全新
浙江省杭州市
平均发货24小时
成功完成率73.33%
-
全新
山东省泰安市
平均发货13小时
成功完成率92.06%
-
全新
河北省保定市
平均发货31小时
成功完成率77.92%
-
全新
河北省保定市
平均发货14小时
成功完成率52.08%
-
九五品
江苏省南京市
平均发货21小时
成功完成率90.55%
-
九品
北京市房山区
平均发货23小时
成功完成率71.14%
-
全新
河北省保定市
平均发货28小时
成功完成率71.7%
-
全新
河北省保定市
平均发货17小时
成功完成率68.63%
-
全新