Microsoft Excel Data Analysis and Business Modeling (5TH ed.)

Wayne Winston

買這商品的人也買了...

商品描述

Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed.

 

Solve real business problems with Excel—and build your competitive advantage

  • Quickly transition from Excel basics to sophisticated analytics
  • Summarize data by using PivotTables and Descriptive Statistics
  • Use Excel trend curves, multiple regression, and exponential smoothing
  • Master advanced functions such as OFFSET and INDIRECT
  • Delve into key financial, statistical, and time functions
  • Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts)
  • Make charts more effective by using Power View
  • Tame complex optimizations by using Excel Solver
  • Run Monte Carlo simulations on stock prices and bidding models
  • Work with the AGGREGATE function and table slicers
  • Create PivotTables from data in different worksheets or workbooks
  • Learn about basic probability and Bayes’ Theorem
  • Automate repetitive tasks by using macros

 

商品描述(中文翻譯)

以 Microsoft Excel 2016 精通商業建模和分析技巧,將數據轉化為底線結果。這本由屢獲殊榮的教育家 Wayne Winston 撰寫的實踐指南,以場景為重點,幫助您使用 Excel 的最新工具提出正確的問題並獲得準確可行的答案。本版新增了150多個帶解決方案的問題,還有一章基本的試算表模型,以確保您完全跟上步伐。

使用 Excel 解決真實的商業問題,並建立您的競爭優勢:

- 快速從 Excel 基礎知識過渡到複雜的分析
- 通過使用樞紐表和描述性統計來總結數據
- 使用 Excel 趨勢曲線、多元回歸和指數平滑
- 掌握偏移和間接等高級函數
- 深入研究關鍵的財務、統計和時間函數
- 利用 Excel 2016 中的新圖表(包括箱形圖和瀑布圖)使圖表更有效
- 通過使用 Power View 使圖表更具效果
- 通過使用 Excel Solver 解決複雜的優化問題
- 在股價和競標模型上運行蒙特卡羅模擬
- 使用 AGGREGATE 函數和表格切片器
- 從不同的工作表或工作簿中的數據創建樞紐表
- 了解基本概率和貝葉斯定理
- 通過使用宏自動化重複任務