Microsoft Excel Data Analysis and Business Modeling, 5th Edition

By Wayne Winston



Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed.

Solve real business problems with Excel—and build your competitive advantage

• Quickly transition from Excel basics to sophisticated analytics
• Summarize data by using PivotTables and Descriptive Statistics
• Use Excel trend curves, multiple regression, and exponential smoothing
• Master advanced functions such as OFFSET and INDIRECT
• Delve into key financial, statistical, and time functions
• Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts)
• Make charts more effective by using Power View
• Tame complex optimizations by using Excel Solver
• Run Monte Carlo simulations on stock prices and bidding models
• Work with the AGGREGATE function and table slicers
• Create PivotTables from data in different worksheets or workbooks
• Learn about basic probability and Bayes’ Theorem
• Automate repetitive tasks by using macros

原版 PDF + EPUB:


  如果你喜欢我分享的书籍，请关注我：
https://bbs.pinggu.org/z_guanzhu.php?action=add&fuid=5975757

订阅我的文库：

【金融 + 经济 + 商学 + 国际政治】
https://bbs.pinggu.org/forum.php?mod=collection&action=view&ctid=3257

【数学 + 统计 + 计算机编程】
https://bbs.pinggu.org/forum.php?mod=collection&action=view&ctid=3258

【历史 + 心理学 + 社会自然科学】
https://bbs.pinggu.org/forum.php?mod=collection&action=view&ctid=3259