<aside> ↙️ Hi, Hello! My name is Sarah - the writer behind redgregory.com.

</aside>

<aside> 📎 In order to cope with the immense amount of data in the information age, the use of spreadsheets and databases is important and extremely useful for management, manipulation and data storage.

Despite their differences, spreadsheets and databases can be complementary methods of data storage. A lot of the time one is used to support the other, and so, if you are familiar with one, you will find the other easy to learn.

</aside>

All About Spreadsheets

<aside> 🖥️ Common programs: Microsoft Excel, Googlesheets, etc.

</aside>

Stores data in cells by rows and columns
Manipulates data for stats, computing and modeling
Has a range of automated functions
Very compatible for presentations and paper reports
Used within applications only meant for spreadsheets

<aside> 🚨 Downsides of the spreadsheet → A large amount of data can become impractical and difficult to make mass alterations. → Filter capabilities are limited → Lack of data integrity and sparse management control

</aside>

All About Databases

✅ The tables inside Notion are databases!

<aside> 🖥️ Database technologies: Microsoft Access, Oracle, MySQL, SQL Server, etc.

</aside>

Stores data in "records." a.k.a column-based tables rather than cell-based
Capable of storing a lot of raw data
Several people can access the same database
Very compatible for sharing and reporting