Master trade modeling and research ways with Microsoft Excel 2016, and change into knowledge into backside-line effects. Written through award-successful educator Wayne Winston, this palms on, situation-targeted information is helping you utilize Excel’s latest gear to invite the proper questions and get correct, actionable answers. This variation provides a hundred and fifty+ new issues of answers, plus a bankruptcy of fundamental spreadsheet fashions to you’ll want to’re absolutely up to the mark.

Solve actual trade issues of Excel—and construct your aggressive advantage

  • Quickly transition from Excel fundamentals to stylish analytics
  • Summarize knowledge through the use of PivotTables and Descriptive Statistics
  • Use Excel pattern curves, more than one regression, and exponential smoothing
  • Master complicated purposes equivalent to OFFSET and INDIRECT
  • Delve into key monetary, statistical, and time functions
  • Leverage the brand new charts in Excel 2016 (together with field and whisker and waterfall charts)
  • Make charts more practical through the use of Energy View
  • Tame complicated optimizations through the use of Excel Solver
  • Run Monte Carlo simulations on inventory costs and bidding models
  • Work with the AGGREGATE serve as and desk slicers
  • Create PivotTables from knowledge in numerous worksheets or workbooks
  • Learn approximately fundamental chance and Bayes’ Theorem
  • Automate repetitive duties through the use of macros