掃一掃
關注中圖網
官方微博
本類五星書更多>
-
>
全國計算機等級考試最新真考題庫模擬考場及詳解·二級MSOffice高級應用
-
>
決戰行測5000題(言語理解與表達)
-
>
軟件性能測試.分析與調優實踐之路
-
>
第一行代碼Android
-
>
JAVA持續交付
-
>
EXCEL最強教科書(完全版)(全彩印刷)
-
>
深度學習
職場力!-最有效的ExcEL商業數據分析技法 版權信息
- ISBN:9787113207779
- 條形碼:9787113207779 ; 978-7-113-20777-9
- 裝幀:70g膠版紙
- 冊數:暫無
- 重量:暫無
- 所屬分類:>>
職場力!-最有效的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
展開全部
書友推薦
- >
我與地壇
- >
唐代進士錄
- >
巴金-再思錄
- >
中國歷史的瞬間
- >
人文閱讀與收藏·良友文學叢書:一天的工作
- >
名家帶你讀魯迅:朝花夕拾
- >
羅曼·羅蘭讀書隨筆-精裝
- >
隨園食單
本類暢銷