Microsoft Excel Data Analysis and Business Modeling, 7/e (Office 2021 and Microsoft 365)

Winston, Wayne

  • 出版商: MicroSoft
  • 出版日期: 2021-12-16
  • 售價: $2,100
  • 貴賓價: 9.5$1,995
  • 語言: 英文
  • 頁數: 1168
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 0137613660
  • ISBN-13: 9780137613663
  • 相關分類: ExcelData Science
  • 立即出貨 (庫存=1)



Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts.



Solve real problems with Microsoft Excel--and build your competitive advantage



  • Quickly transition from Excel basics to sophisticated analytics
  • Use recent Power Query enhancements to connect, combine, and transform data sources more effectively
  • Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA
  • Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music
  • Build more sophisticated and compelling charts
  • Use the new XLOOKUP function to revolutionize your lookup formulas
  • Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries
  • Illuminate insights from geographic and temporal data with 3D Maps
  • Improve decision-making with probability, Bayes' theorem, and Monte Carlo simulation and scenarios
  • Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics
  • Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook













以微軟 Excel 學習商業建模和分析技巧,將數據轉化為底線結果。屢獲殊榮的教育家 Wayne Winston 的實踐性、以情境為導向的指南,幫助您使用當今的 Excel 提出正確的問題並獲得準確、可行的答案。本書比以往任何版本都有更全面的更新,新的內容涵蓋從一鍵數據分析到 STOCKHISTORY、動態數組到 Power Query,並包括六個新章節。通過超過 900 個問題的練習,其中許多基於實際工作分析師面臨的挑戰。

使用 Microsoft Excel 解決實際問題,並建立您的競爭優勢。

- 快速從 Excel 基礎知識過渡到複雜的分析
- 使用最新的 Power Query 增強功能更有效地連接、合併和轉換數據源
- 使用 LAMBDA 和 LAMBDA 助手函數創建自定義函數,無需使用 VBA
- 使用新的數據類型導入數據,包括股價、天氣、地理區域信息、大學、電影和音樂
- 構建更複雜、更引人入勝的圖表
- 使用新的 XLOOKUP 函數革新您的查找公式
- 掌握新的動態數組公式,可使用公式對數據進行排序和篩選,並找到所有唯一的項目
- 使用 3D 地圖從地理和時間數據中獲得洞察力
- 通過概率、貝葉斯定理和蒙特卡羅模擬和情景改進決策能力
- 使用 Excel 趨勢曲線、多元回歸和指數平滑進行預測分析
- 使用數據模型和 Power Pivot 在 Excel 工作簿內部有效地構建和使用關聯數據源


Wayne L. Winston is Professor Emeritus of Decision Sciences at Indiana University's Kelley School of Business, where he won 40+ teaching awards. He developed spreadsheet modeling coursework for Harvard Business School Publishing, and has taught or consulted on using Excel to improve decision-making at Microsoft, Cisco, Morgan Stanley, Pfizer, Verizon, the U.S. Navy, U.S. Army, and many other organizations. A two-time Jeopardy! Champion, he co-developed the Dallas Mavericks' player tracking and rating system.


Wayne L. Winston是印第安納大學凱利商學院的決策科學名譽教授,曾獲得40多個教學獎項。他為哈佛商學院出版社開發了試算表建模課程,並在微軟、思科、摩根士丹利、輝瑞、Verizon、美國海軍、美國陸軍等許多組織中教授或諮詢使用Excel來改善決策。作為兩次《危險邊緣!》冠軍,他共同開發了達拉斯小牛隊的球員追蹤和評分系統。