Microsoft Excel Data Analysis and Business Modeling (5th Edition)

Amazon.com Price: $38.48 (as of 11/10/2019 08:23 PST- Details)

Description

Master business modeling and analysis techniques with Microsoft Excel 2016, and become 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 invite the proper questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to be sure to’re fully on top of things.

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

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

 

Home » Shop » Books » Specialty Boutique » New, Used and Rental Textbooks » Science and Mathematics » Mathematics » Applied » Microsoft Excel Data Analysis and Business Modeling (5th Edition)

Recent Products