Features and Tools of a Spreadsheet mindmap

Features and Tools of a Spreadsheet mindmap

1. Can Sort Data

   • Good for making it easier to find individual data

2. Absolute and relative referencing

   • Makes setting up formulas easier

3. Can protect certain cells from change

   • Handy to make the model more robust

4. Use interface forms

   • Goods to load input values into the model

5. Macro language support

   • Allows complicated subroutines and functions to be written

6. Automatic re-calculation

   • Makes the model respond very quickly

7. Conditional formatting

   • Highlight certain numbers of interest such as a profit/loss

8. Import/Export support

   • Easy to load input values in one go and save output values

9. Searching and filtering

   • Good when looking for specific data in the model

10. Lookup tables

    • Used extensively in modelling to store values

11. Pivot Tables

    • Very powerful tool to summarise a huge amount of data into one table

12. Pivot Charts

    • Good way of seeing the effect of running 'what if' questions

13. Replication

    • Easy to create a list of values by simply dragging down in a certain way

14. Database lookup

    • Can connect to external databases to get values

15. Worksheets suppported

    • good for splitting up parts of the model

16. Graphing

    • Pie charts, Bar charts etc are good for presenting data in different ways