Copyright © 2000-2017 电脑书籍下载 All rights reserved | 沪ICP备05001343号

书籍作者：

[日] 日花弘子

书籍出版：

中国铁道出版社

书籍页数：

332

书籍ISBN：

9787113207779

书籍人气：

623

推荐指数：

★★★★

职场力！最有效的Excel商业数据分析技法

编辑推荐本书将15类Excel应用分析作为重点，以短剧式的会话形式呈现，从企划、生产、销售、财务管理等角度，将Excel的功能和完整应用于范例中。

内容简介本书通过10章的内容详细介绍了使用Excel的15种数据分析方法。第1章为商务数据分析的基础知识，第2章为导入外部数据，第3章为数据透视表，第4章为图表（Excel2010/2007），第5章为图表（Excel2003/2002/2000），第6章为目标查询、规划求解、分析蓝本、运算列表，第7章为关于销售的商业数据分析，第8章为关于企划的商业数据分析，第9章为关于生产的商业数据分析，第10章为关于会计、财务的商业数据分析。

目录

Chapter 01 商务数据分析的基础知识 1

01 开始商务数据分析 ·····························································2

STEP 01 现在可以马上进行的商务数据分析 ····························2

02 日常业务和商务数据分析的关系 ·······································8

STEP 01 日常业务改善的流程和商务数据分析的关系 ·············8

03 商务数据分析的流程 ·························································9

STEP 01 商务数据分析的方法 ·················································9

04 商务数据分析的基本方法 ················································10

STEP 01 算出比率加以分析 ···················································10

STEP 02 绘制图表加以分析 ··················································· 11

STEP 03 改变切入点加以分析 ···············································12

STEP 04 改变维度加以分析 ···················································13

Chapter 02 导入外部数据 15

01 将分析数据导入Excel ·····················································16

STEP 01 数据的导出与导入 ···················································16

02 将文本数据导入Excel ·····················································17

STEP 01 文本数据格式的种类 ···············································17

STEP 02 导入文本数据 ··························································17

STEP 03 美化并以Excel 格式存储 ········································20

03 在Excel 中导入Access 的数据·······································25

STEP 01 导入Access 的数据 ················································25

04 加上筛选条件后导入数据 ················································28

STEP 01 加上筛选条件导入数据 ············································28

05 直接将外部数据制作成数据透视表 ··································31

STEP 01 运用数据透视表导入外部数据 ·································31

06 将Web 数据导入Excel ···················································35

STEP 01 Web 数据的导入······················································35

07 将Web 数据以外部数据的形式导入Excel ······················37

STEP 01 以外部数据的形式导入Web 数据 ···························37

08 练习问题 ·········································································40

Chapter 03 数据透视表 41

01 何为数据透视表·······························································42

STEP 01 数据透视表概要 ·······················································42

STEP 02 数据表与数据透视表的构成 ·····································44

02 制作数据透视表·······························································46

STEP 01 准备数据透视表 ·······················································46

STEP 02 制作数据透视表 ·······················································49

03 更改数据透视表的布局 ····················································52

STEP 01 更改布局 ·································································52

04 筛选数据透视表的数据 ····················································55

STEP 01 显示指定的数据 ·······················································55

05 制作添加筛选条件的数据透视表 ·····································57

STEP 01 添加页字数后根据各项来更改数据透视表 ···············57

06 根据报表筛选的项目区分工作表 ·····································60

STEP 01 制作项目的统计表 ···················································60

07 将数据透视表中的数值数据进行排序 ······························62

STEP 01 数值的排序 ······························································62

STEP 02 将明细显示的数值进行排序 ·····································63

08 显示前10 项 ······································································64

STEP 01 显示前10 项 ····························································64

09 将项目的顺序加以排序 ····················································67

STEP 01 将项目的顺序进行排序 ············································67

10 将数据透视表的合计值用百分比表示 ······························68

STEP 01 显示百分比 ······························································68

STEP 02 设置基准值以比较数据 ············································69

11 更改总计的类型 ·······························································71

STEP 01 更改值汇总方式 ·······················································71

12 将数据透视表的数据创建成组 ·········································73

STEP 01 将日期组成组 ··························································73

13 更新数据透视表的数据 ····················································76

STEP 01 更新数据 ·································································76

14 数据透视图 ······································································78

STEP 01 制作数据透视图 ·······················································78

15 数据透视表的格式化 ·······················································82

STEP 01 空白单元格中显示“0” ··········································82

16 将数据透视表以“值”的形式显示在别的工作表中 ·········85

STEP 01 以“值”的形式显示在其他工作表中 ······················85

Chapter 01 商务数据分析的基础知识 1

01 开始商务数据分析 ·····························································2

STEP 01 现在可以马上进行的商务数据分析 ····························2

02 日常业务和商务数据分析的关系 ·······································8

STEP 01 日常业务改善的流程和商务数据分析的关系 ·············8

03 商务数据分析的流程 ·························································9

STEP 01 商务数据分析的方法 ·················································9

04 商务数据分析的基本方法 ················································10

STEP 01 算出比率加以分析 ···················································10

STEP 02 绘制图表加以分析 ··················································· 11

STEP 03 改变切入点加以分析 ···············································12

STEP 04 改变维度加以分析 ···················································13

Chapter 02 导入外部数据 15

01 将分析数据导入Excel ·····················································16

STEP 01 数据的导出与导入 ···················································16

02 将文本数据导入Excel ·····················································17

STEP 01 文本数据格式的种类 ···············································17

STEP 02 导入文本数据 ··························································17

STEP 03 美化并以Excel 格式存储 ········································20

03 在Excel 中导入Access 的数据·······································25

STEP 01 导入Access 的数据 ················································25

04 加上筛选条件后导入数据 ················································28

STEP 01 加上筛选条件导入数据 ············································28

05 直接将外部数据制作成数据透视表 ··································31

STEP 01 运用数据透视表导入外部数据 ·································31

06 将Web 数据导入Excel ···················································35

STEP 01 Web 数据的导入······················································35

07 将Web 数据以外部数据的形式导入Excel ······················37

STEP 01 以外部数据的形式导入Web 数据 ···························37

08 练习问题 ·········································································40

Chapter 03 数据透视表 41

01 何为数据透视表·······························································42

STEP 01 数据透视表概要 ·······················································42

STEP 02 数据表与数据透视表的构成 ·····································44

02 制作数据透视表·······························································46

STEP 01 准备数据透视表 ·······················································46

STEP 02 制作数据透视表 ·······················································49

03 更改数据透视表的布局 ····················································52

STEP 01 更改布局 ·································································52

04 筛选数据透视表的数据 ····················································55

STEP 01 显示指定的数据 ·······················································55

05 制作添加筛选条件的数据透视表 ·····································57

STEP 01 添加页字数后根据各项来更改数据透视表 ···············57

06 根据报表筛选的项目区分工作表 ·····································60

STEP 01 制作项目的统计表 ···················································60

07 将数据透视表中的数值数据进行排序 ······························62

STEP 01 数值的排序 ······························································62

STEP 02 将明细显示的数值进行排序 ·····································63

08 显示前10 项 ······································································64

STEP 01 显示前10 项 ····························································64

09 将项目的顺序加以排序 ····················································67

STEP 01 将项目的顺序进行排序 ············································67

10 将数据透视表的合计值用百分比表示 ······························68

STEP 01 显示百分比 ······························································68

STEP 02 设置基准值以比较数据 ············································69

11 更改总计的类型 ·······························································71

STEP 01 更改值汇总方式 ·······················································71

12 将数据透视表的数据创建成组 ·········································73

STEP 01 将日期组成组 ··························································73

13 更新数据透视表的数据 ····················································76

STEP 01 更新数据 ·································································76

14 数据透视图 ······································································78

STEP 01 制作数据透视图 ·······················································78

15 数据透视表的格式化 ·······················································82

STEP 01 空白单元格中显示“0” ··········································82

16 将数据透视表以“值”的形式显示在别的工作表中 ·········85

STEP 01 以“值”的形式显示在其他工作表中 ······················85