Microsoft Excel 2016 Data Analysis and Business Modeling

Winston, Wayne

ISBN 10: 1509304215 / ISBN 13: 9781509304219

Published by Microsoft Press, 2017

About this Item

This is an ex-library book and may have the usual library/used-book markings inside.This book has soft covers. In good all round condition. Please note the Image in this listing is a stock photo and may not match the covers of the actual item,1500grams, ISBN:9781509304219.

Seller Inventory # 9789546

Bibliographic Details

• Title: Microsoft Excel 2016 Data Analysis and Business Modeling
• Publisher: Microsoft Press
• Publication Date: 2017
• Language: English
• ISBN 10: 1509304215
• ISBN 13: 9781509304219
• Binding: Soft cover
• Edition: 5th or later Edition
• Condition: Good
• Seller catalogs:
  • Computing

About this title

Synopsis

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

 

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.