borth@sh.itjust.works to Memes@lemmy.mlEnglish · 1 年前You have 1 wish...sh.itjust.worksimagemessage-square89fedilinkarrow-up11.52Karrow-down117
arrow-up11.5Karrow-down1imageYou have 1 wish...sh.itjust.worksborth@sh.itjust.works to Memes@lemmy.mlEnglish · 1 年前message-square89fedilink
minus-squareCoupleOfConcerns@lemmy.nzlinkfedilinkarrow-up10arrow-down1·edit-21 年前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.
minus-squaredroans@lemmy.worldlinkfedilinkarrow-up4·1 年前Iirc tables are actually treated similar to databases on the backend.
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.
Iirc tables are actually treated similar to databases on the backend.