[书籍介绍] Microsoft Excel 2019 Data Analysis and Business Modeling (6th Edition) [推广有奖]

1关注
13粉丝

已卖：4870份资源

博士生

还不是VIP/贵宾

威望: 0 级
论坛币: 18864 个
通用积分: 75.0965
学术水平: 26 点
热心指数: 28 点
信用等级: 17 点
经验: 1646 点
帖子: 54
精华: 0
在线时间: 357 小时
注册时间: 2013-9-10
最后登录: 2025-5-9

楼主

onlyflyttn

发表于 2019-5-30 22:23:20 |AI写论文

是否 +2 论坛币

k人参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

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格式）

Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition.rar (78.08 MB, 需要: 5 个论坛币) 本附件包括：
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition.epub