Translations:Basic Excel Trainer/38/en

Excel is NOT a database. However, there are many good reasons to use Excel in conjunction with a relational database:

  • Excel is relatively easy to use
    • new users can get started using Excel quickly
    • many people have at least some familiarity with Excel
  • Excel is widely available
  • data from a database can easily be exported to Excel, where
    • the data can be analysed
    • calculations can be performed
    • tables can be created (based on the underpinning dataset, so using more than Excel's formatting capabilities)
    • graphs can be produced
  • Excel can be used to prepare data for submission to a database.