/* --- RESPONSIVE --- */

Microsoft Excel 2013 Data Analysis and Business Modeling

Microsoft Excel 2013 Data Analysis and Business Modeling - Free Ebook Download

Book Detail

Author/Editor(s): Wayne Winston
Publication Date: January 25, 2014
ISBN-10: 0735669139
ISBN-13: 978-0735669130
Language: English
Edition: 1
Publisher: Microsoft Press
Size: 25.0 MB
Format: pdf

Book Description

Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook.

Solve real business problems with Excel—and sharpen your edge
  • Summarize data with PivotTables and Descriptive Statistics
  • Explore new trends in predictive and prescriptive analytics
  • Use Excel Trend Curves, multiple regression, and exponential smoothing
  • Master advanced Excel functions such as OFFSET and INDIRECT
  • Delve into key financial, statistical, and time functions
  • Make your charts more effective with the Power View tool
  • Tame complex optimization problems with Excel Solver
  • Run Monte Carlo simulations on stock prices and bidding models
  • Apply important modeling tools such as the Inquire add-in

About the Author

Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and has earned numerous MBA teaching awards. For 20+ years, he has taught clients at Fortune 500 companies how to use Excel to make smarter business decisions. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. He is also a two time Jeopardy! Champion.

Reviews

A highly practical book that takes the mystery out of modeling by working a number of problems, each introduced in small chunks, and all using Excel's built in functionality. It covers most of the most important techniques. The "lots of small chapters" approach allows the user to learn both Excel and modeling capabilities in a relatively painless way. Multiple editions have stood the test of time, and I've found that other people independently have come to the conclusion that this is the right place to start on both using Excel more effectively and thinking about decisions from a modeling perspective.

--Roy Pettis, Amazon Customer Reviews
Buy Download

Links to Download or Buy

If you can afford, then please support the Author(s) by Buying the book. Thank You.

Sharing is Caring

All materials on this website is only for Educational Purposes and strictly for private use
Template Created by Creating Website - Proudly powered by Blogger
Copyright © 2016. 1001 Ebook - All Rights Reserved | DMCA | Privacy Policy
Support: 1001 Tutorial | IDFL | MKR Site | Mas Template | Become Friends