Home > Store

Microsoft Excel Data Analysis and Business Modeling, 5th Edition

Microsoft Excel Data Analysis and Business Modeling, 5th Edition

eBook (Watermarked)

  • Your Price: $31.99
  • List Price: $39.99
  • Estimated Release: Dec 1, 2016
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.

Description

  • Copyright 2017
  • Dimensions: 7-3/8 X 9
  • Pages: 984
  • Edition: 5th
  • eBook (Watermarked)
  • ISBN-10: 1-5093-0425-8
  • ISBN-13: 978-1-5093-0425-7

Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide will help you apply Excel 2016's most valuable innovations for data analysis and business modeling.  It's packed with realistic problems and solutions to help you gain mastery -- including over 150 that are new or revised. Coverage includes:

  • Quickly transitioning from basic Excel to more sophisticated analytics
  • Summarizing data with PivotTables and Descriptive Statistics
  • Exploring new trends in predictive and prescriptive analytics
  • Using Excel Trend Curves, multiple regression, and exponential smoothing
  • Mastering advanced Excel functions such as OFFSET and INDIRECT
  • Delving into key financial, statistical, and time functions
  • Making charts more effective with Power View
  • Tame complex optimization problems with Excel Solver
  • Running Monte Carlo simulations on stock prices and bidding models
  • Using Excel 2016's new FORECAST and Power Map tools
  • Working with the AGGREGATE function and Table Slicers
  • Creating multiple PivotTables from a filter
  • Using HYPERLINKS, ISFORMULA, and UNICODE
  • Performing sensitivity analyses with more than two variables
  • Making the most of the Inquire add-in
  • And much more

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership