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":

Full Course Website:

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
------------

[MrMohamed]

Thanks for making such of this great topic

[MohammadJParsa]

Thank you so much Nick, I Owe you one :)