Leong, Thin-Yin

Business modeling with spreadsheets: problems, principles and practice - 3rd - New Delhi McGraw Hill Education (India) Pvt. Ltd. 2019 - xxviii, 409 p.

CHAPTER 1: CASE STUDY AND SPREADSHEET MODELING
CHAPTER 2: PROBLEM SOLVING AND SPREADSHEET ENGINEERING
CHAPTER 3: DATA LOOKUP AND LINKUP
CHAPTER 4: FUNCTIONS AND RELATIONSHIPS
CHAPTER 5: MAKING ASSUMPTIONS
CHAPTER 6: RISKS AND UNCERTAINTIES
CHAPTER 7: PROCESSES AND TIME
CHAPTER 8: ANALYZING THE DATA
CHAPTER 9: MODELING PROJECTS






APPENDIX A: EXCEL 2010–2013 FEATURES AND FUNCTIONS
APPENDIX B: VISUAL BASIC FOR APPLICATION

An Overview
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.


Highlights
? 101 Spreadsheet Exercises and Tools from real world situations to learn effectively and apply learning outcomes
? 101 Projects as Problem Sets. It is essential for instructors that students need to be given homework and tested to ensure that learning has taken place at the correct pace. Projects or Problem sets will hep students to test their knowledge and skills to achieve perfection in the Modeling.
? 51 Tips to support the understanding and key learning objectives of the text and projects
? Exercises and Projects in the book can be used with Excel 2013, Mac Excel and LibreOffice Cal
? 46 Discovery Points to enlighten readers and instructors on the underlying exploratory thinking employed in the exercises. it will help consolidate the learning for seasoned modellers, and make it easier for instructors to impart the art of modeling to students. The Discovery Points can be used for self-discovery and class discussions. The themes in the points can be applied to various settings and exercises found in this book.

9789353168124


Business--Computer programs
Electronic spreadsheets
Microsoft Excel (Computer file)
Business--Data processing

005.54 / LEO