borth@sh.itjust.works to Memes@lemmy.mlEnglish · 11 months agoYou have 1 wish...sh.itjust.worksimagemessage-square89fedilinkarrow-up11.53Karrow-down117
arrow-up11.51Karrow-down1imageYou have 1 wish...sh.itjust.worksborth@sh.itjust.works to Memes@lemmy.mlEnglish · 11 months agomessage-square89fedilink
minus-squareCoupleOfConcerns@lemmy.nzlinkfedilinkarrow-up10arrow-down1·edit-211 months agoHonestly, 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·11 months agoIirc 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.