Remix.run Logo
alexandrehtrb 2 days ago

1) Today I learned that named cells exist in Excel.

2) Excel is great for technical and non-technical people. You can teach Excel even to 10-year-olds (I first used it when I was a student around that age).

3) 1,048,576 rows are more than enough for 99% of Excel use-cases.

4) Excel can connect to external data sources, like databases and APIs, which can perform heavier and more complex data operations, taking this responsibility away from the spreadsheet. SQL queries and procedure calls can be embedded inside Excel spreadsheets.

5) There are some Excel skills, like named cells and VBA functions, that most people don't know. It's a matter of sharing knowledge with them, so they can make better spreadsheets.