9781509304219-1509304215-Microsoft Excel Data Analysis and Business Modeling

Microsoft Excel Data Analysis and Business Modeling

ISBN-13: 9781509304219
ISBN-10: 1509304215
Edition: 5
Author: Wayne Winston
Publication date: 2016
Publisher: Microsoft Press
Format: Paperback 864 pages
FREE shipping on ALL orders

Book details

ISBN-13: 9781509304219
ISBN-10: 1509304215
Edition: 5
Author: Wayne Winston
Publication date: 2016
Publisher: Microsoft Press
Format: Paperback 864 pages

Summary

Acknowledged authors Wayne Winston wrote Microsoft Excel Data Analysis and Business Modeling comprising 864 pages back in 2016. Textbook and eTextbook are published under ISBN 1509304215 and 9781509304219. Since then Microsoft Excel Data Analysis and Business Modeling textbook was available to sell back to BooksRun online for the top buyback price of $ 5.99 or rent at the marketplace.

Description

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
Rate this book Rate this book

We would LOVE it if you could help us and other readers by reviewing the book