Translations:Basic Excel Trainer/36/en

Nevertheless, Excel is not good at some of the things that a relational database does well, like:

  • storage of large amounts of information (there are restrictions to the number of records that can be stored)
  • supporting multiple users who wish to view or change data at the same time
  • maintaining data integrity
    • identifying data errors (an error in a single cell can make the entire spreadsheet unusable, but it can be very difficult to track down the problem, or identify how and when the problem was caused)
  • handling relationships between pieces of data.