3
Features and techniques
Specific colours for inputs and results
Controls – combo boxes and buttons
Use of functions and types of function
Record a version number, author, etc.
Use names to make formulas easier to understand
Paste names as part of documentation
Dynamic graphs to plot individual series
INTRODUCTION
The basics of design revolve around planning, logic and presentation, whereas this chapter concentrates on a list of features that can be included to make models more user-friendly. ...
Get Mastering Financial Modelling in Microsoft Excel 3rd edn, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
