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

Wayne Winston

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

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

相關主題

商品描述

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 函數和表格切片器
- 從不同的工作表或工作簿中的數據創建樞紐表
- 了解基本概率和貝葉斯定理
- 通過使用宏自動化重複任務

類似商品