Sorry, this item is currently unavailable.

Microsoft Excel Data Analysis and Business Modeling

ISBN: 9781509304219 | 1509304215
Edition: 5th
Format: Paperback
Publisher: Microsoft Press
Pub. Date: 12/1/2016

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Top 5 reasons to order all your textbooks from Knetbooks:

  • We have the lowest prices on thousands of popular textbooks
  • Free shipping both ways on ALL orders
  • Most orders ship within 48 hours
  • Need your book longer than expected? Extending your rental is simple
  • Our customer support team is always here to help

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
  • Performing sensitivity analyses with more than two variables
  • Making the most of the Inquire add-in
  • And much more

Please wait while this item is added to your cart...