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

职场力！最有效的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

查看详情

相关分类

计算机理论编程与开发操作系统大数据与云计算图形图像/多媒体网站设计与网页开发网络与通讯硬件、嵌入式开发办公软件信息安全辅助设计与工程计算软件工程/开发项目管理

0条
|
综合排序
最新上架
店铺
总价从低到高

总价从低到高总价从高到低价格从低到高（不含运费）价格从高到低（不含运费）
四品及以下

全新九五品以上九品以上八五品以上八品以上七品以上六品以上五品以上四品及以下全部品相
只看全新
不同品相有何区别