Microsoft Excel 2019 Data Analysis and Business Modeling, 6/e (Paperback)

Winston, Wayne (



Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts.


Solve real business problems with Excel--and build your competitive advantage:



  • Quickly transition from Excel basics to sophisticated analytics
  • Use PowerQuery or Get & Transform to connect, combine, and refine data sources
  • Leverage Office 365's new Geography and Stock data types and six new functions
  • Illuminate insights from geographic and temporal data with 3D Maps
  • Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts
  • Use Excel trend curves, multiple regression, and exponential smoothing
  • Delve into key financial, statistical, and time functions
  • Master all of Excel's great charts
  • Quickly create forecasts from historical time-based data
  • Use Solver to optimize product mix, logistics, work schedules, and investments--and even rate sports teams
  • Run Monte Carlo simulations on stock prices and bidding models
  • Learn about basic probability and Bayes' Theorem
  • Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook
  • Automate repetitive analytics tasks by using macros









以 Microsoft Excel 2019 和 Office 365 精通商業建模和分析技巧,將數據轉化為底線結果。這本由屢獲殊榮的教育家 Wayne Winston 撰寫的實踐指南,幫助您使用 Excel 提出正確的問題並獲得準確、可行的答案。新的內容涵蓋了從 Power Query/Get & Transform 到 Office 365 地理和股票數據類型的範圍。通過解決超過 800 個問題的練習,其中許多基於實際工作分析師面臨的挑戰。

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

- 快速從 Excel 基礎知識過渡到複雜的分析
- 使用 PowerQuery 或 Get & Transform 連接、結合和精煉數據來源
- 利用 Office 365 的新地理和股票數據類型以及六個新函數
- 使用 3D 地圖從地理和時間數據中獲得洞察力
- 使用樞紐分析表、描述性統計、直方圖和帕累托圖總結數據
- 使用 Excel 趨勢曲線、多元回歸和指數平滑
- 深入研究關鍵的財務、統計和時間函數
- 掌握 Excel 的所有優秀圖表
- 從歷史時間數據快速創建預測
- 使用 Solver 來優化產品組合、物流、工作時間表和投資,甚至評估體育隊伍
- 在股票價格和投標模型上運行蒙特卡羅模擬
- 了解基本概率和貝葉斯定理
- 使用數據模型和 Power Pivot 在 Excel 工作簿內部有效地構建和使用關聯數據源
- 通過使用宏自動化重複的分析任務。