掃一掃
關(guān)注中圖網(wǎng)
官方微博
>
>>
職場(chǎng)力!-最有效的ExcEL商業(yè)數(shù)據(jù)分析技法
包郵 職場(chǎng)力!-最有效的ExcEL商業(yè)數(shù)據(jù)分析技法
作者：日花弘子、黃園園
開(kāi)本：
16開(kāi)
頁(yè)數(shù)：
394
本類(lèi)榜單：計(jì)算機(jī)/網(wǎng)絡(luò)銷(xiāo)量榜
本類(lèi)五星書(shū)更多>
-
>
全國(guó)計(jì)算機(jī)等級(jí)考試最新真考題庫(kù)模擬考場(chǎng)及詳解·二級(jí)MSOffice高級(jí)應(yīng)用
-
>
決戰(zhàn)行測(cè)5000題(言語(yǔ)理解與表達(dá))
-
>
軟件性能測(cè)試.分析與調(diào)優(yōu)實(shí)踐之路
-
>
第一行代碼Android
-
>
JAVA持續(xù)交付
-
>
EXCEL最強(qiáng)教科書(shū)(完全版)(全彩印刷)
-
>
深度學(xué)習(xí)
中圖價(jià):¥40.6
加入購(gòu)物車(chē)
職場(chǎng)力!-最有效的ExcEL商業(yè)數(shù)據(jù)分析技法 版權(quán)信息
- ISBN：9787113207779
- 條形碼：9787113207779 ; 978-7-113-20777-9
- 裝幀：70g膠版紙
- 冊(cè)數(shù)：暫無(wú)
- 重量：暫無(wú)
- 所屬分類(lèi)：>>
職場(chǎng)力!-最有效的ExcEL商業(yè)數(shù)據(jù)分析技法 本書(shū)特色
本書(shū)通過(guò)10章的內(nèi)容詳細(xì)介紹了使用excel的15種數(shù)據(jù)分析方法。第1章為商務(wù)數(shù)據(jù)分析的基礎(chǔ)知識(shí)，第2章為導(dǎo)入外部數(shù)據(jù)，第3章為數(shù)據(jù)透視表，第4章為圖表（excel 2010/2007），第5章為圖表（excel 2003/2002/2000），第6章為目標(biāo)查詢(xún)、規(guī)劃求解、分析藍(lán)本、運(yùn)算列表，第7章為關(guān)于銷(xiāo)售的商業(yè)數(shù)據(jù)分析，第8章為關(guān)于企劃的商業(yè)數(shù)據(jù)分析，第9章為關(guān)于生產(chǎn)的商業(yè)數(shù)據(jù)分析，第10章為關(guān)于會(huì)計(jì)、財(cái)務(wù)的商業(yè)數(shù)據(jù)分析。
職場(chǎng)力!-最有效的ExcEL商業(yè)數(shù)據(jù)分析技法 內(nèi)容簡(jiǎn)介
本書(shū)將15類(lèi)excel應(yīng)用分析作為重點(diǎn)，以短劇式的會(huì)話(huà)形式呈現(xiàn)，從企劃、生產(chǎn)、銷(xiāo)售、財(cái)務(wù)管理等角度，將excel的功能和完整應(yīng)用于范例中。
職場(chǎng)力!-最有效的ExcEL商業(yè)數(shù)據(jù)分析技法 目錄
chapter 01 商務(wù)數(shù)據(jù)分析的基礎(chǔ)知識(shí) 101 開(kāi)始商務(wù)數(shù)據(jù)分析 ·····························································2step 01 現(xiàn)在可以馬上進(jìn)行的商務(wù)數(shù)據(jù)分析 ····························202 日常業(yè)務(wù)和商務(wù)數(shù)據(jù)分析的關(guān)系 ·······································8step 01 日常業(yè)務(wù)改善的流程和商務(wù)數(shù)據(jù)分析的關(guān)系 ·············803 商務(wù)數(shù)據(jù)分析的流程 ·························································9step 01 商務(wù)數(shù)據(jù)分析的方法 ·················································904 商務(wù)數(shù)據(jù)分析的基本方法 ················································10step 01 算出比率加以分析 ···················································10step 02 繪制圖表加以分析 ··················································· 11step 03 改變切入點(diǎn)加以分析 ···············································12step 04 改變維度加以分析 ···················································13chapter 02 導(dǎo)入外部數(shù)據(jù) 1501 將分析數(shù)據(jù)導(dǎo)入excel ·····················································16step 01 數(shù)據(jù)的導(dǎo)出與導(dǎo)入 ···················································1602 將文本數(shù)據(jù)導(dǎo)入excel ·····················································17step 01 文本數(shù)據(jù)格式的種類(lèi) ···············································17step 02 導(dǎo)入文本數(shù)據(jù) ··························································17step 03 美化并以excel 格式存儲(chǔ) ········································2003 在excel 中導(dǎo)入access 的數(shù)據(jù)·······································25step 01 導(dǎo)入access 的數(shù)據(jù) ················································2504 加上篩選條件后導(dǎo)入數(shù)據(jù) ················································28step 01 加上篩選條件導(dǎo)入數(shù)據(jù) ············································2805 直接將外部數(shù)據(jù)制作成數(shù)據(jù)透視表 ··································31step 01 運(yùn)用數(shù)據(jù)透視表導(dǎo)入外部數(shù)據(jù) ·································3106 將web 數(shù)據(jù)導(dǎo)入excel ···················································35step 01 web 數(shù)據(jù)的導(dǎo)入······················································3507 將web 數(shù)據(jù)以外部數(shù)據(jù)的形式導(dǎo)入excel ······················37step 01 以外部數(shù)據(jù)的形式導(dǎo)入web 數(shù)據(jù) ···························3708 練習(xí)問(wèn)題 ·········································································40chapter 03 數(shù)據(jù)透視表 4101 何為數(shù)據(jù)透視表·······························································42step 01 數(shù)據(jù)透視表概要 ·······················································42step 02 數(shù)據(jù)表與數(shù)據(jù)透視表的構(gòu)成 ·····································4402 制作數(shù)據(jù)透視表·······························································46step 01 準(zhǔn)備數(shù)據(jù)透視表 ·······················································46step 02 制作數(shù)據(jù)透視表 ·······················································4903 更改數(shù)據(jù)透視表的布局 ····················································52step 01 更改布局 ·································································5204 篩選數(shù)據(jù)透視表的數(shù)據(jù) ····················································55step 01 顯示指定的數(shù)據(jù) ·······················································5505 制作添加篩選條件的數(shù)據(jù)透視表 ·····································57step 01 添加頁(yè)字?jǐn)?shù)后根據(jù)各項(xiàng)來(lái)更改數(shù)據(jù)透視表 ···············5706 根據(jù)報(bào)表篩選的項(xiàng)目區(qū)分工作表 ·····································60step 01 制作項(xiàng)目的統(tǒng)計(jì)表 ···················································6007 將數(shù)據(jù)透視表中的數(shù)值數(shù)據(jù)進(jìn)行排序 ······························62step 01 數(shù)值的排序 ······························································62step 02 將明細(xì)顯示的數(shù)值進(jìn)行排序 ·····································6308 顯示前10 項(xiàng) ······································································64step 01 顯示前10 項(xiàng) ····························································6409 將項(xiàng)目的順序加以排序 ····················································67step 01 將項(xiàng)目的順序進(jìn)行排序 ············································6710 將數(shù)據(jù)透視表的合計(jì)值用百分比表示 ······························68step 01 顯示百分比 ······························································68step 02 設(shè)置基準(zhǔn)值以比較數(shù)據(jù) ············································6911 更改總計(jì)的類(lèi)型 ·······························································71step 01 更改值匯總方式 ·······················································7112 將數(shù)據(jù)透視表的數(shù)據(jù)創(chuàng)建成組 ·········································73step 01 將日期組成組 ··························································7313 更新數(shù)據(jù)透視表的數(shù)據(jù) ····················································76step 01 更新數(shù)據(jù) ·································································7614 數(shù)據(jù)透視圖 ······································································78step 01 制作數(shù)據(jù)透視圖 ·······················································7815 數(shù)據(jù)透視表的格式化 ·······················································82step 01 空白單元格中顯示“0” ··········································8216 將數(shù)據(jù)透視表以“值”的形式顯示在別的工作表中 ·········85step 01 以“值”的形式顯示在其他工作表中 ······················8517 練習(xí)問(wèn)題 ·········································································87chapter 04 圖表（excel 2010） 8901 圖表的構(gòu)成元素·······························································90step 01 圖表的構(gòu)成元素和可以設(shè)置的內(nèi)容 ··························9002 制作圖表 ·········································································91step 01 制作圖表操作 ··························································91step 02 更改圖表類(lèi)型 ··························································9503 更改圖表的布局·······························································98step 01 更改圖表整體的布局 ···············································98step 02 更改網(wǎng)格線(xiàn)單位 ·····················································100step 03 更改網(wǎng)格線(xiàn) ····························································101step 04 在圖表內(nèi)顯示數(shù)據(jù) ·················································10204 選擇元素設(shè)置格式 ·························································104step 01 選擇元素與格式設(shè)置對(duì)話(huà)框 ···································10405 在既有的圖表上添加數(shù)據(jù) ··············································106step 01 在和圖表相同的工作表中添加數(shù)據(jù) ························10606 在既有圖表上追加其他工作表的數(shù)據(jù) ····························109step 01 添加與圖表分屬不同工作表的數(shù)據(jù) ························10907 組合不同類(lèi)型的圖表 ····················································· 111step 01 制作圖表 ································································11108 保存自定義圖表····························································· 116step 01 保存圖表為模板 ····················································· 116step 02 使用已保存的圖表 ················································· 11709 練習(xí)問(wèn)題 ·······································································122chapter 05 單變量求解●規(guī)劃求解●方案●運(yùn)算列表 12301 何為單變量求解·····························································124step 01 單變量求解概要 ·····················································124step 02 單元格與“單變量求解”對(duì)話(huà)框的對(duì)應(yīng) ·················12502 利用單變量求解逆運(yùn)算數(shù)值 ···········································126step 01 運(yùn)用單變量求解求出目標(biāo)值的zui佳數(shù)值 ·················12603 何為規(guī)劃求解 ································································128step 01 規(guī)劃求解的概要 ·····················································128step 02 單元格與“規(guī)劃求解參數(shù)”對(duì)話(huà)框的對(duì)應(yīng) ·············13004 添加規(guī)劃求解功能 ·························································132step 01 安裝規(guī)劃求解 ························································13205 用規(guī)劃求解求出zui佳解答 ··············································134step 01 明確列出規(guī)劃求解的目的與限制條件 ····················134step 02 在規(guī)劃求解中設(shè)置參數(shù)后求解 ·······························13506 何為方案 ·······································································140step 01 方案概要 ·······························································140step 02 “添加方案”與“方案變量值”對(duì)話(huà)框 ·················141step 03 “方案管理器”對(duì)話(huà)框 ··········································14207 創(chuàng)建方案 ·······································································143step 01 方案的創(chuàng)建 ····························································14308 執(zhí)行方案 ·······································································146step 01 方案的執(zhí)行 ····························································14609 綜合顯示方案的結(jié)果 ·····················································147step 01 將多個(gè)方案綜合顯示 ·············································14710 表格（excel 2010）······················································149step 01 轉(zhuǎn)換成表格 ····························································149step 02 在表格中添加合計(jì)行 ·············································153step 03 在表格中輸入計(jì)算式 ·············································15411 練習(xí)問(wèn)題 ········································································158chapter 06 關(guān)于銷(xiāo)售的商業(yè)數(shù)據(jù)分析 15901 運(yùn)用z 圖表來(lái)分析銷(xiāo)售額變化的傾向 ····························160step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································163step 02 excel 操作①：算出營(yíng)業(yè)額累計(jì)和移動(dòng)年計(jì) ··········164step 03 excel 操作②：制作z 圖表 ···································165step 04 解讀結(jié)果 ·······························································16802 運(yùn)用abc 分析來(lái)弄清重點(diǎn)管理項(xiàng)目 ······························169step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································172step 02 excel 操作①：銷(xiāo)售額的排序和算出銷(xiāo)售實(shí)際成果的合計(jì)值 ·················································172step 03 excel 操作②：計(jì)算銷(xiāo)售構(gòu)成比率和構(gòu)成比率的累計(jì) ····························································175step 04 excel 操作③：顯示劃分的等級(jí)順位 ·····················176step 05 excel 操作④：制作柏拉圖 ····································178step 06 excel 操作⑤：顯示abc 的劃分等級(jí)順位 ············181step 07 解讀結(jié)果 ·······························································18403 提早預(yù)測(cè)并選定能增加利潤(rùn)的商品 ································187step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································189step 02 excel 操作①：輸入運(yùn)算公式 ································189step 03 excel 操作②：交叉比率的排序 ····························191step 04 excel 操作③：制作氣泡圖 ····································191step 05 excel 操作④：編輯圖表 ·······································199step 06 解讀結(jié)果 ·······························································20304 預(yù)測(cè)暢銷(xiāo)商品的銷(xiāo)售數(shù)量 ··············································205step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································206step 02 excel 操作①：制作變化傾向圖 ····························207step 03 excel 操作②：添加趨勢(shì)線(xiàn) ····································209step 04 excel 操作③：算出銷(xiāo)售數(shù)量的預(yù)測(cè) ·····················213step 05 解讀結(jié)果 ·······························································21505 選定拍賣(mài)商品 ································································217step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································220step 02 excel 操作①：制作需求曲線(xiàn) ································220step 03 excel 操作②：算出基準(zhǔn)價(jià)格的預(yù)測(cè)銷(xiāo)售數(shù)量 ·······229step 04 excel 操作③：算出價(jià)格彈性 ································231step 05 解讀結(jié)果 ·······························································23306 練習(xí)問(wèn)題 ·······································································236chapter 07 關(guān)于企劃的商業(yè)數(shù)據(jù)分析 23901 確立商品的市場(chǎng)定位 ·····················································240step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································242step 02 excel 操作①：輸入計(jì)算式 ····································243step 03 excel 操作②：制作氣泡圖 ····································243step 04 excel 操作③：編輯圖表 ·······································250step 05 excel 操作④：在圖表中標(biāo)出商品名稱(chēng) ··················253step 06 分割成4 個(gè)領(lǐng)域 ····················································254step 07 解讀結(jié)果 ·······························································25602 從氣象數(shù)據(jù)預(yù)測(cè)夏季的銷(xiāo)售數(shù)量 ···································258step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································262step 02 excel 操作①：算出相關(guān)系數(shù)與制作散點(diǎn)圖 ··········262step 03 解讀結(jié)果① ····························································267step 04 excel 操作②：添加回歸直線(xiàn) ································267step 05 excel 操作③：算出預(yù)測(cè)值 ····································269step 06 解讀結(jié)果② ····························································27103 求出新開(kāi)店鋪的有效賣(mài)場(chǎng)面積 ·······································273step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································275step 02 excel 操作①：求出商圈人口、賣(mài)場(chǎng)面積以及銷(xiāo)售額的關(guān)系 ························································275step 03 解讀結(jié)果① ····························································277step 04 excel 操作②：在新店鋪用地的商圈人口附近加上趨勢(shì)線(xiàn) ····························································278step 05 解讀結(jié)果② ····························································281step 06 excel 操作③：根據(jù)商圈人口算出預(yù)測(cè)銷(xiāo)售額 ·······282step 07 excel 操作④：根據(jù)trend 函數(shù)算出預(yù)測(cè)銷(xiāo)售額·······································································282目錄.indd 5 2016-1-12 16:53:59contents6step 08 excel 操作⑤：使用單變量求解算出賣(mài)場(chǎng)面積 ·······283step 09 解讀結(jié)果③ ····························································28504 運(yùn)用雷達(dá)圖來(lái)分析商品的強(qiáng)項(xiàng)與弱項(xiàng) ····························287step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································289step 02 excel 操作①：制作雷達(dá)圖 ····································289step 03 excel 操作②：編輯圖表 ·······································290step 04 解讀結(jié)果 ·······························································29305 判定對(duì)提升利潤(rùn)有貢獻(xiàn)的方法 ·······································296step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································303step 02 excel 操作①：掌握現(xiàn)狀 ·······································303step 03 解讀結(jié)果① ····························································310step 04 excel 操作②：模擬的準(zhǔn)備 ····································310step 05 excel 操作③：改善方案的分析 ····························315step 06 excel 操作④：制作方案 ·······································316step 07 解讀結(jié)果② ····························································32006 練習(xí)問(wèn)題 ·······································································323chapter 08 關(guān)于生產(chǎn)的商業(yè)數(shù)據(jù)分析 32501 分析勞動(dòng)生產(chǎn)力以確切指出原因 ···································326step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································328step 02 excel 操作①：算出勞動(dòng)生產(chǎn)力及其3 個(gè)指標(biāo) ·······329step 03 excel 操作②：比較去年和今年 ····························333step 04 解讀結(jié)果 ·······························································33502 導(dǎo)出產(chǎn)生zui大利潤(rùn)的產(chǎn)量 ··············································337step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································339step 02 excel 操作①：目的與生產(chǎn)條件的公式化 ··············340step 03 excel 操作②：規(guī)劃求解的設(shè)置與操作 ··················342step 04 解讀結(jié)果① ····························································347step 05 excel 操作③：產(chǎn)品數(shù)據(jù)的更改與規(guī)劃求解的操作 ···································································347step 06 excel 操作④：運(yùn)算結(jié)果報(bào)表的編輯 ·····················349step 07 解讀結(jié)果② ····························································35003 求出zui佳的訂貨點(diǎn) ·························································352step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································357step 02 excel 操作①：算出研制周期中的平均銷(xiāo)售數(shù)量 ···358step 03 excel 操作②：算出安全庫(kù)存 ································359step 04 excel 操作③：算出訂貨點(diǎn)與訂貨量 ·····················360step 05 解讀結(jié)果 ·······························································361目錄.indd 6 2016-1-12 16:53:597contents04 練習(xí)問(wèn)題 ·······································································363chapter 09 關(guān)于會(huì)計(jì)、財(cái)務(wù)的商業(yè)數(shù)據(jù)分析 36501 根據(jù)客戶(hù)的業(yè)績(jī)?cè)O(shè)置信用范圍（交易限額） ·················366step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································370step 02 excel 操作①：求出信用范圍的基準(zhǔn)金額，準(zhǔn)備評(píng)價(jià)表 ····························································371step 03 excel 操作②：求出流動(dòng)比率以及自有資本比率 ···372step 04 excel 操作③：根據(jù)流動(dòng)比率與自有資本比率設(shè)置信用范圍 ························································373step 05 excel 操作④：信用范圍的設(shè)置 ····························376step 06 解讀結(jié)果 ·······························································37702 決定購(gòu)入或是租借 ·························································379step 01 需準(zhǔn)備的商務(wù)數(shù)據(jù) ·················································384step 02 excel 操作①：準(zhǔn)備資金流動(dòng)表 ····························384step 03 excel 操作②：求出凈現(xiàn)值 ····································387step 04 解讀結(jié)果 ·······························································39003 練習(xí)問(wèn)題 ·······································································393附錄 圖表（excel 2003）（見(jiàn)二維碼）01 整理圖表的格式step 01 圖表的構(gòu)成元素和可以設(shè)置的內(nèi)容02 制作圖表（excel 2003）step 01 制作圖表03 更改圖表類(lèi)型step 01 更改圖表的類(lèi)型04 選擇元素設(shè)置格式step 01 選擇元素與格式設(shè)置對(duì)話(huà)框05 在既有的圖表上添加數(shù)據(jù)step 01 在和圖表相同的工作表中添加數(shù)據(jù)step 02 在既有的圖表上添加其他工作表的數(shù)據(jù)06 組合不同類(lèi)型的圖表step 01 制作圖表07 保存自定義圖表step 01 保存圖表step 02 使用已保存的圖表08 練習(xí)問(wèn)題目錄.indd 7 2016-1-12 16:53:59目錄.indd 8 2016-1-12 16:53:59
展開(kāi)全部
書(shū)友推薦
- >
月亮虎
- >
中國(guó)人在烏蘇里邊疆區(qū):歷史與人類(lèi)學(xué)概述
- >
經(jīng)典常談
- >
二體千字文
- >
伯納黛特,你要去哪(2021新版)
- >
羅曼·羅蘭讀書(shū)隨筆-精裝
- >
新文學(xué)天穹兩巨星--魯迅與胡適/紅燭學(xué)術(shù)叢書(shū)(紅燭學(xué)術(shù)叢書(shū))
- >
羅庸西南聯(lián)大授課錄
本類(lèi)暢銷(xiāo)
