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优化产品组合，物流，工作时间表和投资 - 甚至评估运动团队
运行蒙特卡罗模拟股票价格和投标模型
了解基本概率和贝叶斯定理
使用Data Model和Power Pivot在Excel工作簿中有效地构建和使用关系数据源
使用宏自动执行重复分析任务




（Office365的股票类型数据，国内好像没有上线。附件为epub格式）