This study book by Wayne Winston covers business modeling and analysis with Microsoft Excel. It offers a practical, hands-on approach to transforming data into concrete business results. Thoroughly updated and suitable for professionals who want to deepen their skills with Microsoft Excel.
Contents
The author provides a thorough introduction to modern analysis techniques using Excel. The content includes, among other things:
- Transition from basic to advanced analytical methods
- Using Power Query to connect and transform data
- Applying LAMBDA functions for custom solutions without VBA
- New data types for importing stock prices, weather data, and more
- Improved charting capabilities
- New functions such as XLOOKUP and dynamic array formulas
- Geographic data analysis with 3D Maps
- Decision-making with probability calculations, Bayesian statistics, and Monte Carlo simulations
- Predictive analytics with trend curves and multiple regression
- Relational data integration via Data Model and Power Pivot
Product specifications
- Author: Wayne Winston
- Publisher: Pearson Education (US)
- Imprint: Addison Wesley
- Publication date: 2022-02-26
- Number of pages: 1168
- ISBN: 9780137613663
- Topic: Spreadsheet software
- BISAC: COMPUTERS / Desktop Applications / General
About the author
Wayne L. Winston is Professor Emeritus of Decision Sciences at the Indiana University School of Business. With dozens of teaching awards and experience at Fortune 500 companies, he offers deep expertise in Excel modeling and data analysis.