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
