中图网(原中国图书网):网上书店,尾货特色书店,30万种特价书低至2折!

歡迎光臨中圖網 請 | 注冊
> >>
職場力!-最有效的ExcEL商業數據分析技法

包郵 職場力!-最有效的ExcEL商業數據分析技法

出版社:中國鐵道出版社出版時間:2016-01-01
開本: 16開 頁數: 394
中 圖 價:¥31.3(5.7折) 定價  ¥55.0 登錄后可看到會員價
加入購物車 收藏
開年大促, 全場包郵
?新疆、西藏除外
本類五星書更多>

職場力!-最有效的ExcEL商業數據分析技法 版權信息

職場力!-最有效的ExcEL商業數據分析技法 本書特色

本書通過10章的內容詳細介紹了使用excel的15種數據分析方法。第1章為商務數據分析的基礎知識,第2章為導入外部數據,第3章為數據透視表,第4章為圖表(excel 2010/2007),第5章為圖表(excel 2003/2002/2000),第6章為目標查詢、規劃求解、分析藍本、運算列表,第7章為關于銷售的商業數據分析,第8章為關于企劃的商業數據分析,第9章為關于生產的商業數據分析,第10章為關于會計、財務的商業數據分析。

職場力!-最有效的ExcEL商業數據分析技法 內容簡介

本書將15類excel應用分析作為重點,以短劇式的會話形式呈現,從企劃、生產、銷售、財務管理等角度,將excel的功能和完整應用于范例中。

職場力!-最有效的ExcEL商業數據分析技法 目錄

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 制作數據透視表·······························································46step 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 以“值”的形式顯示在其他工作表中 ······················8517 練習問題 ·········································································87chapter 04 圖表(excel 2010) 8901 圖表的構成元素·······························································90step 01 圖表的構成元素和可以設置的內容 ··························9002 制作圖表 ·········································································91step 01 制作圖表操作 ··························································91step 02 更改圖表類型 ··························································9503 更改圖表的布局·······························································98step 01 更改圖表整體的布局 ···············································98step 02 更改網格線單位 ·····················································100step 03 更改網格線 ····························································101step 04 在圖表內顯示數據 ·················································10204 選擇元素設置格式 ·························································104step 01 選擇元素與格式設置對話框 ···································10405 在既有的圖表上添加數據 ··············································106step 01 在和圖表相同的工作表中添加數據 ························10606 在既有圖表上追加其他工作表的數據 ····························109step 01 添加與圖表分屬不同工作表的數據 ························10907 組合不同類型的圖表 ····················································· 111step 01 制作圖表 ································································11108 保存自定義圖表····························································· 116step 01 保存圖表為模板 ····················································· 116step 02 使用已保存的圖表 ················································· 11709 練習問題 ·······································································122chapter 05 單變量求解●規劃求解●方案●運算列表 12301 何為單變量求解·····························································124step 01 單變量求解概要 ·····················································124step 02 單元格與“單變量求解”對話框的對應 ·················12502 利用單變量求解逆運算數值 ···········································126step 01 運用單變量求解求出目標值的zui佳數值 ·················12603 何為規劃求解 ································································128step 01 規劃求解的概要 ·····················································128step 02 單元格與“規劃求解參數”對話框的對應 ·············13004 添加規劃求解功能 ·························································132step 01 安裝規劃求解 ························································13205 用規劃求解求出zui佳解答 ··············································134step 01 明確列出規劃求解的目的與限制條件 ····················134step 02 在規劃求解中設置參數后求解 ·······························13506 何為方案 ·······································································140step 01 方案概要 ·······························································140step 02 “添加方案”與“方案變量值”對話框 ·················141step 03 “方案管理器”對話框 ··········································14207 創建方案 ·······································································143step 01 方案的創建 ····························································14308 執行方案 ·······································································146step 01 方案的執行 ····························································14609 綜合顯示方案的結果 ·····················································147step 01 將多個方案綜合顯示 ·············································14710 表格(excel 2010)······················································149step 01 轉換成表格 ····························································149step 02 在表格中添加合計行 ·············································153step 03 在表格中輸入計算式 ·············································15411 練習問題 ········································································158chapter 06 關于銷售的商業數據分析 15901 運用z 圖表來分析銷售額變化的傾向 ····························160step 01 需準備的商務數據 ·················································163step 02 excel 操作①:算出營業額累計和移動年計 ··········164step 03 excel 操作②:制作z 圖表 ···································165step 04 解讀結果 ·······························································16802 運用abc 分析來弄清重點管理項目 ······························169step 01 需準備的商務數據 ·················································172step 02 excel 操作①:銷售額的排序和算出銷售實際成果的合計值 ·················································172step 03 excel 操作②:計算銷售構成比率和構成比率的累計 ····························································175step 04 excel 操作③:顯示劃分的等級順位 ·····················176step 05 excel 操作④:制作柏拉圖 ····································178step 06 excel 操作⑤:顯示abc 的劃分等級順位 ············181step 07 解讀結果 ·······························································18403 提早預測并選定能增加利潤的商品 ································187step 01 需準備的商務數據 ·················································189step 02 excel 操作①:輸入運算公式 ································189step 03 excel 操作②:交叉比率的排序 ····························191step 04 excel 操作③:制作氣泡圖 ····································191step 05 excel 操作④:編輯圖表 ·······································199step 06 解讀結果 ·······························································20304 預測暢銷商品的銷售數量 ··············································205step 01 需準備的商務數據 ·················································206step 02 excel 操作①:制作變化傾向圖 ····························207step 03 excel 操作②:添加趨勢線 ····································209step 04 excel 操作③:算出銷售數量的預測 ·····················213step 05 解讀結果 ·······························································21505 選定拍賣商品 ································································217step 01 需準備的商務數據 ·················································220step 02 excel 操作①:制作需求曲線 ································220step 03 excel 操作②:算出基準價格的預測銷售數量 ·······229step 04 excel 操作③:算出價格彈性 ································231step 05 解讀結果 ·······························································23306 練習問題 ·······································································236chapter 07 關于企劃的商業數據分析 23901 確立商品的市場定位 ·····················································240step 01 需準備的商務數據 ·················································242step 02 excel 操作①:輸入計算式 ····································243step 03 excel 操作②:制作氣泡圖 ····································243step 04 excel 操作③:編輯圖表 ·······································250step 05 excel 操作④:在圖表中標出商品名稱 ··················253step 06 分割成4 個領域 ····················································254step 07 解讀結果 ·······························································25602 從氣象數據預測夏季的銷售數量 ···································258step 01 需準備的商務數據 ·················································262step 02 excel 操作①:算出相關系數與制作散點圖 ··········262step 03 解讀結果① ····························································267step 04 excel 操作②:添加回歸直線 ································267step 05 excel 操作③:算出預測值 ····································269step 06 解讀結果② ····························································27103 求出新開店鋪的有效賣場面積 ·······································273step 01 需準備的商務數據 ·················································275step 02 excel 操作①:求出商圈人口、賣場面積以及銷售額的關系 ························································275step 03 解讀結果① ····························································277step 04 excel 操作②:在新店鋪用地的商圈人口附近加上趨勢線 ····························································278step 05 解讀結果② ····························································281step 06 excel 操作③:根據商圈人口算出預測銷售額 ·······282step 07 excel 操作④:根據trend 函數算出預測銷售額·······································································282目錄.indd 5 2016-1-12 16:53:59contents6step 08 excel 操作⑤:使用單變量求解算出賣場面積 ·······283step 09 解讀結果③ ····························································28504 運用雷達圖來分析商品的強項與弱項 ····························287step 01 需準備的商務數據 ·················································289step 02 excel 操作①:制作雷達圖 ····································289step 03 excel 操作②:編輯圖表 ·······································290step 04 解讀結果 ·······························································29305 判定對提升利潤有貢獻的方法 ·······································296step 01 需準備的商務數據 ·················································303step 02 excel 操作①:掌握現狀 ·······································303step 03 解讀結果① ····························································310step 04 excel 操作②:模擬的準備 ····································310step 05 excel 操作③:改善方案的分析 ····························315step 06 excel 操作④:制作方案 ·······································316step 07 解讀結果② ····························································32006 練習問題 ·······································································323chapter 08 關于生產的商業數據分析 32501 分析勞動生產力以確切指出原因 ···································326step 01 需準備的商務數據 ·················································328step 02 excel 操作①:算出勞動生產力及其3 個指標 ·······329step 03 excel 操作②:比較去年和今年 ····························333step 04 解讀結果 ·······························································33502 導出產生zui大利潤的產量 ··············································337step 01 需準備的商務數據 ·················································339step 02 excel 操作①:目的與生產條件的公式化 ··············340step 03 excel 操作②:規劃求解的設置與操作 ··················342step 04 解讀結果① ····························································347step 05 excel 操作③:產品數據的更改與規劃求解的操作 ···································································347step 06 excel 操作④:運算結果報表的編輯 ·····················349step 07 解讀結果② ····························································35003 求出zui佳的訂貨點 ·························································352step 01 需準備的商務數據 ·················································357step 02 excel 操作①:算出研制周期中的平均銷售數量 ···358step 03 excel 操作②:算出安全庫存 ································359step 04 excel 操作③:算出訂貨點與訂貨量 ·····················360step 05 解讀結果 ·······························································361目錄.indd 6 2016-1-12 16:53:597contents04 練習問題 ·······································································363chapter 09 關于會計、財務的商業數據分析 36501 根據客戶的業績設置信用范圍(交易限額) ·················366step 01 需準備的商務數據 ·················································370step 02 excel 操作①:求出信用范圍的基準金額,準備評價表 ····························································371step 03 excel 操作②:求出流動比率以及自有資本比率 ···372step 04 excel 操作③:根據流動比率與自有資本比率設置信用范圍 ························································373step 05 excel 操作④:信用范圍的設置 ····························376step 06 解讀結果 ·······························································37702 決定購入或是租借 ·························································379step 01 需準備的商務數據 ·················································384step 02 excel 操作①:準備資金流動表 ····························384step 03 excel 操作②:求出凈現值 ····································387step 04 解讀結果 ·······························································39003 練習問題 ·······································································393附錄 圖表(excel 2003)(見二維碼)01 整理圖表的格式step 01 圖表的構成元素和可以設置的內容02 制作圖表(excel 2003)step 01 制作圖表03 更改圖表類型step 01 更改圖表的類型04 選擇元素設置格式step 01 選擇元素與格式設置對話框05 在既有的圖表上添加數據step 01 在和圖表相同的工作表中添加數據step 02 在既有的圖表上添加其他工作表的數據06 組合不同類型的圖表step 01 制作圖表07 保存自定義圖表step 01 保存圖表step 02 使用已保存的圖表08 練習問題目錄.indd 7 2016-1-12 16:53:59目錄.indd 8 2016-1-12 16:53:59
展開全部
商品評論(0條)
暫無評論……
書友推薦
本類暢銷
編輯推薦
返回頂部
中圖網
在線客服
主站蜘蛛池模板: 网站建设,北京网站建设,北京网站建设公司,网站系统开发,北京网站制作公司,响应式网站,做网站公司,海淀做网站,朝阳做网站,昌平做网站,建站公司 | 上海小程序开发-小程序制作-上海小程序定制开发公司-微信商城小程序-上海咏熠 | 大白菜官网,大白菜winpe,大白菜U盘装系统, u盘启动盘制作工具 | 土壤有机碳消解器-石油|表层油类分析采水器-青岛溯源环保设备有限公司 | 湖南教师资格网-湖南教师资格证考试网| 软文发布平台 - 云软媒网络软文直编发布营销推广平台 | 全自动固相萃取仪_高通量真空平行浓缩仪-勤业永为 | 臻知网大型互动问答社区-你的问题将在这里得到解答!-无锡据风网络科技有限公司 | 专业广州网站建设,微信小程序开发,一物一码和NFC应用开发、物联网、外贸商城、定制系统和APP开发【致茂网络】 | 美的商用净水器_美的直饮机_一级代理经销商_Midea租赁价格-厂家反渗透滤芯-直饮水批发品牌售后 | HYDAC过滤器,HYDAC滤芯,现货ATOS油泵,ATOS比例阀-东莞市广联自动化科技有限公司 | atcc网站,sigma试剂价格,肿瘤细胞现货,人结肠癌细胞株购买-南京科佰生物 | 临海涌泉蜜桔官网|涌泉蜜桔微商批发代理|涌泉蜜桔供应链|涌泉蜜桔一件代发 | 附着力促进剂-尼龙处理剂-PP处理剂-金属附着力处理剂-东莞市炅盛塑胶科技有限公司 | 超声波清洗机_细胞破碎仪_实验室超声仪器_恒温水浴-广东洁盟深那仪器 | vr安全体验馆|交通安全|工地安全|禁毒|消防|安全教育体验馆|安全体验教室-贝森德(深圳)科技 | 沥青灌缝机_路面灌缝机_道路灌缝机_沥青灌缝机厂家_济宁萨奥机械有限公司 | 布袋除尘器|除尘器设备|除尘布袋|除尘设备_诺和环保设备 | 压接机|高精度压接机|手动压接机|昆明可耐特科技有限公司[官网] 胶泥瓷砖胶,轻质粉刷石膏,嵌缝石膏厂家,腻子粉批发,永康家德兴,永康市家德兴建材厂 | 舞台木地板厂家_体育运动木地板_室内篮球馆木地板_实木运动地板厂家_欧氏篮球地板推荐 | 外贮压-柜式-悬挂式-七氟丙烷-灭火器-灭火系统-药剂-价格-厂家-IG541-混合气体-贮压-非贮压-超细干粉-自动-灭火装置-气体灭火设备-探火管灭火厂家-东莞汇建消防科技有限公司 | 专业广州网站建设,微信小程序开发,一物一码和NFC应用开发、物联网、外贸商城、定制系统和APP开发【致茂网络】 | 苏州防水公司_厂房屋面外墙防水_地下室卫生间防水堵漏-苏州伊诺尔防水工程有限公司 | 蜗轮丝杆升降机-螺旋升降机-丝杠升降机厂家-润驰传动 | 广东护栏厂家-广州护栏网厂家-广东省安麦斯交通设施有限公司 | 电磁流量计厂家_涡街流量计厂家_热式气体流量计-青天伟业仪器仪表有限公司 | 航空连接器,航空插头,航空插座,航空接插件,航插_深圳鸿万科 | 拉曼光谱仪_便携式|激光|显微共焦拉曼光谱仪-北京卓立汉光仪器有限公司 | 山东led显示屏,山东led全彩显示屏,山东LED小间距屏,临沂全彩电子屏-山东亚泰视讯传媒有限公司 | 生物风-销售载体,基因,质粒,ATCC细胞,ATCC菌株等,欢迎购买-百风生物 | 成都LED显示屏丨室内户外全彩led屏厂家方案报价_四川诺显科技 | 北京亦庄厂房出租_经开区产业园招商信息平台 | 阻垢剂-反渗透缓蚀阻垢剂厂家-山东鲁东环保科技有限公司 | 衬塑管道_衬四氟管道厂家-淄博恒固化工设备有限公司 | 奶茶加盟,奶茶加盟店连锁品牌-甜啦啦官网 | 无纺布包装机|径向缠绕包装机|缠绕膜打包机-上海晏陵智能设备有限公司 | 临时厕所租赁_玻璃钢厕所租赁_蹲式|坐式厕所出租-北京慧海通 | 除湿机|工业除湿机|抽湿器|大型地下室车间仓库吊顶防爆除湿机|抽湿烘干房|新风除湿机|调温/降温除湿机|恒温恒湿机|加湿机-杭州川田电器有限公司 | 深圳标识制作公司-标识标牌厂家-深圳广告标识制作-玟璟广告-深圳市玟璟广告有限公司 | 铣刨料沥青破碎机-沥青再生料设备-RAP热再生混合料破碎筛分设备 -江苏锡宝重工 | 昆山PCB加工_SMT贴片_PCB抄板_线路板焊接加工-昆山腾宸电子科技有限公司 |