Designing and Building Business Models Using Microsoft Excel Book

This text provides a formal and structured approach to building spreadsheet models for use in business and decision-making. This approach contrasts with piece-meal methods which often result in badly designed and ineffective models. The text's chapters divide the design process into a number of key stages including problem conceptualization, the collection and examination of data, model structure, the use of macros and model validation and documentation. Later chapters describe the use of formal models in exploring various business scenarios and examine issues of presentation and data security. Finally the text provides guidance in developing modelling templates. The text includes a case study which helps to illustrate the concepts of model design, content and layout. This case study develops throughout the text and is mathematically simple to ensure effective understanding of the key concepts. The concepts developed are readily applicable to different spreadsheet environments and the text uses Microsoft Excel as an illustrative reference. The text's learning aids include chapter objectives, conclusions, review questions and case study questions. In addition the text includes a glossary of spreadsheet terminology.Read More