Coupon
Microsoft Excel Data Analysis and Business Modeling
by Wayne Winston


Overview - 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.  Read more...

 
Paperback
  • $49.99
  • 20% off for Members: Get the Club Price
    $ 39.99
Add to Cart
+ Add to Wishlist
In Stock.

FREE Shipping for Club Members
 
> Check In-Store Availability

In-Store pricing may vary

 
 
New & Used Marketplace 20 copies from $27.47
 
 
 

More About Microsoft Excel Data Analysis and Business Modeling by Wayne Winston
 
 
 
Overview
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


 
Details
  • ISBN-13: 9781509304219
  • ISBN-10: 1509304215
  • Publisher: Microsoft Press
  • Publish Date: December 2016
  • Page Count: 864
  • Dimensions: 9 x 7.4 x 1.8 inches
  • Shipping Weight: 3.05 pounds


Related Categories

Books > Computers > Desktop Applications - Spreadsheets
Books > Computers > Databases - Data Mining

 
BAM Customer Reviews