:

product description page

Microsoft Excel 2016 Data Analysis and Business Modeling (Paperback) (Wayne L. Winston)

Microsoft Excel 2016 Data Analysis and Business Modeling (Paperback) (Wayne L. Winston) - image 1 of 1

about this item

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

 

Number of Pages: 837
Genre: Computers + Internet, Business + Money Management
Format: Paperback
Publisher: Microsoft Pr
Author: Wayne L. Winston
Language: English
Street Date: December 19, 2016
TCIN: 51758225
UPC: 9781509304219
Item Number (DPCI): 248-32-0228
$42.49
MSRPReg: $49.99 Save $7.50 (15% off)

guest reviews

Prices, promotions, styles and availability may vary by store & online. See our price match guarantee. See how a store is chosen for you.