Business Modelling with Spreadsheets
3rd Edition
9814595152
·
9789814595155
© 2015 | Published: October 29, 2014
ABOUT THE BOOKThis book is wholly dedicated to the art of exploratory spreadsheet modeling. Real problems that readers encounter on a day-to-day basis are presented, with the aim of helping them derive applicable principles and link principles to pra…
Read More
Receive via shipping:
- Colour, print bound version of the complete text
CONTENTS
CHAPTER 1 SPREADSHEET MODELING
Pt 1: Concrete versus abstract
Pt 2: Ratio and relativity
Pt 3: Projection versus targeting
Pt 4: Questions and givens
Pt 5: Case study and analysis
CHAPTER 2 PROBLEM SOLVING AND SPREADSHEET ENGINEERING
Pt 6: Exploratory modeling
Pt 7: Linear approximation
Pt 8: What-if, trade-off and sensitivity
Pt 9: Validity, pros and cons
Pt 10: Business excellence
CHAPTER 3 DATA LOOKUP AND LINKUP
Pt 11: Business functions
Pt 12: Plans are just plans
Pt 13: Price differentiation
Pt 14: Discount and rebate
Pt 15: Search and iteration
CHAPTER 4 RELATIONSHIPS
Pt 16: Money over time
Pt 17: Spot, future and option
Pt 18: Simple is hard; hard is simple
Pt 19: Graphic representation
Pt 20. Business strategy analyses
CHAPTER 5 MAKING ASSUMPTIONS
Pt 21: Market and auction
Pt 22: Complexity and competition
Pt 23: Policy, not numbers
Pt 24: Parametric analysis
CHAPTER 6 RISKS AND UNCERTAINTIES
Pt 25: Status quo and change
Pt 26: Follow the contender
Pt 27: Predictably irrational
Pt 28: Flaw of averages
CHAPTER 7 PROCESSES AND TIME
Pt 29: Waiting in line
Pt 30: Power of observation
Pt 31: Single and multiple queues
Pt 32: Queue inference
CHAPTER 8 ANALYZING THE DATA
Pt 33: Practical data analysis
Pt 34: Black swans and data you don’t have
Pt 35: Inadequate and missing data
Pt 36: Correlations and unintended effects
CHAPTER 9 MODELING PROJECTS
Pt 37: Community and individual
Pt 38: Business and services
Pt 39: New venture
Pt 40: Finance and administration
Pt 41: Transportation and supply chain
Pt 42: Manufacturing and operations
Pt 43: Information technology and communications
Pt 44: Global and environmental
Pt 45: Phase out skeuomorphs
Pt 46: Design thinking and social change
APPENDIX A EXCEL 2010-13 FEATURES AND FUNCTIONS
APPENDIX B VISUAL BASIC FOR APPLICATION
CHAPTER 1 SPREADSHEET MODELING
Pt 1: Concrete versus abstract
Pt 2: Ratio and relativity
Pt 3: Projection versus targeting
Pt 4: Questions and givens
Pt 5: Case study and analysis
CHAPTER 2 PROBLEM SOLVING AND SPREADSHEET ENGINEERING
Pt 6: Exploratory modeling
Pt 7: Linear approximation
Pt 8: What-if, trade-off and sensitivity
Pt 9: Validity, pros and cons
Pt 10: Business excellence
CHAPTER 3 DATA LOOKUP AND LINKUP
Pt 11: Business functions
Pt 12: Plans are just plans
Pt 13: Price differentiation
Pt 14: Discount and rebate
Pt 15: Search and iteration
CHAPTER 4 RELATIONSHIPS
Pt 16: Money over time
Pt 17: Spot, future and option
Pt 18: Simple is hard; hard is simple
Pt 19: Graphic representation
Pt 20. Business strategy analyses
CHAPTER 5 MAKING ASSUMPTIONS
Pt 21: Market and auction
Pt 22: Complexity and competition
Pt 23: Policy, not numbers
Pt 24: Parametric analysis
CHAPTER 6 RISKS AND UNCERTAINTIES
Pt 25: Status quo and change
Pt 26: Follow the contender
Pt 27: Predictably irrational
Pt 28: Flaw of averages
CHAPTER 7 PROCESSES AND TIME
Pt 29: Waiting in line
Pt 30: Power of observation
Pt 31: Single and multiple queues
Pt 32: Queue inference
CHAPTER 8 ANALYZING THE DATA
Pt 33: Practical data analysis
Pt 34: Black swans and data you don’t have
Pt 35: Inadequate and missing data
Pt 36: Correlations and unintended effects
CHAPTER 9 MODELING PROJECTS
Pt 37: Community and individual
Pt 38: Business and services
Pt 39: New venture
Pt 40: Finance and administration
Pt 41: Transportation and supply chain
Pt 42: Manufacturing and operations
Pt 43: Information technology and communications
Pt 44: Global and environmental
Pt 45: Phase out skeuomorphs
Pt 46: Design thinking and social change
APPENDIX A EXCEL 2010-13 FEATURES AND FUNCTIONS
APPENDIX B VISUAL BASIC FOR APPLICATION
ABOUT THE BOOK
This book is wholly dedicated to the art of exploratory spreadsheet modeling. Real problems that readers encounter on a day-to-day basis are presented, with the aim of helping them derive applicable principles and link principles to practice.
Users of this book will find it a refreshing learning guide and handy reference resource. It offers 101 spreadsheet exercises and tools, including a chapter featuring another 101 business challenges that readers can practice as modeling projects. Introduced for the first time in this third edition is a set of Discovery Points, 46 in total. They are included to enlighten readers and instructors on the underlying exploratory thinking employed in the exercises.
Though the book can be used with different versions of Microsoft Excel, LibreOffice and OpenOffice Calc, and other spreadsheet application software, this edition only presents Excel 2010-13 spreadsheet features and functions, and Visual Basic for Application in its appendices.
The notes for older Excel versions, and OpenOffice Calc and Basic from the earlier editions, and the newly added LibreOffice Calc and Basic are now found in a new Online Learning Center that accompanies this book. Completed spreadsheet workbooks in the different spreadsheet versions are also provided there.
This way, the book should remain helpful for any person, whether a novice, beginner, or expert, to learn business modeling using basic and advanced spreadsheet features, as well as macro programming.
NEW IN THIS EDITION
Discovery Points:
To better support underlying thinking and give pointers to guide business problem exploration. These are more general than the comments in the Concept sub-section of exercises and they are ideas many experienced modelers use intuitively. Listed at the start of each chapter to help consolidate the learning for seasoned modelers, and make it easier for instructors to impart the art of modeling to students. These points can be used for self-discovery, class discussion and project team deliberations. They can be applied to various settings and exercises found in this book.
Problem Sets:
Provides a means to test students to ensure that learning has taken place at the correct pace. A separate question sets of assignments, quizzes and examinations apart from the exercises in the book. These are simpler and more defined problems for students to practice and be evaluated on their spreadsheet skills. The questions with given data are easier and the harder questions are marked with an asterisk (*).
TARGET AUDIENCE
Undergraduates, graduate students, and professionals involved in business development, finance, accounting and operations.
This book is wholly dedicated to the art of exploratory spreadsheet modeling. Real problems that readers encounter on a day-to-day basis are presented, with the aim of helping them derive applicable principles and link principles to practice.
Users of this book will find it a refreshing learning guide and handy reference resource. It offers 101 spreadsheet exercises and tools, including a chapter featuring another 101 business challenges that readers can practice as modeling projects. Introduced for the first time in this third edition is a set of Discovery Points, 46 in total. They are included to enlighten readers and instructors on the underlying exploratory thinking employed in the exercises.
Though the book can be used with different versions of Microsoft Excel, LibreOffice and OpenOffice Calc, and other spreadsheet application software, this edition only presents Excel 2010-13 spreadsheet features and functions, and Visual Basic for Application in its appendices.
The notes for older Excel versions, and OpenOffice Calc and Basic from the earlier editions, and the newly added LibreOffice Calc and Basic are now found in a new Online Learning Center that accompanies this book. Completed spreadsheet workbooks in the different spreadsheet versions are also provided there.
This way, the book should remain helpful for any person, whether a novice, beginner, or expert, to learn business modeling using basic and advanced spreadsheet features, as well as macro programming.
NEW IN THIS EDITION
Discovery Points:
To better support underlying thinking and give pointers to guide business problem exploration. These are more general than the comments in the Concept sub-section of exercises and they are ideas many experienced modelers use intuitively. Listed at the start of each chapter to help consolidate the learning for seasoned modelers, and make it easier for instructors to impart the art of modeling to students. These points can be used for self-discovery, class discussion and project team deliberations. They can be applied to various settings and exercises found in this book.
Problem Sets:
Provides a means to test students to ensure that learning has taken place at the correct pace. A separate question sets of assignments, quizzes and examinations apart from the exercises in the book. These are simpler and more defined problems for students to practice and be evaluated on their spreadsheet skills. The questions with given data are easier and the harder questions are marked with an asterisk (*).
TARGET AUDIENCE
Undergraduates, graduate students, and professionals involved in business development, finance, accounting and operations.
Supporting Websites
- Online Learning Center: www.mheducation.asia/olc/leong