Spreadsheet Model For Situations

**

  • Absolute and relative cell referencing makes sure you only increment the parts
  • of a formula you need to
  • Cell protection makes sure that the cells you want do not change by accident
  • User interface forms makes it easier to input values into the model
  • Macros make it easier to create more complex formulae or functions
  • Automatic re-calculation means it is not necessary to evaluate a formula every time you change it
  • Conditional formatting allows you to highlight certain values that match specific criteria
  • Graphs/charts to detect trends.

Comments