You are viewing a single thread.
View all comments
9 points
*

Honestly, since the introduction of ‘tables’, pivot tables, Power Pivot and Power Query, Excel is way more viable to be used as a database. Tables in particular mean that formulas fill down and the range automically resizes when records are added.

permalink
report
reply
4 points

Iirc tables are actually treated similar to databases on the backend.

permalink
report
parent
reply

Memes

!memes@lemmy.ml

Create post

Rules:

  1. Be civil and nice.
  2. Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.

Community stats

  • 8K

    Monthly active users

  • 13K

    Posts

  • 288K

    Comments