Mastering Financial Modelling in Microsoft Excel 3rd edn, 3rd Edition

2

Design introduction

Introduction

Basics of design

Objectives

User interface

Key variables and rules

Layout

Individual modules

Menu structure and macros

Management reporting

Future developing

Testing

Protection

Documentation

Peer group comments

Summary

INTRODUCTION

The last chapter exposed weaknesses in traditional layouts, which essentially use Excel as a large piece of automated accounting paper. To base decisions on Excel or to have confidence in the answers requires a more disciplined approach, which centres much more on the objectives, user reports and the process of producing an answer. The systematic approach is designed to speed up model development and reduce errors. Figure 2.1 outlines some of the stages in design.

Figure 2.1 ...