Microsoft 365 Training by 3grow
Microsoft 365 | Specialised Training | SharePoint | Nintex | LiveTiles | Azure | Project Server
Category: Excel
SharePoint Lists vs. Excel Tables
Simply put, and contrary to popular belief, Excel is not designed
for storing tables of data!
Excel is a spreadsheeting tool, intended for data analysis.
Do you know what IS designed for storing tables of data?
Databases.
And SharePoint lists! Which are essentially database tables
anyway.
