Business modeling with spreadsheets: problems, principles and practice

By:

Leong, Thin-Yin

Contributor(s):

Cheong, Michelle L.F

Publication details: McGraw Hill Education (India) Pvt. Ltd. New Delhi 2019Edition: 3rdDescription: xxviii, 409 pISBN:

9789353168124

Subject(s):

DDC classification:

005.54 LEO

Summary: 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.

List(s) this item appears in: Operation & quantitative Techniques | Non Fiction

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings
Item type	Current library	Collection	Call number	Copy number	Status	Date due	Barcode
Book	Indian Institute of Management LRC General Stacks	Operations Management & Quantitative Techniques	005.54 LEO (Browse shelf(Opens below))	1	Available		001476

Browsing Indian Institute of Management LRC shelves, Shelving location: General Stacks, Collection: Operations Management & Quantitative Techniques Close shelf browser (Hides shelf browser)

Previous								Next
Previous	005.1 LEV Introduction to the design and analysis of algorithms	005.1 MOT Randomized algorithms	005.133 GRE Numerical methods in engineering and science	005.54 LEO Business modeling with spreadsheets: problems, principles and practice	005.54 QUI Excel 2019 for advertising statistics: a guide to solving practical problems	005.55 BIT Stata: a really short introduction	005.7 GIZ The practice of qualitative data analysis: research examples using MAXQDA	Next

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.

There are no comments on this title.

to post a comment.