Microsoft Excel Data Analysis and Business Modeling

Beschreibung:

Leichte Risse. 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 ". Bestandsnummer des Verkäufers 52e8d677-ece9-466a-a448-3531be12900c

Diesen Artikel melden

Inhaltsangabe:

Über die Autorin bzw. den Autor: 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.