Overview
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.
Full Product Details
Author: Thin-Yin Leong ,
Michelle Cheong
Publisher: McGraw-Hill Education (Asia)
Imprint: McGraw-Hill Education (Asia)
Edition: 3rd Revised edition
Dimensions:
Width: 18.60cm
, Height: 2.00cm
, Length: 23.50cm
Weight: 0.709kg
ISBN: 9789814595155
ISBN 10: 9814595152
Pages: 350
Publication Date: 01 December 2014
Audience:
College/higher education
,
Tertiary & Higher Education
Format: Book
Publisher's Status: Active
Availability: Available To Order
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.
Author Information
Dr Leong is Practice Associate Professor of Information Systems at the Singapore Management University. A/P Leong was formerly a faculty member of the National University of Singapore’s Business School. Over the years, he had taught courses in operations management, logistics and supply chain management, and business spreadsheet modeling in undergraduate, MBA and executive programs. In between academia, A/P Leong had spent more than a decade's in the industry and was last Senior Vice-President (Information Technology) with the port operator that runs the world’s busiest container terminal, where he spearheaded its operations improvements, and systems and technology development. He also provided many models which supported management decisions in strategy, capacity development, operational planning and scheduling, and financial and tax issues. One of his current pet teaching and research interests is spreadsheet modeling and analysis, leveraging his past experience for research as well as industry applications. Even while in academia, he had been active in business consulting and had worked with many multinational corporations and local companies, particularly those in the electronics, petrochemical, medical, hospitality, banking, cargo logistics, passenger transport, and the government sectors. Dr Cheong is Practice Assistant Professor of Information Systems at the Singapore Management University and Director of the School’s Masters and Professional Programs. Cheong had worked eight years in the industry developing and implementing enterprise IT solutions for manufacturing companies. She had led teams to develop complex IT systems which were implemented enterprise-wide covering business functions from sales to engineering, inventory management, planning, production, and distribution. She consulted for precision engineering, printing, aerospace and brewery companies in business process re-engineering for IT solutions implementation. During her PhD studies, she taught, as a teaching assistant, a course in analytical methods and flow models. Currently, she teaches the undergraduate spreadsheet modeling course together with the first author. As Director of the School’s Masters and Professional Programs, she worked closely with the Dean’s office to conceptualize, design and develop a new master’s program, which was successfully launched in 2007.
