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

Product Details

ISBN-13:	9781509304219
Publisher:	Pearson Education
Publication date:	12/09/2016
Series:	Business Skills
Pages:	864
Product dimensions:	7.40(w) x 9.00(h) x 1.80(d)

About the Author

WAYNE L. WINSTON is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business and Visiting Professor of Decision and Information Sciences at University of Houston Bauer College of Business. He has earned numerous MBA teaching awards. For more than 20 years, he has taught clients at Fortune 500 companies, various accounting groups, the US Navy, and the US Army 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.

Table of Contents

• Chapter 1 Basic spreadsheet modeling
• Chapter 2 Range names
• Chapter 3 Lookup functions
• Chapter 4 The INDEX function
• Chapter 5 The MATCH function
• Chapter 6 Text functions
• Chapter 7 Dates and date functions
• Chapter 8 Evaluating investment by using net present value criteria
• Chapter 9 Internal rate of return
• Chapter 10 More Excel financial functions
• Chapter 11 Circular references
• Chapter 12 IF statements
• Chapter 13 Time and time functions
• Chapter 14 The Paste Special command

Editorial Reviews

The Barnes & Noble Review
Wayne Winston has taught Excel analysis and modeling to thousands of analysts, from Microsoft to the Department of Defense. Now, he’s written the definitive guide for working businesspeople: simply the best we’ve ever seen on the subject.

Winston walks you through one challenge and feature at a time, from the simplest (range names) all the way through Black-Scholes options calculations. Using real-world examples, he explains IRR, auditing, sensitivity analysis, goal seek, data validation, PivotTables, demand curves, risk analysis, and plenty more.

Your payoff: a closing chapter on picking your fantasy football team. Don’t laugh: Winston consults with Mark Cuban and the Dallas Mavericks on using Excel to rate basketball players. Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2003 and Upgrading & Fixing Networks for Dummies, Second Edition.

bn.com