Creative Excel Model Development
by Hervé Thiriez
In my mind, the potential of Excel for creative and efficient modelling – in any domain – knows almost no limits. It is just up to you! I am using the term “creative” for several reasons:
- When I analyze the needs of a customer, I do not ask him what kind of Excel model he needs. If I did that, he would be limited in his imagination by his personal level of Excel expertise. What I ask him to describe to me is the model he dreams of, taking no account of what he knows or does not know about Excel.
- I always try to make my models as flexible as possible. Most of my charts are flexible (they automatically adapt to how much data has been entered), they have pull-down menus, dynamic titles (titles ...