Microsoft Excel 2013: Data Analysis and Business Modeling (Paperback)
暫譯: Microsoft Excel 2013：數據分析與商業建模（平裝本）

Wayne Winston

Microsoft Excel 2013: Data Analysis and Business Modeling (Paperback)

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

相關主題

商品描述

Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook.

Solve real business problems with Excel—and sharpen your edge

  • Summarize data with PivotTables and Descriptive Statistics
  • Explore new trends in predictive and prescriptive analytics
  • Use Excel Trend Curves, multiple regression, and exponential smoothing
  • Master advanced Excel functions such as OFFSET and INDIRECT
  • Delve into key financial, statistical, and time functions
  • Make your charts more effective with the Power View tool
  • Tame complex optimization problems with Excel Solver
  • Run Monte Carlo simulations on stock prices and bidding models
  • Apply important modeling tools such as the Inquire add-in

商品描述(中文翻譯)

掌握 Microsoft Excel 2013 的商業建模和分析技術，將數據轉化為底線結果。這本由獲獎教育家 Wayne Winston 撰寫的實用指南，專注於情境，展示如何使用最新的 Excel 工具整合來自多個表格的數據，以及如何在 Excel 工作簿內有效地建立關聯數據來源。

**使用 Excel 解決實際商業問題，並提升您的競爭優勢**
- 使用樞紐分析表和描述性統計來總結數據
- 探索預測分析和處方分析中的新趨勢
- 使用 Excel 趨勢曲線、多重回歸和指數平滑
- 精通進階 Excel 函數，如 OFFSET 和 INDIRECT
- 深入了解關鍵的財務、統計和時間函數
- 使用 Power View 工具使您的圖表更具效果
- 使用 Excel Solver 解決複雜的優化問題
- 對股票價格和投標模型進行蒙地卡羅模擬
- 應用重要的建模工具，如 Inquire 外掛程式

類似商品