Building a Simple Excel Model - Getting Started with Python and Excel

Building a Simple Excel Model

Part of the lecture series "Getting Started with Python and Excel":
https://nickderobertis.github.io/fin-...

Full Course Website:
https://nickderobertis.github.io/fin-...


Notes
--------

It is crucial that all your Excel calculations are linked together by cell references. If you hard-code values in your calculations you are just using Excel as a calculator.
It is important to visually separate the inputs from the outputs. This makes it much more clear for the consumer of your model, especially in more complex models
More complex models should be broken into multiple sheets with each sheet dedicated to a concept or calculation
Cell formatting can be used in combination with the layout to separate them
For small models, intermediate outputs/calculations may be kept in the outputs section, while for larger models it makes sense to have separate calculation sections

Resources
------------

Simple Retirement Model - Excel: https://nickderobertis.github.io/fin-...